Provide premium DB2 application DBA support and services to Ensono mainframe clients as they relate to Mainframe DB2 systems.
Job Description
FUNCTIONAL RESPONSIBILITIES:

• The successful candidate will perform database creation, development, administration and tuning to support our customers' development, test and production databases.
• 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.
• The individual will need to work with vendor personnel to achieve timely solutions of database problems.
• Expertise and work efforts will focus on the development and support and/or the customization of new services and support efforts.
• 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
• 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 for LOGICAL DB2 Database Administrator:

• Bachelor's degree required and/or equivalent work experience.
• 10 years of professional experience in DB2 for administration and application support. CA and IBM tools for DB2 a plus
• Extensive experience with the following:
  • Administrating and supporting databases in Mainframe DB2
  • Support multiple DB2 subsystems simultaneously
  • Supporting customer and internal requests for building all types of DB2 objects.
  • Analyzing new versions of DB2 for functionality that can improve customer's systems
  • Refreshing test data for whole environments
  • 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
• Experience establishing policies and procedures pertaining to database management, DR, security, maintenance and utilization preferred
• Supporting multiple customer for after hours on-call

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

JR007016