Senior PostgreSQL DBA - Azure HA/DR Expert (NJ)

Valiant Technologies LLC; New Jersey; On-site; USD 92,000 - 131,000; Full time

Job summary

Valiant Technologies LLC is seeking a Senior PostgreSQL DBA to design, manage, and secure production PostgreSQL databases on Microsoft Azure. The role focuses on high availability, disaster recovery, performance tuning, cloud infrastructure, and security.

The candidate will lead replication architectures, manage upgrades, and automate infrastructure using Terraform, Bicep, Ansible, Azure CLI and PowerShell, across Linux and Windows environments.

Qualifications

• Expertise in PostgreSQL high availability, disaster recovery, and replication.
• Experience with Azure Database for PostgreSQL Flexible Server.
• Experience managing self-hosted PostgreSQL on Azure VMs.
• Strong Linux and Windows Server administration knowledge.
• Proficiency with streaming and logical replication, Patroni, and etcd.
• Experience with pgBackRest, Barman, and pg_basebackup.
• Strong performance tuning, indexing, and partitioning skills.
• Knowledge of Azure networking, security, and encryption.
• Experience with monitoring, incidents, migrations, and upgrades.
• Automation using Terraform, Bicep, Ansible, or PowerShell.

Responsibilities

• Design, implement, and maintain HA/DR for PostgreSQL on Azure.
• Manage active-passive and active-active replication architectures.
• Configure automated failover, read replicas, cross-region replication, backups, and recovery.
• Administer Azure PostgreSQL Flexible Server and self-managed PostgreSQL on Azure VMs.
• Manage PostgreSQL on Linux (RHEL/CentOS) and Windows Server environments.
• Configure Azure networking, private endpoints, authentication, and encryption.
• Tune performance using EXPLAIN ANALYZE, pg_stat_statements, and indexing.
• Manage backups, point-in-time recovery, WAL archiving, and restores.
• Implement security, access controls, TLS, and auditing requirements.
• Monitor health and lag with Azure Monitor, Prometheus, and Grafana.
• Lead critical incidents, root-cause analysis, and post-incident improvements.
• Plan migrations and major PostgreSQL version upgrades.
• Automate infra and admin tasks with Terraform, Bicep, Ansible, Azure CLI, and PowerShell.
• Develop and maintain runbooks for failover, backup, recovery, and upgrades.

Skills

PostgreSQL HA

Disaster recovery

Streaming replication

Logical replication

Patroni

Azure PostgreSQL

Linux administration

Windows Server admin

pgBackRest

Barman

pg_basebackup

Query optimization

Indexing

Partitioning

Azure networking

Encryption

Monitoring

Incident management

Migrations

Terraform

Bicep

Ansible

PowerShell

Job description

Valiant Technologies LLC is seeking a Senior PostgreSQL DBA to design, manage, and secure production PostgreSQL databases on Microsoft Azure. The role focuses on high availability, disaster recovery, performance tuning, cloud infrastructure, and security.

The candidate will lead replication architectures, manage upgrades, and automate infrastructure using Terraform, Bicep, Ansible, Azure CLI and PowerShell, across Linux and Windows environments.