Teradata Administrator

Overview

On Site
Up to $80
Contract - W2
Contract - 12 Month(s)

Skills

Teradata Administration
Teradata Admin
SQL tuning
Teradata utilities

Job Details

Teradata Administrator

LOCATION : Peoria, IL

Duration: 1 year

This is day 1 onsite in Peoria, IL

Description:

Seeking askilled Teradata Administrator with strong expertise in performanceoptimization, upgrade, support activities, and development. The idealcandidate will be responsible for managing Teradata environments, ensuring highavailability, optimizing query performance, and supporting business-criticalapplications. This role requires both technical depth and problem-solvingskills to maintain and enhance enterprise data systems.

DatabaseAdministration

o Install, configure, upgrade andmaintain Teradata systems.

o Manage database objects (tables,views, indexes, partitions).

o Monitor system health, capacity, andperformance.

PerformanceOptimization

o Analyze and tune SQL queries forefficiency.

o Implement workload managementstrategies.

o Optimize database design forscalability and speed.

o Conduct performance testing andbenchmarking.

  • Support Activities

o Provide day-to-day support forproduction environments.

o Troubleshoot and resolvedatabase-related issues.

o Ensure system availability,reliability, and disaster recovery readiness.

o Collaborate with application teamsto resolve data-related problems.

  • Development & Enhancement

o Support ETL processes and dataintegration workflows.

o Develop scripts and automation forroutine tasks.

o Participate in data modeling andschema design.

o Contribute to continuous improvementinitiatives.

  • Security & Compliance

Manageuser access, roles, and privileges.

Ensurecompliance with organizational data governance policies.

Implementbackup and recovery strategies.

RequiredSkills & Experience

Stronghands-on experience with Teradata database administration.

Proficiencyin SQL query tuning and optimization.

Knowledgeof Teradata utilities (FastLoad, MultiLoad, BTEQ, TPT).

Experiencewith ETL tools and data integration processes.

Familiaritywith performance monitoring tools and workload management.

Strongproblem-solving and troubleshooting skills.

Experiencein Linux/Unix environments and scripting (Shell, Python, etc.).

Excellentcommunication and collaboration abilities.

Qualifications

10+years of experience in Teradata administration and support.

Certificationsin Teradata or related technologies (preferred).

Nice-to-Have

Exposureto cloud-based Teradata solutions (Teradata Vantage).

Experiencewith BI/Analytics tools (Tableau, Power BI, SAS).

Knowledgeof data warehousing concepts and big data ecosystems.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.