RedShift SQL

RedShift SQL - CREQ Description Job Description :

The role of Commercial IT We are seeking skilled Redshift Query Performance Specialist and developers with eight plus years of experience to join our data engineering team. The ideal candidate will have extensive experience with Amazon Redshift, particularly in optimizing and tuning complex SQL queries to enhance performance and efficiency.

Design and implement efficient data models and structures to support high-performance queries and analytics.

Experience Database design and architecting data solutions with AWS Redshift.

Analyse and optimize complex SQL queries to ensure optimal performance in Redshift. Identify and resolve performance bottlenecks.

Utilize Redshift performance tools and techniques, including EXPLAIN plans, WLM Workload Management), and system tables, to tune the performance of queries and data models. Monitor Redshift cluster performance, identify issues, and troubleshoot slow-running queries. Establish and promote best practices for SQL coding, data modelling, and performance tuning within the organization.

Document optimization strategies, tuning techniques, and best practices for future reference and knowledge sharing.

Primary Location Chennai, Tamil Nadu, India Job Type Experienced Primary Skills Redshift, Amazon Redshift Years of Experience 7 Travel No