Complete Description:
As part of the OCFO technology team, the consultant will be performing the role of DB2 DBA for two primary systems –Tax system and core financial system.
The DBA will work on maintenance and enhancements.
Required:
8+ years DBA/production support experience
BMC Catalog Manager
BMC Change Manager – Table Changes/Migrations
BMC Utilities: Unload, Load, Reorg, Image Copy
IBM Utility: Recovery
Performance Monitoring/Tuning: BMC Apptune or Omegamon for DB2
Development/Modifications to DB2 database structures
Desirable:
DBA with a development/programming background (vs. one with only a systems background)
SQL/efficient SQL
SQL Explorer/Explains
Running Statistics
Binding plans/packages
DB2 Partitioning or Universal DB
It is critical that the DBA has “BMC” product knowledge.
Skills:
Skill
Required / Desired
Amount
of Experience
Expertise Rating
DBA/production support experience
Required
8
Years
3 - Expert
BMC Catalog Manager
Required
4
Years
3 - Expert
BMC Change Manager – Table Changes/Migrations
Required
4
Years
3 - Expert
BMC Utilities: Unload, Load, Reorg, Image Copy
Required
2
Years
2 - Proficient
IBM Utility: Recovery
Required
2
Years
2 - Proficient
Performance Monitoring/Tuning: BMC App tune or Omegamon for DB2
Required
2
Years
2 - Proficient
Development/Modifications to DB2 database structures
Required
2
Years
2 - Proficient
DBA with a development/programming background
Highly desired
3
Years
2 - Proficient
SQL/efficient SQL
Highly desired
3
Years
2 - Proficient
SQL Explorer/Explains
Highly desired
3
Years
2 - Proficient
Bachelors Degree in Computer Science, Engineering or related field
Required
Client or vendor will not provide a laptop or smartphone. Candiate will have to bring his own laptop and smartphone