Mainframe IMS DB Tools Specialist

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

Pay: Up to $70.00 per hour

Work Location: Remote