*Hello,* * *
*Looking for Teradata DBA and Performance Tuning Developer:* *3 Months +* *Lake Buena Vista FL* Skills: DBA experience on V2R6 and 12, Strong Teradata SQL, Strong Teradata Concepts & Architecture, Strong Teradata Query Optimization Experience, Teradata Workload Management (TASM) Duties: Management/Setup of Teradata development/production systems. Implement/setup TASM on a mature warehouse. 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.). Analyze data storage patterns, suggest alternatives. Analyze existing data access patterns and suggest alternatives. 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 exp. 2. Teradata concepts and architecture.. 3 Data warehouse concepts and techniques. 4 Proven Exp Implementing and Tuning large enterprise Teradata Data Warehouses. 5 Teradata ELT. 6. Complex SQL queries. 7. Teradata load utilities: BTQ, Multiload, Fastload, BTEQ, TPump. Programming. Desired skills: Teradata cert. Strong Data Analysis capability. Experience with data mining concepts. Understand source code control concepts. Advanced Math. Understand complex business data integration. BI concepts, Business Objects. Computer Science or Engineering degree. *Send resumes to prad...@clearthoughtsolutions.com* -- R . PRADEEP KUMAR 919-290-7580 IM : cts.pradeep Gtalk:rpradeep.cts -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To post to this group, send email to sap-ba...@googlegroups.com. To unsubscribe from this group, send email to sap-basis+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-basis?hl=en.