We need a SQL expert for a 2-week project to audit and optimize critical stored procedures. You will analyze execution plans, identify bottlenecks, and provide a detailed report with recommendations and optimized code. Deep expertise in SQL performance tuning is required.

We are looking for a database specialist for a short-term, 2-week engagement. The project is to perform a performance audit of several key stored procedures in our production database. You will be responsible for analyzing the execution plans of these procedures, identifying performance bottlenecks, and providing recommendations for optimization.

Your Tasks:

• Review a list of 5-10 mission-critical stored procedures.
• Analyze their execution plans to identify issues like table scans, inefficient joins, or missing indexes.
• Rewrite queries or suggest index changes to improve performance.
• You will not be deploying changes to production, but rather providing a detailed report with your findings and optimized SQL code.
• Your report should clearly explain the identified problems and the rationale behind your proposed solutions.

This is a perfect project for an expert in SQL who enjoys diving deep into query optimization. You need to be highly proficient in reading and interpreting execution plans and have a strong understanding of how database indexes work. A certification in SQL is preferred to demonstrate this expertise.

• Extensive experience with SQL and query performance tuning.
• Ability to read and interpret complex query execution plans.
• Strong understanding of database indexing strategies.
• Excellent analytical and written communication skills to produce a clear report.
• Experience with a major RDBMS like SQL Server or PostgreSQL.

• Short project with a clear deliverable.
• Opportunity to analyze and improve a production system.
• Flexible remote work.
• Work directly with the database administration team.