*Hi Partner,* *Please send me updated resumes to **[email protected]* *Position : DB2 DBA z/OS*
*Location: Cincinnati, Ohio* *Duration: 9 -Months with Possible extension* *Rate Cap: $40 Per Hour All Inclusive* *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 Please send the updated resume of the consultant along with the rate, location and contact information. Please make sure the Consultant's skills match the requirement. After reviewing the resume I will contact you if I need more information. *Thanks & have a nice day*** * * *Sahitya priya* Nihaki Systems Inc 346 Georges Road, Suite # 1, Dayton, NJ 08810. Phone: 732-823-6471/6472 Extn:112 Fax :732-438-6973 www.nihaki.com [email protected] -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sap-abap?hl=en.
