Principal Consultant

Job Description

Inviting applications for the role of Principal Consultant -Sr. Performance DBA Teradata

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

-

-

-

-

-

-