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