*Role: DB2 DBA * *Location: Cincinnati, OH *
*Duration: 6+ Months* *Job Description:* · 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 (static and dynamic), recommending indexes, and configuring database parameters · Provide data migration support · Work with application team to review the SQLs before production migration. · Lead, mentor and/or provide guidance to junior DBAs including guidance for troubleshooting escalated issues · Partner with offshore DBA resources and thoroughly document processes to ensure successful implementation by offshore staff and Production Control · Provide on-call rotational 24/7 Incident Response to database alerts from production monitoring tools and Command Center personnel · Analyze Key Performance Metrics and make recommendations for improvements · Work with IBM and follow-up with PMR tickets. · Maintain the integrity of data within the production environment including the execution of proper backup and restoration policies and procedures which provide point-in-time restore capabilities (disaster recovery) · Perform database capacity planning and trend analysis in IDAA · Deploy database changes in strict accordance with change management policies and procedures · Interact and coordinate work with System Administrators, Project Managers and fellow team members to support various project requests -- *Warm Regards* *Faiz Shaik* *Pace Computer Solutions Inc* *(**An Inc 500 Company**)* *10500 Little Patuxent Pkwy, Suite 310* *Columbia, MD 21044* *Phone*# 443-539-0949 *209 *Fax*# 443-539-0292 Toll Free # 1-877-225-PACE f...@pace-solutionsinc.com www.pace-solutionsinc.com ****** PACE Selected for the 2009 & 2010 Best of Columbia Award by the US Commerce Association ****** *Pace Computer Solutions, Inc. is a registered user of E-Verify* The contents of this message and any attachments are intended solely for the addressee(s) named in this message. This communication is intended to be and to remain confidential and may be subject to privilege. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender and then destroy this message and its attachments. Do not deliver, distribute or copy this message and/or any attachments and if you are not the intended recipient, do not disclose the contents or take any action in reliance upon the information contained in this communication or any attachments. -- You received this message because you are subscribed to the Google Groups "IT RECURITER" group. To unsubscribe from this group and stop receiving emails from it, send an email to it-recuriter+unsubscr...@googlegroups.com. To post to this group, send email to email@example.com. Visit this group at https://groups.google.com/group/it-recuriter. For more options, visit https://groups.google.com/d/optout.