Mainframe Systems Programmer, DB2 Physical

Ensono

. Provide premium DB2 sysprog support and services to Ensono mainframe clients .

Posted 10/8/2026full-timeRemote • United StatesMid-LevelSenior💰 $65,000 - $123,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive expertise in DB2 administration and systems programming support, with a strong focus on database maintenance, disaster recovery, and performance optimization. Capable of managing complex database environments and providing exceptional customer service across multiple time zones.

Highest-signal resume keywords

DB2 AdministrationDisaster Recovery ProceduresSMP/e ExperienceDatabase Performance TuningCustomer Migration Services

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

DB2 Systems ProgrammingDatabase Software UpgradesDatabase MaintenanceSQL Code TuningBuffer Pool ManagementChange Request EvaluationDatabase Security ManagementParallel Sysplex ConfigurationEfficiency ReportingDocumentation Best Practices

Soft Skills

Excellent Communication SkillsSelf-MotivatedAbility to MultitaskTeam CollaborationProblem-Solving

Tools & Technologies

DB2Z/OSIDAAITSM Change Control

Industry Keywords

Mainframe SupportDatabase ManagementDisaster Recovery ServicesCustomer Service OrdersTechnical Hurdles Resolution

Tech Stack

Tools & technologies

ITSMSQL

About the role

Key responsibilities & impact

Provide premium DB2 sysprog support and services to Ensono mainframe clients
Perform mainframe database software upgrades, administration, and tuning
Work with vendor personnel to resolve database problems promptly
Perform day-to-day database maintenance, including backups, restores, file extent growth monitoring, and reorganization scheduling
Create and maintain disaster recovery procedures
Optimize databases through efficiency reporting, configuration analysis, and performance reviews
Develop, support, and customize new services and support efforts
Participate in on-call responsibilities
Fulfill customer service orders for mainframe z/OS customers relating to DB2
Provide primary support for problems related to DB2 tablespaces
Provide support 24x7x365 across multiple time zones
Support customer migration services involving DB2 and related OEM software products
Assist project managers with newly acquired customer migrations and resolve technical hurdles
Execute tasks associated with customer disaster recovery plans in cooperation with Disaster Recovery Services
Manage resources and schedules for timely implementations
Follow ITSM change control procedures

Requirements

What you’ll need

Bachelor’s degree required and/or equivalent work experience
5+ years of professional experience in DB2 administration and systems programming support, including IDAA
Knowledge of best practices in software management, maintenance, and documentation
SMP/e experience
Experience configuring and managing DB2 in a parallel sysplex environment
Ability to develop innovation, strategies, processes, and best practices in software management
Experience establishing policies and procedures for database management, disaster recovery, security, maintenance, and utilization
Experience reviewing new DB2 versions and advising clients on their benefits
Ability to evaluate change requests, determine client impact, and troubleshoot and solve production database issues
Experience supporting DB2 security requests
Ability to review DB2 security and identify potential risks
Experience reorganizing application data
Experience reviewing and tuning internal DB2 buffer pools and SQL code
Ability to respond quickly and effectively to support requests from multiple clients
Ability to support multiple customers during after-hours on-call
Self-motivated and able to work independently
Ability to multitask and work under short deadlines and in high-pressure situations
Excellent written, verbal, and presentation communication skills
Ability to work both independently and as part of a team

Benefits

Comp & perks

Unlimited Paid Days Off
Three health plan options
401k with company match
Dental, vision, short- and long-term disability, life and AD&D coverage
Flexible spending accounts
Family Forming Benefit including fertility coverage and adoption/surrogacy reimbursement
Paid childbearing and paternal leave
Education Reimbursement
Student Loan Assistance or 529 College Funding
Sabbatical leave
Wellness program
Flexible work schedule
Annual bonus plan based on company and individual performance, depending on eligibility
Equity grant under the Associate Equity Appreciation Program, depending on eligibility
Option to work from home or in Ensono offices when not required at a client site