Job description

Duration: 6+ Months Key Responsibilities • 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 Proposed Senior-Level Differentiation • 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 Note: • Remote About US Tech Solutions: US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com. US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. AI Statement: By applying, you acknowledge that AI-assisted tools may be used during hiring.

Requirements

Must-haves

Duration: 6+ Months
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
Proposed Senior-Level Differentiation
10–12+ years of relevant Db2 for z/OS experience

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlai

Platform: jobdiva
Effort: medium