[3194MSCRMCV] Need a DB2 DBA Location: Cincinnati, OH

--
send your resumes to rajesh@intonenetworks.com

Hello Folks,

Hope you're doing good. Please go through with the below job description and send me your consultant update resume ASAP.

Title: DB2 DBA

 Location: Cincinnati, OH

 Duration: 9 to 12 months+ (most likely will be extended)

 

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
POSITION REQUIREMENTS:
-       7 years of heavy DB2 database administration experience and production support
-       Requiring DB2z V8 or V9 experience
-       Not required but prefer DB2 V8 or V9 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
-       Candidate must have excellent communication skills

Regards,
Rajesh
732-658-4249
Yahoo id:raj.tapasvi
Have a Great day :)

--
You received this message because you are subscribed to the Google Groups "CVMSCRM" group.
To post to this group, send email to cvmscrm@googlegroups.com.
To unsubscribe from this group, send email to cvmscrm+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/cvmscrm?hl=en.