Job Seekers, Please send resumes to resumes@hireitpeople.com
Short Description:
The Database Administrator is responsible for data analysis and database management.
Complete 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.
Skills:
Skill |
Required / Desired |
Amount |
of Experience |
DB2 experience |
Required |
10 |
Years |
Excellent knowledge of DB2 z/OS Database Support |
Required |
10 |
Years |
rz/OS DB2 V9 or greater in a production environment with high transaction rates |
Required |
3 |
Years |
Data Modeling expertise – logical and physical design |
Required |
10 |
Years |
DB2 V9 and V10 utilities setup and execution |
Required |
3 |
Years |
DB2 performance and tuning |
Required |
10 |
Years |
Complex SQL coding / tuning |
Required |
10 |
Years |
DB2 attachments/interfaces include DRDA, DB2 Connect |
Required |
5 |
Years |
DB2 tools skill set including/not limited to: IBM DB2 Admin Tool, DB2 Automation Tool, DB2 Explain, Query Monitor, File Mgr, Tivoli OMEGAMON |
Required |
10 |
Years |
z/OS Mainframe skills: TSO and ISPF, JCL, DFSORT and /or ICETOOL, REXX, z/OS Utilities |
Required |
10 |
Years |
Problem solving and analytical skills, Ability to organize and prioritize workflow and projects |
Required |
|
|
DB2 V9 or V10 Certification preferred |
Desired |
3 |
Years |
IMS Database Utilities and Experience (IBM, BMC, NEON, etc.) |
Highly desired |
10 |
Years |
ETL tools experience (InfoShere, Informatica, etc.) |
Desired |
5 |
Years |