Advanced SQL Test on SQL Server

I need an expert to complete an advanced SQL test on SQL Server. The test covers:
- Data manipulation and queries
- Database design and normalization
- Stored procedures and functions

Ideal Skills and Experience:
- Proficiency in SQL Server
- Strong understanding of advanced SQL concepts
- Experience with complex queries and database design

Please provide a detailed plan on how you will approach this task.