Teradata DBA Location: Lake Buena Vista, FL
Length: 3 months Rate: $55/hr all inc. Interview: Phone 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. 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. *RAJESH ….**?*** Phone : 734-591-3562 X 1177 Fax : 734-418-2603 Email : [email protected] | [email protected] |Yahoo IM : rajeshk_aim |www.aim-cc.com *P* Please do not print this email unless it is absolutely necessary. Spread environmental awareness. -- You received this message because you are subscribed to the Google Groups "Business_Intelligence" 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/business_intelligence?hl=en.
