Database Admin Expert

Allstate

Confirmed live today High trust
Remote

Quick summary

Work type
Remote
Location
IL
Salary
$110,000–$181,025 / yr
Employment
Full-time
Posted
9 days ago
Freshness
Confirmed live today

Market check

Salary context

Competitive pay

How this pay compares to similar roles

Similar $159k
This role $146k
$100k $201k
below market most similar roles pay here above market

This role pays less than 55% of similar roles. Most pay $126,800–$191,593 — the blue band above. At the midpoint, this role pays about $146k versus about $159k for comparable roles.

Based on 240 similar postings.

Employer

About Allstate

The Allstate Corporation is one of the largest publicly held personal lines insurers in the US, widely recognized for its "You're In Good Hands With Allstate®" slogan.

Allstate currently has 51 open roles on FindRole.

Listed pay typically runs $100,000–$170,500 across 49 roles with salary data.

Most-posted roles

View all roles at Allstate

At a glance

TL;DR · Database Admin Expert

The Database Admin Expert joins the Database Engineering team to build, operate, and modernize the enterprise PostgreSQL platform. This role involves designing, deploying, and supporting PostgreSQL environments across on-premises and cloud landscapes. Key responsibilities include managing high availability, disaster recovery, security controls, and performance tuning for production and non-production environments. The successful candidate will automate database provisioning using Infrastructure as Code and manage lifecycle activities like patching and migrations. Required technical skills include deep PostgreSQL expertise, strong Linux administration (RHEL), and proficiency with tools such as Patroni, etcd, HAProxy, Keepalived, and pgBackRest. The role also requires experience with SQL optimization, streaming replication, and cloud platforms like AWS, Azure, or Google Cloud Platform to ensure database reliability and operational excellence in a regulated enterprise environment.

What you'll do

  • Design, build, deploy, and support enterprise PostgreSQL environments across production and non-production landscapes.
  • Lead PostgreSQL installation, configuration, patching, upgrades, migrations, and lifecycle management activities.
  • Design and support high-availability solutions using technologies like Patroni, etcd, HAProxy, and streaming replication.
  • Implement and operate enterprise backup and recovery solutions including pgBackRest and WAL archiving.
  • Analyze and optimize SQL queries, indexes, execution plans, and database configurations to improve performance.
  • Implement database security controls, access management standards, and encryption protocols.
  • Develop automation for database provisioning, deployment, and routine operations using Infrastructure as Code.
  • Provide on-call support for mission-critical production environments and lead root-cause analysis for complex incidents.

What we're looking for

  • 7+ years of database administration experience (preferred).
  • 7+ years of hands-on PostgreSQL administration experience supporting mission-critical production environments (highly desired).
  • 10+ years of database administration experience (preferred).
  • 8+ years of hands-on PostgreSQL administration experience supporting mission-critical production environments (preferred).
  • Strong Linux administration experience, preferably with RHEL or a comparable enterprise distribution.
  • Deep understanding of PostgreSQL architecture, internals, configuration, security, maintenance, and performance tuning.
  • Hands-on experience with PostgreSQL streaming replication, high availability, disaster recovery, backup and recovery, and capacity planning.
  • Strong SQL, execution-plan analysis, indexing, and query-optimization skills.

More like this

Similar roles

Senior Database Administrator

McKesson Corporation

Remote (Columbus, OH) +3 43 days ago
PostgreSQL Microsoft SQL Server Azure PL/pgSQL T-SQL Python PowerShell AWS RDS Google AlloyDB Oracle MySQL High Availability Disaster Recovery SQL
7+ yrs exp Remote

Lead PostgreSQL Engineer

Mastercard

O'Fallon, MO 6 days ago $122,000–$207,000
PostgreSQL AWS Aurora PostgreSQL EnterpriseDB (EDB) Terraform CloudFormation Ansible Chef Kubernetes OpenShift Oracle Cassandra MongoDB Redis CI/CD Infrastructure as Code Linux Unix Distributed Systems Microservices Platform Engineering

Senior Database Reliability Engineer (DBRE)

Okta Inc

Bellevue, WA +4 98 days ago $160,000–$220,000
PostgreSQL MySQL SQL Go Python Terraform Ansible Kubernetes Prometheus Grafana Datadog AWS GCP Kafka Debezium PgBouncer HAProxy Linux
Hybrid

Senior Database Reliability Engineer (DBRE)

Okta Inc

Bellevue, WA +4 98 days ago $160,000–$220,000
PostgreSQL MySQL SQL Go Python Terraform Ansible Kubernetes Prometheus Grafana Datadog AWS GCP Kafka Debezium PgBouncer HAProxy Linux
Hybrid

Database Management Specialist

General Dynamics

Washington, DC 134 days ago $111,155–$150,385
Database Administration Microsoft SQL Server MySQL T-SQL SQL Server Management Studio (SSMS) ETL Agile Methodology SDLC Linux Windows Administration Python Bash PHP YAML Ansible Git Jira Confluence ServiceNow Veritas NetBackup Visio SharePoint LAMP MySQL Workbench
10+ yrs exp Hybrid

Senior Database Analyst / Administrator

General Dynamics

Remote (Washington, DC) 75 days ago $114,750–$155,250
SQL Server Oracle Informix Snowflake Azure ETL CI/CD Data Warehousing Data Modeling Business Intelligence Splunk Atlassian Suite Relational Data Modeling Data Mining Predictive Modeling Agile SAFe SQL Server Management Studio
7+ yrs exp Remote