March 18, 2014 at 12:26 pm
Hi folks.
Can someone shed some steps for becoming a Sequel Server DBA?
My background is in Mainframe programming and development. For the most of my career I was a consultant/contractor and did not have chances to switch as it was not exactly in line of my work. I do know database structure of DB2 and SQL, but now I would like to become a DBA.
Where do I start
Thanks to all
March 18, 2014 at 12:37 pm
Start with this book:
http://www.amazon.com/DBA-Survivor-Become-Rock-Star/dp/1430227877
It has good, practical advice on how to break into a DBA role and what you need to know once you get in one.
Also, it's SQL Server, not Sequel Server. The only reason I mention it is if you use the latter, a lot of folks aren't going to be sure of what you're referring to and those who do might think less of you for not using the right name. So far as I am aware, as long as it's been publicly available, it's always been SQL Server.
HTH.
K. Brian Kelley
@kbriankelley
March 18, 2014 at 1:52 pm
That's a good one recommended by Brain.
Also try to get some SQL Server DBA training. And here is a list of good books for SQL DBA.
http://www.brentozar.com/best-sql-server-dba-books/
Free books are available here .. http://www.sqlservercentral.com/Books/
There are lot of good resources online too. If possible, participate in local SQL Server user groups, SQL Saturdays, SQLPass etc ..
--
SQLBuddy
March 18, 2014 at 5:30 pm
Thank you for the replies.
But what are the chances to be hired merely from studying the books and some theory knowledge? What I'm trying to say is just by putting on a resume "training in SQL Server" and maybe describing what I know about the subject, would be enough to even get the attention without hands-on real thing?
March 18, 2014 at 6:48 pm
felix150h (3/18/2014)
Thank you for the replies.But what are the chances to be hired merely from studying the books and some theory knowledge? What I'm trying to say is just by putting on a resume "training in SQL Server" and maybe describing what I know about the subject, would be enough to even get the attention without hands-on real thing?
First you should understand the subject and the role of a DBA. You can take some training classes in person or online. Reading books also will gives you a good systematic understanding.
To begin with, you can download the evaluation SQL Server software, install it and practice well. To get real time experience \ hands-on, you can do some volunteer work for your local companies or apply for Jr DBA positions though job posting sites like Indeed.com, dice.com etc .. You can even meet people at your local SQL User Groups, SQL saturdays etc .. to see if you can get some hands-on experience\job.
But without learning the stuff, there won't much use in applying for jobs.
--
SQLDBA
March 19, 2014 at 4:21 am
Breaking in is very difficult. There are very few junior DBA positions out there that will take you from knowing little and grow you into knowing a lot. The best thing you can do is do a lot of database work. Talk to your local churches, charitable organizations, places like that and see if they have databases that need maintenance and backup or if they have need of a database. Experience and knowledge are what you need to break in. You can get the knowledge from books, but the experience you're only going to get through hands on work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 19, 2014 at 6:36 am
That's one of the reasons I like Tom LaRock's book and recommended it. Usually folks transition into a DBA position in an existing company or after a body of work as a DB developer. Tom talks about that.
K. Brian Kelley
@kbriankelley
March 19, 2014 at 7:51 am
sqlbuddy123 (3/18/2014)
That's a good one recommended by Brain.Also try to get some SQL Server DBA training. And here is a list of good books for SQL DBA.
http://www.brentozar.com/best-sql-server-dba-books/
Free books are available here .. http://www.sqlservercentral.com/Books/
There are lot of good resources online too. If possible, participate in local SQL Server user groups, SQL Saturdays, SQLPass etc ..
--
SQLBuddy
Kendra recently posted a new video on Brent's website on this subject.
http://www.brentozar.com/archive/2014/03/get-first-job-dba-video/[/url]
March 19, 2014 at 9:13 am
MysteryJimbo (3/19/2014)
sqlbuddy123 (3/18/2014)
That's a good one recommended by Brain.Also try to get some SQL Server DBA training. And here is a list of good books for SQL DBA.
http://www.brentozar.com/best-sql-server-dba-books/
Free books are available here .. http://www.sqlservercentral.com/Books/
There are lot of good resources online too. If possible, participate in local SQL Server user groups, SQL Saturdays, SQLPass etc ..
--
SQLBuddy
Kendra recently posted a new video on Brent's website on this subject.
http://www.brentozar.com/archive/2014/03/get-first-job-dba-video/[/url]
Great info and a vid!
This is all very familiar. Although I was on application/development side, this is exactly what we do in a DB2 environment as well.
March 19, 2014 at 3:41 pm
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply