01 Sep
|
SMC Group
|
Delhi
Role/Position – SQL Server & Postgre SQL Database Administrator.
Experience: 4+yrs.
Job Summary
We are looking for an experienced SQL Server & Postgre SQL 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.
Key Responsibilities
Administer, monitor, and troubleshoot SQL Server and Postgre SQL production environments. Manage databases hosted on On-Premises and AWS infrastructure . Perform database installation, configuration, patching, upgrades, migrations, and capacity planning. Manage SQL Server Always On, Postgre SQL Replication, HA/DR , and failover activities. Perform database backup, restore, recovery, and DR testing . Perform performance tuning, query optimization, indexing, and troubleshooting. Manage database growth, storage, and capacity planning. Implement database security including users, roles, permissions, encryption, TDE, and least-privilege access . Support security audits, compliance requirements, access reviews, and audit findings remediation . Monitor database health, performance, replication, backups, storage, and availability. Automate routine DBA activities using T-SQL,
Power Shell, Bash, or Python . Handle production incidents, perform RCA , and implement preventive measures. Maintain DBA documentation, SOPs, security controls, and operational procedures.
Required
Skills
4+ years of hands-on DBA experience. Strong experience with Microsoft SQL Server and Postgre SQL .
Experience managing databases on On-Premises and AWS-hosted infrastructure . Strong knowledge of backup/recovery, performance tuning, HA/DR, replication, and database security . Good experience with Postgre SQL Timescale DB .
Experience with SQL Server Always on and Postgre SQL replication.
Experience with database audit, compliance, access management, and security controls . Positive Linux and Windows administration knowledge. Strong troubleshooting, analytical, and communication skills. Good to Have
AWS infrastructure/database hosting experience. Postgre SQL Timescale DB administration and performance tuning. AWS DMS / database migration experience. Cloud Watch or other monitoring tools. Python/Bash/Power Shell automation. Mongo DB administration. Interested candidates can share their CV on hinachoudhary@ or can apply directly on this Job Posting.
📌 Sql Server & Postgresql Database Administrator (Delhi)
🏢 SMC Group
📍 Delhi