Senior SQL Server & Postgres DBA

Programmers.io; India; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Programmers.io is seeking a seasoned Senior SQL Server & PostgreSQL DBA to manage enterprise database platforms across on-premise and multi-cloud environments (AWS, Azure, GCP). The role emphasizes SQL Server with strong PostgreSQL hands-on experience and cloud-native DB familiarity.

The candidate should own critical systems, adapt to evolving database platforms, and collaborate across relational and non-relational ecosystems to ensure performance and reliability.

Qualifications

• 5+ years of strong SQL Server DBA experience.
• Min 3+ years of hands-on PostgreSQL experience.
• Experience with Azure SQL, AWS RDS or other managed database platforms.

Responsibilities

• Administer SQL Server environments across development, test and production.
• Implement HA/DR solutions including Always On, replication, clustering and log shipping.
• Monitor performance, perform tuning, and manage backups and DR readiness.
• Support PostgreSQL in self-managed and cloud-managed environments, including migrations.

Skills

SQL Server DBA

PostgreSQL

Performance tuning

HA/DR

Cloud DB (Azure/AWS)

Scripting (PowerShell/Python)

Tools

PowerShell

Python

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.

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

Key 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 environment 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 degradation

2. Multi‑Cloud & Managed Database Operations

• Administration of databases on Azure SQL, Managed Instances, AWS RDS, and relevant GCP managed database services
• Support high availability, scaling, failover, and backup strategies across cloud environments
• Monitor database performance, availability, and capacity across cloud deployments
• Work on hybrid database connectivity across on‑prem and cloud environments

3. Cross‑Skilled Database Operations (SQL + PostgreSQL + Cloud DBs)

• Hands‑on support and administration of PostgreSQL databases across environments
• Work with PostgreSQL in both self‑managed and cloud‑managed platforms (RDS / Azure PostgreSQL / Aurora PostgreSQL)
• Exposure to MySQL / MariaDB environments and ability to support operational activities
• Familiarity with cloud‑native databases such as Aurora, Cosmos DB, DynamoDB, Cassandra or equivalent platforms
• Ability to work across relational and non‑relational database technologies as part of modern data platforms

4. Database Migration & Modernization Support

• Support on‑prem to cloud database migrations across SQL Server and PostgreSQL platforms
• Participate in database re‑platforming and modernization initiatives
• Assist in cross‑database migration scenarios (SQL Server ? PostgreSQL / others)
• Ensure data consistency, performance stability, and minimal downtime during migrations

5. Production Support & Reliability

• Own day‑to‑day production database operations for mission‑critical systems
• Monitor database health, performance trends, and capacity utilization
• Participate in incident management, troubleshooting, and root cause analysis (RCA)
• Maintain runbooks, SOPs, and operational documentation

Required Skills & Experience

• 5+ years of strong SQL Server DBA experience
• Min 3+ 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.

Automation & DevOps Alignment

• Support automation of database provisioning, monitoring, and maintenance tasks
• Work with DevOps teams to integrate database operations within CI/CD pipelines
• Use scripting (PowerShell, Python) for operational efficiency
• Contribute to improving DBA processes through automation and standardization

Must‑Have Skills

5+ 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.