Senior PostgreSQL Platform Engineer

Allstate; Northbrook (IL); Remote; USD 110,000 - 181,000; Full time

Job summary

Allstate is seeking an experienced Senior PostgreSQL Database Administrator to join the Database Engineering team. You will design, implement, and operate enterprise PostgreSQL environments across on‑premises and cloud platforms, focusing on performance, security, and reliability.

The role requires 7+ years of PostgreSQL experience, strong Linux skills, and a proven track record in HA, DR, and automation. You will mentor engineers and lead critical database initiatives in a large, regulated

Qualifications

• 7+ years of database administration experience (lead level).
• 7+ years of hands-on PostgreSQL administration experience in production environments.

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 activities.
• Define and maintain PostgreSQL engineering standards, reference architectures, build procedures, operational controls, and best practices.
• Participate in architecture reviews and advise application teams on database design, scalability, resilience, and operational readiness.
• Design and support PostgreSQL high-availability solutions using Patroni, etcd, HAProxy, Keepalived, and streaming replication.
• Implement and maintain disaster-recovery strategies across multiple sites or regions.
• Design, implement, and operate enterprise PostgreSQL backup and recovery solutions.
• Monitor database availability, capacity, health, and performance.
• Analyze and optimize SQL queries, indexes, execution plans, database configurations, and workloads.
• Troubleshoot complex production incidents, lead root‑cause analysis, and implement preventive actions.
• Drive database reliability, observability, capacity planning, and operational excellence initiatives.
• Implement database security controls, access‑management standards, and least‑privilege practices.
• Manage roles, privileges, authentication, encryption, auditing, and credential‑management integrations.
• Support compliance reviews, vulnerability remediation, security assessments, and evidence requests.
• Develop automation for database provisioning, configuration, deployment, patching, validation, and routine operations.
• Use Infrastructure as Code, configuration management, source control, and CI/CD practices to improve consistency and repeatability.
• Partner with engineering teams to expand safe self‑service capabilities and reduce manual operational effort.
• Provide support for mission‑critical production and non‑production PostgreSQL environments.
• Participate in on‑call rotations, major incident response, change management, and problem management.
• Create and maintain runbooks, troubleshooting guides, standards, and operational documentation.
• Mentor engineers, review technical solutions, and provide technical leadership for PostgreSQL initiatives.

Skills

PostgreSQL

Linux administration

High availability

Performance tuning

SQL optimization

Incident troubleshooting

Cloud platforms

Tools

Patroni

etcd

HAProxy

Keepalived

pgBackRest

Monitoring tools

Job description

Allstate is seeking an experienced Senior PostgreSQL Database Administrator to join the Database Engineering team. You will design, implement, and operate enterprise PostgreSQL environments across on‑premises and cloud platforms, focusing on performance, security, and reliability.

The role requires 7+ years of PostgreSQL experience, strong Linux skills, and a proven track record in HA, DR, and automation. You will mentor engineers and lead critical database initiatives in a large, regulated