Senior PostgreSQL DBA — Azure HA/DR & Cloud Automation

Robotic Technologies Automation; New Jersey; On-site; USD 92,000 - 131,000; Full time

Job summary

Robotic Technologies Automation is seeking a Senior PostgreSQL DBA to design, manage, and secure production PostgreSQL databases on Microsoft Azure, including HA/DR and cross-region replication. The role covers cloud-native and self-hosted PostgreSQL across Linux and Windows environments.

The ideal candidate will optimize performance with EXPLAIN ANALYZE, handle backups and PITR, implement strong security and monitoring, and automate infrastructure with Terraform, Ansible, and PowerShell.

Qualifications

• Extensive PostgreSQL HA/DR and replication experience.
• Experience with Azure Database for PostgreSQL Flexible Server and PostgreSQL on Azure VMs.
• Proficiency in Linux (RHEL/CentOS) and Windows Server administration.
• Ability to perform performance tuning and query optimization.

Responsibilities

• Design and maintain HA/DR for PostgreSQL databases on Azure.
• Manage streaming and logical replication, including failover.
• Configure backups, PITR, and recovery procedures.
• Administer Azure PostgreSQL Flexible Server and PostgreSQL on Azure VMs.
• Perform performance tuning using EXPLAIN ANALYZE and indexing.
• Monitor health with Azure Monitor, Grafana, and Prometheus.
• Lead incident management and post-incident improvements.
• Plan migrations and major version upgrades.
• Automate infra using Terraform, Bicep, Ansible, Azure CLI, and PowerShell.
• Develop runbooks for failover, backup, and recovery.

Skills

PostgreSQL HA

Azure PostgreSQL

PostgreSQL on Azure VMs

Linux admin

Windows admin

Streaming replication

Logical replication

Patroni

etcd

pgBackRest

Query optimization

EXPLAIN ANALYZE

Tools

Terraform

Azure CLI

PowerShell

Bicep

Ansible

Grafana

Prometheus

Azure Monitor

pg_basebackup

Job description

Robotic Technologies Automation is seeking a Senior PostgreSQL DBA to design, manage, and secure production PostgreSQL databases on Microsoft Azure, including HA/DR and cross-region replication. The role covers cloud-native and self-hosted PostgreSQL across Linux and Windows environments.

The ideal candidate will optimize performance with EXPLAIN ANALYZE, handle backups and PITR, implement strong security and monitoring, and automate infrastructure with Terraform, Ansible, and PowerShell.