US CONSULTING - CONTRACT REQ::DB2 DBA Admin -- Cincinnati, OH

DB2 DBA Admin

Cincinnati, OH

9-12 months+

Candidate must be a US Citizen, GC or EAD GC or EAD OPT

 Send profiles to dilip@clearthoughtsolutions.com

GENERAL FUNCTION:

This is a Contract DB2 z/OS DBA position, responsible for supporting the organization's DB2z database initiatives and ensuring their performance, availability, and security.  

DUTIES & RESPONSIBILITIES:

-      Responsible for database object creation based on site standards for large scale OLTP and Data Warehouse Star Schema environments

-       Provide design assistance with large partitioned objects

-       Build compression dictionaries on very large objects

-       Create automated REORG and Partition Rotation scripts by using IBM DB2 Utilities and in-house SQL Stored Procedures.

-       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 job scheduling support between application and utility jobs

-       Perform database capacity planning, object sizing and trend analysis

-       Deploy database changes in strict accordance with change management policies and procedures

-       Interact and coordinate directed work with System Administrators, Project Managers and fellow team members to support various project requests

DESIRED EXPERIENCE:

 

-       7 years of DB2z database administration experience and production support

-       DB2z  V9 or v10 experience

-       Not required but prefer 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 modeling with Star Schema and *Operational Data Store* concepts

-       Experience working with IBM Admin tool suite, Query Monitor, and Omegamon (DB2 PE)

-       In-depth knowledge of IBM DB2 utilities such as LOAD, UNLOAD (HPU), RUNSTAT, REORG, COPY, COPYTOCOPY, MERGECOPY, MODIFY and SPUFI.

-       Solid understanding of DB2 client tools such as DB2 Connect, Visual Explain and Data Studio

-       Hands on experience with performance tuning of complex SQLs

-       Experience with DB2 SQL Stored Procedures

--

Thanks & Regards,

 Venkata Dilip

Clear Thought Solutions LLC 
ERP/EAI SERVICES |Consulting – Development – Staffing
| Tel: (919)386-2300| Fax 347-296-3797,

YM:dilipcamelot,GTalk:venkat.cts1,dilip.staffing@gmail.com
| Email: dilip@clearthoughtsolutions.com | www.clearthoughtsolutions.com

--
--
You received this message because you are subscribed to the Google
Groups "US consulting Contract Opportunities" group.
To post to this group, send email to us-consulting-temp@googlegroups.com
To unsubscribe from this group, send email to
us-consulting-temp+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.co.in/group/us-consulting-temp?hl=en-GB
---
You received this message because you are subscribed to the Google Groups "US consulting Contract Opportunities" group.
To unsubscribe from this group and stop receiving emails from it, send an email to us-consulting-temp+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.