I find that many people want Microsoft CRM aka Dynamics aka GP. I find the system highly lacking and horrificly designed from a database standpoint. Dynamics is at least one major version behind from SQL server and does not take a lot of skill to maintain once implemented. It is designed to let office admins administer the system and try to keep the dba out.
Biztalk and sharepoint use SQL Server as a backend and have specialized uses. Biztalk is low maint once setup. The databases still need maintained. Sharepoint can be the most intensive and require the most skills out of what you have listed amongst the other packages.
SSIS is a portal to BI. You should learn BI - there is a massive need in this arena.
I would also agree with Grant in that you need to establish some Powershell abilities.
I have given a name to my pain...MCM SQL Server, MVP
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events