If you are strong in TSQL then you can be a good SQL Developer. SQL Developer is responsible for developing reports, ETL tools, Data warehousing and query tuning. If you are familiar with SQL server 2005/2008 then you will get all integrated tools for report (SQL reporting Service), ETL( SQL Server integration service) , Data warehouse (SQL server Analysis service). 
Good luck!!!