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 ManagementDesign, 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 movementImplement best practices for utility parameter settings to maximize throughputDatabase Administration (DBA)Manage user accounts, roles, and security privileges
Perform regular backups, restores, and archiving operationsPlan and execute capacity management and space allocation strategiesApply patches, upgrades, and system configuration changesETL & Data IntegrationCollaborate with ETL developers to design efficient data pipelines (DataBricks, DataStage, SSIS, Talend or equivalent)
Troubleshoot and optimize ETL workflows for large-scale data loadsEnsure data quality, consistency, and lineage across source-to-target processesMonitoring & Incident ManagementInvestigate and resolve conversion related incidents, service disruptions, and critical production issues
Document runbooks, standard operating procedures, and post-mortem reportsCollaboration & DocumentationWork closely with data architects, BI / reporting teams, and application developers
Provide guidance on changes required to data modeling, partitioning, and indexing strategies to support conversionDevelop & Maintain clear, up-to-date system documentation and knowledgebase articlesRequired Skills & Qualifications
Teradata Expertise :5+ years’ hands-on experience in a production Teradata environment
Strong command of Teradata SQL and Analytics functionsDeep knowledge of Teradata utilities : FastLoad, MultiLoad, MLoad, TPump, BTEQ, and TPTDatabase Administration :User / security management, space management, backup / recovery, and system maintenance
Familiarity with Unix / Linux shell scripting and basic system administrationETL & 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 designPerformance & Optimization :Experience analyzing explain plans, statistics collection, and index strategies
Skilled at diagnosing data skew, CPU / memory contention, and I / O hotspotsSoft Skills :Excellent problem-solving and troubleshooting abilities
Strong communication skills, able to explain technical issues to non-technical stakeholdersTeam player with a proactive, service-oriented mindsetPreferred Qualifications
Teradata Certified Professional (e.g., Teradata Certified Database Administrator)Experience with Teradata Active System Management (TASM) and Viewpoint administrationKnowledge 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.