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:
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.
#LI-KG6