T-SQL Stored Procedure Modification

I need an SQL expert to modify an existing T-SQL stored procedure. The task primarily involves tweaking the query logic.

To be specific, I'm looking for someone who can:

- Insert and add more tables/joins to enhance the complexity and robustness of the existing procedure.
- Modify some of the current conditions to align with business dynamics and needs.

The ideal candidate should have extensive experience with T-SQL, and a good understanding of complex query logic and stored procedure optimization. Your experience with SQL server optimization will be a plus.