Job Description :
Position:-Teradata DBA
Location:- Cleveland OH
Duration:-Full Time
Job Description
· Need at least 7 years of experience in Teradata tools and utilities, database administration
· Experienced in performance optimization techniques and Structured Query Language (SQL) tuning. Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL)
· Ability to write complex Teradata SQL queries, stored procedures, triggers, functions
· Practical experience in managing the internal and external Teradata database security
· Strong understanding of Teradata Load Utilities, MVC, TPT, BTEQ scripts
· High degree of efficiency installing and configuring Teradata systems with Teradata
· Expertise with installing, maintaining, using all the Teradata tools (ex BTEQ, SQL Assistant, TPUMP, TD Administrator, ODBC, MLOAD, Fastload, etc)
· Informatica 9.X (Power Exchange, Power Center) is plus
· knowledge of UNIX scripting is a plus
· Understanding of CA7 is a plus
· Experience in migration project from Oracle to Teradata is plus
· Data warehouse experience is plus"