Mainframe IMS DB2 System Programmer

Required Skills and Experience
• 10+ years of professional experience in IMS and DB2 database administration.
• BMC COPE and IBM tools for IMS and DB2.
• Hands-on experience with IMS/DB2 performance monitoring and automation.
• Establishing policies and procedures pertaining to database management, DR,
maintenance and utilization
• Strong knowledge of IMS/DB2 utilities, backup/recovery processes, and database
tuning techniques.
• Expertise in IMS Full Function, HALDB, Fast Path, DB2 for z/OS, and various
IMS/DB2 utilities.

Preferred Skills and Experience
• Bachelor’s degree in computer science or a related field.
• Manage IMS database structures (VSAM, OSAM, HALDB, Fast Path, GSAM), DB2
storage, locking, and referential integrity.
• Disaster recovery planning, log archive management, DBRC utilities, and forward
recovery.
• Experience with Tools: IBM DB2 V12+, IMS V15, IBM InfoSphere Data Replication
(CDC), Query Monitor, SQL Performance Analyzer.

Key Responsibilities:
• To lead DB2 z/OS projects and initiatives, working together with experienced DB2
z/OS and IMS DBAs.
• To work closely with IMS and DB2 z/OS System Programmers on IMS and DB2 z/OS
systems and tools upgrades.
• To provide DBA support to a list of critical applications that use DB2 z/OS and IMS
databases/transactions.
• The individual will need to work with vendor personnel to achieve timely solutions of
database problems.
• System programming knowledge of multiple DBMS's is a bonus.
• The individual will need to participate in on-call responsibilities.