02 Sep
|
SMC Group
|
New Delhi
02 Sep
SMC Group
New Delhi
Job Description
nRole/Position – SQL Server & PostgreSQL Database Administrator.
nExperience: 4+yrs.
n
nJob Summary
n
nWe are looking for an experienced SQL Server & PostgreSQL DBA with 4+ years of hands-on experience managing production databases hosted across On-Premises and AWS environments. The candidate will be responsible for database availability, performance, security, backup/recovery, compliance, and operational support.
n
nKey Responsibilities
n
n
n
Administer, monitor, and troubleshoot SQL Server and PostgreSQL production environments.n
Manage databases hosted on On-Premises and AWS infrastructure.n
Perform database installation, configuration, patching, upgrades, migrations, and capacity planning.n
Manage SQL Server Always On, PostgreSQL Replication, HA/DR, and failover activities.n
Perform database backup, restore, recovery, and DR testing.n
Perform performance tuning, query optimization, indexing, and troubleshooting.n
Manage database growth, storage, and capacity planning.n
Implement database security including users,
roles, permissions, encryption, TDE, and least-privilege access.n
Support security audits, compliance requirements, access reviews, and audit findings remediation.n
Monitor database health, performance, replication, backups, storage, and availability.n
Automate routine DBA activities using T-SQL, PowerShell, Bash, or Python.n
Handle production incidents, perform RCA, and implement preventive measures.n
Maintain DBA documentation, SOPs, security controls, and operational procedures.n
n
nRequired Skills
n
n
n
4+ years of hands-on DBA experience.n
Robust experience with Microsoft SQL Server and PostgreSQL.n
Experience managing databases on On-Premises and AWS-hosted infrastructure.n
Robust knowledge of backup/recovery, performance tuning, HA/DR, replication, and database security.n
Positive experience with PostgreSQL TimescaleDB.n
Experience with SQL Server Alwa
📌 Sql Server New Delhi
🏢 SMC Group
📍 New Delhi