SQL Database Administrator - Lead Consultant
About The Position
Allstate Identity Protection is a part of The Allstate Corporation, which means we have the same innovative drive that keeps us a step ahead of our customers’ evolving needs. We combine our advanced investigative systems with our expertise in working with businesses to ensure our customers remain protected from any online threat. Note: Though this role is remote, we require candidates to be local to Arizona. We are Allstate Identity Protection (formerly, InfoArmor), a wholly owned subsidiary, and Business Unit of Allstate since 2019. We are committed to making digital life easier, safer, and more rewarding by offering innovative protection against digital fraud, so members can live confidently online. We are seeking a Database Administrator Lead Consultant to provide “hands on” technical leadership across our enterprise database platforms, ensuring they remain secure, reliable, scalable, and high performing. This is an excellent opportunity for a hands-on database professional who enjoys solving complex infrastructure challenges, driving modernization initiatives, and influencing the future of enterprise data services.
Requirements
- High School Diploma/GED
- 8+ years of progressive database administration experience with Microsoft SQL Server.
- 2+ years of hands-on DBA experience with MongoDB, MySQL (or) MariaDB.
- Strong analytical and problem-solving abilities.
- Ability to work independently while collaborating effectively across teams.
- Excellent communication and stakeholder management skills.
- Passion for continuous improvement, automation, and operational excellence.
- Curiosity to learn and adapt in a fast-moving technology environment.
- Strong knowledge of Microsoft SQL Server technologies, including: SSMS, Always On Availability Groups (AOAG), Performance tuning and optimization, Security and encryption, Partitioning, SSIS and SSRS, Data synchronization technologies.
- Experience with: SQL Server High Availability (HA) and Disaster Recovery (DR), SQL automation and deployment strategies, PowerShell (preferred), Windows and SQL administration utilities.
- MongoDB experience, including: Production upgrades, Replica set deployment and administration, Percona MongoDB and monitoring tools (PMM).
- MySQL/MariaDB administration experience, including: Production upgrades, Replication and replica set configuration, Enterprise platform support.
Nice To Haves
- PowerShell (preferred)
Responsibilities
- Own the administration, performance, availability, and security of mission-critical database environments while partnering closely with application, infrastructure, and engineering teams.
- Lead administration and support of enterprise database platforms including SQL Server, MongoDB, MySQL/MariaDB, and PostgreSQL.
- Manage database installations, upgrades, patching, lifecycle management, and capacity planning.
- Monitor platform health and proactively optimize performance, reliability, and availability.
- Drive incident resolution, problem management, and operational excellence initiatives.
- Implement and maintain high-availability and disaster recovery solutions, including backup, recovery, replication, and failover capabilities.
- Partner with engineering and infrastructure teams to design and optimize database architectures.
- Strengthen database security, access controls, and governance practices.
- Develop automation, monitoring solutions, and operational processes that improve scalability and efficiency.
- Support cloud and platform modernization efforts as part of our evolving data strategy.
- Provide technical mentorship and guidance on database best practices and performance optimization.
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
