Key Responsibilities
Install, configure, maintain, and upgrade Db2 for z/OS subsystems.
Apply maintenance and fixes using SMP/E.
Administer production and non-production Db2 databases.
Execute and optimize Db2 utilities, including REORG, RUNSTATS, COPY, RECOVER, LOAD, and REBUILD INDEX.
Monitor and tune Db2 subsystems, SQL, buffer pools, locking, logging, storage, and application performance.
Support backup, recovery, high availability, and disaster-recovery testing.
Troubleshoot production incidents and perform root-cause analysis.
Support Q Replication, SQL Replication, Change Data Capture, and Db2 Connect.
Collaborate with application, CICS, storage, security, and z/OS infrastructure teams.
Follow ITIL incident, problem, change, and release-management processes.
Maintain technical documentation, implementation plans, and operational procedures.
Participate in rotational on-call and scheduled after-hours support.
Core Technical Skills
Db2 for z/OS
z/OS, MVS, TSO/ISPF, SDSF, JES2/JES3
CICS, IMS, RACF, DFSMS, and SMP/E
SQL, COBOL, REXX, CLIST, SAS, or Assembler
Q Replication, SQL Replication, and Change Data Capture
Db2 Connect and Informatica PowerExchange
OMEGAMON, IntelliMagic, MXG, BMC MainView, Apptune, Query Monitor, TMON, Strobe, or Db2PM
TWS/OPC, SA z/OS, and NetView
Proposed Senior-Level Differentiation
10 12+ years of relevant Db2 for z/OS experience
Independent ownership of subsystem administration, upgrades, migrations, and complex production issues
Advanced performance tuning and recovery expertise
Technical leadership, client communication, mentoring, and project ownership
Serves as the escalation point for high-severity incidents
Proposed Junior-Level Differentiation
Approximately 3 6 years of relevant mainframe or Db2 experience
Supports database administration, monitoring, utilities, maintenance, and incident resolution under senior guidance
Working knowledge of Db2, z/OS, JCL, SQL, TSO/ISPF, and production-support processes
Willingness to participate in on-call support and develop deeper systems-programming expertise