Senior DB2/IMS Mainframe DBA – 24x7 Production Support

Valiant Technologies LLC

Chicago (IL)

On-site

USD 110,000 - 150,000

Full time

7 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Valiant Technologies LLC seeks an experienced DB2/IMS Database Administrator to provide 24x7 production support for DB2 and IMS environments. You will monitor performance, troubleshoot incidents, and manage backup/recovery, reorgs, and patching.

You will collaborate with developers on data access strategies and participate in releases to ensure production readiness. The role requires expertise in DB2 for z/OS, IMS, JCL/TSO, and mainframe tooling, with a focus on security, compliance, and

Qualifications

6+ years of hands-on experience supporting DB2 for z/OS and IMS in a production environment.
Proven experience as a DB2/IMS Database Administrator in production support environments.
Strong knowledge of mainframe tools such as SPUFI, QMF, BMC, CA-DB2/IMS tools, and IBM utilities.
Deep understanding of DB2 database internals, logs, buffer pools, catalog/directory, and utilities.
Proficient in IMS Full-Function and Fast Path databases, DL/I calls, PSB/DBD maintenance.
Solid experience with JCL, TSO/ISPF, SDSF, and mainframe batch job troubleshooting.
Experience with modern mainframe automation tools and schedulers (e.g., Control‑M, CA‑7).
Knowledge of COBOL, CICS, and batch job data flows.
Understanding of DB2 Data Sharing and IMS Sysplex environments.
Experience with backup and recovery solutions
Solid knowledge of Linux/Unix systems and scripting (Shell, Python, or similar).
Proficiency in troubleshooting performance tuning, and capacity planning.
In‑depth understanding of data management (e.g. permissions, recovery, security and monitoring)
Strong troubleshooting and problem‑solving skills.
Excellent communication and collaboration abilities.
Ability to work in a 24/7 support rotation and handle urgent production issues.
Familiarity with data security is the best practice and backup procedures.

Responsibilities

Provide 24x7 support for DB2 and IMS database environments, including on‑call rotation.
Monitor database performance, availability, and integrity using mainframe tools and utilities.
Respond to incidents, troubleshoot issues, and resolve problems related to DB2/IMS systems.
Perform database backup and recovery procedures for DB2 and IMS databases.
Conduct regular reorgs, image copies, and utilities execution (RUNSTATS, REORG, CHECK).
Support DB2 and IMS subsystem maintenance, upgrades, and patching.
Analyze and tune SQL queries, buffer pools, and access paths in DB2.
Optimize IMS database segments, DBDs, PSBs, and access methods.
Work with developers to design efficient data access strategies.
Review and implement database schema changes via Change Control processes.
Participate in software releases, ensuring database readiness and minimal impact on production.