Overview
Skills
Job Details
Title: Mainframe IMS Application Database Administrator
Location: Austin, TX (Remote)
Client: Railroad Commission of Texas -(455-25-25765)
Duration: 05+ Months
Due date: 04/09/2025
Description: 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 a DB2 DBA.
Administer mainframe application IMS databases.
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
- Proficient with performing DBRC forward recoveries
- Experience with selecting points in time to do valid recoveries and performing actual database recoveries.
- Knowledgeable of IBM IMS utilities and familiar with vendor utilities.
- Create, modify and maintain IMS database descriptions.
- Add, remove and re-org database records as needed. Monitor and maintain IMS database performance.
Application support issues that involve IMS databases. Assist application programmers on DBRC issues in the test environment o Research and resolve DBRC related abends in the production environment o Refresh Dev/Test databases with prod backup images as requested.
- Maintain Mainframe Operating Systems Administration
- Coordinate testing of mainframe software upgrades and Disaster Recovery plans with DCS vendor.
- Assist primary agency DCS contact with problem management and change management activities. o Maintains knowledge of DCS vendor standards and reports agency system non-compliance to management. o Coordinates the testing and deployment of mainframe software upgrades with DCS contractor.
- Reviews and tests mainframe disaster recovery plans with DCS contractor.
- Maintain and provide technical support for Mainframe Production Control and Support Jobs and monthly Mainframe Job Scheduler.
- Support agency application development work by creating and maintaining procedures for use during application deployments; and creating and expanding application environments during development.
- Provide technical assistance to programmers and operations personnel for all problems and testing that involves mainframe operations.
- Provide after-hour support for nightly batch Mainframe schedule COBOL and JCL programs.
Required Skills:
10 Years of Experience with z/OS Systems platform
5 Years of Experience with mainframe application IMS database administration
5 Years of Experience with DBRC and forward recoveries
7 Years of Experience in basic z/OS utilities: TSO, SYSVIEW and/or SDSF, JSF, Basic IBM utilities IDCAMS, IEBGENER, IEFBR14
5 Years of Experience with Batch and CICS Cobol, IMS programming and problem resolution
5 Years of Experience developing and troubleshooting complex JCL
5 Years of Experience with JCL, CICS, VSAM, and TSO
2 Years of Experience writing, analyzing, and debugging REXX programs in a z/OS environment
2 Years of Experience with IMS HAL databases
2 Years of Experience with IMS Catalog
Preferred Skills:
5 Years of Working knowledge of Top Secret setup, administration, and reporting
2 Years of Experience maintaining mainframe printer assignments, including working knowledge of IPPrintway
4 Years of Experience with ISPF panels, skeletons and REXX code
4 Years of Experience with ISMF storage functions
Working knowledge of batch SFTP and FTPS processing
Working knowledge of Informatica Power Exchange software using mainframe datasets (IMS and VSAM) as either a source or target for change data capture
Experience with logically related application IMS databases