*Job Title: DB2 UDB DBA* *Location: *Auburn Hills, MI
*Duration:* Long Term *Experience Level*: 6+ years *Type of hire:* Contract *Must Have Skills:* *DB2 UDB DBA with XML tuning experience* *• Performance Tuning of DB2 PURE XML features including XQUERY, XPATH, XMLTABLE, etc. * *• DB2 Performance Tuning this includes but not limited to, rewriting SQL statements, creating/altering indexes, designing MQTs and MDCs, * *and using XQUERY functionality.* · DB2 v8,v9.1,v9.7,v10.1,v10.5 in AIX/LINUX and WINDOWS operating systems. • Install, Upgrade and Maintenance of DB2 Software including pre-requisite verification and post install validation. • DB2 DPF (Data Partitioning Feature) and HA Cluster (i.e. HACMP) environments. • Design & Implementation of New DB2 Instances & Databases in Dev/QA/Prod • Managing Security on Database objects (groups, users and roles) • Implementing & managing backup and recovery procedures for DB2 UDB databases. • Develop shell scripts to automate db2 processes & Deploy the Vendor database scripts. • Monitor OVO alerts, Disk space usage, Error log(s), db log space, user activity/ security violations. • Using IBM data studio, IBM Optim tools etc. • Working with AIX admins for application of OS patches and maintenance required for database servers. • Participate on DR/LRU exercise for DB2 UDB databases and dependent applications. • Create and manage partitioned tables, MDC and MQT's. • Configure TSM and perform cross node recovery, redirect restore databases. • 24x7 Production Support • Ability to Multi-tasking/ Prioritize and troubleshoot priority 1 and 2 incidents immediately and provide root cause analysis. • Excellent Oral and Written communication skills to collaborate & effectively work with staff of varying technical expertise. Thanks & Regards, Vivek Jha | Account Manager Email: [email protected] | 4800 Patrick Henry Drive | Santa Clara | CA | 95054 Cell: 408-459-1656| Desk: (408) 874-8333 extn. 248 www.droisys.com *Seven-Time Inc. 5000 Honoree *2008, 2009, 2010, 2011, 2012, 2013, 2014 <http://www.inc.com/profile/droisys> -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
