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 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 V11Experience and good exposure to unsupported, new features in the recent versions of DB2 on z / OS software. (V11, V10 etc.,)Good knowledge on mainframe compilers like LE 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 ofIBM 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 toolsExperience 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 okayExperience 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.Additional / Nice to have Skills :
Experience in DB2 Connect and IBM Data StudioDB2 Cloning process - IBM DB2 Cloning Tool or any customized in-house Tools.SAP / DB2 architecture knowledge - SAP Service market place, SAP note reference like 81737 etc,mSAP / DB2 Maintenance procedure. Experience in SAP note, high availability solutions, GUI DB transactions etc.,PeopleSoft / DB2 architecture.