Dear Folks,
Wishes for the Day !!!
We Need consultant for DB2 DBA z/OS
Please share suitable profiles to s...@panzersolutions.com
*Job Title : DB2 DBA z/OS
Location : Cincinnati, OH
Duration : 9 months
Rate : $50/Hr
Local to OH/PA Needed !!*
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:
MINIMUM KINOWLEDGE, SKILLS, AND ABILITIES REQUUIRED:
Bachelor's degree in CS/MIS or equivalent experience
Minimum of 7 years of heavy DB2z 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
--
Thanks and Best Regards,
Sam Riley | Sr Technical Recruiter
Email: s...@panzersolutions.com
Direct: 201-710-8278
--
You received this message because you are subscribed to the Google Groups
oraapps group.
To post to this group, send email to oraapps@googlegroups.com.
To unsubscribe from this group, send email to
oraapps+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/oraapps?hl=en.
