Ensono

Senior Mainframe Systems Programmer, DB2

Ensono

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 $85,000 - $148,000 per year

Job Level

Senior

Tech Stack

ITSMSQL

About the role

  • Provide premium DB2 sysprog support and services to Ensono mainframe clients as they relate to Mainframe DB2 systems
  • Perform mainframe database software upgrades coupled with administration and tuning to support customers’ DB2 environments
  • Work with vendor personnel to achieve timely solutions of database problems
  • 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
  • Perform a variety of database optimizations including reporting and analysis of the efficiency of the database configuration and periodic review of database performance
  • Participate in on-call responsibilities and provide support on 24 x 7 x 365 basis across multiple time zones
  • 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 key support for customer migration services (new customer transitions) as they pertain to DB2 and related OEM software products
  • Assist assigned project manager in the migration of newly acquired customers addressing technical hurdles timely
  • Execute tasks associated with customer disaster recovery plans in cooperation with Disaster Recovery Services
  • Adhere to ITSM change control procedures and schedules that efficiently manage resources and allow timely implementations

Requirements

  • Bachelor’s degree required and/or equivalent work experience
  • 5+ years of professional experience in DB2 for administration and systems programming support
  • CA and IBM tools for DB2 a plus
  • Knowledgeable in best practices of software management, maintenance and documentation
  • SMP/e experience
  • Experience with configuring and managing DB2 in a parallel sysplex environment
  • Ability to develop innovation, strategies, processes and best practices in software management
  • Experience with establishing policies and procedures pertaining to database management, DR, security, maintenance, and utilization
  • Experience with reviewing new versions of DB2 for functionality, advising how they benefit the client
  • Ability to evaluate change requests and determine impact to assigned clients and troubleshooting and solving production database issues
  • Experience with supporting DB2 security requests
  • Ability to review DB2 security to find potential risks
  • Experience with reorganization of application data
  • Experience with reviewing, tuning of internal DB2 buffer pools and SQL code
  • 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