<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
How to become sql server dba
18 posts, Page 1 of 2
1
2
»»
How to become sql server dba
Rate Topic
Display Mode
Topic Options
Author
Message
gupta1282
gupta1282
Posted Sunday, February 08, 2009 6:16 AM
Valued Member
Group: General Forum Members
Last Login: Monday, March 07, 2011 6:52 AM
Points: 73,
Visits: 254
Hi
I am Ghanshyam Gupta , currently working on CRM customization and having more than 3 years experience in IT filed, but now I want to start my carrier as a sql server dba.
Please provide me some guidence how to start my carrier as a dba, how to get job in this field , how to prepare
Should i take any certification in this field or how to get job as a sql server dba without leaving current job or should i leave current job.
I am very upset for my carrier path.
Please help me.
Thanks & Regards
Ghanshyam Gupta
Post #652391
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Posted Sunday, February 08, 2009 7:00 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 12:22 PM
Points: 3,017,
Visits: 4,471
1- Take Microsoft training
2- Get certified
3- Get a job as Transact-SQL developer
4- Get an entry level job as SQL Server DBA
_____________________________________
Pablo (Paul) Berzukov
Author of
Understanding Database Administration
available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #652399
terryj30
terryj30
Posted Monday, February 09, 2009 1:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, September 20, 2012 9:27 PM
Points: 1,118,
Visits: 258
The best step will be to ask your DBA if you can do some work with him, get some t-sql books.
Install SQL at home, practise on it, look at sites like this then go and apply for work as a jnr DBA or dba assistant and work and learn for the snr dba.
Take some courses if you can however, most of these will just teach you the theory practical is what you need. To be a good DBA you will need to learn to say no, Also you well have to be calm if your going to become a production dba as you will get alot of bad issues. The good news to be a production dba you wont need to know every thing about programming t-sql or any other langauge but it does help. Production DBAs are in charge of the production env, and will monitor backups, databases running commands like dbcc checkalloc and checkdb and so on. maintaince of databases. how to monitor performance and tuning where nessecery. now if you want to be an application dba you will need to be able to programme and write nice code and work with the prod dba on issues and be-able to change code where neccesry.
Good luck if you need a mentor I am always here. :) if I cant help on everything then the forum is here. :)
Terry
Post #652589
gupta1282
gupta1282
Posted Tuesday, February 10, 2009 9:06 AM
Valued Member
Group: General Forum Members
Last Login: Monday, March 07, 2011 6:52 AM
Points: 73,
Visits: 254
Sir I searched a lot of jobs for junior level or entry level sql server dba, but did not find any such job.
Could you provide me some onlie trainig sites or books from where i can learn.
Thanks
Ghanshyam Gupta
Post #653858
Jonathan Kehayias
Jonathan Kehayias
Posted Tuesday, February 10, 2009 9:13 AM
SSCommitted
Group: General Forum Members
Last Login: Monday, June 03, 2013 7:03 PM
Points: 1,696,
Visits: 1,746
If you want to be a DBA and you want really good, worth their weight in gold books that apply to being a DBA. Goto Amazon.com and search for Kalen Delaney. Any of her Inside SQL Server 2005 books is well worth the cost to purchase them. I own all of them, and they are a constant source of information. Another book that is really good is Ken Henderson's SQL Server 2005 Practical Troubleshooting.
I became a DBA by working through the development ranks for a few years. If you position yourself where you can learn performance tuning and the likes, you get to play with the internals side of things, which leads towards DBA type tasks.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog
|
Twitter
|
MVP Profile
Training
|
Consulting
|
Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs
Post #653873
Mike - CI
Mike - CI
Posted Tuesday, February 10, 2009 9:23 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, June 14, 2013 12:27 PM
Points: 197,
Visits: 1,034
Jonathan Kehayias (2/10/2009)
If you want to be a DBA and you want really good, worth their weight in gold books that apply to being a DBA. Goto Amazon.com and search for Kalen Delaney. Any of her Inside SQL Server 2005 books is well worth the cost to purchase them. I own all of them, and they are a constant source of information. Another book that is really good is Ken Henderson's SQL Server 2005 Practical Troubleshooting.
I became a DBA by working through the development ranks for a few years. If you position yourself where you can learn performance tuning and the likes, you get to play with the internals side of things, which leads towards DBA type tasks.
I second all of the above.
Post #653883
The_SQL_DBA
The_SQL_DBA
Posted Tuesday, February 10, 2009 9:24 AM
Right there with Babe
Group: General Forum Members
Last Login: Friday, June 14, 2013 12:06 PM
Points: 794,
Visits: 902
gupta1282 (2/10/2009)
Sir I searched a lot of jobs for junior level or entry level sql server dba, but did not find any such job.
Could you provide me some onlie trainig sites or books from where i can learn.
Thanks
Ghanshyam Gupta
The problem with finding a entry level DBA job is Companies don't want to risk the data loss with someone novice in the field. I have some colleagues who work as Developers and do some DBA stuff do but guess what the comapny has puny data and that some basic issues are resolved by them with the help of google.
As someone suggested above become a Developer first or get help from any friend who happens to be a DBA..
Start with SQL Express at home. DBA is not just a 9-5 job, especially when a PRODUCTION DBA..
Even though I am busy with my 22 Production Servers I LOVE MY JOB as a DBA...
terryj that was a good one '
LEARN TO SAY NO As a DBA
'
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Post #653885
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, February 10, 2009 9:36 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
I like Jonathan's advice. The other things I'd recommend are:
- Don't get certified now. Do that when you have a little experience working with the product, even in side projects.
- Read a lot, and work through examples. Get this daily newsletter, read the articles, work through the QOD, etc. Ask questions in the forums about specifics you don't understand.
- Work on the product. Mimic your DBA, do what he does, or ask if you can do some simple tasks (security, create tables, etc.) under his/her supervision.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #653903
GilaMonster
GilaMonster
Posted Tuesday, February 10, 2009 9:49 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:19 PM
Points: 38,095,
Visits: 30,388
gupta1282 (2/8/2009)
now I want to start my carrier as a sql server dba.
Why do you want to be a DBA? What is it about that career that attracts you?
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #653927
Jonathan Kehayias
Jonathan Kehayias
Posted Tuesday, February 10, 2009 9:55 AM
SSCommitted
Group: General Forum Members
Last Login: Monday, June 03, 2013 7:03 PM
Points: 1,696,
Visits: 1,746
GilaMonster (2/10/2009)
gupta1282 (2/8/2009)
now I want to start my carrier as a sql server dba.
Why do you want to be a DBA? What is it about that career that attracts you?
I ask myself that same question sometimes. Usually at 2:30am when I am driving to the office to begin a maintenance task like installing SP3 on SQL 2005 because the only window for downtime is 3-5am for some server, and then 5am-7am for others. At that point the regular work day starts and I really begin to question why I do this.
Aside from those moments, I love my job.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog
|
Twitter
|
MVP Profile
Training
|
Consulting
|
Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs
Post #653935
« Prev Topic
|
Next Topic »
18 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
