DB2 / IMS Database Administrator
Core
Provide day-to-day administration, production support, performance tuning, backup/recovery, and disaster recovery for DB2 for z/OS and IMS databases in large-scale z/OS production environments.
Role type
Senior DB2/IMS Database Administrator
Builds
Stable, recoverable, and performant mainframe database environments for business-critical applications
Domain
Mainframe (z/OS), Enterprise Data Management
Required skills
DB2 for z/OS administration, IMS DB/DC administration, SQL tuning, JCL, TSO/ISPF, DB2 BIND/REBIND, IMS DBRC/RECON, backup and recovery utilities, performance monitoring, root-cause analysis
Preferred skills
IMS/TM, VSAM/OSAM, REXX, COBOL, DFSORT, IDCAMS, SMP/E, OMEGAMON, BMC MainView, CA/BMC tools, DB2 Query Monitor
Technologies
DB2 for z/OS, IMS DB/DC, z/OS, JCL, TSO/ISPF, SQL, REORG, RUNSTATS, LOAD, UNLOAD, DBRC, RECON
Responsibilities
Monitor database health, performance, and storage utilization; Execute DB2 maintenance utilities (REORG, RUNSTATS, LOAD, UNLOAD); Troubleshoot and resolve database incidents and performance issues; Participate in on-call rotation and disaster recovery exercises; Collaborate with application teams on database design and service requests; Maintain technical documentation and runbooks
Seniority
Senior, hands-on IC