Senior DB2 Database Administrator (DBA)

Yoh has a contract opportunity for a SENIOR DB2 DATABASE ADMINISTRATOR (DBA) to join our client in Morris Plains, NJ.

Job Overview:
This is a Senior Consultant DB2 V10 DBA position, responsible for supporting the organization's DB2 V10 databases and ensuring their performance, availability, and security. The Senior Consultant is viewed as an expert in the administration and support of database technology. The candidate is expected to communicate common goals and direction for the team and also provide superior technical leadership.

JOB RESPONSIBILITIES:
- Responsible for database design, development and administration of large scale Operational, OLTP and analytical data structures including logical and physical design.
- Provide SQL performance tuning on both OLTP and Data warehouse environments.
- Optimize DB2 resource utilization by tuning queries, recommending indexes, and configuring database parameters.
- Provide data migration support.
- Provide trend analysis to management team to enable them to make informed decisions regarding resource management.
- Consult, mentor and/or provide guidance to less experienced database analysts where applicable including guidance for troubleshooting escalated issues.
- Partner with offshore DBA resources and thoroughly document processes to ensure successful implementation by offshore staff and Production Control.
- Provide oncall rotational 24/7 Incident Response to database alerts from production monitoring tools and Command Center personnel.
- Analyze Key Performance Metrics and make recommendations for improvements.
- Provide input on the selection and implementation of all database administration tools.
- Maintain the integrity of data within the production environment including the execution of proper backup and restoration policies and procedures which provide point-in-time restore capabilities (disaster recovery).
- Enhance site monitoring to improve availability and performance.
- Perform database capacity planning and trend analysis.
- Deploy database changes in strict accordance with change management policies and procedures.
- Interact and coordinate work with System Administrators, Project Managers and fellow team members to support various project requests.

JOB QUALIFICATIONS:
- Bachelor's degree in CS/MIS or equivalent experience.
- Minimum of seven (7) years of heavy DB database administration experience and production support.
- Requiring DB2 V10 experience.
- Preferred DB2 V9 or V10 database certification.
- Experience working with very large database partitioning.
- Experience working with large systems in data sharing sysplex environment.
- Preferred experience in data modelling with Star Schema and.Operational Data Store* concepts.
- Experience with evaluating and consolidating database workloads to maximize hardware resources.
- Experience working with IBM Admin tool suite, Query Monitor, and Omegamon (DB2 PE).
- In-depth knowledge of DB2 utilities such as LOAD, UNLOAD, RUNSTAT, REORG, COPY, COPYTOCOPY, MERGECOPY, MODIFY and SPUFI.
- Solid understanding of DB2 client tools such as DB2 Connect and Visual Explain.
- Hands on experience with performance tuning of complex SQLs.
- Experience with XML.
- Experience with DB2 Stored Procedures (SQL and Cobol).
- Preferred experience with IBM Optim Move for DB2.
- Preferred experience with Erwin or RDA data modelling tools.
- Prefer that the candidate has worked in an onshore/offshore model.
- Candidate must have excellent communication skills.

DISCOVER ALL THAT\'S POSSIBLE WITH YOH. APPLY NOW.

RECRUITER: Arvind Thirumalaisamy

Yoh is a professional staffing provider with over 70 years of experience in the short- and long-term staffing services industry; visit our website to learn both about our company and about our leading staffing solutions.

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer, M/F/D/V.

J2W: INFOTECH

Tax Term: CON_W2J2WBRNY

Ref:

Branch: IT & Telecom