Senior PostgreSQL DBA — Azure HA/DR & Cloud Automation

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

Job summary

Ethereum Technologies in Basking Ridge, NJ is seeking an experienced Senior PostgreSQL DBA to design, manage, and secure production PostgreSQL databases hosted on Microsoft Azure. The ideal candidate will own HA/DR, replication (streaming and logical), backups, upgrades, performance tuning, security, and cloud infrastructure, with hands-on administration across Linux and Windows environments.

Strong scripting and automation skills with Terraform, Ansible, Azure CLI, PowerShell, and monitoring

Qualifications

• Must have extensive PostgreSQL HA/DR experience.
• Experience with Azure Database for PostgreSQL Flexible Server.
• Experience managing self-hosted PostgreSQL on Azure VMs.
• Strong Linux (RHEL/CentOS) and Windows Server administration.
• Expertise in streaming and logical replication, Patroni, etcd.
• Experience with pgBackRest, Barman, pg_basebackup backups.
• Strong performance tuning and query optimization.
• Knowledge of Azure networking, security, and encryption.
• Experience with monitoring, incidents, migrations, and upgrades.
• Infrastructure automation with Terraform, Ansible, PowerShell, or similar.

Responsibilities

• Design and maintain high-availability and disaster-recovery for PostgreSQL on Azure.
• Manage active-passive and active-active replication and backup strategies.
• Configure automated failover, read replicas, cross-region replication, and recovery procedures.
• Administer Azure PostgreSQL Flexible Server and self-managed PostgreSQL on Azure VMs.
• Handle PostgreSQL across Linux and Windows environments.
• Configure Azure networking, private endpoints, and encryption.
• Tune performance using EXPLAIN ANALYZE, indexing, and partitioning.
• Manage backups, PITR, WAL archiving, and restore testing.
• Implement security, access controls, TLS, auditing, and compliance.
• Monitor health and lag with Azure Monitor, Prometheus, Grafana, and logs.
• Lead incidents, root-cause analysis, and post-incident improvements.
• Plan migrations and major version upgrades.
• Automate with Terraform, Bicep, Ansible, Azure CLI, and PowerShell.

Skills

PostgreSQL HA

PostgreSQL DR

Azure PostgreSQL

Linux admin

Windows Server admin

Replication (Streaming)

Patroni/etcd

pgBackRest/Barman

Performance tuning

Terraform/Ansible

Tools

Azure CLI

PowerShell

Terraform

Ansible

Bicep

Job description

Ethereum Technologies in Basking Ridge, NJ is seeking an experienced Senior PostgreSQL DBA to design, manage, and secure production PostgreSQL databases hosted on Microsoft Azure. The ideal candidate will own HA/DR, replication (streaming and logical), backups, upgrades, performance tuning, security, and cloud infrastructure, with hands-on administration across Linux and Windows environments.

Strong scripting and automation skills with Terraform, Ansible, Azure CLI, PowerShell, and monitoring