What are the responsibilities and job description for the Mainframe IMS Application Database Administrator position at JID Solutions Inc?
Job Overview
We are seeking a skilled and detail-oriented Database Administrator to work Railroad Commission of Texas.
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 Applications 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 a DB2 DBA.
WORKER SKILLS AND QUALIFICATIONS
- Administer mainframe application IMS databases.
o 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.
o 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.
o 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.
o 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.
Years of Experience Required/Preferred Experience Description
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
7 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
2 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 log
Join us in this exciting opportunity to contribute your expertise as a Database Administrator while growing your career in a supportive environment.
Job Type: Contract
Pay: $62.00 - $65.00 per hour
Expected hours: 40 per week
Schedule:
- 8 hour shift
- On call
Work Location: Hybrid remote in Austin, TX 78757
Salary : $62 - $65