Our Team Teradata ASIA consulting team is looking for individuals that exemplify our principle of Customer Obsession through operational excellence, leadership, and a passion to continually be the voice of the customer. If you are interested in working in a dynamic and fast paced environment where you can directly influence the outcomes of consulting services, then this is the place for you. You will actively support and help our customers to meet their SLA’s by making sure of data availability, identify & troubleshoot Performance issues of critical workloads for seamless business operations and provide performance recommendations.
Your Specific Role/Business objectives would include:
• 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.
• 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.
Minimum Qualifications
• More than 10 years of Teradata 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 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.
Preferred Qualifications
• 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.
x
