Note: The job is a remote job and is open to candidates in USA. Allstate Identity Protection is a subsidiary of The Allstate Corporation, focused on providing innovative protection against digital fraud. They are seeking a Lead Consultant - Database Administrator to manage and optimize enterprise database platforms while ensuring security and reliability in a collaborative environment.
Responsibilities
- In this role, you will administer and support enterprise database platforms including SQL Server, MongoDB, MySQL/MariaDB, and PostgreSQL. You will monitor, tune, and optimize database performance, availability, and reliability while supporting installations, upgrades, patching, lifecycle management, and capacity planning
- You will also support high-availability and disaster recovery solutions, including clustering, replication, backup, and recovery strategies. A key focus for this role will include supporting active-active disaster recovery capabilities and helping ensure database environments are designed for resilience across critical production systems
- You will partner closely with application developers, infrastructure teams, and data engineering stakeholders to troubleshoot application performance issues, improve database design, strengthen security and access controls, and contribute to automation and modernization initiatives
Skills
- High School Diploma/GED
- 8+ years of progressive experience in Microsoft SQL Server database administration
- Experience with additional database platforms such as MongoDB, MySQL, or MariaDB
- Strong expertise in SQL Server performance tuning, security, backup/recovery, and Always On Availability Groups
- 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
- Familiarity with Nutanix or other enterprise virtualization platforms
- Experience with PostgreSQL administration and support
- Experience with SQL Server High Availability and Disaster Recovery 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
Benefits
- Annual Bonus: Eligible, and up to 20% of base salary
- 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
- 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
Company Overview