Allstate Identity Protection (AIP) · United States
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
Database Administrator Lead Consultant
Allstate Identity Protection (AIP)
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.
Team & Work Scope
Join a small, highly collaborative database engineering team responsible for maintaining and modernizing the enterprise data platforms that support millions of consumers.
This hands-on role combines database administration, performance optimization, security, and reliability engineering across mission-critical environments.
You will partner closely with application developers, infrastructure teams, and data engineering stakeholders to ensure our database platforms remain secure, scalable, and highly available.
Ideal Candidate: A hands-on database professional with deep SQL Server expertise who enjoys performance tuning, solving complex technical challenges, collaborating with engineering teams, and driving operational excellence across a diverse enterprise database environment.
Essential Functions & Responsibilities
Administer and support enterprise database platforms, including SQL Server, MongoDB, MySQL/MariaDB, and PostgreSQL.
Monitor, tune, and optimize database performance, availability, and reliability.
Manage database installations, upgrades, patching, lifecycle management, and capacity planning.
Support high-availability and disaster recovery solutions, including clustering, replication, backup, and recovery strategies.
Partner with development teams to review implementations, solve application performance issues, and improve database design.
Strengthen database security, access controls, monitoring, and operational processes.
Contribute to platform modernization and automation initiatives that improve scalability and operational efficiency.
Participate in an on-call rotation supporting critical production systems.
Required Qualifications
High School Diploma/GED.
8+ years of progressive experience in Microsoft SQL Server database administration experience, along with other database experiences such as MongoDB, MySQL or MariaDB.
Strong expertise in SQL Server performance tuning, security, backup/recovery, and Always On Availability Groups (AOAG).
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.
Preferred Qualifications
Familiarity with Nutanix or other enterprise virtualization platforms.
Experience with PostgreSQL administration and support.
Experience with SQL Server High Availability (HA) and Disaster Recovery (DR) 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.
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 Modeling
Compensation
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 provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, national origin, age, disability, or veteran status.
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.
LANGUAGE REQUIREMENT: Detect the primary language used in the source document and write all generated descriptive text fields in that SAME language. For JD this includes: description_summary, intro_text, responsibilities, generated_html_description. Return salary fields separately as requested: salary_type, salary_period, salary_currency, salary_min, salary_max. Do NOT translate these fields to English unless the source is English. Detected source language code: en (English). Use this detected language for all generated narrative fields. If uncertain, default to English (en).