Overview
Skills
Job Details
Position: Teradata Database Administrator
Location: San Jose, California (Remote)
Duration: Contract
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.