> Markdown version of [/jobs/ext/2037275-lead-consultant-database-administration-sql-mongodb](https://www.wearedevelopers.com/jobs/ext/2037275-lead-consultant-database-administration-sql-mongodb). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Consultant -Database Administration (SQL, MongoDB) - **Company:** Allstate Corporation - **Location:** Chicago, IL, United States (Remote available) - **Experience:** Expert - **Salary:** $140,000.0 - $160,000.0 - **Contract:** Permanent contract - **Skills:** Software Applications, Application Performance Management, Collaborative Software, Databases, Information Engineering, Data Integration, Database Design, Disaster Recovery, Monitoring of Systems, PostgreSQL, MariaDB, Microsoft SQL Server, MongoDB, MySQL, Office Suite, Performance Tuning, Windows PowerShell, Reliability Engineering, SQL Databases, Virtualization Technology, Enterprise Data Management, System Availability, Database Performance, Nutanix - **Published:** August 12, 2026 - **Apply:** https://jobs.localjobnetwork.com/apply/add/87888044/1 ## About the Role * 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. Preferred Qualifications * 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., 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. ## Description We are looking for a hands-on, highly experienced Database Administrator Lead Consultant to join a small, collaborative database engineering team supporting enterprise data platforms used by millions of consumers. This role combines deep technical database administration with performance optimization, security, reliability engineering, and modernization across mission-critical environments. This is an opportunity for someone who does more than maintain systems. We are looking for a proactive technical leader who can assess the environment, identify opportunities for improvement, and drive solutions forward without waiting to be directed. The ideal candidate is a go-getter who enjoys solving complex problems, partnering across teams, and helping shape a more scalable, secure, and resilient database ecosystem. What You'll Do * 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. Why This Role Matters * Our database platforms support critical services at scale, and this role will help ensure those environments remain reliable, secure, performant, and ready for future growth. * If you are a seasoned SQL Server database professional who enjoys leading from the front, improving complex environments, and partnering across teams to solve meaningful technical problems, this role offers the opportunity to make a direct impact. Leadership Profile We're Looking For * Take ownership of complex database challenges and proactively recommend improvements. * Lead through influence while working across application, infrastructure, and data engineering teams. * Communicate clearly with technical and non-technical stakeholders. * Balance hands-on execution with strategic thinking around performance, reliability, scalability, and operational excellence. * Navigate growing data environments, including large-scale communications data, and help determine practical ways to optimize cost, performance, and platform fit., 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. ## Related Videos - [Shipping Faster with Less: Render on Cloud Hosting, AI Workloads, and the Future of DevOps](https://www.wearedevelopers.com/videos/1894-shipping-faster-with-less-render-on-cloud-hosting-ai-workloads-and-the-future-of-devops) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [40 Minutes to Build a Serverless COVID-19 REST and GraphQL APIs](https://www.wearedevelopers.com/videos/208-40-minutes-to-build-a-serverless-covid-19-rest-and-graphql-apis) - [Remote Driving on Plant Grounds with State-of-the-Art Cloud Technologies](https://www.wearedevelopers.com/videos/251-remote-driving-on-plant-grounds-with-state-of-the-art-cloud-technologies) - [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app) - [NoSQL Data Modeling for Front-end Developers](https://www.wearedevelopers.com/videos/297-nosql-data-modeling-for-front-end-developers) ## Related Articles - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Best Paying Remote Jobs](https://www.wearedevelopers.com/magazine/255-best-paying-remote-jobs) - [Remote Work: Best Practices for Developers](https://www.wearedevelopers.com/magazine/315-remote-work-best-practices-for-developers) - [The Best Job Search Websites of 2025](https://www.wearedevelopers.com/magazine/368-the-best-job-search-websites-of-2025) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)