Duration: 3-6 months
DB2 Analyst
REQUIRED SKILLS:
--SQL
--DB2
--Erwin
--Data Modeling
--JCL
--Data Analysis
--DBA
--SQL Query
DESCRIPTION:
Administer, maintain and utilize policies and procedures for ensuring the security and integrity of the databases. Implement data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues, replication, and other data issues. Support all environments (production, development, conversion) in daily or emergency procedures to identify and resolve issues.Work with the Information Architect and Database Designer to help implement the physical data model. Help develop and validate the database implementation plan. Create database objects and maintain their physical organization/relationships. Support the data loads into the databases. Ensure that the application, and any enhancements interact efficiently with the database. Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities. Create/Implement database maintenance plan to ensure data integrity. Manage the on-site backup and recovery process and/or support the off-site backup and recovery teams. Plan for and execute any required database upgrades and migration (patches etc.)
PREFERRED EXPERIENCE:
Experienced DBA using DB2 in a Z/OS Mainframe environment.
Experienced with third party products including BMC and Omegamon products.
Capable of investigating and resolving performance issues within the DB2 subsystem.
Well versed in database backup and recovery, disaster recovery, DB2 performance and problem determination in a 24 x 7 environment.
Minimum 3 years of work experience as a DB2 Database Administrator
Strong Database Management skills, including backup and recovery procedures
Solid skills in database performance factors, monitoring tools and tuning procedures
Solid skills in productivity factors and ability to understand impact of problem on overall database performance
Knowledge of fault detection and resolution processes
Strong skills in maintenance tools and procedures
Solid skills with one or more programming language and design technique
Experience with other relational or hierarchical databases a plus
Senior DB2 DBA on Z/os on the mainframe. 5-6 years experience with DB2 to V8 with relavent experience with very large partitioned tables.
Key Words: data analysis; DB2; DBA; Erwin; JCL; SQL
Click Here To Apply