[Hiring] Senior SQL Server & PostgreSQL DBA @programmers.io

Role Description

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

Qualifications

• 8+ years of hands-on experience in Database Administration and SQL Development.
• Strong 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.

Professional Expectations

• Strong ownership and accountability for critical production databases.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Ability to manage multiple priorities in a fast-paced environment.
• Strong communication and collaboration skills with cross-functional teams.
• Commitment to database reliability, performance, security, and continuous improvement.