Database Administrator (DB2 on z/OS)

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 8 Month(s)
No Travel Required

Skills

DB2 DBA experience on z/OS
DB2 V10+ utilities
Data Studio
Admin Tool
Automation Tool
Query Monitor
Optim Workload Query Tuner
File Manager
Tivoli OMEGAMON
QMF
TSO/ISPF
JCL
DFSORT/ICETOOL
REXX
z/OS utilities

Job Details

Local Candidates Preferred.

Required Skills:

10+ years DB2 DBA experience on z/OS (v12 or higher)

Expertise in high availability 24x7 designs, performance tuning, large data store management

Strong skills in SQL code review/optimization, logical & physical data modeling, data warehouse/OLAP design

Hands-on with DB2 V10+ utilities, stored procedures, triggers, referential integrity, backup/recovery & DR planning

Proficiency in DB2 tools: Data Studio, Admin Tool, Automation Tool, Query Monitor, Optim Workload Query Tuner, File Manager, Tivoli OMEGAMON, QMF

Knowledge of attachments/interfaces: DRDA, DB2 Connect

z/OS mainframe skills: TSO/ISPF, JCL, DFSORT/ICETOOL, REXX, z/OS utilities

Desired Skills:

DB2 Certification (V9/V10), IMS database experience, ETL tools (InfoSphere, Informatica)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.