Job Summary
Job Description
Role: DB2 System Programmer / Administrator
Platform: IBM DB2 (Mainframe)
Band: U3 ‿ DB2 System Programmer / Administrator
(Experienced System Programmer / L2‿L3 Operations Role)
Role Summary
The DB2 System Programmer / Administrator (U3) is responsible for day to day system level administration, configuration, monitoring, and operational support of IBM DB2 subsystems on mainframe platforms. The role focuses on maintaining availability, performance, security, and operational stability of the DB2 system environment supporting business critical applications, while delivering incident, problem, change, and service request management within agreed SLAs.
Key Responsibilities
Functional Responsibilities
• Provide L2/L3 operational support for DB2 system level environments supporting in scope applications
• Handle DB2 system related incidents, service requests, problems, and changes as per ITIL processes
• Participate in on call support for P1 / critical DB2 system incidents
• Support planned maintenance, fix application cycles, and minor system enhancements
• Provide inputs for SLA tracking, service reporting, and governance reviews
• Collaborate with DB2 Application DBAs, mainframe infrastructure, storage, and security teams
• Support DR/BCP drills, system recovery testing, and audit activities
• Maintain and update DB2 system runbooks, SOPs, and operational documentation
Technical Responsibilities
• Install, configure, and maintain IBM DB2 subsystems and related system components
• Apply DB2 fix packs, software upgrades, and system level configuration changes
• Monitor DB2 subsystem health including CPU utilization, memory, storage, DDF threads, and system resources
• Manage DB2 backup and recovery mechanisms including image copies, log management, quiesce, and load/unload processing
• Perform DB2 system level performance monitoring and tuning (buffer pools, storage groups, reorgs, runstats)
• Monitor tablespace and storage growth and coordinate capacity adjustments
• Manage DB2 system level security including authorizations, privileges, and integration with RACF / ACF2
• Troubleshoot DB2 subsystem failures, service degradation, and availability issues
• Participate in and support disaster recovery execution and validation
Skills & Experience
Technical Skills
• Strong experience in IBM DB2 system programming and administration on mainframe platforms
• Hands on experience with DB2 installation, configuration, upgrades, and fix pack application
• Solid understanding of DB2 subsystem architecture, logging, backup, and recovery
• Experience with DB2 system level performance tuning and resource optimization
• Working knowledge of mainframe security integrations (RACF / ACF2)
Functional / Process Skills
• Experience with ITIL aligned Incident, Problem, Change, and Service Request Management
• Ability to work in 24ÿ7 production support environments with on call rotations
• Strong documentation and operational discipline
• Effective collaboration with cross functional technical teams
Experience Band
• 4 ‿ 7 years of overall DB2 experience
• 3+ years hands on experience as a DB2 System Programmer / Administrator on mainframe platforms