Oak Brook, IL 60523

Posted: 08/27/2018 Industry: Other Area(s) Job Number: 31022




This DB2 DBA is responsible for Database reorgs (the is a scheduled RCA/PAR reorg on Weds mornings, others are less scheduled.  This will be on a  z/OS Mainframe v8.6 environment.

Evaluate table spaces from any system code that are poorly reorganized

Evaluate poorly performing SQL queries/programs daily, work with programmer or user to modify query

Use DB2 query monitor Use TMON Use SDSF Analysis using DB2 EXPLAIN facility Scheduled job utililities support Identify single bad queries Identify hung CICS transactions

Retire DB2 applications as they are removed from the mainframe

Monitor known issues with existing applications (ex. DB2PR070 tables with referential integrity problems) DDF connections and DB2

Connect RACF issues Audit and compliance PSJOB and PSNOTIFY

Interact with Ensono during some issues that can be the result of upgrades and undocumented features

Collaborate with other DBA' s or programmers who are defacto Application DBA' s Cover anything Ensono does not consider to be in their SLA Random things come up, the expectation is that you learn what you need to learn and address the issue Always oncall.


Bachelor’ s degree plus 3 years of demonstrated professional IT Systems DB2 DBA experience OR Associate’ s degree plus 5 years of demonstrated professional IT Systems DB2  DBA experience. A high school diploma and 7 years of demonstrated professional IT Systems DB2 DBA experience in a large, complex enterprise organization may be considered in lieu of the degree.

Must have DB2 DBA experience on  z/OS Mainframe v8.6

Ability to work remote - US based
Apply Online
Apply with LinkedIn Apply with Facebook Apply with Twitter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.