Sr. DB2 DBA- REMOTE
- Oak Brook, IL 60523
DB2 DBA - REMOTE
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