Teradata Admin

Overview

On Site
Accepts corp to corp applications
Contract - W2

Skills

Teradata Administrator
Teradata SQL
Teradata utilities

Job Details

12+ years of experience with at least 7 years of hands-on experience in Teradata database administration

Strong hands-on experience with Teradata SQL, Teradata utilities.

Proficient with scripting language Python, PowerShell for automation.

Understanding of data modeling, ETL/ELT processes, and data warehousing concepts.

Experience working with Azure cloud-based environment is a plus

Experience with Data governance, data security, data quality, data lineage, data catalog and compliance practices

Excellent problem-solving, communication and collaboration skills

Job Summary:

We are seeking for skilled and experienced Teradata Administrator and with a strong background on Teradata and ETL/ELT process. A Teradata Administrator will be responsible for managing and maintaining Teradata database systems to ensure optimal performance, security, and availability. This role involves working closely with database developers, system administrators, and business analysts to support enterprise data needs.

Key Responsibilities:

Database Management & Maintenance

Install, configure, and upgrade Teradata database software and associated tools.

Monitor database health and performance using Teradata Viewpoint and other monitoring tools.

Perform routine maintenance tasks including space management, statistics collection, and system housekeeping.

Performance Tuning & Optimization

Analyze and optimize SQL queries for performance improvements.

Implement indexing strategies and partitioning to enhance query efficiency.

Collaborate with developers and data engineers to design scalable data models.

Security & Compliance

Manage user access, roles, and privileges in accordance with organizational policies.

Ensure compliance with data governance and security standards.

Monitor and audit database activities to detect and prevent unauthorized access.

Backup & Recovery

Design and implement backup strategies using Teradata tools (e.g., ARC).

Perform recovery operations in case of system failures or data corruption.

Test disaster recovery procedures regularly to ensure readiness.

Capacity Planning & System Scaling

Forecast storage and compute requirements based on usage trends.

Plan and execute system scaling activities to support growing data volumes.

Coordinate with infrastructure teams for hardware and resource provisioning.

Troubleshooting & Support

Investigate and resolve database-related issues and incidents.

Provide support during system outages and performance degradation.

Maintain documentation for configurations, procedures, and troubleshooting steps.

Required Skills & Qualifications:

Bachelor's degree in Computer Science, Information Technology, or related field

Preferred Qualifications:

Teradata certifications (e.g., Teradata Certified Professional, Teradata Administrator)

Exposure to DevOps practices and CI/CD pipelines for database deployments.

Exposure to Agile/Scrum methodologies and collaborative development environments.

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.