DB2 Systems Programmer

11 hours ago

Chennai India TECEZE Full time

Job Description

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 Programmer

    3 days 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, NoidaExperience: 5-8 yearsWork mode: HybridJob 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,...

  • Mainframe Db2 System Programmers

    1 week ago

    Chennai, Tamil Nadu, India Cognizant Full time

    **DB2 Systems Programmer** Install, upgrade, and administer Mainframe DB2 and DB2 related software. Assist with testing, implementation, and installation of new/improved systems, as well as product upgrades. Attend meetings and interact regularly with management, team, and clients to continuously improve services. Participate in On-Call rotation...

  • Senior Lead DB2 Mainframe System programmer

    1 week ago

    Bengaluru, India Kyndryl Full time

    Job Description Who We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl We are always moving forward - always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our...

  • DB2 Systems

    4 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...

  • CICS System Programmer-Z/OS Mainframe

    6 days ago

    Chennai, India TECEZE Full time

    Job Description Job Title: CICS System Programmer z/OS Mainframe Location: Chennai, Noida, Bangalore Experience: 58 Years Job Type: Full-Time Job Title: CICS System Programmer z/OS Mainframe JD CICS System programmer 5-8 years of extensive hands-on experience as a CICS Systems Programmer on z/OS. Job Summary: We are seeking a highly skilled and...

  • DB2 Systems

    4 days ago

    Chennai, 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

    5 days ago

    Chennai, 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

    2 weeks ago

    Chennai, 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,...