The last position I held we were a SQL server shop with Cognos as our BI tool. I will definately tell you Cognos is a lucrative background to have. Cognos developers/admins are in such high demand that you can have minimal education and still make over 100k if you know Cognos. One of the girls on my team did not even have a bachelors degree but because she had like 10 years of cognos experience she was making 128k.

I also agree that having a wide birth of skills is a good thing even if you are a SQL server DBA. Personally, I hate Oracle but I find that having both SQL and Oracle makes me way more marketable. Many jobs I've had I had to be flexible in whether I developed in SQL or oracle. I also usually have to deal with getting data out of oracle and into my SQL server.

I'd definately say keep your options open and maybe put yourself out there but it could be a great opportunity to get some additional work experience with these other tools.