Description:
System One is seeking a Teradata Database Administrator for an on-site hybrid role. The selected candidate must be local or willing to relocate within commuting distance of Strongsville, OH (preferred) or one of the secondary locations. This role involves database administration, query optimization, system monitoring, and ETL processes for Teradata environments.
Key Responsibilities:
- Database Administration: Manage, monitor, and maintain Teradata databases to ensure optimal performance and uptime.
- SQL Query Optimization: Enhance database performance by tuning complex queries and resolving bottlenecks.
- Data Migration & Integration: Utilize Teradata utilities such as BTEQ, FastLoad, MultiLoad, TPump, and Data Mover for data migration and integration tasks.
- System Monitoring & Performance Management: Use Teradata Viewpoint to monitor system performance, troubleshoot issues, and maintain system health.
- Unix/Linux & Scripting: Work within Unix/Linux environments, leveraging shell scripting for automation and system administration.
- ETL Process Management: Support Extract, Transform, and Load (ETL) operations using Informatica PowerCenter and other data integration tools.
Qualifications & Skills:
✅ Experience: 3-5 years as a Teradata Database Administrator
✅ Technical Skills:
- Strong knowledge of Teradata SQL, query optimization, and database tuning
- Hands-on experience with Teradata utilities (BTEQ, FastLoad, MultiLoad, TPump)
- Expertise in Teradata Viewpoint for system monitoring and performance management
- Proficiency in Unix/Linux operating systems and shell scripting
- Familiarity with Teradata Data Mover and FastExport/FastLoad for data migration
- Experience with ETL tools, preferably Informatica PowerCenter
✅ Location Requirement: Candidates must be local to one of the preferred locations or willing to relocate.
✅ Work Authorization: Candidates must provide work authorization details.