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.