*Hi Friends,* *Need Teradata DBA*
*Location: Lake Buena Vista, FL* *Length: 3 months* *Send your resumes to [email protected]* * * * * *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, 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: * · *Proven Teradata DBA exp. * · *Teradata concepts and architecture.* · *Data warehouse concepts and techniques. * · *Proven Exp Implementing and Tuning large enterprise Teradata Data Warehouses. * · *Teradata ELT* · *Complex SQL queries. * · *Teradata load utilities: BTQ, Multiload, Fastload, BTEQ, TPump. * -- Thanks & Regards, Bhanu Clear Thought Solutions LLC | Tel: 919-655-4169 |Email:[email protected]<email%[email protected]> -- You received this message because you are subscribed to the Google Groups "Exact Match" 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/exact-match?hl=en.
