DB2 Systems Programmer

9 hours ago

Chennai, Tamil Nadu, India TECEZE Full time ₹ 1,20,000 - ₹ 1,80,000 per year

Job Title: DB2 Systems Programmer (Mainframe z/OS)

Location: Chennai, Bangalore, Noida

Experience: 5-8 years

Work mode: Hybrid

Job Summary:

The DB2 Systems Programmer is responsible for installation, maintenance, and upgrade of IBM DB2 for z/OS subsystems, ensuring optimal performance, availability, and stability. Works with DB2 DBAs, z/OS Systems Programmers, and development teams.

Key Responsibilities:

DB2 Subsystem Management:

  • Plan and execute DB2 subsystem installations, upgrades, migrations (e.g., DB2 12 to DB2 13).
  • Apply DB2 maintenance (PTFs, APARs, SPEs) using SMP/E.
  • Configure and maintain DB2 PARMLIB, DSNZPARM.
  • Perform DB2 subsystem restarts (IPLs, Quiesce/Start).

DB2 Tool and Utility Support:

  • Install, configure, upgrade, maintain DB2 utilities (REORG, RUNSTATS, COPY, LOAD, UNLOAD).
  • Support ISV tools for DB2 (BMC, Broadcom/CA, IBM Admin Tool, IBM Data Studio).
  • Troubleshoot DB2 utilities and ISV tools.

Performance Monitoring and Tuning:

  • Monitor subsystem health and performance (Omegamon, DB2 PM, SMF, RMF).
  • Analyze performance data, recommend tuning improvements.
  • Assist DBAs and application teams in SQL optimization.

Problem Diagnosis and Resolution:

  • Provide expert-level support for DB2 incidents.
  • Analyze dumps, logs, traces; resolve issues.
  • Collaborate with IBM support and ISV vendors.
  • Participate in 24/7 on-call support.

Collaboration and Coordination:

  • Work with DB2 DBAs for requirements and guidance.
  • Collaborate with z/OS Systems Programmers on shared resources.
  • Liaise with application teams for DB2 changes and deployments.
  • Coordinate with operations for maintenance and incidents.

Automation and Scripting:

  • Develop and maintain JCL, REXX, CLISTs, and other scripts.

Disaster Recovery and Business Continuity:

  • Assist in planning, testing, execution of DR procedures.
  • Ensure high availability and recoverability.

Documentation and Best Practices:

  • Create and maintain documentation for installations, configurations, procedures.
  • Follow ITIL best practices for change, incident, problem management.

Security and Compliance:

  • Implement DB2 security best practices (RACF/ACF2/Top Secret).
  • Ensure compliance with policies and regulations.

Required Skills and Experience:

  • 5-8 years as Mainframe DB2 Systems Programmer.
  • Hands-on with DB2 for z/OS (installation, configuration, maintenance, migration).
  • Proficient in JCL, TSO/ISPF, SMP/E.
  • Experience with DB2 utilities (COPY, RECOVER, REORG, RUNSTATS, LOAD, UNLOAD).
  • Knowledge of DB2 ISV tools (BMC, Broadcom/CA, IBM Admin Tool, Omegamon).
  • Understanding of DB2 architecture, data sharing, buffer pool, logging.
  • Performance monitoring, tuning, problem diagnosis.
  • Ability to read DB2 dumps for problem determination.
  • Proficiency in REXX, CLISTs, or other scripting.
  • Familiarity with z/OS fundamentals (JES2/JES3, SMS, VSAM).
  • Analytical, problem-solving, and communication skills.

Desired Skills:

  • Experience with Parallel Sysplex and DB2 Data Sharing.
  • Knowledge of IBM MQ, IMS, or CICS connectivity.
  • Experience with DB2 DDF and remote connectivity.
  • DB2 for z/OS certifications.

  • DB2 Systems

    3 weeks ago

    Chennai, Tamil Nadu, India Teceze LTD Full time

    Job Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: ChennaiJob Type: Full-timeRole OverviewWe are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable), performance tuning, high...

  • DB2 Systems

    3 weeks ago

    Chennai, Tamil Nadu, India Teceze LTD Full time

    Job Title: DB2 Systems & Database Administrator Experience: 8–10 Years Location: Chennai Job Type: Full-time Role Overview We are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable) , performance...

  • DB2 Systems

    2 weeks ago

    Chennai, Tamil Nadu, India Teceze LTD Full time

    Job Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: Chennai Job Type: Full-timeRole OverviewWe are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable), performance tuning, high...

  • Mainframe System Programmer

    3 weeks ago

    Chennai, Tamil Nadu, India People Prime World Wide Full time

    About Company :Our Client is a multinational IT services and consulting company headquartered in USA, With revenues 19.7 Billion USD, with Global work force of 3,50,000 and Listed in NASDAQ, It is one of the leading IT services firms globally, known for its work in digital transformation, technology consulting, and business process outsourcing, Business...

  • z/OS System Programmer

    3 weeks ago

    Chennai, Tamil Nadu, India TECEZE Full time

    Job Title: z/OS System ProgrammerLocation: Chennai, Bangalore, NoidaExperience: 7–10 YearsEmployment Type: Full-Time- Mainframe z/OS Systems Programmer : 7-10 years of hands-on experience as a Mainframe Systems Programmer.- Job Summary: We are seeking a highly skilled and experienced Mainframe z/OS Systems Programmer to join our dynamic IT team. The...

  • z/OS System Programmer

    3 weeks ago

    Chennai, Tamil Nadu, India TECEZE Full time

    Job Title: z/OS System Programmer Location: Chennai, Bangalore, Noida Experience: 7–10 Years Employment Type: Full-Time Mainframe z/OS Systems Programmer : 7-10 years of hands-on experience as a Mainframe Systems Programmer. Job Summary: We are seeking a highly skilled and experienced Mainframe z/OS Systems Programmer to join our dynamic IT team. The...

  • z/OS System Programmer

    2 weeks ago

    Chennai, Tamil Nadu, India TECEZE Full time

    Job Title: z/OS System Programmer Location: Chennai, Bangalore, Noida Experience: 7–10 Years Employment Type: Full-TimeMainframe z/OS Systems Programmer : 7-10 years of hands-on experience as a Mainframe Systems Programmer. Job Summary: We are seeking a highly skilled and experienced Mainframe z/OS Systems Programmer to join our dynamic IT team. The...

  • CICS System Programmer

    2 weeks ago

    Chennai, Tamil Nadu, India People Prime World Wide Full time

    Key Responsibilities :- Perform CICS administration tasks, including CICS TS upgrades, maintenance via SMP/E, and region setup and decommissioning.- Configure and maintain CICS regions, define and manage CICS RDO resources, and ensure high availability.- Troubleshoot and resolve complex CICS issues, performance bottlenecks, and system abends.- Collaborate...

  • Mainframe Cobol Developer

    2 weeks ago

    Chennai, Tamil Nadu, India beBeeCobol Full time ₹ 80,00,000 - ₹ 1,50,00,000

    Job Title:Cobol ProgrammerDescription:Are you a skilled programmer looking for a challenging opportunity? We have an exciting job opening for a Cobol Developer to join our team.We are seeking a highly motivated and experienced Cobol developer to work on our mainframe projects. The ideal candidate will have strong knowledge of Cobol programming, JCL, DB2,...

  • PLC Programmer

    2 weeks ago

    Chennai, Tamil Nadu, India INNOVATIVE INSTRUEMENTS & CONTROLS Full time

    Company DescriptionINNOVATIVE INSTRUMENTS AND CONTROLS provides industrial automation solutions for sectors such as process industry, automotive, food processing, water and waste water, and chemical industries. The company focuses on delivering high-quality solutions tailored to meet the unique requirements of each sector. Our expertise ensures operational...