About The Position

The Sr. DB2 zOS Systems Programmer monitors and manages DB2 for z/OS environments, including system resources, performance, maintenance, software, and related tools. The role investigates and resolves DB2 software and performance issues, identifies root causes, develops workarounds and preventive measures, and responds to S1 calls. It also supports Disaster Recovery planning and recovery, subsystem builds and relocations, and the implementation of DB2 features and tools. The position works with IBM and ISV support teams, application staff, and the internal DB2 community. It manages DB2 catalog and directory, WLM, bufferpools, zparms, procedures, RLF, RTS, stored procedures, reorgs, runstats, and rebinds. It contributes to monitoring and trending, REXX automation, SQL performance tuning, software upgrades and maintenance, and documentation such as SOPs, runbooks, procedures, and change controls. The role is hybrid, with three days per week onsite at one of the listed locations: Bethlehem, Pennsylvania; Stamford, Connecticut; Holmdel, New Jersey; or New York City. Local candidates only. The position is a contract of 12 or more months.

Requirements

  • At least 10 years of experience as a DB2 for z/OS Systems Programmer.
  • Ability to monitor and tune DB2 performance and diagnose issues involving data distribution, cardinality, join structures, bufferpools, and data-sharing members.
  • Experience managing DB2 subsystem components and operations, including catalog/directory, WLM, bufferpools, zparms, procedures, RLF, RTS, reorgs, runstats, rebinds, and stored procedures.
  • Experience with DB2 software installation, upgrades, maintenance, PTFs, and software fixes using SMP/E and related processes.
  • Ability to support Disaster Recovery, change control, technical documentation, and coordination with application teams and vendors.
  • Local to one of the listed onsite locations; the role requires onsite work three days per week.

Nice To Haves

  • Experience with IBM DB2 Connect.
  • Experience with a DB2 data-sharing environment.
  • Experience with mainframe/DB2 secure transfers.

Responsibilities

  • Monitor DB2 system storage, memory, I/O, and CPU resources and design performance improvements.
  • Evaluate and recommend technology solutions for new and existing business requirements.
  • Perform daily checklists, review DB2 reports for anomalies, and open ServiceNow tickets for application groups to resolve problems.
  • Resolve DB2 software-related problems and work with IBM and ISV Level 2 and technical support teams to investigate them.
  • Respond to S1 calls; evaluate DB2 components for stability or errors; identify root causes, workarounds, and preventive measures.
  • Create and maintain DB2 systems SOPs, runbooks, and other environment documentation.
  • Participate in planning and recovery of DB2 subsystems for Disaster Recovery.
  • Use the ServiceNow ticketing process for change control, complete systems-task checklists, and submit change controls for review.
  • Manage DB2 catalog and directory, WLM, bufferpools, zparms, procedures, RLF, and RTS.
  • Build new DB2 subsystems or relocate existing subsystems upon request.
  • Assist with implementing Data Studio and debugger tools.
  • Provide technical expertise and guidance to the internal DB2 community.
  • Develop DB2 monitoring and trending metrics using the MainView shipped SMF database.
  • Manage DB2 reorgs, runstats, rebinds, procedures, RTS, RLF, and stored procedures.
  • Contribute to REXX automation/autonomics for preventative, corrective, and predictive outage-avoidance measures.
  • Tune tablespaces, partitions, and indexes; assist application staff with well-tuned SQL; and diagnose performance issues involving data distribution, cardinality, join structures, bufferpools, and data-sharing members.
  • Explain the distinction between Explain output and run-time access-path determination.
  • Use SMP/E, IBM Link, and ShopZSeries to upgrade and maintain IBM and BMC DB2 products; receive, apply, and propagate software fixes across supported DB2 platforms.
  • Plan and manage software upgrades and product implementations for DB2 environments, coordinating maintenance and upgrades with affected applications.
  • Install, support, and customize licensed DB2 software and related client and third-party tools; upgrade DB2 subsystem environments to newly released versions.
  • Perform OEM and DB2 problem analysis and resolution, and maintain OEM documentation.
  • Implement advanced DB2 software features and functions, such as DB2 Data Sharing and native XML.
  • Maintain DB2 at optimal maintenance levels and apply PTFs as needed.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service