IBM DB2 Consultant

ProKatchers • Trenton, NJ

9d • Onsite

About The Position

OIT supplemental DB2 Technical/Database support for upgrading DB2 Version 10 to Version 11. Maintain and support DB2 databases, providing backups, recoveries, and disaster recovery. Monitor space utilization for all DB2 databases, logs, etc. Monitor DB2 database fragmentation and perform reorgs when required. Provide logical and physical database design and implementation of physical DB structures into DB2 DBMS. Provide technical and lead Database support for OIT projects to facilitate successful completion of established goals. Daily core-hour onsite support presence and on-call availability during off hours

Requirements

• IBM DB2 DBMS
• DB2 connect
• IBM Z/OS
• IBM Utilities
• IBM JCL
• TSO
• 10 years of IBM DB2.
• 4 year college degree or equivalent technical study.

Nice To Haves

• CA DB2 SYSVIEW monitoring.
• Understanding of NJ OIT business processes and operations.

Responsibilities

• Maintain and support DB2 databases, providing backups, recoveries, and disaster recovery.
• Monitor space utilization for all DB2 databases, logs, etc.
• Monitor DB2 database fragmentation and perform reorgs when required.
• Provide logical and physical database design and implementation of physical DB structures into DB2 DBMS.
• Provide technical and lead Database support for OIT projects to facilitate successful completion of established goals.
• Daily core-hour onsite support presence and on-call availability during off hours

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level