DB2 System Programmer

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

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.

Education

Bachelor Of Technology (B.Tech / B.E), Bachelor of Business Administration (B.B.A), Bachelor of Education (B.Ed), Bachelor of Music, Bachelor in General Studies (BGS), Bachelor of Social Work (B.S.W), Bachelor in Hotel Management (B.H.M), Bachelor of Applied Science (BAS), Bachelor of Liberal Arts (BLA / ALB), Bachelor of Science (B.Sc), Bachelor of Music Education (B.M.E.), Bachelor of Interdisciplinary Studies, Bachelor of Arts (B.A), Bachelor of Health Science

Skills Required

Runstats, Load, Smf, RMF, Wlm