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.

About Virtusa



Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 30,000 people globally that cares about your growth -- one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.



Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.



Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.