Lead Consultant -Database Administration (SQL, MongoDB)
About The Position
Allstate Identity Protection is looking for a hands-on, highly experienced Database Administrator Lead Consultant to join a small, collaborative database engineering team supporting enterprise data platforms used by millions of consumers. This role combines deep technical database administration with performance optimization, security, reliability engineering, and modernization across mission-critical environments. This is an opportunity for someone who does more than maintain systems. We are looking for a proactive technical leader who can assess the environment, identify opportunities for improvement, and drive solutions forward without waiting to be directed. The ideal candidate is a go-getter who enjoys solving complex problems, partnering across teams, and helping shape a more scalable, secure, and resilient database ecosystem.
Requirements
- High School Diploma/GED.
- 8+ years of progressive experience in Microsoft SQL Server database administration.
- Experience with additional database platforms such as MongoDB, MySQL, or MariaDB.
- Strong expertise in 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.
Nice To Haves
- Familiarity with Nutanix or other enterprise virtualization platforms.
- Experience with PostgreSQL administration and support.
- Experience with SQL Server High Availability and Disaster Recovery architectures.
- PowerShell scripting and database automation experience.
- Experience with MongoDB replica sets, production upgrades, and monitoring tools.
- Experience with MySQL/MariaDB replication and enterprise platform support.
Responsibilities
- Administer and support enterprise database platforms including SQL Server, MongoDB, MySQL/MariaDB, and PostgreSQL.
- Monitor, tune, and optimize database performance, availability, and reliability.
- Support installations, upgrades, patching, lifecycle management, and capacity planning.
- Support high-availability and disaster recovery solutions, including clustering, replication, backup, and recovery strategies.
- Support active-active disaster recovery capabilities and help ensure database environments are designed for resilience across critical production systems.
- Partner closely with application developers, infrastructure teams, and data engineering stakeholders to troubleshoot application performance issues, improve database design, strengthen security and access controls, and contribute to automation and modernization initiatives.
Benefits
- Annual Bonus: Eligible, and up to 20% of base salary
- Comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse.
- Monthly connectivity reimbursement to help offset internet costs for remote employees.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
High school or GED
