Skip to content
Expert Mainframe Systems Programmer, DB2

Expert Mainframe Systems Programmer, DB2

United Kingdom

DUTIES AND RESPONSIBILITIES

  • 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 as part of a global support team.

  • 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

QUALIFICATIONS AND EXPERIENCE

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

  • Demonstrable experience in DB2 for administration and systems programming support.  CA and IBM tools for DB2 a plus

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

  • 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

  • Self-motivated and able to work independently

  • 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.