Skip to content

Senior DB2 Systems Programmer


Job Description Summary
Provide premium DB2 sysprog support and services to Ensono mainframe clients as they relate to Mainframe DB2 systems.


  • The successful candidate will perform mainframe database software upgrades coupled with administration and tuning to support our customers’ DB2 environments.

  • The individual will need to work with vendor personnel to achieve timely solutions of database problems.

  • The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth, scheduling reorganizations, creating and maintaining DR procedures and overall support of customer needs and requests.

  • The successful candidate will be called upon to perform a variety of database optimizations that will include general reporting and analysis of the efficiency of the database configuration and periodic review of database performance.

  • Expertise and work efforts will focus on the development and support and/or the customization of new services and support efforts.

  • System programming knowledge of multiple DBMS’s is a bonus.

  • The individual will need to participate in on-call responsibilities.

• Fulfill customer service orders (CSOs) for mainframe z/OS customers in a timely manner as they pertain to DB2

• Provide primary support for reported problems related to DB2 tables spaces

• Provide support on 24 x 7 x 365 basis across multiple time zones.

• Provide key support for customer migration services (new customer transitions) as they pertain to DB2 and related OEM software products.

• Assist the assigned project manager in the migration of newly acquired customers such that all technical hurdles are addressed in a timely manner and do not impede the expected progress of the transition nor the targeted migration date.

• In joint cooperation with the Disaster Recovery Services, successfully execute tasks associated with any given customer’s disaster recovery plans.

• Adhere to a schedule that efficiently manages resources and allows timely implementations.

• Follow ITSM change control procedures

Required technical skills:

  • Bachelor’s degree required and/or equivalent work experience.

  • 10+ years of professional experience in DB2 for administration and systems programming support.  CA and IBM tools for DB2 a plus

  • Extensive experience with the following:

    • Knowledged in best practices of software management, maintenance and documentation

    • SMP/e experience

    • Configure and manage DB2 in a parallel sysplex environment

    • Develops innovation, strategies, processes and  best practices in software management

    • Establishing policies and procedures pertaining to database management, DR, security, maintenance and utilization

    • Reviewing new versions of DB2 for functionality, advising how they benefit the client

    • Evaluating change requests and determine impact to assigned clients

    • Providing supervision and development opportunities for associates

    • Supporting DB2 security requests 

    • Review DB2 security to find potential risks

    • Reorganization of application data

    • Vendor consultations for problems and questions

    • Space calculations for new objects and environments

    • Reviewing, tuning of internal DB2 buffer pools and SQL code

    •  DR recovery of application objects

    •  Troubleshooting and solving production database issues

  •  Demonstrated ability to respond quickly and effectively to support requests from multiple clients

  • Supporting multiple customer for after hours on-call

  • Must work customer's business hours Eastern Time USA.

Secondary skills

  • Self-motivated and able to work independently. 

  • Demonstrated ability to respond quickly and effectively to support requests from multiple clients

  • Must be able to multi-task and work under short deadlines and in high pressure situations.

  • Excellent communication skills (written, verbal and presentations)

  • Ability to work as part of a team, as well as independently.


Your journey with Ensono starts here.

Apply now

More career opportunities at Ensono

Explore additional openings with our team, and apply today.

Start your digital transformation today.