Required Skills

rest Installation Policies database security Tools Performance optimization Triggers Stored procedures Tuning sql Database mvc Rollout

Work Authorization

  • Citizen

Preferred Employment

  • Full Time

Employment Type

  • Direct Hire

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 25th Jun 2022

JOB DETAIL

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) Roles and Responsibilities 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 monitor 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. Work with the team to ensure that the associated hardware resources 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.

Company Information