Senior DB2 z/OS DBA

Greymatter Solutions; Washington (District of Columbia); Remote; USD 68.000 - 97.000; Vollzeit

Zusammenfassung

Greymatter Solutions is seeking a Senior DB2 z/OS DBA for remote engagement. The role involves managing Db2 for z/OS subsystems, applying SMP/E fixes, and ensuring high availability across production and non-production environments.

Responsibilities include performance tuning, coordinating backups, DR testing, and collaborating with CICS/storage teams. Strong expertise in Db2 utilities, replication, and change data capture is required.

Qualifikationen

• Extensive experience with Db2 for z/OS and mainframe subsystems.
• Strong knowledge of z/OS, MVS, TSO/ISPF, SDSF, JES2/JES3.
• Experience with SMP/E maintenance and DB2 utilities.

Aufgaben

• 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 utilities like REORG, RUNSTATS, COPY, RECOVER, LOAD.
• Monitor and tune subsystems, SQL, buffer pools, locking, logging, storage, performance.
• Support backup, recovery, HA, and DR testing.
• Troubleshoot incidents and perform root-cause analysis.
• Support Q Replication, SQL Replication, and Change Data Capture.
• Collaborate with application, CICS, storage, security teams; follow ITIL processes.
• Maintain documentation and participate in on-call rotations.

Tools

Db2 for z/OS

z/OS

SMP/E

CICS

SQL

Q Replication

SQL Replication

Change Data Capture

Db2 Connect

Informatica PowerExchange

Jobbeschreibung

Remote Roles

Rate: $60/hr on c2c

Role: Senior DB2 z/OS DBA

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