RCI-TRV-6003 Sr Mainframe Database Systems Engineer (IBM Db2)

Rangam; Hartford (CT); Presencial; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

Rangam is seeking a senior Db2 for z/OS systems programmer/engineer to manage complex Db2 subsystems across production and non-production environments. You will install, configure, and maintain Db2 subsystems, lead version migrations, and coordinate with IBM support for issue resolution.

You will plan and perform software maintenance using SMP/E, manage DR readiness, and mentor junior DBAs while driving automation and reliability across mainframe platforms.

Formación

• Bachelor's degree in computer science or related STEM field or equivalent work experience.
• Hands-on Db2 for z/OS systems programming including install, maintenance and upgrades.
• Strong knowledge of SMP/E, z/OS, JCL, TSO/ISPF, SDSF/IOF and REXX.
• Experience with subsystem-level problem determination and recovery, including IBM support cases.
• Experience configuring and tuning Db2 subsystems: DSNZPARMs, buffer pools, logging and memory.
• Working knowledge of RACF with Db2 and IMS.

Responsabilidades

• Serve as lead Db2 for z/OS systems programmer/engineer for production and non-production environments.
• Plan and apply software maintenance using SMP/E, PTFs, RSU and HIPER, and coordinate around freezes.
• Lead Db2 version migrations and function level activations end-to-end.
• Own subsystem configuration: DSNZPARMs, buffer pools, memory and logs.
• Manage Db2 connectivity, TLS certificates and RACF integration; collaborate with security teams.
• Monitor subsystem performance and capacity; perform disaster recovery planning and DR exercises.
• Provide technical direction to managed service partners and mentor DBAs.

Conocimientos

IMS systems programming

Db2 for z/OS

SMP/E maintenance

RACF integration

DB2 data sharing / Parallel Sysplex

DDF/DRDA TCP/IP

REXX

JCL / TSO/ISPF / SDSF/IOF

DB2 connectivity (Db2 Connect)

QMF / Db2 SQL Tuning Services

Educación

Bachelor's degree in computer science or related STEM field

Herramientas

BMC AMI tools

Broadcom CA tools (File Master)

IBM Db2 tools (SQL Tuning Services)

Informatica PowerExchange on z/OS

Db2 LUW / distributed Db2 connectivity

Descripción del empleo

• 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 BSDS
• IRLM, WLM application environments and RRS
• Lead 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 PowerExchange 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 experience
• hands-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.