SQL Server & PostgreSQL Database Administrator

SMC Group; Delhi; On-site; INR 800,000 - 1,600,000; Full time

Job summary

SMC Group is seeking an experienced SQL Server & PostgreSQL DBA with 4+ years of hands-on experience to manage production databases hosted both on-premises and in AWS. You will ensure availability, performance, security, and DR readiness while supporting audits and compliance.

The role requires strong skills in SQL Server Always On, PostgreSQL replication, and TimescaleDB, with expertise in backup, recovery, and automation. Linux/Windows administration and robust problem-solving are essential.

Qualifications

• 4+ years of hands-on DBA experience.
• Strong experience with Microsoft SQL Server and PostgreSQL.
• 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 PostgreSQL TimescaleDB.
• Experience with SQL Server Always On and PostgreSQL replication.
• Experience with database audit, compliance, access management, and security controls.
• Good Linux and Windows administration knowledge.
• Strong troubleshooting, analytical, and communication skills.

Responsibilities

• Administer, monitor, and troubleshoot SQL Server and PostgreSQL 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, PostgreSQL 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, PowerShell, Bash, or Python.
• Handle production incidents, perform RCA, and implement preventive measures.
• Maintain DBA documentation, SOPs, security controls, and operational procedures.

Skills

SQL Server

PostgreSQL

HA/DR

Backup & Recovery

Performance Tuning

Replication

Security & Compliance

Linux & Windows

Scripting (PowerShell/Python/Bash)

On-Prem & AWS

Tools

TimescaleDB

SQL Server Always On

AWS

CloudWatch

Monitoring Tools

Job description

Experience: 4+yrs.

Job Summary

We 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.

Key Responsibilities

• Administer, monitor, and troubleshoot SQL Server and PostgreSQL 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, PostgreSQL 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, PowerShell, 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 PostgreSQL.
• 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 PostgreSQL TimescaleDB.
• Experience with SQL Server Always on and PostgreSQL replication.
• Experience with database audit, compliance, access management, and security controls.
• Good Linux and Windows administration knowledge.
• Strong troubleshooting, analytical, and communication skills.

Good to Have

• AWS infrastructure/database hosting experience.
• PostgreSQL TimescaleDB administration and performance tuning.
• CloudWatch or other monitoring tools.
• Python/Bash/PowerShell automation.
• MongoDB administration.