Mainframe DB2 SYS PROG ADMIN

Tata Consultancy Services Limited; Pune District, Chennai, Bengaluru; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Tata Consultancy Services Limited in India seeks a MAINFRAME DB2 SYS PROG ADMIN with 6+ years of experience. The role involves DBA on DB2 for z/OS, data sharing, performance tuning, capacity planning, and DR planning across Pune/Chennai/Bengaluru locations.

Candidates should have strong z/OS, JCL, SMP/E, and UMS experience, plus knowledge of CICS/DB2, DB2 ISV products, and security interfaces. Migration and production support skills are valued.

Qualifications

• DB2 on z/OS DBA experience required.
• DB2 internals, fundamentals, installations and operations.
• DB2 Data Sharing in Parallel Sysplex environment.
• Systems performance tuning and capacity planning.
• DB2 security interfaces; SMP/E and UserMods.
• DB2 ISV products installation and usage; strong z/OS, USS, JCL.
• REXX, HTML and/or java coding; CICS/DB2 experience.
• Experience with interfacing and installing OEM vendor tools.
• Disaster Recovery planning and support.

Skills

DB2 z/OS

DB2 DBA

Data Sharing

Performance Tuning

Capacity Planning

SMP/E

JCL

CICS/DB2

Rexx

Java

HTML

USS

Security with DB2

DB2 ISV Tools

Tools

DB2 ISV Products

OEM Tools

Job description

Job Title : MAINFRAME DB2 SYS PROG ADMIN

Job Location : Pune/Chennai/Bengaluru

Experience required : 6+ years

Job Description:

• Experience as a DB2 (on z/OS) Database Administrator
• Working knowledge of DB2 Internals, fundaments, installations and operations
• Working knowledge of DB2 Data Sharing in Parallel Sysplex environment
• Knowledge of Systems Performance Tuning and Capacity Planning
• Knowledge of security interface with DB2 & Experience with SMP/E and UserMods
• Experience with installation and using DB2 ISV Products, Strong z/OS, USS and JCL skills
• REXX, HTML and/or java coding ability, CICS/DB2
• Knowledge of interfacing with and installing OEM vendor tools
• Disaster Recovery Planning and support
• Proficiency in DB2 Systems Performance Tuning and Capacity Planning
• Proficiency in application related performance and tuning,