Teradata Administrator

We are looking for

• Installs, configures, and upgrades Teradata software and related products.
• Backup, restore, migrate Teradata data and objects.
• Establish and maintain backup and recovery policies and procedures.
• Manages and monitors system performance.
• Proactively monitor the database systems to ensure secure services with minimum downtime.
• Implements and maintains database security.
• Sets up and maintains documentation and standards.
• Supports multiple Teradata Systems including independent marts/ enterprise warehouse.
• Experience 6 to 9 years.
• Required Skills - Teradata, Teradata Administration.
• Technical Skills- Azure Admin.

• Work with the team to ensure that the associated hardware resources are allocated to the databases and to ensure high availability and optimum performance.
• Responsible for improvement and maintenance of the databases to include rollout and upgrades.
• Responsible for implementation and release of database changes as submitted by the development team.
• Need at least 7 years of experience in Teradata tools and utilities.
• Need at least 2 years Teradata Database Administration experience.
• 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.).
• 9 Years of Experience.