JOBSEARCHER

Sr Mainframe Database Systems Engineer (IBM Db2)

RangamBel Air, MDL6 LeadNovember 10th, 2026
Responsible for performing complex analysis and implementation of database infrastructure platforms across cloud and on-premises environments with a high degree of accuracy and speed as an individual contributor.
Additional Job Responsibilities:
  • Serve as the lead Db2 for z/OS systems programmer/engineer. You'll be accountable for the installation, configuration, maintenance, health and availability of all Db2 subsystems across production and non-production environments.
  • Plan and apply software maintenance using SMP/E, including PTFs, RSU and HIPER service, and maintenance for IBM, BMC and Broadcom tools. Sequence the work around enterprise freezes and blackout periods.
  • Lead Db2 version migrations and function level activations from planning and testing through implementation and fallback.
  • Own subsystem configuration and tuning:
  • Db2 parameters (DSNZPARMs), buffer pools, memory and EDM pools
  • Active and archive logs and the BSDSIRLM, WLM application environments and RRSLead subsystem-level problem determination and recovery, including restart and log or BSDS issues, storage constraints and dump analysis. Manage cases with IBM and other software vendors.
  • Manage Db2 connectivity and security, including DDF/DRDA, TCP/IP, certificates and TLS, and RACF integration. Partner with z/OS security, network and storage teams.
  • Participate when required in the activities related to monitoring subsystem performance and capacity using SMF data and monitoring tools
  • Own subsystem-level disaster recovery and business continuity procedures, participate in DR exercises, and provide audit and SOX evidence.
  • Provide technical direction and oversight to the managed service partner that executes routine Run work. Review their plans, approve changes and validate results.
  • Mentor DBAs and managed service resources. Build and maintain runbooks and documentation so critical knowledge doesn't rest with one person.
  • Maintain a product currency calendar that tracks versions, end-of-support dates and dependencies across mainframe database software. Advise leadership on upgrade timing and risk.
  • Drive automation of systems programming tasks using REXX, JCL and modern tooling, including AI-assisted development.
  • Support distributed Db2 components that connect to the mainframe, such as Db2 Connect, Data Server Client and Db2 gateway, along with related modernization efforts.
  • What Will Our Ideal Candidate Have?
  • Technical Expertise & Education:
  • IMS systems programming experience: DB/DC, DBRC, HALDB, managed ACBs and the IMS catalog.
  • Db2 data sharing, Parallel Sysplex and coupling facility experience.
  • Experience with BMC AMI and Broadcom (CA) tools such as File Master, and IBM tools such as Db2 SQL Tuning Services and QMF.Experience with Informatica Power
  • Exchange listeners on z/OS.Experience with Db2 LUW and distributed Db2 connectivity.3 or more years as a technical lead, ideally including oversight of vendor or managed service teams.
  • Experience planning and running DR exercises for Db2 and IMS.IBM Db2 for z/OS certification.
  • Leadership & Influence:
  • Strong communicator who translates complex database concepts into clear, actionable insights for business stakeholders.
  • You excel at documenting work accessibly, mentoring others while remaining open to learning, and asking the right clarifying questions on requirements.
  • What is a Must Have?
  • Bachelor's degree in computer science, related STEM field, or its equivalent in work experiencehands-on Db2 for z/OS systems programming experience, including installation, maintenance and version migration.
  • Strong working knowledge of SMP/E, z/OS, JCL, TSO/ISPF, SDSF/IOF and REXX.Demonstrated experience with subsystem-level problem determination and recovery, including working cases with IBM support.
  • Experience configuring and tuning Db2 subsystems: DSNZPARMs, buffer pools, logging and memory.
  • Working knowledge of RACF as it applies to Db2 and IMS.