Hi All

I am a Software developer with around 15 months of experience in .Net 2.0 and VSTO.
I am currently working in a SQLServer 2000 project.
I feel more interest to work with database than front end coding.
Can anyone suggest what need to be done for the one to be a DBA.
Could you please provide more details on the roles and responsibilities and the scope for career development on becoming a DBA.
In what Timeline can i be a DBA. After becoming a DBA what are the career options available. Please help me out in deciding my career

Thanks in Advance,

Sidharth

Here is what I suggest:

1. Study SQL, database design and administration from books, live courses/seminars, training CD-s

2. Buy SQL Server 2005 Developer Edition for practicing along

3. Pass MCITP: Database Administrator certification: 70-431, 70-443, 70-444 ( see microsoft.com for more info)

4. Apply for a job

Most places DBA is not a full-time occupation, so you need side skills, like T-SQL stored procedure development, database design, Reporting Services development, SSIS package development, etc.

• Marked as answer by Naomi NModerator Friday, November 25, 2011 5:25 PM

On these days DBA is an abstract level word. DBA can be further classified to Development DBA , Production DBA , Data warehouse dba, ETL DBA , DB Architect DBA and even may be REPORTING DBA. Each job has its own significance. Role for each dba may differ. Some time DBA perform multiple role in an organization (in my case i am doing Architecting / part time Production DBA and Dev DBA role).

In addition to Kalman suggestion, what you can do is , you can start from Virtual labs provided by Microsoft. If you ask the timeline, its all depends. Hands on experience is the key.

Virtual Labs for SQL Server 2005

http://technet.microsoft.com/en-us/bb499681.aspx