Allstate
Lead Consultant -Database Administration (SQL, MongoDB)
US - Remote
Sponsorship not specified$140k-$160kDetected 26 days ago
PowerShellSQLPostgreSQLMySQLMongoDBData EngineeringCommunicationCollaborationProblem Solving
Stay score
odds of building a lasting career here
50Sponsors, lottery-bound
Cap-exempt (no lottery)0
Sponsors this role65
Entry-level history0
PERM / green-card track0
Lottery odds (Level III)83
Fits your clock70
Sponsors, but it's cap-subject — you still face the weighted lottery (~45% per draw at Level III). Good if you win; have a cap-exempt backup on your list.
Lottery odds assume a STEM candidate.
Personalize to your clock →Community outcomes
No reports yet — be the first to help the next applicant.
About the role
- 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.
- This hands-on role combines database administration, performance optimization, security, and reliability engineering across mission-critical environments.
Responsibilities
- Support high-availability and disaster recovery solutions, including clustering, replication, backup, and recovery strategies.
- Database Administration, Database Design, Database Management Systems (DBMS), Database Performance, Data Modeling
Requirements
- 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.
- Employees must be able to remain stationary for extended periods and must be able to observe and interpret written and/or verbal communication.
- 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.
- Employment Criteria: The candidate(s) offered this position will be required to submit to a background investigation, which includes a drug screen
- The candidate(s) offered this position will be required to submit to a background investigation, which includes a drug screen
Nice to have
- 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.
- Please ignore the range given below as that constitutes the entirety of the job profile range.
- Joining our team isn't just a job - it's an opportunity.
Skills
- Compensation
- One that takes your skills and pushes them to the next level.
- 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 ".
- To view the FMLA poster, click " here ".
Compensation
- The a nnual salary offered will be in the range of $140,000- $160,000.
- Eligible, and up to 20% of base salary
- Compensation offered for this role is 98,100.00 - 167,850.00 annually and is based on experience and qualifications.
- 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.
Benefits
- This poster summarizing the major provisions of the Family and Medical Leave Act (FMLA) and telling employees how to file a complaint.
Company info
- We combine our advanced investigative systems with our expertise in working with businesses to ensure our customers remain protected from any online threat.
- Joining our team means being part of something bigger - a winning team making a meaningful impact.
- 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
- We are committed to the full inclusion of all qualified individuals.
- 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.
Equal opportunity
- Please let us know if you need a reasonable accommodation.
Apply directly at Allstate →Create a free account for alerts like thisView Allstate immigration profile
This listing is sourced directly from Allstate's careers page and normalized into a canonical job model.