SQL performance and maintenance
Tune a slow SQL Server query in a sample database and document the existing logic, index change and measured result.
The Junior SQL Server Developer role includes query tuning, indexing and reverse engineering existing code for documentation and maintenance.
Source posting