DB2 Client Sysplex Omegamon SQL Tuning TechLead (Jobs in Cincinnati, OH)   Requirement id 15025 Job title Tech Lead Job location in Cincinnati, OH Skills required DB2z Database Administration, DB2z V9 Or V10, DB2 Connect, DB2 Client Sysplex Omegamon SQL Tuning Open Date 12-Aug-2013 Close Date Job type Not specified Duration 99 Months Compensation DOE Status requirement --- Job interview type Face to Face interview Apply    Email Recruiter: coolsoft Job Description Tech Lead: DB2z Database Administration, DB2z V9 Or V10, DB2 Connect, DB2 Client Sysplex Omegamon SQL Tuning This is a Team Lead DB2 DBA (DB2 Mainframe) position, responsible for supporting the organizations DB2z databases and ensuring their performance, availability, scalability and security. The Team Lead is viewed as an expert in the administration and support of database technology. The candidate is expected to communicate common goals and direction for the team and also provide superior technical leadership. DUTIES & RESPONSIBILITIES: - Responsible for database design, development and administration of large scale Operational, OLTP and analytical data structures including logical and physical design - Provide SQL performance tuning on both OLTP and Data warehouse environments - Optimize DB2 resource utilization by tuning queries, recommending indexes, architect and configuring database parameters - Lead, mentor and/or provide guidance to less experienced database analysts where applicable including guidance for troubleshooting escalated issues - Provide on call rotational 24/7 Incident Response - Maintain data integrity within the production environment including the execution of proper backup and restoration policies and procedures which provide point-in-time restore capabilities (disaster recovery) - Deploy database changes in strict accordance with Service Management policies and procedures POSITION REQUIREMENTS: MINIMUM KINOWLEDGE, SKILLS, AND ABILITIES REQUUIRED: - Bachelors degree in CS/MIS or equivalent experience - Minimum of 7 years of heavy DB2z database administration experience and production support requiring DB2z V9 or V10 experience - DB2 Connect and DB2 Client installations and configuration - Experience working with very large database partitioning (> billion rows) - Experience working with large systems in data sharing sysplex environment - Experience working with IBM Admin tool suite, Query Monitor, and Omegamon (DB2 PE) and in-depth knowledge of DB2 utilities such as LOAD, UNLOAD, High Speed Unload, RUNSTAT, REORG, COPY, COPYTOCOPY, MERGECOPY, MODIFY and SPUFI. - Hands on experience with performance tuning of complex SQLs WORKING CONDITIONS: • Normal office environment with little exposure to dust, noise, temperature and the like. • Extended viewing of CRT screen.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 15025 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2),         (Tech Lead: DB2z Database Administration, DB2z V9 Or V10, DB2 Connect, DB2 Client Sysplex Omegamon SQL Tuning in Cincinnati, OH)

Featured Jobs Azure Cybersecurity PIM Engineer (Jobs in Richmond, Virginia) Analyst (Jobs in Lansing, Wisconsin) Management Microsoft Manager (Jobs in Raleigh, North Carolina) SDLC Strategic Manager (Jobs in Richmond, Virginia) Smartsheet Analysis Testing Specialist (Jobs in Raleigh, North Carolina) Azure RBAC Azure Architect (Jobs in Richmond, Virginia) HTML Consultant (Jobs in Lansing, Michigan) COTS SaaS Written Analyst (Jobs in Hartford, Connecticut) Manager (Jobs in Columbus, Ohio) Kubernetes API Red Architect (Jobs in Lansing, Michigan)