What are the responsibilities and job description for the Teradata Admin position at 1 Point System?
Job Details
Title; Teradata Administrator
LOCATION : Peoria, IL
Duration: 1 year
This is day 1 onsite in Peoria, IL
15 YEARS EXP.
Description:
Seeking askilled Teradata Administrator with strong expertise in performanceoptimization, upgrade, support activities, and development. The idealcandidate will be responsible for managing Teradata environments, ensuring highavailability, optimizing query performance, and supporting business-criticalapplications. This role requires both technical depth and problem-solvingskills to maintain and enhance enterprise data systems.
DatabaseAdministration
o Install, configure, upgrade andmaintain Teradata systems.
o Manage database objects (tables,views, indexes, partitions).
o Monitor system health, capacity, andperformance.
• PerformanceOptimization
o Analyze and tune SQL queries forefficiency.
o Implement workload managementstrategies.
o Optimize database design forscalability and speed.
o Conduct performance testing andbenchmarking.
• Support Activities
o Provide day-to-day support forproduction environments.
o Troubleshoot and resolvedatabase-related issues.
o Ensure system availability,reliability, and disaster recovery readiness.
o Collaborate with application teamsto resolve data-related problems.
• Development & Enhancement
o Support ETL processes and dataintegration workflows.
o Develop scripts and automation forroutine tasks.
o Participate in data modeling andschema design.
o Contribute to continuous improvementinitiatives.
• Security & Compliance
• Manageuser access, roles, and privileges.
• Ensurecompliance with organizational data governance policies.
• Implementbackup and recovery strategies.
RequiredSkills & Experience
• Stronghands-on experience with Teradata database administration.
• Proficiencyin SQL query tuning and optimization.
• Knowledgeof Teradata utilities (FastLoad, MultiLoad, BTEQ, TPT).
• Experiencewith ETL tools and data integration processes.
• Familiaritywith performance monitoring tools and workload management.
• Strongproblem-solving and troubleshooting skills.
• Experiencein Linux/Unix environments and scripting (Shell, Python, etc.).
• Excellentcommunication and collaboration abilities.
Qualifications
• 10 years of experience in Teradata administration and support.
• Certificationsin Teradata or related technologies (preferred).
Nice-to-Have
• Exposureto cloud-based Teradata solutions (Teradata Vantage).
• Experiencewith BI/Analytics tools (Tableau, Power BI, SAS).
• Knowledgeof data warehousing concepts and big data ecosystems.