IMS Database Administrator

Columbia, South Carolina

CAI
Apply for this Job
Job ID Number

R5073

Employment Type

Full time

Worksite Flexibility

Remote

Job Summary

We are looking for a motivated IMS Database Administrator ready to take us to the next level. If you have 7+ years of experience with z/OS Systems platform and 5+ years of experience with mainframe application IMS database administration, apply now.

Job Description

We are looking for an IMS Database Administrator to administer mainframe application IMS databases. This position will be a contract through August, 2025 and Remote .

Due to our end client, candidates must be able to work on CAI's W2 without a need for sponsorship now or in the future.

What You'll Do
  • Administer mainframe application IMS databases
  • Conduct performance monitoring and tuning activities, backup and recovery, and troubleshoot applications on IMS databases
  • Use DBRC/RECONS and List reports proficiently
  • Perform DBRC forward recoveries
  • Select points in time to do valid recoveries and perform actual database recoveries
  • Utilize IBM IMS utilities and be 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
  • Address application support issues involving 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
  • Maintain knowledge of DCS vendor standards and report agency system non-compliance to management
  • Coordinate the testing and deployment of mainframe software upgrades with DCS contractor
  • Review and test mainframe disaster recovery plans with DCS contractor
  • Maintain and provide technical support for Mainframe Production Control
  • 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 involving mainframe operations
  • Provide after-hour support for nightly batch Mainframe schedule COBOL and JCL programs
What You'll Need

Required:
  • Bachelor's degree in computer science or a related field
  • 7+ years of experience with z/OS Systems platform, basic z/OS utilities: TSO, SYSVIEW and/or SDSF, JSF, Basic IBM utilities IDCAMS, IEBGENER, IEFBR14
  • 5+ years of experience with mainframe application IMS database administration, DBRC and forward recoveries, batch and CICS Cobol, IMS programming and problem resolution, developing and troubleshooting complex JCL, VSAM, and TSO
  • 3+ years of experience with ISMF storage functions, ISPF panels, skeletons, and REXX code
  • 2+ years of experience writing, analyzing, and debugging REXX programs in a z/OS environment
  • 2+ years of experience with IMS HAL databases, IMS Catalog
Preferred:
  • Experience maintaining mainframe printer assignments, including working knowledge of IPPrintway
  • 5+ years of experience of Top Secret setup, administration, and reporting
  • Knowledge of batch SFTP and FTPS processing
  • Knowledge of Informatica Power
  • Experience with 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
Physical Demands
  • Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards
  • Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
  • Must be able to communicate with customers/team members over the phone and in person
  • Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.


Reasonable Accommodation Statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to or 824 - 8111.

Equal Employment Opportunity Policy Statement

CAI is committed to equal employment opportunity. We do not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability, or veteran status. All employment decisions are based on valid job requirements, including hiring, promotion, and compensation. Harassment and retaliation are prohibited.

Date Posted: 05 April 2025
Apply for this Job