DB2 Systems Programmer

3 weeks ago


New Delhi, India TECEZE Full time

Job Title: DB2 Systems Programmer (Mainframe z/OS) Location: Chennai, Bangalore, Noida Experience: 5-8 years Work 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.



  • New Delhi, India DXC Technology Full time

    DB2 System Programmer: - Location: Any DXC India Location. Experience: 4-20 Yrs.Environment- Subsystem setup, Backup & Recovery and Data Sharing Experience and Expertise in Monoplex, SYSPLEX architecture and data sharing architecture. Experience in DB2 subsystem setup - both Stand-alone and data sharing. Experience and Expertise on tweaking DB2 ZPARMs Good...


  • New Delhi, India DXC Technology Full time

    DB2 System Programmer: -Location: Any DXC India Location. Experience: 4-20 Yrs.Environment- Subsystem setup, Backup & Recovery and Data Sharing Experience and Expertise in Monoplex, SYSPLEX architecture and data sharing architecture. Experience in DB2 subsystem setup - both Stand-alone and data sharing. Experience and Expertise on tweaking DB2 ZPARMs Good...


  • New Delhi, India DXC Technology Full time

    DB2 System Programmer: -Location: Any DXC India Location.Experience: 4-20 Yrs.Environment- Subsystem setup, Backup & Recovery and Data Sharing- Experience and Expertise in Monoplex, SYSPLEX architecture and data sharing architecture. - Experience in DB2 subsystem setup - both Stand-alone and data sharing. - Experience and Expertise on tweaking DB2 ZPARMs -...


  • New Delhi, India Tata Consultancy Services Full time

    Exp Range- 2-10 yrsSummary of key responsibilities- Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements - Recommend operating system and database performance monitoring, tuning and configuration changes - Experience with database physical and logical design, query analysis and optimization - Provide...


  • New Delhi, India Tata Consultancy Services Full time

    Technical requirementsExperience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS DB2 installation, upgrade, patching, configuration and operations Proficiency in DB2, VSAM Systems Performance Tuning and Capacity Planning Experience in Data Sharing setup in Parallel Sysplex environment Knowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9...


  • New Delhi, India Live Connections Full time

    Subject Line:Application – Mainframe [Role Name] – Chennai/BangaloreHiring: Mainframe Specialists | Chennai & Bangalore | ₹20++ to 50++ LPAWe are looking forseasoned Mainframe professionalsacross multiple roles for a leading technology organization. If you have strong expertise inSystem Programming, Architecture, Storage, or Administration , we’d...


  • New Delhi, India Vaisesika Full time

    Vaisesika is looking for Senior / Lead Systems ProgrammerJob Title: Senior / Lead Systems Programmer – Windows InfrastructureLocation: RemoteExperience: 8 – 15 yearsEmployment Type: Full-TimeRequired Skills & Experience- 8–15 years of hands-on experience in Windows Systems Programming or Administration. - Strong proficiency in PowerShell scripting and...


  • New Delhi, India Vaisesika Full time

    Vaisesika is looking for Senior / Lead Systems ProgrammerJob Title: Senior / Lead Systems Programmer – Windows InfrastructureLocation: RemoteExperience: 8 – 15 yearsEmployment Type: Full-TimeRequired Skills & Experience- 8–15 years of hands-on experience in Windows Systems Programming or Administration. - Strong proficiency in PowerShell scripting and...


  • New Delhi, India TECEZE Full time

    Job Title: CICS System Programmer – z/OS MainframeLocation: Chennai, Noida, BangaloreExperience: 5–8 YearsJob Type: Full-TimeJob Title: CICS System Programmer – z/OS MainframeJD CICS System programmer5-8 years of extensive hands-on experience as a CICS Systems Programmer on z/OS.Job Summary: We are seeking a highly skilled and experienced CICS Systems...


  • New Delhi, India TECEZE Full time

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