Senior PostgreSQL DBA – Azure HA/DR Expert (Hybrid LA)

Tranzeal Incorporated; Los Angeles (CA); Hybrid; USD 140,000 - 210,000; Full time

Job summary

Tranzeal Incorporated is hiring a Senior PostgreSQL DBA in West Los Angeles for a hybrid role. You will design, implement, and operate enterprise PostgreSQL databases across Linux and Windows, centered on high availability, disaster recovery, and performance optimization.

The ideal candidate will oversee replication, backups, security, and upgrades, while contributing to Terraform/Bicep-based infrastructure as code and production incident response.

Qualifications

• 8+ years of hands-on PostgreSQL administration in production environments.
• 5+ years of experience managing PostgreSQL on Microsoft Azure, including Azure Database for PostgreSQL Flexible Server.
• Proven experience designing and operating production high-availability clusters and failover scenarios.
• Hands-on experience with active-active or bi-directional replication and conflict resolution.
• Strong experience with PostgreSQL streaming and logical replication, replication slots, and Patroni.
• Production PostgreSQL administration on Linux (RHEL/CentOS) and Windows Server.
• Strong knowledge of Azure networking, private endpoints, authentication, managed identities, and Azure Monitor.
• Experience with database backup/recovery tools such as pgBackRest or Barman.
• Advanced SQL query tuning, indexing, partitioning, and major version upgrades.
• Experience with Terraform or Bicep, Azure CLI, PowerShell, and CI/CD workflows.
• Ability to lead critical production incidents and participate in on-call rotation.

Responsibilities

• Design, implement, and maintain PostgreSQL high-availability and disaster recovery solutions.
• Manage Azure Database for PostgreSQL Flexible Server, read replicas, backups, and upgrades.
• Administer self-managed PostgreSQL on Azure VMs (RHEL/CentOS and Windows Server).
• Configure streaming and logical replication, Patroni, etcd, PgBouncer, and HAProxy.
• Perform advanced query optimization, indexing, partitioning, vacuum tuning, and performance troubleshooting.
• Manage database security, access controls, encryption, patching, and compliance requirements.
• Monitor database health, troubleshoot incidents, and lead incident resolution.
• Execute migrations, upgrades, backup and recovery testing.
• Automate DB infrastructure and operations using Terraform, Bicep, Ansible, PowerShell, scripting tools.
• Maintain technical documentation, recovery procedures, and runbooks.

Skills

PostgreSQL

Azure PostgreSQL

HA/DR

Replication

Performance tuning

Linux/Windows

Terraform/Bicep

On-call rotation

Security & Compliance

Tools

pgBackRest

Barman

Patroni

Azure CLI

Job description

Tranzeal Incorporated is hiring a Senior PostgreSQL DBA in West Los Angeles for a hybrid role. You will design, implement, and operate enterprise PostgreSQL databases across Linux and Windows, centered on high availability, disaster recovery, and performance optimization.

The ideal candidate will oversee replication, backups, security, and upgrades, while contributing to Terraform/Bicep-based infrastructure as code and production incident response.