Overview
On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)
Skills
Teradata
Teradata Warehouse Miner
SQL
Data Governance
CPU
Backup Administration
Backup
Auditing
Data Integrity
Database
Disaster Recovery
System Monitoring
Service Level
Computer Hardware
Job Details
The following requirement is open with our client.
Title : Teradata DBA
Location : San Jose, CA (Onsite)
Duration : 12+Months
Relevant Experience (in Yrs.) : 9+
Detailed Job Description:
- Database Installation and Configuration: Installing, configuring, and upgrading Teradata database systems, including software and utilities.
- User and Security Management: Creating and managing user accounts, roles, profiles, and basic access privileges to control database access.
- Backup and Recovery Operations: Performing routine data backups, managing recovery processes, and ensuring data integrity and availability.
- System Monitoring and Alerting: Monitoring database health, performance metrics (CPU, I/O, space), and setting up alerts for potential issues.
- Performance Tuning and Optimization: Deep-diving into SQL query optimization, analyzing explain plans, and implementing advanced techniques (e.g., join indexes, partitioning) to enhance system performance.
- Workload Management (TWM/TDWM): Designing, configuring, and managing Teradata Workload Manager rules to prioritize queries, manage concurrency, and ensure service level agreements (SLAs).
- Capacity Planning and Growth Management: Analyzing historical usage patterns, forecasting future growth, and planning for hardware and software upgrades to meet evolving business needs.
- Disaster Recovery Planning and Testing: Developing, documenting, and regularly testing comprehensive disaster recovery strategies to ensure business continuity in the event of a major outage.
- Advanced Security and Compliance: Implementing advanced security features (e.g., encryption, auditing, row-level security), ensuring compliance with data governance policies, and conducting security audits.
Must Have Skill:
- Teradata
- SQL
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.