Ims Db2 Admin

About Company

They balance innovation with an open, friendly culture and the backing of a long-established parent company, known for its ethical reputation. We guide customers from what’s now to what’s next by unlocking the value of their data and applications to solve their digital challenges, achieving outcomes that benefit both business and society.

About Client:

Our client is a global digital solutions and technology consulting company headquartered in Mumbai, India. The company generates annual revenue of over $4.29 billion (₹35,517 crore), reflecting a 4.4% year-over-year growth in USD terms. It has a workforce of around 86,000 professionals operating in more than 40 countries and serves a global client base of over 700 organizations.

Our client operates across several major industry sectors, including Banking, Financial Services & Insurance (BFSI), Technology, Media & Telecommunications (TMT), Healthcare & Life Sciences, and Manufacturing & Consumer. In the past year, the company achieved a net profit of $553.4 million (₹4,584.6 crore), marking a 1.4% increase from the previous year. It also recorded a strong order inflow of $5.6 billion, up 15.7% year-over-year, highlighting growing demand across its service lines.

Key focus areas include Digital Transformation, Enterprise AI, Data & Analytics, and Product Engineering—reflecting its strategic commitment to driving innovation and value for clients across industries.

Who are we looking for?

6+ years of administrator experienced and detail-oriented DB2 and IMS

Technical Skills:

· Proven experience as a DB2/IMS Databases Administrator or similar role in production support environments.

6+ years

· Strong knowledge of mainframe tools such as SPUFI, QMF, BMC, CA-DB2/IMS tools, and IBM utilities.

· Deep understanding of DB2 database internals, logs, buffer pools, catalog/directory, and utilities.

· Proficient in IMS Full-Function and Fast Path databases, DL/I calls, PSB/DBD maintenance.

· Solid experience with JCL, TSO/ISPF, SDSF, and mainframe batch job troubleshooting

· Experience with modern mainframe automation tools and schedulers (e.g., Control-M, CA-7).

· Knowledge of COBOL, CICS, and batch job data flows.

· Understanding of DB2 Data Sharing and IMS Sysplex environments.

· Experience with backup and recovery solutions

· Solid knowledge of Linux/Unix systems and scripting (Shell, Python, or similar).

· Proficiency in troubleshooting performance tuning, and capacity planning.

· In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)

· Strong troubleshooting and problem-solving skills.

· Excellent communication and collaboration abilities.

· Ability to work in a 24/7 support rotation and handle urgent production issues.

· Familiarity with data security is the best practice and backup procedures.

Responsibilities

· Production Support & Monitoring:

o Provide 24x7 support for DB2 and IMS database environments, including on-call rotation.

o Monitor database performance, availability, and integrity using mainframe tools and utilities.

o Respond to incidents, troubleshoot issues, and resolve problems related to DB2/IMS systems.

· Database Maintenance & Administration:

o Perform database backup and recovery procedures for DB2 and IMS databases.

o Conduct regular reorgs, image copies, and utilities execution (RUNSTATS, REORG, CHECK).

o Support DB2 and IMS subsystem maintenance, upgrades, and patching.

· Performance Tuning & Optimization:

o Analyze and tune SQL queries, buffer pools, and access paths in DB2.

o Optimize IMS database segments, DBDs, PSBs, and access methods.

o Work with developers to design efficient data access strategies .

· Change Management & Deployments:

o Review and implement database schema changes via Change Control processes.

o Participate in software releases, ensuring database readiness and minimal impact on production.

· Security & Compliance:

o Manage user access, RACF integration, and permissions in DB2/IMS environments.

o Ensure compliance with enterprise security standards and data privacy regulations.

· Documentation & Collaboration:

o Maintain accurate and up-to-date documentation, including runbooks, architecture diagrams, and operational procedures.

o Collaborate with application teams, infrastructure, and middleware teams to support business applications