Senior PostgreSQL DBA

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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Senior PostgreSQL DBA
Location: Basking Ridge NJ
Duration: 6 Months + Extension
Bill Rate: $81/hour
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

Job Description

We are seeking an experienced Senior PostgreSQL DBA to design, manage, optimize, and secure production PostgreSQL databases hosted on Microsoft Azure. The ideal candidate will have strong hands‑on expertise in PostgreSQL administration, high availability, disaster recovery, performance tuning, cloud infrastructure, and database security.

Key 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 (RHEL, CentOS Stream) 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.

Required Skills:

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

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.