Senior PostgreSQL DBA - Platform Reliability & Automation

Allstate

United States

Remote

USD 110,000 - 181,000

Full time

4 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

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

You will lead installation, upgrades, migrations, and lifecycle activities, define standards, and collaborate with application, security, and SRE teams to ensure disaster recovery and operational excellence.

Qualifications

Lead Level 7+ years of database administration experience.

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.
High Availability and Disaster Recovery design and support PostgreSQL HA solutions (Patroni, etcd, HAProxy, Keepalived, streaming replication).
Implement and maintain disaster-recovery strategies across multiple sites/regions.
Plan and execute failover, switchover, recovery, and resiliency tests.
Work with stakeholders to define recovery time/point objectives.
Backup and Recovery design, implement, and operate enterprise PostgreSQL backup and recovery solutions.
Administer pgBackRest, WAL archiving, PITR, retention, recovery validation.
Conduct regular restore testing and disaster-recovery exercises.
Performance and reliability: monitor availability, capacity, health, and performance.
Analyze and optimize SQL queries, indexes, execution plans, configurations, and workloads.
Troubleshoot complex production incidents and lead root-cause analysis.
Drive database reliability, observability, capacity planning, and operational excellence.
Security and compliance: implement access controls, least privilege, auditing.
Manage roles, privileges, authentication, encryption, and credential-management integrations.
Support compliance reviews, vulnerability remediation, security assessments, and evidence requests.
Automation and DevOps: automate provisioning, configuration, deployment, patching, validation, and operations.
Use IaC, CM, source control, and CI/CD to improve repeatability.
Partner with teams to enable safe self-service and reduce manual work.
Platform operations and technical leadership: support mission-critical environments.
On-call rotations, incident response, change management, problem management.
Create runbooks, guides, standards, and docs.
Mentor engineers and provide leadership for PostgreSQL initiatives.