Mainframe Db2 Engineer

Mainframe Db2 Engineer
Midvale, UT

Job Description
Skill: Mainframe Db2

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:
Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements 
Recommend operating system and database performance monitoring, tuning and configuration changes
Experience with database physical and logical design, query analysis and optimization
Provide technical assistance and subject matter expertise to applications groups 
Provide database storage management and capacity management recommendations
Define and manage database security and access permissions in consultation with customer
Ensure completion of authorized Service Requests, Changes, Problem tickets
Manage escalations and track Service Delivery and ensure SLA compliance including with vendors
Review and update the SOP documents on regular basis
Support on all in-flight and upcoming project activities
 Recommend and perform customer-approved database replication procedures