ENT-Software Engineer-Associate Mgr

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

Application DB2 DBA Lead Consultant would be involved in database design and capacity planning. A DB2 DBA Lead Consultant is responsible for managing and maintaining databases, including performance improvements, backup and restore support, and troubleshooting. This role would include process development and process governance supporting Production/Test & Development environments. The DB2 DBA Lead also engages in the support of disaster recovery activities, and assists in the management of business partners relationships, trains, develops, and provides guidance to department staff.

Key Responsibilities:

• Perform 24x7 round the clock support for DB2 subsystems for Allstate.  The Allstate Mainframe DB2 environment supports 2 Datacenters and 30 LPARs. 
• Each DB2 group consists of individual DB2 data sharing members spread across the mainframe CPU’s running in a Sysplex environment. 
• The Mainframe server z16 DB2 Database Administrator primarily support Mainframe DB2 groups and performs the following day-to-day activities on shared DB2 database groups.
  • Tuning and optimizing the complex queries for better performance.   
  • Performance study and improvements along with backup, recovery, reorgs, runstats, etc.
  • Perform DB2 binds for various DB2 database groups across LPARs.  
  • Granting and Revoking DB2 object privileges to DB2 objects across z16 environments.
  • Perform the DB2 performance and tuning of DB2 Databases for all the applications across the z16 mainframe LPARs.
  • Database Administration includes set up of DB2 database environments Production, Development & Test, creation of databases, table spaces, tables, indexes and other DB2 objects from logical data models and works closely with developers to design and tune the database of various business applications.
  • Perform the database sizing and perform the online/offline REORG activities. Manage and create utility schedules.  
  • Perform the core DB2 administration activities.  Image copies, repairing the table spaces & objects, quiesce the databases, archiving the DB2 active logs, and database recovery activities, perform the lock escalations and concurrency states and other related activities. 
  • Resolve the DB2 error states for all Test & Production operations across z16 mainframe systems.
  • Perform the Database design and sizing as per each application architectural design requires.
  • Perform the analysis of DB2 batch job failures.

Experience

• 10 or more years of experience (Preferred)

Supervisory Responsibilities

• This job may have supervisory duties.

Primary Skills

Employee Supervision, IBM Db2, IBM DB2 Database, Mainframe Computers, Process Improvements, Project Implementations, Project Management Leadership, Project Management Life Cycle (PMLC)

Shift Time

Shift B (India)

Recruiter Info

Yateesh B G

[email protected]

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. And one where you can impact the future for the greater good.  

You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live. 

Good Hands. Greater Together.

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.