Avani Technology Solutions is seeking a SQL Analyst to review and optimize database queries for a client's reporting system. Your main task will be to analyze slow-running queries, rewrite them for better performance, and suggest indexing strategies. This contract role requires a strong analytical mindset and deep expertise in SQL to improve the efficiency and speed of critical data retrieval operations.

In this specialized role, you will be a performance tuning expert for our client's database systems. The primary goal is to identify performance bottlenecks within the database layer and resolve them by optimizing SQL queries. You will work closely with the client's development and BI teams to understand data access patterns and improve the overall responsiveness of their applications and reports.

Core Responsibilities

• Use database profiling tools to identify slow-performing queries and stored procedures.
• Analyze query execution plans to understand performance issues.
• Rewrite complex SQL queries to improve efficiency, reduce execution time, and lower resource consumption.
• Recommend and implement database indexing strategies to support faster data retrieval.
• Validate that optimized queries return correct results and do not introduce regressions.
• Document changes and provide clear explanations of the performance improvements achieved.
• Provide guidance to developers on best practices for writing performant SQL.

This project is perfect for someone who enjoys diving deep into database performance and has a passion for efficiency. Your work will have a direct and measurable impact on the user experience of the client's systems.

• 2-3 years of experience working heavily with SQL.
• Strong understanding of SQL query optimization techniques and execution plans.
• Experience with at least one major RDBMS like SQL Server, Oracle, or PostgreSQL.
• Analytical and problem-solving skills.
• Ability to work independently and manage your own tasks.

• Specialize in a high-demand skill area (database performance tuning).
• Work with large and complex datasets.
• Flexible remote work environment.
• Make a significant, measurable impact on system performance.