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

  • Mainframe DB2 System Programmer

    1 week ago

    Chennai, Tamil Nadu, India UST Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    5 - 12 Years1 OpeningChennaiRole descriptionJob Description :-Install, configure, and upgrade DB2 databases (z/OS as applicable).Perform regular database maintenance, patching, and health checks.Monitor database performance and conduct tuning as needed.Implement backup and recovery strategies using native DB2 tools or third-party solutions.Manage database...

  • Mainframe DB2 System Programmer

    5 days ago

    Chennai, Tamil Nadu, India Infosys Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Key Responsibilities:Skills involves and not limited too Evaluate and implement new features functions of DB2 and associated third party productso Extensive use of utilities and Performance Monitoring tools using BMC CA and IBM productso Consultant on DB2 database applications architectureo Knowledge of SMP E and can prepare for and apply maintenance to a...

  • Senior Systems Programming Analyst

    5 days ago

    Chennai, Tamil Nadu, India UPS Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Before you apply to a job, select your language preference from the options available at the top right of this page.Explore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS into...

  • Mainframe DB2 Admin

    17 hours ago

    Chennai, Tamil Nadu, India Tata Consultancy Services (TCS) Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    TCS has been a great pioneer in feeding the fire of young techies like you. We are a global leader in the technology arena and there's nothing that can stop us from growing together.What we are looking forRole: Mainframe DB2 SupportExperience Range: 4 – 8 YearsLocation: ChennaiMust Have:Hands-on experience in COBOL, JCL, DB2 and VSAM based...

  • Db2 Luw Database Administrator

    3 days ago

    Chennai, Tamil Nadu, India Vega Intellisoft Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Dear Candidate,Immediate openings for DB2 DBA LUW ADMINISTRATOR.JOB DESCRIPTION;Job DescriptionWe are looking for an experienced DB2 DBA to join our team As a DB2 DBA you will be responsible forthe implementation, configuration, maintenance, and performance of critical DB2 RDBMS systemsRequirements10 years of experience as a DB2 DBA or similar role•...

  • DB2 Database Administrator

    1 week ago

    Chennai, Tamil Nadu, India Barclays Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Join us as a DB2 Database Administrator role, where to build and maintain infrastructure platforms and products that support applications and data systems, using hardware, software, networks, and cloud computing platforms as required with the aim of ensuring that the infrastructure is reliable, scalable, and secure. At Barclays, we don't just anticipate the...

  • System/Application programmers

    3 days ago

    Chennai, Tamil Nadu, India HiPro IT Solutions Private Limited Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Yes, we are constantly looking for like minded awesome programmers like us. So, if you fit into one of the following and would love to work with us, do send us your resume.The following is required for all positions;Strong computer science fundamentals (data structures, algorithms, object oriented programming)Working experience on GNU/Linux...

  • Linux Admistrator with DB2/Adabas Database

    2 weeks ago

    Chennai, Tamil Nadu, India Infotel UK Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    Role: Linux Administrator Location: ChennaiAbout Us: Infotel India is a renowned technology consulting firm dedicated to delivering innovative IT solutions and services to a diverse range of industries. We are passionate about leveraging technology to drive business effectiveness and efficiency. We are currently looking for a skilled Linux Administrator with...

  • Sr. Oracle, DB2 Database Administrator

    15 hours ago

    Chennai, Tamil Nadu, India Atos Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    About Atos GroupAtos Group is a global leader in digital transformation with c. 70,000 employees and annual revenue of c. € 10 billion, operating in 67 countries under two brands — Atos for services and Eviden for products. European number one in cybersecurity, cloud and high-performance computing, Atos Group is committed to a secure and decarbonized...

  • Sr. Oracle, DB2 Database Administrator

    23 hours ago

    Chennai, Tamil Nadu, India Atos Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    About Atos GroupAtos Group is a global leader in digital transformation with c. 70,000 employees and annual revenue of c. € 10 billion, operating in 67 countries under two brands — Atos for services and Eviden for products. European number one in cybersecurity, cloud and high-performance computing, Atos Group is committed to a secure and decarbonized...