Senior Lead Database Administrator for High Availability & Performance

Allstate Insurance; Illinois; On-site; USD 140,000 - 160,000; Full time

Job summary

Allstate Identity Protection is seeking a hands-on Lead Consultant - Database Administrator to join a collaborative team supporting enterprise data platforms used by millions. The role combines deep technical DBA work with performance optimization, security, reliability engineering, and modernization across critical production systems.

You will lead from the front, assess environments, identify improvements, and drive solutions with application developers, infrastructure, and data engineering

Qualifications

• 8+ years of Microsoft SQL Server database administration experience.
• Experience with MongoDB, MySQL or MariaDB.
• Strong SQL Server performance tuning, security, backup/recovery, and Always On availability groups.
• Experience supporting databases in virtualized environments.
• Proven ability to troubleshoot complex database, application connectivity, and data integration issues.
• Strong analytical, problem-solving, communication, and stakeholder partnership skills.

Responsibilities

• Administer and support enterprise database platforms including SQL Server, MongoDB, MySQL/MariaDB, and PostgreSQL; monitor, tune, and optimize performance while handling installations, upgrades, patching, lifecycle management, and capacity planning.
• Support high-availability and disaster recovery solutions, including clustering, replication, backup, and recovery strategies; focus on active-active DR capabilities and resilience across production systems.
• Partner with application developers, infrastructure teams, and data engineering stakeholders to troubleshoot performance issues, improve design, strengthen security, and drive automation and modernization initiatives.

Skills

SQL Server

Database Design

DBMS

Performance Tuning

Security & Compliance

Job description

Allstate Identity Protection is seeking a hands-on Lead Consultant - Database Administrator to join a collaborative team supporting enterprise data platforms used by millions. The role combines deep technical DBA work with performance optimization, security, reliability engineering, and modernization across critical production systems.

You will lead from the front, assess environments, identify improvements, and drive solutions with application developers, infrastructure, and data engineering