Senior Teradata Database Administrator

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