Job Summary
Responsible for the administration, performance, availability, security, maintenance, upgrade, backup, recovery, and lifecycle management of enterprise Teradata database environments. The role requires strong hands-on expertise in Teradata database administration, performance monitoring and tuning, workload management, production support, migration, disaster recovery, and Teradata platform maintenance.
Key Responsibilities
1. Teradata Database Administration
- Administer and support enterprise Teradata database environments across Production, UAT, Development, and DR systems.
- Perform Teradata database administration, configuration, monitoring, and troubleshooting.
- Manage Teradata users, roles, profiles, privileges, spool space, permanent space, and temporary space.
- Create and manage Teradata database objects including databases, tables, views, indexes, statistics, and partitions.
- Monitor database health, availability, system resources, space utilization, and operational performance.
- Troubleshoot database-related issues and perform root-cause analysis.
2. Teradata Performance Monitoring & Tuning
- Monitor Teradata system and query performance using Teradata Viewpoint, DBQL, and PDCR.
- Identify and analyze high CPU, high I/O, long-running, inefficient, and resource-intensive queries.
- Analyze query execution plans and identify performance bottlenecks.
- Analyze full-table scans, joins, indexes, statistics, partitioning, data distribution, and query access paths.
- Provide SQL and database performance tuning recommendations.
- Work with ETL and application teams to optimize poorly performing queries and database processes.
- Analyze historical workload information using DBQL and PDCR for performance investigation and reporting.
3. PDCR & Teradata Viewpoint
- Configure, install, and administer Teradata Performance & Data Collection (PDCR).
- Generate and maintain PDCR performance and management reports.
- Analyze historical database performance and workload information using PDCR.
- Configure and maintain Teradata Viewpoint portlets for database monitoring.
- Configure Query Spotlight and other monitoring capabilities to identify high CPU, high I/O, long-running, and problematic queries.
- Configure Viewpoint alerts for critical database conditions such as high space utilization, blocking sessions, and ETL-window performance issues.
- Develop and maintain customized Teradata performance and operational reports.
4. TASM & Workload Management
- Monitor and administer Teradata Active System Management (TASM) and workload management.
- Analyze workload behavior, resource consumption, query classification, and workload performance.
- Monitor CPU, I/O, concurrency, throttling, and workload utilization.
- Support workload optimization and tuning based on business and operational requirements.
- Investigate workload-related performance issues and recommend appropriate corrective actions.
5. Backup, Recovery & Disaster Recovery
- Perform and support Teradata database backup and recovery activities.
- Administer and monitor Teradata BAR Data Stream Controller (DSC) backup and restore operations.
- Support disaster recovery activities and database recovery validation.
- Perform database restoration and post-restore validation.
- Conduct DR/UAT validation to ensure database objects and data are correctly restored.
- Investigate and resolve backup, restore, and recovery issues.
6. Teradata Data Migration
- Perform Teradata database and data migration activities between environments and platforms.
- Support hardware and database migrations, including backup, restoration, validation, and post-migration activities.
- Coordinate migration activities with Teradata support and relevant technical teams.
- Perform source and destination validation following migration or restoration.
- Ensure migration activities are completed within agreed timelines with appropriate validation and rollback procedures.
7. Teradata DBMS Upgrades & Patching
- Plan and execute Teradata DBMS upgrades, patches, and service packs.
- Perform pre-upgrade health checks and prerequisite validation.
- Coordinate upgrade activities with Teradata support and internal technical teams.
- Execute DBMS upgrades and perform post-upgrade database validation.
- Troubleshoot issues arising during or after Teradata upgrades.
- Support Teradata Appliance Operating System (SLES) upgrades and service-pack activities.
- Coordinate planned downtime and post-upgrade service validation.
8. Space & Capacity Management
- Monitor Teradata database, table, user, and system space utilization.
- Identify tables and databases with significant or abnormal space growth.
- Perform capacity monitoring and provide space utilization and growth reports.
- Manage permanent space, spool space, and temporary space requirements.
- Configure and monitor space-related alerts.
- Support capacity planning based on historical Teradata usage and growth trends.
9. Teradata User & Security Administration
- Create and manage Teradata users, roles, profiles, and privileges.
- Manage user access and database permissions in accordance with organizational security requirements.
- Configure and manage profile-level spool and resource limits.
- Perform access and privilege administration for Teradata environments.
- Support security and audit requirements related to Teradata database access.
10. Production Support
- Provide support for enterprise Teradata production environments.
- Troubleshoot Teradata database, performance, workload, space, locking, query, and operational issues.
- Monitor critical production workloads and database activities.
- Investigate incidents and perform root-cause analysis.
- Coordinate with Teradata support for complex database and platform issues.
- Support production deployments, changes, maintenance activities, and emergency fixes.
11. Teradata Monitoring & Operational Reporting
- Perform regular Teradata database health checks.
- Monitor database performance, capacity, workload, space, and system availability.
- Prepare daily, weekly, and management-level Teradata operational and performance reports.
- Monitor blocking sessions, resource-intensive queries, ETL workload windows, and system capacity.
- Identify trends and proactively recommend corrective actions.
12. Change, Incident & Problem Management
- Follow established change-management and production-support procedures.
- Prepare technical implementation and rollback plans for Teradata changes.
- Participate in incident, problem, and change-management activities.
- Document root-cause analysis and preventive actions.
- Maintain Teradata DBA operational procedures, technical documentation.
Experience & Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- 8+ years of database administration experience with significant hands-on Teradata DBA experience.
- Proven experience supporting enterprise-scale Teradata production environments.
- Experience with Teradata performance tuning, DBQL, PDCR, Viewpoint, TASM, backup/recovery, migration, and upgrades.
- Experience working with Teradata vendor/support teams.
- Experience in mission-critical enterprise environments is preferred.
Also, You can forward your CV through below link for more upcoming Job vacancies: https://cv-fnrco.com
