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