*Hi Partners,* ** *Greetings,* ** *Hope you are doing Well!!!!!!!!!!!!!!!* ** *Please forward a profiles to **shan...@techconsultinc.com*<shan...@techconsultinc.com> ** *Here are the requirement details* **
Teradata DBA Location: Lake Buena Vista, FL Length: 3 months 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. * * -- Regards, Shankar 248-522-6879 Technology consultanst inc -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to sap-a...@googlegroups.com. To unsubscribe from this group, send email to sap-abap+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-abap?hl=en.