Teradata Admin (Onsite)

DMS Vision • Frisco, AL

18h • Onsite

About The Position

We are seeking an experienced Teradata Administrator to manage, maintain, and optimize Teradata environments. The role is onsite in Pleasanton, California; Dallas, Texas; Coppell, Texas; or San Francisco, California, with relocation acceptable. The position is listed for a six-month duration.

The administrator will install, configure, and upgrade Teradata Database systems; manage utilities used for data loading and extraction; tune performance, workloads, and queries; monitor system health and plan capacity; manage storage, access, and security; troubleshoot database issues; and implement backup, recovery, and disaster recovery practices. The role also involves collaborating with development teams on schema design and query optimization, and maintaining documentation of configurations, processes, and best practices.

Requirements

• At least 5 years of experience in Teradata Database Administration.
• Proficiency in Teradata tools and utilities, including BTEQ, FastLoad, MultiLoad, and TPT.
• Expertise in SQL and query optimization.
• Knowledge of Teradata Workload Management (TASM).
• Familiarity with Teradata Viewpoint, monitoring, and alerting.
• Experience with backup and recovery strategies and disaster recovery planning.
• Understanding of data warehousing concepts and ETL processes.
• Good knowledge of Linux/Unix environments and scripting.
• Bachelor’s degree in Computer Science, Information Technology, or a related field.

Nice To Haves

• Exposure to Teradata Data Mover and BAR (Backup Archive Restore).
• Knowledge of cloud-based Teradata solutions.
• Experience with BI tools and integration.

Responsibilities

• Install, configure, and upgrade Teradata Database systems.
• Manage Teradata utilities, including BTEQ, FastLoad, MultiLoad, and TPT, for data loading and extraction.
• Perform performance tuning, workload management, and query optimization.
• Monitor system health, plan capacity, and implement proactive measures.
• Manage space allocation, user access, and security controls.
• Troubleshoot and resolve database issues to ensure high availability and reliability.
• Implement backup and recovery strategies using Teradata tools.
• Collaborate with development teams on schema design and query optimization.
• Maintain documentation for configurations, processes, and best practices.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior