Teradata Performance Database Administrator

Teradata expert is responsible for solving real world cutting edge problem and mentor a team of one or more junior developer to address the goal. Responsibilities : - Strong expertise in writing and optimizing Teradata SQL queries, TPT script etc. - Manage Production/Development databases performance. - Review Teradata system reports and provide "performance assessment" report with recommendations to optimize system. - Investigate and quantify opportunities from "performance assessment" reports and. - Apply best practices in each of the areas. - Monitor using Viewpoint tool for Teradata system performance using different portlets. - Review poor performing queries generated from BI/ETL tools and provide best practice recommendations on how to simplify and restructure views, apply PPI or other index changes. - Closely monitor the performance of various work groups on the system and make sure data is available to business as per the SLA requirement. - Optimal index analysis Review Index usage on tables and recommend adding dropping indexes for optimal data access. - Review uncompressed tables, analyse its usage, and implement compression to save space and reduce IO activity - using various algorithms like MVC/ BLC/ ALC. - Optimize locking statements in views, macros & queries to eliminate blocking contention invest. - Review the Spool Limits for the users and recommend optimal limit for the Ad-hoc users to avoid run away queries over consuming system resources. - Check for Mismatch data types in the system and make them unique to avoid costly translations during query processing. - Review Set tables and check for the options to convert to MultiSet to avoid costly duplicate row checking operation. - Review Large Scan Tables on the system and analyze for using PPI, MLPPI, Compression, Secondary indexes & Join Indexes. - Analyze various applications and understand the space requirements and segregate the disk space under the categories of perm, spool, and temp space. - Setting up the database hierarchy that includes database creation and management of objects such as users, Roles, Profiles, tables, views. - Maintain profiles, roles, access rights and permissions for Teradata user groups and objects. - Generate periodic performance reports using PDCR and identify bottlenecks with the system performance. - Establish PDCR canary performance baselines. - Utilize standard canary queries to identify variance from baseline. - Effective usage of TASM & Priority distribution to penalize the resource intensive queries, Give high priority to business-critical workloads, Throttling of different workloads for optimal throughput and provide performance reports to check workload management health. Qualifications we seek in you Minimum qualifications : - 6-12 years of Teradata Performance DBA experience. - Experience in review of poor performing queries and provide best practice recommendations on how to simplify and restructure views, apply PPI or other index changes. - Statistics Management and Optimization. - Exposure to DWH Env (Knowledge of ETL/DI/BI Reporting). - Exposure to troubleshoot the TPT/ FastLoad / Multiload/ FastExport/ BTEQ/ TPump errors, should be good at error handling. - Experience in fine tuning various application parameters/number of sessions to ensure optimal functioning of the application. - Well conversant with various ticketing system/production change request/ Teradata Incident management. - Should be good at automating various processes. - Ability to write efficient SQL & exposure to query tuning. - Preferably understand Normalization and De-normalization concepts. - Preferable exposure to visualization tools like Tableau, PowerBI. - Preferably have good working knowledge on UNIX shell, Python scripting. - Good to have exposure to FSLDM. - Good to have exposure to GCFR framework. (ref:hirist.tech)

Location: bangalore, IN

Posted Date: 4/16/2025