Senior Teradata Database Administrator

Job SummaryResponsible 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 Responsibilities1. Teradata Database AdministrationAdminister 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 & TuningMonitor 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 ViewpointConfigure, 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 ManagementMonitor 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 RecoveryPerform 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 MigrationPerform 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 & PatchingPlan 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 ManagementMonitor 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 AdministrationCreate 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 SupportProvide 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 ReportingPerform 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 ManagementFollow 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 & QualificationsBachelor'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