Job Description

At Allstate, great things happen when our people work together to protect families and their belongings from life's uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers' evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection.

The Senior Consultant II creates database structures for medium to large projects, provides support in the day to day operational management of Database Technologies and aids in software maintenance lifecycle management with little to no assistance. The individual analyzes, consults, and recommends different options for database performance tuning, database configuration implementation, creates and maintains scripts and test plan execution.
We are looking for a skilled and detail-oriented MongoDB DBA to join our dynamic team.


The ideal candidate will have hands-on experience in developing, managing, and optimizing MongoDB databases for scalable and high-performance applications.


You will work closely with developers, architects, and DevOps teams to ensure database efficiency, integrity, and security.


Responsibilities


Able to handle Production issues.


Design and develop MongoDB databases and collections to support application needs.


Implement and optimize CRUD operations, indexing strategies, and data aggregation pipelines.


Monitor database performance and proactively identify optimization opportunities.


Work with development teams to model data and integrate MongoDB with backend systems.


Ensure data integrity and security through proper access control, backup strategies, and monitoring.


Write scripts and tools for data migration, transformation, and reporting.


Participate in design and code reviews, contributing to best practices in database development.


Collaborate with DevOps teams for MongoDB deployment, scaling, and monitoring in cloud/on-prem environments.


Provide technical support for database-related issues and troubleshoot production problems.


Requirements


Strong proficiency in MongoDB, including schema design, indexing, and aggregation framework.


Experience with MongoDB Atlas and managing cloud-hosted databases.


Solid understanding of NoSQL principles and how they differ from traditional RDBMS.


Hands-on experience with MongoDB tools (Compass, Atlas CLI, mongodump/mongorestore, etc. ).


Familiarity with JSON, BSON, REST APIs, and data integration concepts.


Knowledge of performance tuning and replication/sharding strategies.


Experience with version control systems like Git..

Education

4 year Bachelors Degree (Preferred)

Experience

8 or more years of experience (Preferred)

Supervisory Responsibilities

This job does not have supervisory duties.

Education & Experience (in lieu)

In lieu of the above education requirements, an equivalent combination of education and experience may be considered.

Primary Skills

Database Administration, Database Design, Database Management Systems (DBMS), Database Performance, Data Modeling

Shift Time

Shift B (India)

Recruiter Info

Shriya Kumari
skuow@allstate.com

About Allstate

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.

The Allstate Corporation is one of the largest publicly held insurance providers in the United States. Ranked No. 84 in the 2023 Fortune 500 list of the largest United States corporations by total revenue, The Allstate Corporation owns and operates 18 companies in the United States, Canada, Northern Ireland, and India. Allstate India Private Limited, also known as Allstate India, is a subsidiary of The Allstate Corporation. The India talent center was set up in 2012 and operates under the corporation's Good Hands promise. As it innovates operations and technology, Allstate India has evolved beyond its technology functions to be the critical strategic business services arm of the corporation. With offices in Bengaluru and Pune, the company offers expertise to the parent organization's business areas including technology and innovation, accounting and imaging services, policy administration, transformation solution design and support services, transformation of property liability service design, global operations and integration, and training and transition.


Learn more about Allstate India here.