Description

Manage Teradata database administration and support complex data environments.

Responsibilities

• Administer Teradata databases using BTEQ, SQL Assistant, TPUMP, ODBC, MLOAD, Fastload, and FastExport.
• Optimize performance through complex SQL tuning and advanced data analysis.
• Monitor and report on system performance using PDCR and DBQL.
• Implement and maintain multi-tier database security and support policies.
• Integrate Teradata with BI tools, ETL processes, and AWS technologies.

Required Skills

• 7+ years of Teradata Database Administration experience.
• Expertise in Teradata Tools and Utilities (TTU).
• Proficiency in writing complex Teradata SQL queries, stored procedures, triggers, and functions.
• Experience with DSA and Quantum I3 BAR technologies.
• Hands-on experience connecting BI tools such as OBIEE, SAS, Spotfire, and PowerBI to Teradata.
• Experience integrating with AbInitio ETL tools.
• Experience with AWS technologies, NOS, cloudlake architecture, and Clearscape Analytics.
• Strong knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL).
• Solid understanding of Data Engineering principles.

Preferred Skills

• Ability to design and document formal support procedures and strategies.

Key Skills

Education

Any Gradute