Mainframe Systems Programmer, DB2 DBA

Ensono•New York City, NY

4d•$80,000 - $150,000•Remote

About The Position

At Ensono, our Purpose is to be a relentless ally, disrupting the status quo and unleashing our clients to Do Great Things ! We enable our clients to achieve key business outcomes that reshape how our world runs. As an expert technology adviser and managed service provider with cross-platform certifications, Ensono empowers our clients to keep up with continuous change and embrace innovation. We can Do Great Things because we have great Associates. The Ensono Core Values unify our diverse talents and are woven into how we do business. These five traits are the key to achieving our purpose: Honesty, Reliability, Curiosity, Collaboration, and Passion. About the role and what you'll be doing: in this role you are responsible for creating Low-Level Design (LLD) documentation and providing technical expertise to support Sales and Solution Architecture teams. You also work directly with prospective and new clients to identify components in scope for client onboarding and migration activities. 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 Ensono’s managed services model. This role may support multiple migrations or projects concurrently. 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. We want all new Associates to succeed in their roles at Ensono. That's why we've outlined the job requirements below. To be considered for this role, it's important that you meet all Required Qualifications. If you do not meet all of the Preferred Qualifications, we still encourage you to apply.

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.

Nice To Haves

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

creating Low-Level Design (LLD) documentation
providing technical expertise to support Sales and Solution Architecture teams
work directly with prospective and new clients to identify components in scope for client onboarding and migration activities
lead client onboarding and migration efforts and complete end-to-end server builds
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 Ensono’s managed services model
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

Benefits

Unlimited Paid Days Off
Three health plan options through Blue Cross Blue Shield
401k with company match
Eligibility for dental, vision, short and long-term disability, life and AD&D coverage, and flexible spending accounts
Paid Maternity Leave, Paternity Leave, and Sabbatical Leave
Education Reimbursement, Student Loan Assistance or 529 College Funding
Enhanced fertility coverage
Wellness program
Depending on location, ability to take advantage of fitness centers
Flexible work schedule