Description

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

Responsibilities

• Execute database administration tasks including system administration, backup, archive, and restore management.
• Perform capacity planning, performance monitoring, and tuning using Teradata Viewpoint.
• Manage user security, space, and workload management following Teradata best practices.
• Troubleshoot Teradata utilities including FastLoad, MultiLoad, FastExport, BTEQ, and TPT.
• Coordinate software and hardware upgrades and manage lower environments like Dev and QA.

Required Skills

• 3-12 years of experience as a Teradata DBA.
• Proficiency with Teradata tools such as Teradata Administrator, SQL Assistant, and TSET.
• Hands-on experience with Teradata utilities and DSA.
• Ability to write efficient SQL and perform query tuning.
• Working knowledge of Unix commands and basic scripting.
• Experience with backup and restore processes using Veritas netbackup (TARA), netvault, or Tivoli.
• Exposure to TASM/TDWM, MVC, and capacity planning.
• Experience with Statistics Management and PDCR reporting and analysis.
• Strong debugging skills and familiarity with ITIL processes.

Preferred Skills

• Experience with Teradata in public or private cloud environments.
• Working knowledge of Python.

Key Skills

Education

Any Graduate