Allstate

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.

This listing is sourced directly from Allstate's careers page and normalized into a canonical job model.