*Please respond to [email protected]* * *
*Location: Orlando, FL* *Duration: 7 Months* Teradata DBA and Performance Tuning Developer: Skills: DBA experience on V2R6 and 12, Strong Teradata SQL, Strong Teradata Concepts & Architecture, Strong Teradata Query Optimization Experience The contractor will assist with the following: · Management/Setup of Teradata development/production systems - Database management (create users/roles, databases, etc.) - Implement/conduct database load/performance monitoring - Recommend use of statistics, indexes, partitioning, temp tables, other techniques to reduce or redistribute database load · Performance analysis and tuning. - Analyze existing Business Object (BO) queries and ETL code using EXPLAIN, query log, timings, CPU utilization to identify system choke points. - Suggest/modify existing queries and database objects (indexes, partitions, etc.) to maximize performance across suite of BO reports and ETL. - Analyze existing data storage patterns and suggest alternatives to improve space and performance utilization. - Analyze existing data access patterns and suggest alternatives to improve system utilization. · Development of EDW loads and extracts using SQL transformations. - Write SQL to transform data into enterprise model. - Use existing tools and templates to conform to site standards. Required skills: 1. Proven Teradata DBA experience. 2. Teradata concepts and architecture. 3. Data warehouse concepts and techniques. 4. Proven Experience Implementing and Tuning large enterprise Teradata Data Warehouses. 5. Teradata ELT. 6. Complex SQL queries. 7. Teradata load utilities: BTQ, Multiload, Fastload, BTEQ, TPump. Desired skills: 1. Teradata certification. 2. Strong Data Analysis capability/experience. Experience with data mining concepts a plus. 3. Understanding of source code control concepts. 4. Advanced Math. 5. Ability to understand complex business data integration. 6. Reporting: BI concepts, Business Objects. Required degree: Computer Science or Engineering degree. Thanks Vikram M Revosys IT Inc 108-31 47th Avenue, Corona, New York, 11368 Phone: 347-468-7163 Fax : 347-649-2053 Email: [email protected] <[email protected]> Website: www.revosysIT.com <http://www.revosysit.com/> -- You received this message because you are subscribed to the Google Groups "Java Tech Group" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/java-tech-group?hl=en.
