Job Description
- 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, a...
Ready to Apply?
Take the next step in your AI career. Submit your application to Systechcorp Private Limited today.
Submit Application