24 Sep
|
Programmers.io
|
India
24 Sep
Programmers.io
India
Job Description
We are seeking a highly experienced Senior SQL Server & Postgres DBA to manage and support enterprise database platforms across on-premise and multi-cloud environments (AWS, Azure, GCP). The role is primarily centered around Microsoft SQL Server, while also requiring strong hands-on experience in PostgreSQL and exposure to modern cloud-native database services.
T
he ideal candidate should operate as a cross-skilled senior DBA, capable of working across multiple database technologies, supporting both SQL Server and PostgreSQL environments in production, and contributing to cloud-native database operations. The role demands strong ownership of critical systems, along with the ability to adapt to evolving database platforms across relational and non-relational ecosystems.K
e
y Responsibilities 1.
SQL Server Administration & Production Operations •
Manage end-to-end SQL Server DBA operations across development, test, and production environments•
Perform installation, configuration, upgrades, patching, and setting maintenance•
Lead performance tuning efforts including execution plan analysis, indexing strategies, and query optimization•
Implement and support HA/DR solutions such as Always On Availability Groups, replication, clustering, and log shipping•
Manage backup, restore, and disaster recovery with periodic DR validations•
Troubleshoot production issues including blocking, deadlocks, IO bottlenecks, and performance degradation2.
Multi-Cloud & Managed Database Operations • A
dministration of databases on Azure SQL, Managed Instances, AWS RDS, and relevant GCP managed database services• S
upport high availability, scaling, failover, and backup strategies across cloud environments• M
onitor database performance, availability, and capacity across cloud deployments• W
ork on hybrid database connectivity across on-prem and cloud environments3.
C
ross-Skilled Database Operations (SQL + PostgreSQL + Cloud DBs) • Ha
nds-on support and administration of PostgreSQL databases across environments• Wo
rk with PostgreSQL in both self-managed and cloud-managed platforms (RDS / Azure PostgreSQL / Aurora PostgreSQL)• Ex
posure to MySQL / MariaDB environments and ability to support operational activities• Fa
miliarity with cloud-native databases such as Aurora, Cosmos DB, DynamoDB, Cassandra or equivalent platforms• Ab
ility to work across relational and non-relational database technologies as part of modern data platforms4. D
a
tabase Migration & Modernization Support • Sup
port on-prem to cloud database migrations across SQL Server and PostgreSQL platforms• Par
ticipate in database re-platforming and modernization initiatives• Ass
ist in cross-database migration scenarios (SQL Server ? PostgreSQL / others)• Ens
ure data consistency, performance stability, and minimal downtime during migrations5. Pr
o
duction Support & Reliability • Own
day-to-day production database operations for mission-critical systems• Moni
tor database health, performance trends, and capacity utilization• Part
icipate in incident management, troubleshooting, and root cause analysis (RCA)• Main
tain runbooks, SOPs, and operational documentation Requir
e
d Skills & Experience 8+ year
- s of strong SQL Server DBA experience Min 3+
- years of hands-on working experience with PostgreSQLProven
- expertise in performance tuning, HA/DR, and production system management Min 5+
- years of hands-on experience with Azure SQL, AWS RDS, or other managed database platforms Exposur
- e to MySQL / MariaDB and modern cloud-native databases Strong
- troubleshooting, performance tuning, and scripting skills. Automat
ion & Dev Ops Alignment • Suppo
rt automation of database provisioning, monitoring, and maintenance tasks• Work
with Dev Ops teams to integrate database operations within CI/CD pipelines• Use s
cripting (Power Shell, Python) for operational efficiency• Contr
ibute to improving DBA processes through automation and standardization Must-Ha
v
e Skills5+ years
of strong SQL Server DBA experience Min 6+ years of hands-on working experience with PostgreSQL Proven expertise in performance tuning, HA/DR, and production system management Min 5+ years of hands-on experience with Azure SQL, AWS RDS, or other managed database platforms Exposure to MySQL / MariaDB and modern cloud-native databases Strong troubleshooting, performance tuning, and scripting skills.
📌 Senior SQL Server & Postgres DBA (India)
🏢 Programmers.io
📍 India