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.
Job Description
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.
What You'll Do
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.
Required Qualifications:
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 annual 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 ModelingCompensation
Compensation offered for this role is 98,100.00 - 167,850.00 annually and is based on experience and qualifications.Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.
Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component.
For jobs in San Francisco, please click “here” for information regarding the San Francisco Fair Chance Ordinance.
For jobs in Los Angeles, please click “here” for information regarding the Los Angeles Fair Chance Initiative for Hiring Ordinance.
To view the “EEO Know Your Rights” poster click “here”. This poster provides information concerning the laws and procedures for filing complaints of violations of the laws with the Office of Federal Contract Compliance Programs.
To view the FMLA poster, click “here”. This poster summarizing the major provisions of the Family and Medical Leave Act (FMLA) and telling employees how to file a complaint.
It is the Company’s policy to employ the best qualified individuals available for all jobs. Therefore, any discriminatory action taken on account of an employee’s ancestry, age, color, disability, genetic information, gender, gender identity, gender expression, sexual and reproductive health decision, marital status, medical condition, military or veteran status, national origin, race (include traits historically associated with race, including, but not limited to, hair texture and protective hairstyles), religion (including religious dress), sex, or sexual orientation that adversely affects an employee's terms or conditions of employment is prohibited. This policy applies to all aspects of the employment relationship, including, but not limited to, hiring, training, salary administration, promotion, job assignment, benefits, discipline, and separation of employment.
We are Allstate Identity Protection (formerly, InfoArmor), a wholly owned subsidiary of The Allstate Corporation. We go beyond the typical identity theft protection! Our Allstate Digital Footprint™, identity theft and credit monitoring services, fraud remediation and restoration services help our subscribers safeguard their personal information, data they share online, and the relationships they treasure.
Employment Criteria: The candidate(s) offered this position will be required to submit to a background investigation, which includes a drug screen
Work Environment: Except for our Customer Care roles which necessitates onsite work, most other roles are remote. AIP is a remote-first company; however, our roles are open to in-office or flex work if you live in a city with a physical office location
Physical Demands: We primarily collaborate with our colleagues through virtual meetings and office collaboration tools. Employees will have to operate a laptop computer (PC or Mac available), computer software platforms, and other office productivity machinery, as necessary. Employees must be able to remain stationary for extended periods and must be able to observe and interpret written and/or verbal communication.
Additional Information: AIP provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
We are committed to the full inclusion of all qualified individuals. As part of this commitment, AIP will provide reasonable accommodations to all qualified individuals with disabilities to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment. Please let us know if you need a reasonable accommodation.
AIP uses the E-Verify employment verification program.
Allstate provides a comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse. Employees eligible to work from home also receive a monthly connectivity reimbursement to help offset internet costs.
When working from home, you must have a dedicated, private workspace free from distractions, along with appropriate desk and seating. Reliable internet is required, with minimum speeds of 50 MB download and 5 MB upload.