DB2 Systems Programmer

23 hours ago

Chennai, India TECEZE Full time

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

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

  • DB2 Systems Programmer

    2 days ago

    Chennai, India TECEZE Full time

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

  • DB2 Systems Programmer

    7 days ago

    Chennai, India TECEZE Full time

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

  • DB2 Systems Programmer

    1 day ago

    Chennai, India TECEZE Full time

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

  • DB2 Systems Programmer

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

  • DB2 Systems Programmer

    7 days ago

    Chennai, India TECEZE Full time

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

  • DB2 Systems Programmer

    7 days ago

    Chennai, India TECEZE Full time

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

  • DB2 Systems Programmer

    1 week ago

    Chennai, India TECEZE Full time

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

  • DB2 Systems Programmer

    2 days ago

    Chennai, India TECEZE Full time

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

  • DB2 Systems Programmer

    1 day ago

    Chennai, India TECEZE Full time

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