Senior PostgreSQL DBA – High Availability & DR Expert

Allstate; Alton (IL); On-site; USD 110,000 - 181,000; Full time

Benefits offered by this job

Laptop provided

Connectivity reimbursement

Job summary

Allstate is seeking an experienced Senior PostgreSQL Database Administrator to join the Database Engineering team. This role will own the design, deployment, and operation of enterprise PostgreSQL environments across on-premises and cloud platforms.

You will lead HA, backup, restore, performance tuning, security, and automation initiatives while partnering with application, security, SRE, and cloud teams to drive reliability and scalability.

Qualifications

• 7+ years of database administration experience.
• 7+ years of hands-on PostgreSQL administration experience.
• Strong Linux administration and PostgreSQL expertise.
• Experience with high availability, disaster recovery, and maintenance.
• Ability to collaborate with engineering, security, SRE, and cloud teams.

Responsibilities

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

Skills

Linux administration

PostgreSQL architecture

SQL/Query optimization

Troubleshooting production incidents

Upgrades and migrations

cross-team communication

Tools

Patroni

etcd

HAProxy

Keepalived

pgBackRest

WAL management

Azure AWS GCP

Datadog/Prometheus/Grafana

Ansible

Terraform

GitHub/GitLab/CI/CD

Job description

Allstate is seeking an experienced Senior PostgreSQL Database Administrator to join the Database Engineering team. This role will own the design, deployment, and operation of enterprise PostgreSQL environments across on-premises and cloud platforms.

You will lead HA, backup, restore, performance tuning, security, and automation initiatives while partnering with application, security, SRE, and cloud teams to drive reliability and scalability.