IMS Application Database Administrator

Allied Consultants, Inc.•Austin, QC

3d•Remote

About The Position

Allied Consultants, Inc is a proudly Austin based firm with over 34 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience IMS Application Database Administrator to play a key role within a high-impact technical services team. At Allied Consultants, we value our consultants and are committed to providing an exceptional experience including: Highly competitive pay rates, Local support staff for responsive, personal service, Comprehensive benefits package, including: Medical insurance (with employer cost sharing), Life insurance, A 401(K) plan with company match, Flexible spending through a cafeteria plan. Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening, in compliance with federal and state regulations. All offers of employment are contingent upon successful completion of these checks. Allied Consultants is a proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Requirements

Experience with z/OS Systems platform
Experience in basic z/OS utilities: TSO, SYSVIEW and/or SDSF, JSF, Basic IBM utilities IDCAMS, IEBGENER, IEFBR14
Experience with mainframe application IMS database administration
Experience with DBRC and forward recoveries
Experience with Batch and CICS Cobol, IMS programming and problem resolution
Experience developing and troubleshooting complex JCL
Experience with JCL, CICS, VSAM, and TSO
Experience writing, analyzing, and debugging REXX programs in a z/OS environment
Experience with IMS HAL databases
Experience with IMS Catalog

Nice To Haves

Working knowledge of Top-Secret setup, administration, and reporting.
Experience with ISPF panels, skeletons and REXX code
Experience with ISMF storage functions
Experience maintaining mainframe printer assignments, including working knowledge of IPPrintway
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

Responsibilities

Provides technical leadership and guidance to the mainframe IMS application teams and collaborate 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 production control 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.
Administer mainframe application 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.