I am planning to switch over my profile from Dot net Support to sql DBA. I just want to know how's the opportunities for sql server DBA. Can any please compare with oracle vs SQL DBA and also the future growth of sql. Your suggestions are much appreciated.
Both DBAs (SQL Server or Oracle or even MySQL) are very valuable profession, it depends from the company profile and the projects that it manages! Both (SQL - Oracle) technologies are working hard and will publish more new features to make the job easy for the DBAs.
Sorry for the "tough love" but my belief is that if you can't find the answers to such questions on your own, you're not ready for the job. The same goes for switching your profile from Dot Net Support to SQL DBA... are you actually qualified to do the job of an SQL DBA? Do you actually know what SQL DBAs have to do? Do you know that there's more than 1 type of DBA? As for the availability of DBA jobs, they are a lot more scarce than those for Dot Net Developers because too many people still think that SQL Server is "just a place to store data".