Mainframe IMS DB Tools Specialist

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, Department
  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