Blog

Hi,

Mainframe DB2/IMS Systems Database Administrator

Dallas, TX-Remote

Contract

Must-have skills for this role:

1. Hands on working operations experience with mainframe DB2 database system administration, proficiency with IMS database desirable

2. Install, implement, test, tune DB2, and IMS DB and DC system

3. Hands-on knowledge of SMP/E to install, maintain, test, and configure base system libraries

Years of experience required for each skill: 10+

Primary job duties / responsibilities:

• Install, implement, test, tune DB2, and IMS DB and DC system.

• Maintain/tune backup-recovery processes for DB2, and IMS DR.

• Administer IMS system using consoles, JCL, DL/I, backup, reorg.

• Manage and maintain IBM DB2 databases, ensuring their availability, security, and performance.

• Responsible for SDLC, PSB generation, copybooks, templates, Message Format Service (MFS) DBRC and IMS control/message regions.

• Work with DB monitoring tools.

• Hands-on knowledge of SMP/E to install, maintain, test, and configure base IMS system libraries.

• Configure and maintain IMS data sharing across multiple Sysplex environments.

• Manage and maintain IBM IMS databases, ensuring their availability, security, and performance.

• Proficient skills in z/OS, CICS, JCL, CLIST/REXX.

• Strong troubleshooting skills.

• Design and implement database solutions that meet business requirements.

• Collaborate with the development team to ensure database solutions are integrated with applications.

• Perform database backups, restores, and disaster recovery procedures.

• Monitor database performance and tune as necessary to optimize performance.

• Experienced in Service Management, Service Delivery, Incident Response, Problem Management, and Change Management to support a live production environment 24*7 .

Nice-to-have skills:

1. Scripting language support or other i.e., Programming (Assembler, COBOL, REXX).

2. Experience with release planning and management products.

3. Experienced in Service Management, Service Delivery, Incident Response, Problem Management, and Change Management to support a live production environment 24*7.