DB2 System Programmer / DB2 System Administrator

DB2 System Programmer / DB2 System Administrator

Install, configure and maintain IBM Db2 for z/OS subsystems across environments.

Perform Db2 version upgrades, migrations, maintenance and RSU/PTF application.

Manage Db2 subsystems, members, data sharing groups and system parameters (DSNZPARM).

Configure and maintain BSDS, active/archive logs, bootstrap datasets and Db2 libraries.

Manage Db2 Data Sharing, Group Attach, coupling facility structures and CF configuration.

Perform Db2 startup, shutdown, recovery and subsystem health checks.

Administer Db2 security, RACF integration, roles, privileges and trusted contexts.

Configure WLM, DDF, TCP/IP, DRDA and distributed connectivity.

Manage Db2 buffer pools, EDM pools, storage groups and system resources.

Monitor Db2 performance using RMF, SMF, Db2 accounting/statistics and performance tools.

Troubleshoot Db2 abends, resource contention, locking, timeout and performance issues.

Manage Db2 utilities, image copies, REORG, RUNSTATS, RECOVER and CHECK DATA.

Support backup, recovery, disaster recovery and business-continuity solutions.

Configure and maintain Db2 Stored Procedures, User Defined Functions and native REST services.

Manage Db2 subsystem cloning, migration and environment refresh activities.

Coordinate Db2 changes with z/OS, Storage, Network, Security and Application teams.

Automate operational tasks using JCL, REXX, SQL and scheduling tools.

Maintain Db2 PROCLIB, PARMLIB, started tasks, procedures and operational documentation.

Participate in capacity planning, performance tuning and production incident resolution.

Required: Db2 for z/OS, JCL, SDSF, RACF, SMP/E, VSAM, JES2 and strong z/OS system programming knowledge.Role & responsibilities

Preferred candidate profile