Description

Manage and support 24x7 production and development Teradata databases to ensure maximum availability.

Responsibilities

• Execute system administration, database administration, backup, archive, and restore processes.
• Perform capacity planning, performance monitoring, tuning, and problem resolution.
• Manage users, security, space, and workload following Teradata best practices.
• Troubleshoot FastLoad, MultiLoad, FastExport, BTEQ, and TPT, including error handling.
• Coordinate software and hardware upgrade activities and manage lower environments.

Required Skills

• 3-12 years of experience as a Teradata DBA.
• Hands-on experience with Teradata tools including Teradata Administrator, SQL Assistant, and TSET.
• Proficiency in Teradata utilities and hands-on experience using DSA.
• Experience with TASM/TDWM and MVC.
• Knowledge of Statistics Management and PDCR Reporting and Analysis.
• Experience with backup and restore processes using Veritas NetBackup (TARA), NetVault, or Tivoli.
• Ability to write efficient SQL and perform query tuning.
• Working knowledge of Unix commands and basic scripting.
• Experience in DWH environments with knowledge of ETL, DI, and BI reporting.

Preferred Skills

• Experience with Teradata in public or private cloud environments.
• Working knowledge of Python.
• Exposure to ETL/BI tools such as Informatica, DataStage, Business Objects, SAS, Microstrategy, Tableau, or Power BI.

Key Skills

Education

Any Graduate