Mainframe IMS Application Database Administrator (REMOTE)

DESCRIPTION OF SERVICES

• Provides technical leadership and guidance to the mainframe IMS application teams and collaborates with the Mainframe Systems teams to ensure the applications are highly available. Provide DBA maintenance and development support of application databases in all environments (development, acceptance, and production). Work will involve highly advanced (senior-level) systems administration in support of agency mainframe applications and supporting infrastructure; and coordination of day-to-day system administration functions. As the DBA, you will conduct performance monitoring and tuning activities, backup and recovery as well as troubleshooting applications on IMS databases.
• Routine system administration functions to include performance monitoring, security monitoring, and maintenance
• Work includes supporting processes, overseeing and coordinating mainframe operations in the State's Consolidated Data Center Services (DCS), and working with the Network Administration, Customer Support and Application Development & Support teams to provide support necessary for day-to-day mainframe operations.

The Worker will apply their expert knowledge and experience as a Mainframe IMS Application Database Administrator to support both the needs of the Legacy Systems as well as those for the Mainframe Transformation Team.

IMPORTANT : This position is for a hands-on Application IMS DBA, not for DB2 DBA.

WORKER SKILLS AND QUALIFICATIONS

As the DBA, you will conduct performance monitoring and tuning activities, backup and recovery as well as troubleshooting applications on IMS databases.

Proficient with using DBRC / RECONS and List reports

Assist application programmers on DBRC issues in the test environment

Assist primary agency DCS contact with problem management and change management activities.

MINIMUM SKILLS / EXPERIENCE REQUIREMENTS

Minimum Requirements :

Candidates who do not meet or exceed the minimum stated requirements (skills / experience) will be displayed to customers but may not be chosen for this opportunity.

Please complete the chart below and submit it with your response. Years of Experience Needed Candidate Years of Experience Required or preferred

Experience 7 Required Experience with z / OS Systems platform 5 Required Experience with mainframe application IMS

database administration 5 Required Experience with DBRC and forward recoveries

Required Experience in basic z / OS utilities : TSO, SYSVIEW and / or SDSF, JSF, Basic IBM

utilities IDCAMS, IEBGENER, IEFBR14 5 Required Experience with Batch and CICS Cobol, IMS

programming and problem resolution 5 Required Experience developing and troubleshooting

complex JCL 5 Required Experience with JCL, CICS, VSAM, and TSO 2 Required Experience writing, analyzing, and debugging

REXX programs in a z / OS environment 2 Required Experience with IMS HAL databases 2 Required Experience with IMS Catalog

5 Preferred Working knowledge of Top Secret setup,

administration, and reporting

Preferred Experience maintaining mainframe printer assignments, including working knowledge of IPPrintway 3+ Preferred Experience with ISPF panels, skeletons and

REXX code 3+ Preferred Experience with ISMF storage functions Preferred Working knowledge of batch SFTP and FTPS

processing

Preferred Working knowledge of Informatica Power Exchange software using mainframe datasets (IMS and VSAM) as either a source or target for change data capture Preferred Experience with logically related application

IMS databases