Teradata Administrator

YASH Technologies; Peoria (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

An IT Consulting firm is seeking a skilled Teradata Administrator to manage their database administration tasks. The ideal candidate will have over 10 years of experience, along with expertise in SQL query tuning, performance optimization, and a strong understanding of Teradata utilities. Responsibilities include system monitoring, troubleshooting, and ensuring compliance with data governance policies. This mid-senior level contract role is located in Peoria, IL and requires onsite presence from day one.

Qualifications

• Strong hands-on experience with Teradata database administration.
• Proficiency in SQL query tuning and optimization.
• Knowledge of Teradata utilities like FastLoad and MultiLoad.
• Experience in ETL processes and data integration workflows.
• Familiarity with performance monitoring tools.

Responsibilities

• Install and maintain Teradata systems.
• Monitor system health and performance.
• Analyze SQL queries for efficiency.
• Provide support for production environments.
• Manage user access and ensure data compliance.

Skills

Teradata database administration

SQL query tuning and optimization

Teradata utilities (FastLoad, MultiLoad, BTEQ, TPT)

ETL tools and data integration

Performance monitoring tools

Linux/Unix scripting

Problem-solving skills

Communication and collaboration

Education

10+ years of experience in Teradata administration

Certifications in Teradata or related technologies

Tools

SQL

Shell scripting

Python

Teradata Vantage

Tableau

Power BI

SAS

Job description

Sr. Technical Recruiter at YASH Technologies

We are actively looking for a Teradata Administrator. If you are actively looking for a new job please share your profile.

Duration: 6+ Months

Location: Peoria, IL

Day 1 onsite in Peoria, IL

Description

Seeking a skilled Teradata Administrator with strong expertise in performance optimization, upgrade, support activities, and development. The ideal candidate will be responsible for managing Teradata environments, ensuring high availability, optimizing query performance, and supporting business‑critical applications. This role requires both technical depth and problem‑solving skills to maintain and enhance enterprise data systems.

Responsibilities

Database Administration

• Install, configure, upgrade and maintain Teradata systems.
• Monitor system health, capacity, and performance.

Performance Optimization

• Analyze and tune SQL queries for efficiency.
• Optimize database design for scalability and speed.
• Conduct performance testing and benchmarking.

Support Activities

• Provide day‑to‑day support for production environments.
• Troubleshoot and resolve database‑related issues.
• Ensure system availability, reliability, and disaster recovery readiness.
• Collaborate with application teams to resolve data‑related problems.
• Support ETL processes and data integration workflows.
• Develop scripts and automation for routine tasks.
• Participate in data modeling and schema design.
• Contribute to continuous improvement initiatives.

Security & Compliance

• Manage user access, roles, and privileges.
• Ensure compliance with organizational data governance policies.
• Implement backup and recovery strategies.

Required Skills & Experience

• Strong hands‑on experience with Teradata database administration.
• Proficiency in SQL query tuning and optimization.
• Knowledge of Teradata utilities (FastLoad, MultiLoad, BTEQ, TPT).
• Experience with ETL tools and data integration processes.
• Familiarity with performance monitoring tools and workload management.
• Strong problem‑solving and troubleshooting skills.
• Experience in Linux/Unix environments and scripting (Shell, Python, etc.).
• Excellent communication and collaboration abilities.

Qualifications

• 10+ years of experience in Teradata administration and support.
• Certifications in Teradata or related technologies (preferred).

Nice‑to‑Have

• Exposure to cloud‑based Teradata solutions (Teradata Vantage).
• Experience with BI/Analytics tools (Tableau, Power BI, SAS).
• Knowledge of data warehousing concepts and big data ecosystems.

Thank You

Seniority Level

Mid‑Senior level

Employment Type

Contract

Job Function

IT Services and IT Consulting

Referrals increase your chances of interviewing at YASH Technologies by 2x