Overview
Remote
Depends on Experience
Contract - Independent
Contract - W2
Skills
Teradata
Extract
Transform
Load
Job Details
Position: Teradata - Principal Subject Matter Expert (SME)
Location: Remote Opportunity
Are you an expert in Teradata with 18 20 years of deep, hands-on experience in managing, optimizing, and refining Teradata environments? We are looking for a Principal Subject Matter Expert (SME) to join our team and lead initiatives focused on improving and optimizing our Teradata systems.
Key Responsibilities:
Assess and Optimize Current Teradata Environment:
- Conduct a thorough evaluation of the existing Teradata architecture, performance, and configurations.
- Identify areas for performance improvement and provide actionable recommendations to optimize the system's efficiency.
Identify and Remove Unused Database Objects:
- Audit and clean up unused, obsolete, or redundant database objects like tables, views, and indexes.
- Improve database performance and maintain a lean, efficient environment by removing unnecessary objects.
Decommission Unnecessary ETL Jobs:
- Evaluate the ETL pipelines and identify redundant or obsolete ETL processes that no longer add value.
- Streamline data processes by decommissioning outdated jobs and suggesting more efficient alternatives.
Reclaim Storage from Obsolete/Inactive Data:
- Identify and archive or remove obsolete data that no longer serves the business needs.
- Work on strategies to reclaim storage and optimize the allocation of resources within the Teradata system.
Recommend Tools and Strategies for System Improvement:
- Propose and implement tools and methodologies to enhance the performance, scalability, and overall management of the Teradata environment.
- Stay up to date with the latest advancements in Teradata technologies and recommend best practices for continuous improvement.
Desired Expertise & Qualifications:
- Experience: 18-20 years of hands-on experience with Teradata solid understanding of Teradata architecture, optimization, and performance tuning.
- Technical Skills: Proficiency in database performance tuning, query optimization, ETL processes, and storage reclamation within Teradata. Strong knowledge of data management best practices.
- Strategic Thinking: Ability to recommend and implement long-term strategies that align with business needs while improving system performance.
- Problem-Solving: Strong analytical and troubleshooting skills, with the ability to resolve complex database issues efficiently.
Why Join Us?
- Work remotely with a dynamic team that is passionate about optimizing cutting-edge database solutions.
- Contribute to a high-impact project that will have long-term benefits for the system s performance and business efficiency.
- A collaborative environment where your expertise will be valued and recognized.
If you are a passionate database optimization expert and have the experience and skills to drive change in a Teradata environment, we want to hear from you!
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.