Mainframe Db2 System Programmer

Sreejiinfosys; Hyderabad, Bengaluru; Hybrid; INR 1,200,000 - 2,000,000; Full time

Job summary

Sreejiinfosys is seeking an experienced Mainframe DB2 Specialist to join our team in Hyderabad. The role focuses on designing, developing, testing, and deploying mainframe DB2 applications on the z/OS platform.

You will perform database administration tasks including backups, recovery, and performance tuning. Proficiency with DB2 utilities (REORG, RUNSTATS, LOAD, COPY, RECOVER) and familiarity with JCL and SDSF are required.

Qualifications

• 8-12 years of experience in Mainframe DB2 System Programming.
• Strong DB2 on z/OS expertise (System & DBA level).
• Proficient in SQL tuning and performance optimization techniques.
• Familiarity with z/OS operating system commands (JCL), SDSF scheduling tool.

Responsibilities

• Design, develop, test, and deploy mainframe applications using IBM DB2 on z/OS platform.
• Perform database administration tasks such as backups, recovery, and performance optimization.
• Utilize various DB2 utilities like REORG, RUNSTATS, LOAD, COPY, RECOVER to manage databases efficiently.
• Collaborate with cross-functional teams to identify business requirements and implement solutions.

Skills

Mainframe DB2

z/OS

SQL tuning

JCL

SDSF

Tools

REORG

RUNSTATS

LOAD

COPY

RECOVER

Job description

Roles and Responsibilities

• Design, develop, test, and deploy mainframe applications using IBM DB2 on z/OS platform.
• Perform database administration tasks such as backups, recovery, and performance optimization.
• Utilize various DB2 utilities like REORG, RUNSTATS, LOAD, COPY, RECOVER to manage databases efficiently.
• Collaborate with cross-functional teams to identify business requirements and implement solutions.

Desired Candidate Profile

• 8-12 years of experience in Mainframe DB2 System Programming or related field.
• Strong experience in DB2 on z/OS (System & DBA level).
• Proficiency in SQL tuning and performance optimisation techniques.
• Familiarity with z/OS operating system commands (JCL), SDSF scheduling tool.