DB2 DBA

Charlotte, NC 28202

Post Date: 01/18/2018 Job ID: 27043 Industry: Information Technology

Provide Administration Support for Db2 Connect Gateway (v9.7 FP6 on AIX/Linux) used to connect up to Db2 on z/OS in Production, Development and Test subsystems residing on multiple LPARs in a 24x7 environment
Handle weekly on-call rotation as part of a DBA team for Db2 on z/OS (expected to perform root cause analysis, identify fixes, resolve issues by making appropriate changes using established procedures and document solutions primarily related to Db2 on z/OS and Db2 Connect)
Monitor Incident tickets and Provide Problem resolution based on customer Service Level requirements for issues related to Db2 & Db2 Connect 
Devise a long term plan to migrate current distributed processes to connect directly to Db2 v11 on z/OS using the Data Server Driver Package without going through the Db2 Connect gateway
Provide basic Support for applications/Projects by creating, migrating and implementing object definitions, Plans and Packages in Db2 on z/OS
Provide DBA Support for Mainframe/Db2 upgrades & Preventive Maintenance across LPARs/Subsystems by Performing Testing for Db2 & Db2 Connect Tools
Participate in annual Disaster recovery exercise Skills and Experience

Requirements: 

Advanced knowledge of Db2 Connect (v11 is a plus)
Good knowledge of the mainframe operating environment Including z/OS, TSO/ ISPF, JCL, all IBM Db2 tools and Utilities for Db2 on z/OS v9 or higher
At least 3 years’ experience with Db2 Connect and 2+ Years with Db2 v9.7 or higher 
At least 1 time experience with Db2 Connect Upgrades on a medium to large scale 
At least 4 years’ experience with Db2 on the Mainframe 

Desired: 

Batch Scheduler CA7, Zeke & Job history – IOF, JHS etc.
Coding language like DSNREXX
Data Extract Tool - OPTIM
Change management Tool - ENDEVOR
Storage – SMS & TMS 
Db2 Change Management – CA Catalog Manager and Change Manager,
CA Performance Monitors – DETECTOR, INSIGHT, SUBSYSTEM ANALYZER 
Apply Online

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: