PostgreSQL DBA
Position Overview:
We are seeking a highly experienced Senior PostgreSQL Database Administrator (DBA) to own the architecture, performance, availability, security, and disaster recovery of enterprise PostgreSQL environments hosted on Microsoft Azure. This is a hands-on senior engineering role requiring deep expertise in Azure Database for PostgreSQL Flexible Server, high availability (HA), disaster recovery (DR), and active-active/active-passive replication.
Key Responsibilities:
Design, implement, and manage PostgreSQL high-availability and disaster recovery solutions, including active-passive and active-active replication.
Administer Azure Database for PostgreSQL Flexible Server, including read replicas, backups, point-in-time recovery, geo-redundancy, and major version upgrades.
Manage self-hosted PostgreSQL databases on Azure VMs running Red Hat Linux, CentOS, and Windows Server.
Configure and troubleshoot streaming replication, logical replication, Patroni, etcd, pglogical, HAProxy, and PgBouncer.
Optimize database performance through query tuning, indexing, partitioning, execution plan analysis, and memory management.
Implement database security, authentication, encryption, access controls, and compliance requirements.
Lead critical database incident response, troubleshoot production issues, and develop recovery procedures and technical runbooks.
Automate database infrastructure and administration using Terraform, Bicep, Ansible, Azure CLI, and PowerShell.
Plan and execute database migrations, upgrades, backup validation, and disaster recovery testing.
Provide technical mentorship to junior DBAs and collaborate with cross-functional engineering teams.
Required Qualifications:
7+ years of hands-on PostgreSQL database administration experience, including PostgreSQL 14 or later.3+ years of PostgreSQL experience on Microsoft Azure, including 2+ years with Azure Database for PostgreSQL Flexible Server.
Strong production experience designing and managing active-passive HA and active-active/bi-directional replication environments.
Expertise in Azure PostgreSQL, replication, backup/recovery, failover, and disaster recovery.
Hands-on PostgreSQL administration across Linux (RHEL/CentOS) and Windows Server environments.
Strong knowledge of PostgreSQL performance tuning, query optimization, indexing, partitioning, and database security.
Experience with Terraform/Bicep, Azure CLI, PowerShell, and infrastructure automation.
Excellent communication skills, production incident management experience, and the ability to mentor junior team members.
Ability to participate in a 24x7 on-call rotation.
Preferred Qualifications:
Azure certifications such as DP-300 or AZ-305.Experience with PostgreSQL 18/19 features, Citus, pgvector, or Kubernetes-based PostgreSQL.Knowledge of SOC 2, HIPAA, or PCI DSS compliance.
Important:
Azure-hosted PostgreSQL experience is mandatory. Candidates with only on-premises or other cloud PostgreSQL experience will not be considered.