
DB2 Systems Programmer
21 hours ago
Location: Chennai, Bangalore, Noida
Mode: Hybrid Model
Roles and Responsibilities:
Key Responsibilities:
- DB2 Subsystem Management:
- Plan, prepare, and execute DB2 for z/OS subsystem installations, upgrades, and migrations (e.g., from DB2 12 to DB2 13, or between Function Levels).
- Apply IBM DB2 maintenance (PTFs, APARs, SPEs) regularly using SMP/E to ensure system integrity, resolve issues, and enhance functionality.
- Configure and maintain DB2 PARMLIB, DSNZPARM, and other critical DB2 initialization parameters.
- Perform DB2 subsystem restarts (IPLs, Quiesce/Start) as required for maintenance and configuration changes.
- DB2 Tool and Utility Support:
- Install, configure, upgrade, and maintain IBM DB2 utilities (e.g., REORG, RUNSTATS, COPY, LOAD, UNLOAD).
- Install and support various Independent Software Vendor (ISV) tools for DB2 (e.g., BMC DB2 tools, Broadcom/CA DB2 tools, IBM DB2 Admin Tool, IBM Data Studio, etc.) used for performance monitoring, backup/recovery, administration, and development.
- Troubleshoot issues related to DB2 utilities and ISV tools.
- Performance Monitoring and Tuning:
- Monitor DB2 subsystem health, performance, and resource utilization using tools like Omegamon for DB2, DB2 PM, SMF, RMF, and other performance monitors.
- Analyze performance data to identify bottlenecks within DB2 and recommend tuning improvements at the subsystem, buffer pool, and thread level.
- Assist DBAs and application teams in optimizing SQL queries and application performance.
- Problem Diagnosis and Resolution:
- Provide expert-level support for DB2 incidents, including problem determination, diagnosis (e.g., analyzing dumps, logs, traces), and resolution in a timely manner.
- Collaborate with IBM support and ISV vendors to resolve complex issues.
- Participate in on-call rotation for 24/7 support of critical DB2 environments.
- Collaboration and Coordination:
- Work closely with DB2 DBAs to understand their requirements, provide technical guidance, and ensure the smooth operation of database environments.
- Collaborate with z/OS Systems Programmers on shared resources, system-level issues, and overall mainframe health.
- Liaise with application development teams for DB2-related changes, new application deployments, and problem resolution.
- Coordinate with mainframe operations for scheduled maintenance and incident response.
- Automation and Scripting:
- Develop and maintain JCL, REXX, CLISTs, and other scripts for DB2 administration, monitoring, and automation tasks.
- Disaster Recovery and Business Continuity:
- Assist in the planning, testing, and execution of disaster recovery procedures for DB2 subsystems.
- Ensure the high availability and recoverability of critical DB2 environments.
- Documentation and Best Practices:
- Create and maintain comprehensive documentation for DB2 installations, configurations, operational procedures, and troubleshooting guides.
- Adhere to ITIL best practices for change management, incident management, and problem management within the DB2 domain.
- Security and Compliance:
- Implement and enforce security best practices within DB2, working with security administrators (RACF/ACF2/Top Secret) to define and manage DB2 security profiles.
- Ensure compliance with internal security policies and external regulatory requirements for DB2 data.
Required Skills and Experience:
- 5-8 years of hands-on experience as a Mainframe DB2 Systems Programmer.
- In-depth knowledge and hands-on experience with IBM DB2 for z/OS installation, configuration, maintenance, and migration (preferably including recent versions like DB2 12 or 13).
- Strong proficiency in JCL, TSO/ISPF, and SMP/E.
- Extensive experience with IBM DB2 utilities (COPY, RECOVER, REORG, RUNSTATS, LOAD, UNLOAD).
- Proven experience with installation and support of leading DB2 ISV tools (e.g., BMC DB2 tools, Broadcom/CA DB2 tools, IBM DB2 Admin Tool, Omegamon for DB2).
- Solid understanding of DB2 architecture, data sharing, buffer pool management, and logging.
- Experience with DB2 performance monitoring, tuning, and problem diagnosis (e.g., reading traces, interpreting DSNZPARM settings).
- Ability to read and interpret DB2 dumps for problem determination.
- Proficiency in REXX, CLISTs, or other scripting languages for automation.
- Familiarity with z/OS operating system fundamentals, including JES2/JES3, SMS, VSAM.
- Excellent analytical, problem-solving, and troubleshooting skills.
- Strong communication (written and verbal) and interpersonal skills, with the ability to collaborate effectively with various teams.
- Ability to work independently and manage multiple priorities in a dynamic environment.
Desired Skills and Experience (Plus Points):
- Experience with Parallel Sysplex and DB2 Data Sharing environments.
- Knowledge of IBM MQ for z/OS, IMS, or CICS connectivity with DB2.
- Experience with DB2 DDF (Distributed Data Facility) and remote connectivity.
- Certifications related to DB2 for z/OS.
-
Mainframe DB2 System Programmer
2 weeks ago
Bengaluru, Karnataka, India Kyndryl Full time ₹ 15,00,000 - ₹ 20,00,000 per yearWho We AreAt 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 communities.The RoleThe...
-
DB2 Database Administrator
22 hours ago
Bengaluru, Karnataka, India beBeeDatabase Full time ₹ 9,00,000 - ₹ 12,00,000Job Title: DB2 Systems ProgrammerWe are seeking a skilled DB2 Systems Programmer to join our team. As a key member of our database administration team, you will be responsible for ensuring the smooth operation and maintenance of our DB2 environments.Key Responsibilities:- Plan, prepare, and execute DB2 for z/OS subsystem installations, upgrades, and...
-
DB2 Systems
1 day ago
Bengaluru, Karnataka, India TECEZE Full timeJob Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: BengaluruJob 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...
-
Principal Systems Programmer
3 days ago
Bengaluru, Karnataka, India beBeeMainframe Full time ₹ 12,00,000 - ₹ 15,00,000**Job Role:** Principal Systems ProgrammerRole OverviewThis is a senior-level role in mainframe programming, focusing on developing and maintaining critical batch processing systems. Key responsibilities include creating and optimizing COBOL-based job control language (JCL) scripts, database administration for IBM DB2, and implementing IMS-based...
-
Lead - Mainframe IMS DB2 System Support
2 weeks ago
Bengaluru, Karnataka, India Kyndryl Full time US$ 1,50,000 - US$ 2,00,000 per yearWho We AreAt 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 communities.The RoleAs a...
-
Architect-Mainframe IMS DB2 system support
2 weeks ago
Bengaluru, Karnataka, India Kyndryl Full time ₹ 15,00,000 - ₹ 20,00,000 per yearWho We AreAt 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 communities.The RoleAs a...
-
DB2 Database Systems Engineer
1 day ago
Bengaluru, Karnataka, India beBeeDatabase Full time ₹ 1,20,00,000 - ₹ 2,00,00,000DB2 Database Systems EngineerWe are seeking a highly skilled DB2 Database Systems Engineer to manage, optimize, and support our DB2 database environments. This role requires strong expertise in DB2 administration, performance tuning, high availability, backup/recovery strategies, and troubleshooting critical production issues.About the Role:Install,...
-
Highly Skilled Database Administrator
14 hours ago
Bengaluru, Karnataka, India beBeeDatabase Full time ₹ 30,00,000 - ₹ 40,00,000DB2 Systems Programmer Job SummaryThe DB2 Systems Programmer is responsible for the installation, configuration, maintenance, and migration of DB2 for z/OS subsystems.Main Responsibilities:Plan, prepare, and execute DB2 for z/OS subsystem installations, upgrades, and migrations.Apply IBM DB2 maintenance regularly using SMP/E to ensure system integrity and...
-
Mainframe DB2 Database Development Position
2 days ago
Bengaluru, Karnataka, India beBeeDatabase Full timeJob Title: DB2 Mainframe Database SpecialistAbout the RoleThe ideal candidate will have a strong background in Mainframe DB2 database administration and development, with experience in application development, SQL query optimization, and database design. They will be responsible for designing, implementing, and optimizing DB2 database structures to ensure...
-
DB2 database Administrator
1 day ago
Bengaluru, Karnataka, India Tata Consultancy Services Full timeJOB DESCRIPTIONJob Title:AWS – IBM DB2 database AdministratorExperience : 4 to 8Location:BangaloreDepartment/Practice:FSITJob Purpose and primary objectives:DB2 AdministratorKey responsibilities (please specify if the position is an individual one or part of a team):Part of teamSupervisory / Managerial responsibilities (please specify if the position will...