Managing procedures and tools required to support development and testing activities
Assisting in all operational environments in the maintenance of production data and data archiving
Functioning as a Subject Matter Expert (SME) for solving complex problems
Supporting IMS and stored procedure calls
Works with the Project Manager and Release Coordinators to control changes made to supported databases
Support of day-to-day production, conversions, application and enterprise IT projects
Disaster recovery
Logical/physical database design and performance tuning
Ability to troubleshoot IMS service calls from a host and distributed environment
Provide on-call support on a rotational basis outside normal business hours as needed

Requirements

6+ years of DBA experience in a z/OS / MVS environment
6+ years database administration for IMS in an IBM mainframe environment
4-year college degree or equivalent
Knowledge of IMS Database Manager, DBD source and generation
Understanding of Database Recovery Control [DBRC] information and commands
BMP and basic DL/I coding imbedded in COBOL source
Familiarity with IMS Transaction Manager
Basic control region and message region processing
PSB coding and generation
ACB, MODBLKS, and FORMAT generation
Strong working knowledge of HALDB partitioning schemes and underlying structures
Ability to backup and restore and maintain partitions
Familiarity with IMS Utility JCL, execution, restart, commands for Database allocation changes
DB2 for z/OS DB2 Catalog knowledge
Understanding of DB2 security administration including Grants, Revokes
Basic knowledge of required authorities for application development including Bind, Plans, Packages
Familiarity with DB2 Utility JCL, execution, restart
Understanding of utility impact on DB2 object availability
Knowledge of SQL and basic DB2 development techniques
Ability to understand COBOL and SQL/PL for analysis
z/OS, TSO, ISPF, JCL, and SDSF Coding and debugging
Familiarity with RACF, rules protecting datasets

Benefits

healthcare benefits (health, vision, dental)
insurance benefits (short & long-term disability)
performance-based incentive plans
paid time off
401(k) retirement plan with an employer match up to 5% and an additional 4.5% contribution whether you contribute to the plan or not

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

DBA experienceIMS database administrationdatabase recovery controlBMP codingDL/I codingIMS Transaction ManagerHALDB partitioningDB2 for z/OSSQLCOBOL

Soft Skills

problem solvingon-call supportcollaboration

Certifications

4-year college degree