We need a Certified SQL Specialist for a 4-month project on database optimization. You will analyze and improve our indexing strategy and rewrite slow queries to enhance performance. This role requires certified, expert-level skills in SQL performance tuning and index management.

We are seeking a Certified SQL Database Specialist for a 4-month project focused on database indexing and query optimization. Our application is experiencing performance degradation, and we need an expert to analyze our database usage, identify missing or inefficient indexes, and optimize our most resource-intensive queries.

Project Goals:

• Perform a comprehensive analysis of our database's indexing strategy.
• Identify and create missing indexes to improve query performance.
• Analyze and rewrite slow-running queries to be more efficient.
• Monitor the impact of changes on database performance.
• Provide a final report detailing the optimizations made and their impact.

This is a highly specialized role for a developer who is an expert in SQL performance tuning. You must be able to read query execution plans, understand the trade-offs of different indexing strategies, and write highly efficient SQL. The SQL Database Management certification is required as a validation of these critical skills.

• 3+ years of experience in a SQL-heavy role.
• Deep expertise in SQL performance tuning and optimization.
• Strong understanding of database indexing strategies (e.g., B-tree, clustered, non-clustered).
• Experience with analyzing query execution plans.
• Must hold the SQL Database Management certification.
• Meticulous attention to detail.

• Gain experience with a large and complex database environment.
• Work alongside experienced DBAs and data architects.
• Fully remote contract position.
• Opportunity to make a significant impact on data performance.