SQL Database Administrator
Apply NowJubil ID: 353
Company: CACI International
Location: Wright, MN
Description:
Role: Mainframe IMS Application Database Administrator Location: Work from home - USA Contract role Job description: NOTE: This position is for a hands-on Application IMS DBA
not for a DB2 DBA. WORKER 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 troubleshootin
Qualifications:
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
Assist application programmers on DBRC issues in the test environment
Refresh Dev/Test databases with prod backup images as requested
Coordinates the testing and deployment of mainframe software upgrades with DCS contractor
Reviews and tests mainframe disaster recovery plans with DCS contractor
Experience with z/OS Systems platform
Experience with mainframe application IMS database administration
Experience with DBRC and forward recoveries
Experience in basic z/OS utilities: TSO
SYSVIEW and/or SDSF
JSF
Basic IBM utilities IDCAMS
IEBGENER
IEFBR14
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
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
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
Responsibilities:
As the DBA
you will conduct performance monitoring and tuning activities
backup and recovery as well as troubleshooting applications on IMS databases
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
Research and resolve DBRC related abends in the production environment
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
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
Provide DBA maintenance and development support of application databases in all environments
