Senior PostgreSQL DBA: Platform Reliability & Automation

Allstate Corporation; Illinois; Hybrid; USD 110,000 - 181,000; Full time

Job summary

Allstate Corporation is seeking an experienced Senior PostgreSQL Database Administrator to lead and modernize our enterprise PostgreSQL platform. The role spans design, automation, security, performance, and recovery across on‑prem and cloud environments.

The candidate will drive HA/DR using Patroni, etcd, HAProxy, and streaming replication, while mentoring teams and defining engineering standards. Strong Linux and SQL skills are essential.

Qualifications

• 7+ years of database administration experience.
• 7+ years of hands‑on PostgreSQL administration experience in mission‑critical environments.
• Expert level database administration experience is preferred.
• Strong Linux administration experience (RHEL preferred).
• Experience with PostgreSQL streaming replication, HA, DR, backup and recovery, WAL management, and capacity planning.

Responsibilities

• Design, build, deploy, administer, and support enterprise PostgreSQL environments.
• Lead PostgreSQL installation, configuration, patching, upgrades, migrations, and lifecycle management.
• Define and maintain PostgreSQL engineering standards and reference architectures.
• Advise application teams on database design, scalability, and resilience.
• Design and support high‑availability and disaster recovery across multiple sites.

Skills

PostgreSQL

Linux administration

High availability

Disaster recovery

SQL performance tuning

Migrations & upgrades

Cross‑functional collaboration

Tools

pgBackRest

Patroni

etcd

HAProxy

Keepalived

AWS

Azure

GCP

Datadog

Prometheus

Grafana

Ansible

Terraform

GitHub

GitLab

CI/CD

Job description

Allstate Corporation is seeking an experienced Senior PostgreSQL Database Administrator to lead and modernize our enterprise PostgreSQL platform. The role spans design, automation, security, performance, and recovery across on‑prem and cloud environments.

The candidate will drive HA/DR using Patroni, etcd, HAProxy, and streaming replication, while mentoring teams and defining engineering standards. Strong Linux and SQL skills are essential.