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