Required Skills and Experience
- 7+ Yrs experience in DB2 subsystem setup (standalone & data sharing) and ZPARM tuning.
- Expertise in Monoplex, SYSPLEX, and data-sharing architecture.
- Strong knowledge of DB2 DRDA architecture, backup & recovery (image copy, FLASH, mirroring).
- Experience in REXX/CLIST, ISPF programming, and CICS/IMS-DB2 interface.
- Expertise in SMP/E, DB2 software migration (V12, V13), and maintenance.
- Familiarity with unsupported/new DB2 z/OS features, compilers, and debugging.
- Experience handling PMR tickets and DB2 security/health checks.
- Installation & maintenance of IBM tools (OMEGAMON, DB2 Admin, HPU).
- Experience with Broadcom (RC Migration, Fast Load/Unload) and BMC tools.
Preferred Skills and Experience
- Strong knowledge of IBM utilities (REORG, RUNSTATS, LOAD, UNLOAD).
- Expertise in DB2 traces, SMF, RMF, WLM, and performance reports.
- Tuning virtual storage (Buffer Pool, EDM Pool, thread storage).
- Experience with monitoring tools (IBM Omegamon, CA Insight, BMC Mainview).
- Experience with DB2 Connect, IBM Data Studio, and DB2 Cloning.
- SAP/DB2 & PeopleSoft/DB2 architecture knowledge, high availability solutions.
Key Responsibilities:
- Manage DB2 ZPARM settings and optimize system parameters.
- Use tools like IBM Omegamon, CA Insight, and BMC Mainview for performance monitoring.
- Strong knowledge of IBM utilities (REORG, RUNSTATS, LOAD, UNLOAD).
- Troubleshoot DB2 system issues, diagnose performance bottlenecks.
- Coordinate with vendors for PMR ticket resolution and issue debugging.
- Support transactional environments like CICS and IMS with DB2