Database Admin Expert

Job not on LinkedIn

🔥 0 minutes ago

🌽 Illinois – Remote

🌽 Illinois – Remote

💵 $110k - $181k / year

⏰ Full Time

🟠 Senior

🔴 Lead

📀 Database Administrator

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 0%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Allstate

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1931

💼 Consulting

📦 Logistics

🛡️ Insurance

💰 Post-IPO Equity on 2014-01

Consulting • Logistics • Insurance

Allstate is an industry leader in providing insurance solutions, focusing on home, auto, device, and identity protection. With a commitment to customer well-being, Allstate aims to instill peace of mind and financial security for its customers. The company also emphasizes community impact and sustainability through various initiatives, showcasing their dedication to social responsibility and positive change.

📋 Description

• 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 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 • Plan and execute failover, switchover, recovery, and resiliency tests • Define, validate, and maintain recovery time and recovery point objectives with stakeholders • Design, implement, and operate PostgreSQL backup and recovery solutions • Administer pgBackRest, WAL archiving, point-in-time recovery, retention, and recovery validation processes • Conduct restore testing and support disaster-recovery exercises • 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 • Partner with engineering teams to expand safe self-service capabilities and reduce manual operational effort • Support 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

🎯 Requirements

• 7+ years of hands-on PostgreSQL administration experience supporting mission-critical production environments for Lead level (highly desired) • 10+ years of database administration experience for Expert level • 8+ years of hands-on PostgreSQL administration experience supporting mission-critical production environments for Expert level • Strong Linux administration experience; RHEL or a comparable enterprise Linux distribution is preferred • 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, point-in-time recovery, WAL management, and capacity planning • Strong SQL, execution-plan analysis, indexing, and query-optimization skills • Proven ability to troubleshoot complex database, operating system, storage, and connectivity issues in production environments • Experience planning and executing database upgrades, migrations, patching, and production changes • Experience with Percona Distribution for PostgreSQL or Percona-supported PostgreSQL environments is preferred • Hands-on experience with Patroni, etcd, HAProxy, Keepalived, pgBackRest, and PostgreSQL-native monitoring and diagnostic tools is preferred • Experience with cloud database and infrastructure platforms such as Microsoft Azure, Amazon Web Services, or Google Cloud Platform is preferred • Experience with observability platforms such as Datadog, Prometheus, Grafana, or Percona Monitoring and Management is preferred • Experience with automation and delivery tools such as Ansible, Terraform, GitHub, GitLab, or CI/CD pipelines is preferred • Exposure to other database technologies such as Oracle, SQL Server, MySQL, MongoDB, or Neo4j is preferred • Experience leading technical initiatives, mentoring team members, and influencing platform standards is preferred • Ability to communicate clearly with technical and non-technical stakeholders and work effectively across organizational boundaries • Successful completion of a background investigation • Reliable internet with minimum speeds of 50 MB download and 5 MB upload • Dedicated, private workspace free from distractions with appropriate desk and seating • Allstate generally does not sponsor individuals for employment-based visas for this position

🏖️ Benefits

• Comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse • Monthly connectivity reimbursement to help offset internet costs for employees eligible to work from home