Teradata Database Administrator

Summary: The Teradata Database Administrator role involves managing and optimizing Teradata databases in a remote capacity. Key responsibilities include installation, configuration, and performance tuning of databases, as well as ensuring data integrity and security. The position requires troubleshooting database issues and implementing disaster recovery strategies. This contract role is classified as outside IR35.

Key Responsibilities:

• Install, configure, and upgrade Teradata databases, software, and utilities.
• Manage users, roles, and security permissions to ensure controlled access.
• Perform regular data backups, recovery operations, and ensure data integrity.
• Monitor system performance (CPU, I/O, space) and set up alerts for issues.
• Troubleshoot database problems such as connectivity and job failures.
• Optimize SQL queries and tune database performance using explain plans, join indexes, and partitioning.
• Configure and manage Teradata Workload Manager (TWM/TDWM) for query prioritization and SLAs.
• Conduct capacity planning, analyze usage trends, and forecast system growth.
• Develop and test disaster recovery strategies to maintain business continuity.
• Implement encryption, auditing, and row-level security to ensure compliance with data governance standards.

Key Skills:

• Experience with Teradata database installation and configuration.
• Knowledge of database security management and user roles.
• Proficiency in SQL query optimization and performance tuning.
• Ability to monitor and troubleshoot database performance issues.
• Experience with disaster recovery planning and implementation.
• Familiarity with Teradata Workload Manager (TWM/TDWM).
• Understanding of data governance and compliance standards.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT