Postgresql DBA

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.

Job Description

The Consultant II creates basic 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 assistance. The individual assists with database performance tuning and consultation, database configuration implementation, creates and maintains scripts and test plan execution.

• Installs/creates low complexity database based on established documented procedures
• Assists and in some cases lead root-cause analysis on minor incidents; participate with DBMS vendors and others to determine causes and solutions for database problems/issues
• Installs client tools and drivers based on established documented procedures; assist with installing and maintaining database tools/utilities to support the DBMS environment
• Performs basic DDL implementation, such as creating tables, indexes, schemas, and setting up security; perform basic database maintenance services for application development teams
• Able to convert logical data models into physical data models for basic application databases utilizing modeling tool
• Assists senior DBAs working with application areas to collect application requirements including data, volumetric, access paths, and infrastructure requirements such as backup and recovery; assists with recovery/roll-back as directed for low to medium complex applications

• 4 year Bachelors Degree (Preferred)

• 5 or more years of experience (Preferred)

• This job does not have supervisory duties.

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

Primary Skills

PostgreSQL, PostgreSQL Administration

Shift Time

Shift B (India)

Recruiter Info

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.