Mainframe IMS DB Tools

Key Skills
IMS system programming (install, configure, maintain)
IMS in Parallel Sysplex administration
IMS tools expertise IBM, BMC, Broadcom/CA
z/OS systems programming fundamentals
Tool migration / conversion experience
Role Profile
Job Description/ Responsibilities Core Technical Skills:
Install, configure and manage IMS in a parallel sysplex environment
Install, configure and manage IBM IMS Tools
IMS systems programming
Establishing policies and procedures pertaining to database management, DR, security, maintenance and utilization
Reviewing new versions of IMS for functionality, advising how they benefit the client
Evaluating change requests and determine impact to assigned clients
Vendor consultations for problems and questions
DR recovery of application objects
Lead and execute complex migrations to IBM IMS Tools from 3rd party products
Develop a project plan with defined phases (Planning, Conversion, Implementation, Cutover) and timelines, ensuring alignment with client objectives and internal best practices
Conduct customer training sessions and develop presentation materials for IMS Tools and migration processes
Database Skills
Database Administration
Knowledge of IMS database organization using access methods of VSAM and OSAM
Full function database organization types
HSAM, HISAM, SHISAM, HDAM, HIDAM, INDEX, GSAM
Definition and use of LOGICAL databases
HALDB (partitioned): PHDAM, PHIDAM, ILDS, PSINDEX, etc.
Fast Path databases (DEDBs)
Database Design and related utilities
DBD source coding and DBDGEN
PSBGEN source coding and PSBGEN
How databases are processed using secondary indexes (PROCSEQ=)
Correct usage of PROCOPT= to minimize database locking
ACBGEN
Online Change
IMS Catalog and IMS Management of ACBs
Database monitoring
Space management
Database dataset space reporting for proactive outage avoidance.
How to immediately fix an out of space condition for a VSAM database dataset
Optional Skills
BMC IMS Tools experience
Broadcom IMS Tools experience
Z/OS scheduling expertise
IMS DBA experience
Troubleshooting and solving production database issues
Install, configure and manage IMS in a parallel sysplex environment
Install, configure and manage IBM IMS Tools
IMS systems programming
Establishing policies and procedures pertaining to database management, DR, security, maintenance and utilization
DR recovery of application objects
Lead and execute complex migrations to IBM IMS Tools from 3rd party products

Work arrangement
Yes