Job Description

Job Title: Teradata Specialist

Location: Remote

Reports To: Data Warehouse Manager / IT Infrastructure Lead

Position Overview

We're seeking an experienced Teradata Specialist to join our project team. In this role, you will be supporting complex migration off of a Teradata platform into a Databricks environment. This role is responsible for optimizing data extracts and queries, managing overall system performance, and ensuring the stability of the Teradata environment. You will leverage your DBA expertise, deep understanding of Teradata utilities, and ETL know-how to drive performance improvements and support our growing analytical workloads.

Key Responsibilities

• Performance Optimization & Tuning
  • Analyze and tune complex SQL queries for optimal response times
  • Monitor system health and workload management (TASM, Resource Classes)
  • Identify and resolve performance bottlenecks (data skew, join strategies, indexing)
• Teradata Utilities Management
  • Design, develop, and maintain load/unload processes using FastLoad, MultiLoad, MLoad, TPump, and BTEQ
  • Build and manage Teradata Parallel Transporter (TPT) scripts for high-volume data movement
  • Implement best practices for utility parameter settings to maximize throughput
• Database Administration (DBA)
  • Manage user accounts, roles, and security privileges
  • Perform regular backups, restores, and archiving operations
  • Plan and execute capacity management and space allocation strategies
  • Apply patches, upgrades, and system configuration changes
• ETL & Data Integration
  • Collaborate with ETL developers to design efficient data pipelines (DataBricks, DataStage, SSIS, Talend or equivalent)
  • Troubleshoot and optimize ETL workflows for large-scale data loads
  • Ensure data quality, consistency, and lineage across source-to-target processes
• Monitoring & Incident Management
  • Investigate and resolve conversion related incidents, service disruptions, and critical production issues
  • Document runbooks, standard operating procedures, and post-mortem reports
• Collaboration & Documentation
  • Work closely with data architects, BI/reporting teams, and application developers
  • Provide guidance on changes required to data modeling, partitioning, and indexing strategies to support conversion
  • Develop & Maintain clear, up-to-date system documentation and knowledgebase articles

Required Skills & Qualifications

• Teradata Expertise:
  • 5+ years' hands-on experience in a production Teradata environment
  • Strong command of Teradata SQL and Analytics functions
  • Deep knowledge of Teradata utilities: FastLoad, MultiLoad, MLoad, TPump, BTEQ, and TPT
• Database Administration:
  • User/security management, space management, backup/recovery, and system maintenance
  • Familiarity with Unix/Linux shell scripting and basic system administration
• ETL & Data Warehousing:
  • Proficiency with at least one enterprise ETL tool (Databricks, Informatica, IBM DataStage, SSIS, Talend etc.)
  • Solid understanding of dimensional modeling, star schemas, and data mart design
• Performance & Optimization:
  • Experience analyzing explain plans, statistics collection, and index strategies
  • Skilled at diagnosing data skew, CPU/memory contention, and I/O hotspots
• Soft Skills:
  • Excellent problem-solving and troubleshooting abilities
  • Strong communication skills, able to explain technical issues to non-technical stakeholders
  • Team player with a proactive, service-oriented mindset

Preferred Qualifications

• Teradata Certified Professional (e.g., Teradata Certified Database Administrator)
• Experience with Teradata Active System Management (TASM) and Viewpoint administration
• Knowledge of cloud-based Teradata solutions (e.g., Teradata Vantage on AWS/Azure)
• Familiarity with version control (Git), CI/CD pipelines, and infrastructure-as-code tools.

Job Tags

Similar Jobs