IMS DB System Administrator

About the Role

We are looking for an experienced IMS System Programmer to install, maintain, and support our IMS V15 environment. You will own the day-to-day health of the IMS subsystem, from installation and fix maintenance through backup and recovery, and help the business evaluate new IMS capabilities.

Key Responsibilities

• Perform IMS V15 system programming: software installation and application of fixes.
• Carry out scheduled administrative activities, including system start-up and shutdown.
• Perform problem determination and resolution for IMS system software and related products, utilities, and tools.
• Define and implement policies for disk storage set-up, CPU consumption limits, and backup strategy for IMS subsystem objects.
• Administer and maintain IMS systems, including running backups and recovering corrupted data.
• Carry out research and proof-of-concept work to test new and recent features of IMS and related products, and report long-term cost-benefits to senior management on an ongoing basis.

Mandatory Skills

• Strong knowledge of RDBMS concepts
• Experience with IMS software upgrades
• Experience with complete system-level backup and recovery
• IMS system definition (IMSGEN / SYSGEN)
• Knowledge of IBM IMS utilities, including backup, reorganization, recovery, load, unload, and pointer checking
• Creation of databases, tablespaces, tables, and indexes
• Knowledge of basic IMS or Db2 commands
• Security management and space management
• Incident, change, and problem management
• SQL performance tuning
• Monitoring DBA housekeeping jobs, and resolving deadlocks and timeouts

Good-to-Have Skills

• Change and configuration management: testing and moving updates through staging environments (ITIL Change and Configuration Management)
• Problem identification, determination, and resolution for products or their usage, in conjunction with the requestor (ITIL Incident/Problem Management)