Job Title: Teradata DBA
Location: San Jose, CA(Onsite)
Duration : 12 Months
Rate : $60/hr on C2C
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. Basic Troubleshooting: Diagnosing and resolving common database-related problems, such as connectivity issues, space constraints, or failed jobs.
Advanced Responsibilities:
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. 1Advanced Security and Compliance: Implementing advanced security features (e.g., encryption, auditing, row-level security), ensuring compliance with data governance policies, and conducting security audits.
Kind regards,
Venu Gopal
Flexon Technologies Inc.
venu@flexontechnologies.com
