Sr DB2 for z/OS Mainframe Systems Programmer/ Db2 DBA

IT Associates; United States; Remote; USD 100,000 - 130,000; Full time

Job summary

A technology consulting firm is seeking a Db2 Systems Programmer / Db2 DBA on Z/OS to support DB2 environments for multiple clients. This remote position requires extensive expertise in DB2 for z/OS, covering upgrades, installations, and troubleshooting. Candidates must have at least 10 years of experience in a z/OS mainframe environment and strong communication skills. The role involves leading client onboarding efforts, ensuring successful migrations, and supporting ongoing client environments without on-call requirements.

Qualifications

• Minimum of 10 years of experience working in a z/OS mainframe environment.
• Broad expertise across core mainframe domains.
• Strong technical capability with DB2-related ISV software on the z/OS platform.

Responsibilities

• Support DB2 environments for one or more clients.
• Upgrade, install, and support DB2-related ISV software.
• Collaborate with clients to resolve DB2 system issues.

Skills

DB2 for z/OS upgrades

z/OS mainframe environment experience

DB2 system troubleshooting

Client communication

SMP/E proficiency

Microsoft Word proficiency

Microsoft Excel proficiency

Knowledge of CA database tools

Tools

IBM database tools

Sysview

OMEGAMON

MainView

Job description

Db2 Systems Programmer / Db2 DBA on Z/OS

• 12 months contract ( option for hire )
• REMOTE - 100%
• There is NO on-Call requirement

In this role, you lead client onboarding and migration efforts and complete end-to-end server builds. You are responsible for DB2 for z/OS upgrades and associated ISV products and actively support the transition of client environments from in-house IT teams to our managed services model. This role may support multiple migrations or projects concurrently.

REQUIREMENTS

• Minimum of 10 years of experience working in a z/OS mainframe environment.
• Broad expertise across core mainframe domains, including the z/OS operating system, storage, databases, CICS, and disaster recovery concepts.
• Proven experience implementing, supporting, and upgrading DB2 for z/OS in enterprise production environments.
• Experience supporting DB2 for z/OS from a systems or DBA perspective.
• Strong technical capability with DB2-related ISV software on the z/OS platform.
• Proficiency with SMP/E, including base installations and ongoing maintenance for DB2 and associated ISV software.
• Demonstrated experience working with ISV vendors to perform problem determination and drive issue resolution.
• Working knowledge of common DB2 tooling, including CA database tools, IBM database tools, Sysview, OMEGAMON, and MainView.
• Solid understanding of DB2 Connect, security exits, DB2 data sharing in a Sysplex environment, DB2 log analysis, and DB2 system recovery.
• Ability to act as the primary technical database point of contact for clients during transitions and ongoing support.
• Strong communication and organizational skills, with the ability to manage multiple initiatives in a client-facing environment.
• Experience leading and participating in client meetings, workshops, and conference calls.
• Proficiency in Microsoft Word and Excel to produce clear, client-ready documentation.

Preferred Qualifications

• Experience with CICS or advanced knowledge of the z/OS operating system.
• Experience with IBM DB2 Analytics Accelerator (IDAA).
• Experience with IMS and IMS upgrades.

RESPONSIBILITIES

• Support DB2 environments for one or more clients, including applying maintenance and performing upgrades as needed.
• Upgrade, install, and support DB2-related ISV software.
• Test and monitor existing DB2 workloads following OS or CPU upgrades.
• Collaborate with clients to diagnose, troubleshoot, and resolve DB2 system, software, and database-related issues.
• Participate in onboarding new clients by supporting knowledge transfer activities and shadowing client environments.
• Work collaboratively with a team of mainframe professionals to transition new clients into Ensono’s support model.
• Apply a strong working knowledge of DB2 utilities, TSO, and FTP to daily support and project work.
• Leverage a solid understanding of SMP/E and its role in the DB2 installation and maintenance process.
• Demonstrate working knowledge of the WLM environment as it relates to DB2 performance and workload management.
• Perform project-based work; this role does not require 24×7 on-call support.