Job Title: Mainframe IMS Application Database Administrator
Location: Remote
Duration: 4+ Months Contract
The consultant 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.
SKILLS AND QUALIFICATIONS
- 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
- Research and resolve DBRC related abends in the production environment
- 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.
- Maintains knowledge of DCS vendor standards and reports agency system non-compliance to management.
- 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 / YEARS OF EXPERIENCE
- Experience with z/OS Systems platform – 7
- Experience with mainframe application IMS database administration – 5
- Experience with DBRC and forward recoveries – 5
- Experience in basic z/OS utilities: TSO, SYSVIEW and/or SDSF, JSF, Basic IBM utilities IDCAMS, IEBGENER, IEFBR14 – 7
- Experience with Batch and CICS Cobol, IMS programming and problem resolution – 5
- Experience developing and troubleshooting complex JCL – 5
- Experience with JCL, CICS, VSAM, and TSO – 5
- Experience writing, analyzing, and debugging REXX programs in a z/OS environment – 2
- Experience with IMS HAL databases – 2
- Experience with IMS Catalog – 2
PREFERRED
- Working knowledge of Top-Secret setup, administration, and reporting
- Experience maintaining mainframe printer assignments, including working knowledge of IP Printway
- Experience with ISPF panels, skeletons and REXX code
- 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
