SQL Database Administrator - Lead Consultant

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.

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.

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. Technical Skill Set: 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 AIP2024 Compensation: The a nnual salary offered will be in the range of $140,000- $160,000. Please ignore the range given below as that constitutes the entirety of the job profile range. Annual Bonus: Eligible, and up to 20% of base salary Skills Database Administration, Database Design, Database Management Systems (DBMS), Database Performance, Data Modeling