Senior PostgreSQL DBA — Azure HA/DR & Replication Expert

Quantum Technologies. LLC; New Jersey; On-site; USD 95,000 - 128,000; Full time

Job summary

Quantum Technologies. LLC in the United States is seeking a Senior PostgreSQL DBA to design, manage, and secure production PostgreSQL databases hosted on Microsoft Azure.

The role emphasizes HA/DR, performance tuning, and cloud infrastructure expertise. The ideal candidate will lead replication architectures (streaming and logical), automate infrastructure with Terraform, Bicep, Ansible, and ensure security and compliance across Linux and Windows environments.

Qualifications

• Strong expertise in PostgreSQL high availability, disaster recovery, and replication.
• Experience with Azure Database for PostgreSQL Flexible Server.
• Experience managing self-hosted PostgreSQL on Azure Virtual Machines.
• Strong knowledge of Linux (RHEL/CentOS) and Windows Server administration.
• Expertise in streaming replication, logical replication, Patroni, and etcd.
• Experience with backup and recovery tools such as pgBackRest, Barman, and pg_basebackup.
• Strong database performance tuning, query optimization, indexing, and partitioning skills.
• Knowledge of Azure networking, security, authentication, and encryption.
• Experience with database monitoring, incident management, migrations, and version upgrades.
• Infrastructure automation using Terraform, Bicep, Ansible, or PowerShell.

Responsibilities

• Design, implement, and maintain high-availability (HA) and disaster recovery (DR) solutions for PostgreSQL databases on Azure.
• Manage active-passive and active-active replication architectures, including streaming and logical replication.
• Configure automated failover, read replicas, cross-region replication, backup strategies, and recovery procedures.
• Administer Azure Database for PostgreSQL Flexible Server and self-managed PostgreSQL environments on Azure VMs.
• Manage PostgreSQL installations and upgrades across Linux and Windows Server environments.
• Configure Azure networking, private endpoints, VNet integration, authentication, managed identities, and encryption.
• Perform database performance tuning using EXPLAIN ANALYZE, pg_stat_statements, indexing, partitioning, and query optimization.
• Manage database backups, point-in-time recovery, WAL archiving, and restore testing.
• Implement database security, access controls, TLS, encryption, auditing, and compliance requirements.
• Monitor database health, replication lag, performance, and availability using Azure Monitor, Log Analytics, Prometheus, and Grafana.
• Lead critical database incidents, troubleshooting, root cause analysis, and post-incident improvements.
• Plan and execute database migrations and major PostgreSQL version upgrades.
• Automate database infrastructure and administration using Terraform, Bicep, Ansible, Azure CLI, and PowerShell.
• Develop and maintain technical runbooks for failover, backup, recovery, and upgrade procedures.

Skills

PostgreSQL HA

Disaster recovery

Streaming replication

Azure PostgreSQL

Linux/Windows admin

Performance tuning

Tools

Terraform

Bicep

Ansible

Azure CLI

PowerShell

pgBackRest

Grafana/Prometheus

Job description

Quantum Technologies. LLC in the United States is seeking a Senior PostgreSQL DBA to design, manage, and secure production PostgreSQL databases hosted on Microsoft Azure.

The role emphasizes HA/DR, performance tuning, and cloud infrastructure expertise. The ideal candidate will lead replication architectures (streaming and logical), automate infrastructure with Terraform, Bicep, Ansible, and ensure security and compliance across Linux and Windows environments.