Dba serp_jobs.h1.location_city

1. Database Installation and Configuration : Installing, configuring, and upgrading Teradata database systems, including software and utilities.

2. User and Security Management : Creating and managing user accounts, roles, profiles, and basic access privileges to control database access.

3. Backup and Recovery Operations : Performing routine data backups, managing recovery processes, and ensuring data integrity and availability.

4. System Monitoring and Alerting : Monitoring database health, performance metrics (CPU, I / O, space), and setting up alerts for potential issues.

5. Basic Troubleshooting : Diagnosing and resolving common database-related problems, such as connectivity issues, space constraints, or failed jobs.

6. Advanced Responsibilities :

7. 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.

8. Workload Management (TWM / TDWM) : Designing, configuring, and managing Teradata Workload Manager rules to prioritize queries, manage concurrency, and ensure service level agreements (SLAs).

9. Capacity Planning and Growth Management : Analyzing historical usage patterns, forecasting future growth, and planning for hardware and software upgrades to meet evolving business needs.

10. 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.

11. 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.