Senior PostgreSQL Platform Engineer

Allstate Foundation; Illinois; On-site; USD 110,000 - 181,000; Full time

Job summary

Allstate Foundation is seeking an experienced Senior PostgreSQL Database Administrator to join the Database Engineering team and modernize our enterprise PostgreSQL platform. You will design, implement, secure, and optimize PostgreSQL across on-premises and cloud environments, ensuring high availability and robust backup strategies.

You will partner with application, security, SRE, and cloud teams, lead migrations and upgrades, and contribute to platform standards.

Qualifications

• 7+ years of database administration experience.
• 7+ years of hands-on PostgreSQL administration experience (production).
• Strong Linux administration skills and experience with HA/DR technologies.

Responsibilities

• Design, build, deploy, administer, and support enterprise PostgreSQL environments across production and non-production landscapes.
• Lead PostgreSQL installation, configuration, patching, upgrades, migrations, and lifecycle management.
• Define engineering standards, reference architectures, and operational controls for PostgreSQL.

Skills

PostgreSQL

Linux

High availability

Backup and recovery

SQL performance tuning

DevOps

Cloud platforms

Tools

Patroni

etcd

HAProxy

Keepalived

pgBackRest

Datadog

Job description

Allstate Foundation is seeking an experienced Senior PostgreSQL Database Administrator to join the Database Engineering team and modernize our enterprise PostgreSQL platform. You will design, implement, secure, and optimize PostgreSQL across on-premises and cloud environments, ensuring high availability and robust backup strategies.

You will partner with application, security, SRE, and cloud teams, lead migrations and upgrades, and contribute to platform standards.