Job Description -
Local only | LinkedIn mandatory
Title : Teradata Application DBA
Location: Chicago, IL (must be local), 1 day a week onsite (Hybrid NO remote)
Duration: 6+ months
Exp: At least 7+ years of Teradata experience is required.
Role: Teradata Application DBA
? Need at least 7 years Teradata Database Administration experience and experience with significant experience with all Teradata Tools and Utilities (TTU) eg BTEQ, SQL Assistant, TPUMP, ODBC, MLOAD, Fastload, fast export)
? Experienced in performance optimization techniques and complex SQL tuning.
? Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL) ? Experienced in DSA and Quantum I3 BAR technologies
? Ability to write complex Teradata SQL queries, stored procedures, triggers, functions
? Advanced data analysis, problem identification and correction skills
? Experience connecting different BI tools to Teradata like OBIEE, SAS, Spotfire, PowerBI
? Experience integrating with ETL tools like AbInitio
? Experience integrating with AWS technologies
? Experience with using NOS and knowledge of cloudlake architecture and clearscape analytics.
? Ability to understand, manage and fix complex problems and to work with different teams and other technology groups collaboratively
? Understand, design and document support policies, procedures and strategies
? Understands, implements and maintains multi-tier database security
? Knowledge of Data Engineering principles and the ability to apply them to complex environment