Mainframe DB2 System Support
Job Description
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 knowledge on DB2 DRDA architecture and Communication database.
• Experience in DB2 backup and recovery scenarios - traditional image copy, FLASH, mirroring etc., methodology.
• Experience in REXX/CLIST and ISPF programming skills.
• Good knowledge on transactional environment like CICS, IMS architecture and interface with DB2.
• DB2 Data sharing skills - Installation, customization, DB2 structures, CFRM policy, DB2 CF recovery, Data sharing locking mechanism etc.
Software migration/maintenance:
• Experience and good exposure to SMP/E process.
• Experience and Expertise on software migration and maintenance procedures - Install, backout, re-migration process - DB2 V9, V10, and V11.
• Experience and good exposure to unsupported, new features in the recent versions of DB2 on z/OS software (V11, V10 etc.,).
• Experience and Expertise on SMP/E basics and debugging.
• Good knowledge on process related to PMR tickets and co-ordination with L2 development support.
• Good Knowledge on DB2 Health check, DB2 security and Patch management.
ISV Products/Tools:
• Good exposure to the Installation and maintenance of IBM tools like OMEGAMON, DB2 Admin, HPU etc.
• CA - Suite of tools like RC Migration/update/Query etc., Fast Load/Unload, Insight etc.
• BMC - Suite of tools.
• Experience and expertise in IBM utilities like REORG, RUNSTATS, LOAD, UNLOAD etc.
• Experience in IBM tools/products is mandatory. Candidate should have good experience in both BMC and CA products or either one is okay.
• Experience in problem debugging and Vendor specific PMR ticketing procedure.
Problem Solving & Performance:
• Good knowledge and experience on DB2 traces, SMF, RMF and WLM.
• Good knowledge and experience on SMF Statistics, accounting and performance reports.
• Good knowledge on Virtual storage tuning like Buffer Pool, EDM Pool and thread storage parameters.
• Good knowledge on SYSPLEX, data sharing and distributed problem-solving skills.
• Expertise on monitoring tools like IBM Omegamon, CA Insight, BMC Mainview etc.
• Good Knowledge on z/OS and DB2 system performance tuning methods.
• 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 knowledge on DB2 DRDA architecture and Communication database.
• Experience in DB2 backup and recovery scenarios - traditional image copy, FLASH, mirroring etc., methodology.
• Experience in REXX/CLIST and ISPF programming skills.
• Good knowledge on transactional environment like CICS, IMS architecture and interface with DB2.
• DB2 Data sharing skills - Installation, customization, DB2 structures, CFRM policy, DB2 CF recovery, Data sharing locking mechanism etc.
Software migration/maintenance:
• Experience and good exposure to SMP/E process.
• Experience and Expertise on software migration and maintenance procedures - Install, backout, re-migration process - DB2 V9, V10, and V11.
• Experience and good exposure to unsupported, new features in the recent versions of DB2 on z/OS software (V11, V10 etc.,).
• Experience and Expertise on SMP/E basics and debugging.
• Good knowledge on process related to PMR tickets and co-ordination with L2 development support.
• Good Knowledge on DB2 Health check, DB2 security and Patch management.
ISV Products/Tools:
• Good exposure to the Installation and maintenance of IBM tools like OMEGAMON, DB2 Admin, HPU etc.
• CA - Suite of tools like RC Migration/update/Query etc., Fast Load/Unload, Insight etc.
• BMC - Suite of tools.
• Experience and expertise in IBM utilities like REORG, RUNSTATS, LOAD, UNLOAD etc.
• Experience in IBM tools/products is mandatory. Candidate should have good experience in both BMC and CA products or either one is okay.
• Experience in problem debugging and Vendor specific PMR ticketing procedure.
Problem Solving & Performance:
• Good knowledge and experience on DB2 traces, SMF, RMF and WLM.
• Good knowledge and experience on SMF Statistics, accounting and performance reports.
• Good knowledge on Virtual storage tuning like Buffer Pool, EDM Pool and thread storage parameters.
• Good knowledge on SYSPLEX, data sharing and distributed problem-solving skills.
• Expertise on monitoring tools like IBM Omegamon, CA Insight, BMC Mainview etc.
• Good Knowledge on z/OS and DB2 system performance tuning methods.
Job Requirement
ISV Products/Tools:
• Good exposure to the Installation and maintenance of IBM tools like OMEGAMON, DB2 Admin, HPU etc.
• CA - Suite of tools like RC Migration/update/Query etc., Fast Load/Unload, Insight etc.
• BMC - Suite of tools.
• Experience and expertise in IBM utilities like REORG, RUNSTATS, LOAD, UNLOAD etc.
• Experience in IBM tools/products is mandatory. Candidate should have good experience in both BMC and CA products or either one is okay.
• Experience in problem debugging and Vendor specific PMR ticketing procedure.
Problem Solving & Performance:
• Good knowledge and experience on DB2 traces, SMF, RMF and WLM.
• Good knowledge and experience on SMF Statistics, accounting and performance reports.
• Good knowledge on Virtual storage tuning like Buffer Pool, EDM Pool and thread storage parameters.
• Good knowledge on SYSPLEX, data sharing and distributed problem-solving skills.
• Expertise on monitoring tools like IBM Omegamon, CA Insight, BMC Mainview etc.
• Good Knowledge on z/OS and DB2 system performance tuning methods.