Job Description
Must Have Technical/Functional Skills:
DB2/DBA in Mainframe Z O/S architecture.
TSO, MVS, JCL, SDSF & ISPF expert knowledge
Knowledge with Rexx coding and maintenance
Knowledge Cobol/VSAM capabilities
Full understanding of DASD requirements, calculations & interpretation
DB2 Master Console
DB2PMSTR
DB2PDBM1
DB2PDIST
DBA Administration/SKillset will include
DB2 UTS Conversion Strategies
Requirements, Limitations, Enhancements
DB2 v12
DB2 Catalog Tables
DB2 Performance Tunning, Explain and Plan Tables, Plan vs Packages
DB2 Partition Rotation Architecture
Understanding of DDL, DML & CML
Understanding DB2 PRIMARY OPTION MENU
SPUFI, DCLGEN, PROGRAM PREPARATION, PRECOMPILE, BIND/REBIND/FREE, RUN, DB2 COMMANDS, UTILITIES, DB2I DEFAULTS
DB2 Commands
Display, Cancel Threads, Term Utility, Start/Stop, etc
DB2 IBM Tool sets DB2 Administration Menu
DB2 Utilities
UNLOAD/LOAD, IMAGE COPY, RUNSTATS, REORGS, RECOVER, CHECK Data/Index, REPAIR, STOSPACE, DSNCOPY
DB2 Logs
Roles & Responsibilities:
Maintain the integrity of the data of the organization, while facilitating Business developments and innovations through deploys and user provisioning.
Focus on detailed data problems and come up with creative and efficient solutions.
Other duties as assigned