*Role: DB2 Performance Tuning* *Location: Whippany, NJ*
*Contract* *Job description: * Technical skills: Need to be strong at following technologies with hands-on experience. - DB2 development experience on IBM Z/OS platform. - Strong DB2 database knowledge. - Expert level knowledge of advanced database concepts. - Understanding of how the DB2 query optimizers work. - Able to understand the DB2 explain functionality to review potential query access plans and determine how to tune queries for best performance. - Understanding of the supported DB2 isolation levels and how best to use them in designing queries for optimum performance. - DB2 lock and concurrency control and the locking behavior of the partitioned tables and deadlock controls. - Data compression for performance. - Experience in DB2 to non-DB2 RDBMS data replication is a plus exposure to DB2 V10/V11 - Exposure to IDAA(Netezza). - Static and Dynamic SQL capture, analysis and tuning. - Exposure to Java Batch (BPXBATCH) and JZOS for batch modernization. - Exposure to Native SQL, Stored procedure development and performance tuning. - Exposure to scripting languages such as Perl, JavaScript with DB2 connectivity and result set processing. *Regards* Supraj Sarian Solutions *[email protected] <[email protected]>* Direct : 732-790-2266 Ext:212| Fax: 732-790-0944 Email: [email protected] -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" 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 https://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
