We are seeking an experienced Senior SQL Server & PostgreSQL DBA to manage, support, optimize, and enhance enterprise database environments across on-premises and cloud platforms. The ideal candidate will possess strong expertise in database administration, SQL development, performance tuning, migration, and production support.

This role requires hands-on experience with SQL Server, PostgreSQL, and cloud-managed database services, along with the ability to collaborate effectively with application development, infrastructure, and DevOps teams.

Key Responsibilities

- Administer and support SQL Server and PostgreSQL databases across development, testing, and production environments.
- Perform database installation, configuration, upgrades, patching, backup, recovery, and disaster recovery planning.
- Design, develop, and maintain complex SQL queries, stored procedures, functions, views, triggers, and other database objects.
- Analyze and optimize query performance through execution plan analysis, indexing strategies, partitioning, and database tuning techniques.
- Troubleshoot database performance issues, blocking, deadlocks, replication failures, and production incidents.
- Implement and maintain high availability and disaster recovery solutions such as Always On Availability Groups, replication, clustering, and PostgreSQL replication.
- Support database migration, modernization, and cloud adoption initiatives, including SQL Server to PostgreSQL migrations and on-premises to cloud transitions.
- Administer cloud database platforms including AWS RDS and Aurora PostgreSQL.
- Develop database deployment, automation,



and maintenance scripts using SQL, Python, or Bash.
- Collaborate with development and DevOps teams to support CI/CD pipelines, database releases, schema changes, and application performance improvements.
- Monitor database health, capacity, availability, and security while ensuring adherence to operational and compliance standards.

Required Skills & Experience

- 8+ years of hands-on experience in Database Administration and SQL Development.
- Robust expertise in SQL Server DBA activities supporting mission-critical production environments.
- Hands-on experience with PostgreSQL administration, performance tuning, and troubleshooting.
- Proficiency in writing and optimizing complex SQL queries, stored procedures, functions, views, and triggers.
- Experience with query tuning, execution plan analysis, indexing, database optimization, and performance troubleshooting.
- Experience with database migration, schema conversion, data migration, and modernization projects.
- Hands-on experience with AWS RDS and Aurora PostgreSQL.
- Strong understanding of backup and recovery, high availability, disaster recovery, and database security best practices.
- Experience with scripting and automation using Python, Bash, or similar technologies.
- Familiarity with database deployment tools, version control, and CI/CD processes.

Preferred Skills

- Exposure to Flyway, Liquibase, Alembic, or similar database migration tools.
- Experience working in multi-cloud environments (AWS, Azure, GCP).
- Knowledge of database monitoring, observability, and capacity planning tools.

📌 Senior SQL Server & PostgreSQL DBA (Pune)
🏢 Programmers.io
📍 Pune