Mainframe DB2 DBA

U.S. Tech Solutions Inc.

McLean, VA, United States

4 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Application Performance Management Customer Information Control System (CICS) CLIST COBOL (Programming Language) Databases IBM DB2 Job Control Language (JCL) Rexx (Programming Language) Tivoli Management Framework Job Entry Subsystem 2/3 MVS (OS) Performance Tuning

+10 more

IBM Resource Access Control Facility SAS (Software) SQL Databases Subsystems Z/OS Data Logging Tso/ispf System Availability Change Data Capture Omegamon

Job description

Install, configure, maintain, and upgrade Db2 for z/OS subsystems.
Apply maintenance and fixes using SMP/E.
Administer production and non-production Db2 databases.
Execute and optimize Db2 utilities, including REORG, RUNSTATS, COPY, RECOVER, LOAD, and REBUILD INDEX.
Monitor and tune Db2 subsystems, SQL, buffer pools, locking, logging, storage, and application performance.
Support backup, recovery, high availability, and disaster-recovery testing.
Troubleshoot production incidents and perform root-cause analysis.
Support Q Replication, SQL Replication, Change Data Capture, and Db2 Connect.
Collaborate with application, CICS, storage, security, and z/OS infrastructure teams.
Follow ITIL incident, problem, change, and release-management processes.
Maintain technical documentation, implementation plans, and operational procedures.
Participate in rotational on-call and scheduled after-hours support.

Core Technical Skills

Db2 for z/OS
z/OS, MVS, TSO/ISPF, SDSF, JES2/JES3
CICS, IMS, RACF, DFSMS, and SMP/E
SQL, COBOL, REXX, CLIST, SAS, or Assembler
Q Replication, SQL Replication, and Change Data Capture
Db2 Connect and Informatica PowerExchange
OMEGAMON, IntelliMagic, MXG, BMC MainView, Apptune, Query Monitor, TMON, Strobe, or Db2PM
TWS/OPC, SA z/OS, and NetView

Requirements

10-12+ years of relevant Db2 for z/OS experience
Independent ownership of subsystem administration, upgrades, migrations, and complex production issues
Advanced performance tuning and recovery expertise
Technical leadership, client communication, mentoring, and project ownership
Serves as the escalation point for high-severity incidents

Proposed Junior-Level Differentiation

Approximately 3-6 years of relevant mainframe or Db2 experience
Supports database administration, monitoring, utilities, maintenance, and incident resolution under senior guidance
Working knowledge of Db2, z/OS, JCL, SQL, TSO/ISPF, and production-support processes
Willingness to participate in on-call support and develop deeper systems-programming expertise