DB2 Database Administrator

Required Experience: 10+ years DB2 experience

Job Description

Description

• Design and maintain DB2 Database applications which have the following characteristics:

• Design for high availability.
• Design for maximum performance.
• Maintain and develop techniques and procedures to provide 24x7 availability.
• Provide production and test database support in a complex environment.

• Perform all functions which are performed by a DB2 Database Administrator, such as:

• SQL code reviews.
• Performance Monitoring and Tuning DB2 at the application database level.
• Enforce appropriate DB2 security standards.
• Collaborate with the DB2 systems programming staff to appropriately manage DSNZPARM settings.
• Create, manage and support DB2 Stored Procedures, DB2 Triggers, and DB2 Referential Integrity.
• Create Change Requests, Resolve Service Requests, Provide 24x7 On call support.
• Provide DB2 Connect configuration access support for individual users and distributed systems.
• Coordinate with team members on technical decisions and directions.
• Work with Management to develop project schedules.
• Provide Database performance and tuning which typically involves collaboration between Data Center, Technical Operations, Database Design and Administration, and the various software development areas.
• Responsible for the evaluation and creation of appropriate backup and recovery strategies for new database requirements.
• Participate in Disaster Recovery planning.

Qualifications

Excellent knowledge of DB2 z/OS Database Support, including but not limited to the following:

• z/OS DB2 12 for zOS or higher in a production environment with high transaction rates

• High availability 24x7 designs and techniques

• Managing large data stores

• DB2 V10 utilities setup and execution

• DB2 performance and tuning

• Data Modeling expertise logical and physical design

• Complex SQL coding / tuning

• Data Warehouse design with an understanding of OLAP design and query solutions

• DB2 attachments/interfaces include DRDA, DB2Connect
• DB2 tools skill set will include, but is not limited to the following:
• IBM Data Studio
• IBM DB2 Administration Tool
• IBM DB2 Automation Tool
• IBM DB2 Explain
• IBM DB2 Query Monitor
• IBM OPTIM Workload Query Tuner
• IBM File Manager
• IBM Tivoli OMEGAMON
• QMF

z/OS Mainframe skills, but not limited to the following:

• TSO and ISPF

• JCL

• DFSORT and /or ICETOOL

• REXX

• z/OS Utilities

Additional Desired Skills:

• Problem solving and analytical skills

• Ability to organize and prioritize workflow and projects

• Excellent written and oral communication skills

• DB2 V9 or V10 Certification preferred
• IMS Database experience
• IMS Database Utilities (IBM, BMC, NEON, etc.)
• ETL tools experience (Info Shere, Informatica, etc.)