24 Aug
|
SMC Group
|
Delhi
Role/Position – SQL Server & PostgreSQL Database Administrator.
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.
Robust experience with Microsoft SQL Server and PostgreSQL.
Experience managing databases on On-Premises and AWS-hosted infrastructure.
Robust 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.
Solid troubleshooting, analytical, and communication skills.
Good to Have
AWS infrastructure/database hosting experience.
PostgreSQL TimescaleDB administration and performance tuning.
AWS DMS / database migration experience.
CloudWatch or other monitoring tools.
Python/Bash/PowerShell automation.
MongoDB administration.
Interested candidates can share their CV on [HIDDEN TEXT] or can apply directly on this Job Posting.
📌 Sql Server & Postgresql Database Administrator Delhi
🏢 SMC Group
📍 Delhi