SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to become a DBA for a career?
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 5

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/10/2007 :  08:24:09  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
Hi all,

I am working as a Reporting Analyst for huge company for the last 2 years before which i was working a Customer Care Expert in the same company. As Reporting Analyst I maintain a server for the segment I work for.I was thinking on getting Certified on MCDBA is that a right move to go on to be a DBA. I have no other programming language other than working experince on T-SQL, DTS , Jobs and things nomarlly required to generate reports for the Contact Center I work for. Please help me on how to go about.

Thank you


Necessity is the mother of all inventions!

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 01/10/2007 :  08:32:28  Show Profile  Visit spirit1's Homepage  Reply with Quote
MCDBA is a good start.
then you can show management that you're certified. usualy that means something to the management although
that doesn't make you a better DBA.

then you have to somehow become a dba in your company. how to do that depends on your working enviroment
and open positions. Do they need another DBA?



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30250 Posts

Posted - 01/10/2007 :  08:44:44  Show Profile  Visit SwePeso's Homepage  Reply with Quote
MCDBA acronym is obselete.

The new flashy titles are

MCITP: Database Administrator
MCITP: Database Developer
MCITP: Business Intelligence Developer
quote:
SQL Server Technical Certifications

Embraced by industry professionals worldwide, Microsoft certification has proven itself as one of the most effective ways for individuals to reach long-term career goals and organizations to gain a competitive advantage through increased customer satisfaction, reduced network downtime, and the ability to provide a higher level of service.

The Microsoft Certified IT Professional (MCITP) credentials and new Microsoft Certified Technology Specialist (MCTS) provide IT professionals with a simpler and more targeted framework to showcase their technical skills in addition to the skills that are required for specific developer job roles.

The MCITP credential lets you highlight your specific area of job role expertise. Now, you can distinguish yourself as an expert in database administration, database development, or business intelligence.

Microsoft Certified IT Professional: Database Administrator

Microsoft Certified IT Professional: Database Developer

Microsoft Certified IT Professional: Business Intelligence Developer

The new MCTS credential for SQL Server 2005 highlights your skills and knowledge of Microsoft technologies. With the credential, you can demonstrate your expertise administering, deploying, and maintaining Microsoft SQL Server 2005.

Microsoft Certified Technology Specialist: SQL Server 2005

The Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Desktop Support Technician (MCDST), Microsoft Certified System Administrator (MCSA), and Microsoft Certified Systems Engineer (MCSE) credentials continue to provide IT professionals using Microsoft SQL Server 2000, Microsoft Windows XP, and Microsoft Windows Server 2003 with industry recognition and validation of their IT skills and experience.
Read more here http://www.microsoft.com/sql/techinfo/certifications.mspx


Peter Larsson
Helsingborg, Sweden

Edited by - SwePeso on 01/10/2007 08:46:53
Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/10/2007 :  08:45:54  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
Thank you spirit, I was also thinking on the same lines as to that it only shows I may have a few skills in SQL but doesnt prove anything.

And unfornutately for me I will have to change the company since there are no DBA positions in India at aleast from where I work for them . They have all of the DBA's in US. The only lucky part is I have a very high end server for which I am the Admin and the only person who uses it. So this gives me a opportunity to test things I learn.

Since I will have to shift companies . Any suggestions as to how to go about. Since they may only take me in as a Senior Analyst than a DBA or close to it.



Necessity is the mother of all inventions!
Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/10/2007 :  08:54:19  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
That is interesting Peso , I never thought about any other Certifications offered my MS part from MCDBA. So this is interesting. I am sure I can never be a Developer since I am no good with any other langauge of programming than T-Sql. So MCITP: Database Administrator might be something I need to look at. As I check the MS web on the same, I find 2 exams has to be cleared..70-443 ,70-444 to be get "MCITP DBA" . This means I will be spending less on the exams which is good.

Thank you Peso for the info , you saved half my money ;-)

Necessity is the mother of all inventions!
Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/10/2007 :  09:01:35  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
I will still have to take 3 exams , that is I need to fulfil the prereqirements by passing the 70-431 as a "MCTS: SQL Server 2005" and only then I can appear for MCITP DBA.
Thank you for the Great info Peso.

But I am still wondering , If getting certified will get me a job close to be becoming a DBA down the line....

Necessity is the mother of all inventions!
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 01/10/2007 :  09:18:05  Show Profile  Visit spirit1's Homepage  Reply with Quote
it could. companies' HR like the nice sounding MS abbreviations.



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/10/2007 :  09:37:55  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
That is true spirirt HR's like names and than skill, I other roles are there before you actually become a DBA. Like Reporting Analyst becomes a Senior Reporting Analyst , Programming Analyst Or Business analyst based on the skills one has. Is there some path like this to be a DBA.


Necessity is the mother of all inventions!
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 01/10/2007 :  09:56:17  Show Profile  Visit spirit1's Homepage  Reply with Quote
no there isn't a specific path. it depends on each company's structure and needs.



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/10/2007 :  10:12:14  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
hmmm.... spirit any roles u know of in our organisation... just to get a idea as to where I need to be heading. So I part is clear... The names like MCITP DBA or MCTS SQL Server 2005 on my resume will impress HR ;-) . The next part is what roles I agree for when offered. Since "ALL Roads don't Lead to a Becoming a DBA"

Necessity is the mother of all inventions!
Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/10/2007 :  11:43:02  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
Hey I think I found the answer to my question . I need to find roles like Database Analyst , Tester , Developer or Programmer before I can be a DBA.

Please let me know if I am wrong.

Necessity is the mother of all inventions!
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 01/10/2007 :  12:00:13  Show Profile  Reply with Quote
Why do you want to be a dba....

And what type of dba?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/10/2007 :  13:58:38  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
That is really Good question !
The only thing I am good(aware of) technically is with MSSQL.That I do like playing with huge data , which I am already doing ( about 0.4 million rows of data daily uploading) it fasinates me to make the processing , uploading and retriviewing data faster than what it is now. And it is a no non sense role then a app developer where u have people asking u to do things which seem stupid at times, eventhou you know wat u have done is better than wat is asked for from u. The other thing is also DBA's the best paid people in the IT industry who do technical work ( not Managers or CEOs) ;-)

And the 2nd question....
I am not aware of the types of DBA's , I will be interested to know if u can enlighten me Brett (X002548). I will happy knowing anything and everything of becoming DBA. And ur info might also trigger me in liking something more specific , than on a wild ride to be a DBA.

Thank you


Necessity is the mother of all inventions!
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36997 Posts

Posted - 01/10/2007 :  14:09:33  Show Profile  Visit tkizer's Homepage  Reply with Quote
Most DBAs became DBAs first by being programmers. Since you don't have that, you probabably would need to take a very entry level position, such as a junior DBA or even lower, perhaps intern DBA. I started as a student worker and was lucky enough to be placed in the DBA group. I've never been anything else, but mine is a very unique path. We do hire interns here and then eventually they could become junior DBAs, so you should probably find a company like this. Interns though typically mean you are currently going to college, majoring in computer science or the likes, and are interested in databases.

It will take years to get to a high paying position as a DBA. You just need to have patience.

Hopefully you realize that the reason why DBAs get paid the way they do is because they are on-call 7x24 plus the high level of knowledge and experience that is required to do the job.

Tara Kizer

Edited by - tkizer on 01/10/2007 14:10:36
Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/10/2007 :  14:24:15  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
Thank you Tara for the info. I dont think I will be luckly as you .. So I am starting my hunt on Database programmer jobs. I am out of College with my Masters in Computer applications about 2 years now, so Interns is out, and for being on-call 7x24 i am already in a role at my current position since I am the only one working on SQL in the Segment I work for, and reporting all the things reqired for the business I can say everything on any ppt or deck is from my mail box.
Patience - this is a long term goal ( 3 years from now ) atleast as a Associate DBA .To mature to be a good DBA in 10 to 12 years from now.
High level of knowledge is only coming when I spent more time on SQL ;-)

And Tara , Brett mentioned about types of DBA , what did he mean by that. And wat are they.




Necessity is the mother of all inventions!
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36997 Posts

Posted - 01/10/2007 :  14:32:09  Show Profile  Visit tkizer's Homepage  Reply with Quote
I just took the Microsoft Skills Assessment for a DBA and I received a 60% (got 18 out of 30 questions correct)! lol

This just goes to show you how accurate those certifications are.

But I must admit...I'm a terrible test taker, which is why I'll probably never even attempt getting certified. At my level, it just isn't needed. Certifications are typically needed when you don't have very much experience.

And being on-call is different than what you described. Being on-call 7x24 means being paged in the middle of the night and fixing whatever problem occurred. It means having to either carry your laptop with you when you are more than say 30 minutes away or not being able to go too far from a place where you can get remote access. A lot of programmers would not make the leap to being a DBA due to the on-call part. But if you're a pretty decent DBA and have taken pro-active actions to ensure the stability of your environment, then you should rarely get paged at night.

Tara Kizer

Edited by - tkizer on 01/10/2007 14:36:22
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36997 Posts

Posted - 01/10/2007 :  14:33:24  Show Profile  Visit tkizer's Homepage  Reply with Quote
The two types of DBAs that I know of are production DBA and developer DBA. Our DBAs here are both. We don't have separate staff for each. Production DBA and developer DBA should be self-explanatory.

Tara Kizer
Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/10/2007 :  14:59:18  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
Thank you Tara for the info on DBA types and as well on ur scores on MS DBA Assessment :-)...I will still try to score better than that since I will still need to impress the HR's ;-) eventhou a Guru will know skill level with a answers I give on the interview. So I am all Ready to start my journey of being DBA.

I will sure will be back with more and more questions. To fill all the blanks I have in my head.

Necessity is the mother of all inventions!
Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/11/2007 :  07:17:34  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
Is it necessary to know other databases along with MSSQL 2005 and 2000. Like Oracle , Sybase ,DB2 ..etc.

And is it also necessary to learn any other programming langauge like C# , VB along with SQL 2005.

Necessity is the mother of all inventions!
Go to Top of Page

mr_mist
Grunnio

United Kingdom
1870 Posts

Posted - 01/11/2007 :  07:32:47  Show Profile  Visit mr_mist's Homepage  Reply with Quote
You don't generally need to know more than one RDM system because people tend to specialise in one area or the other. Of course, if you really do know SQL Server and Oracle (for example) well, then you could find yourself well-placed in a company that needs such knowledge.

Some programming knowledge may be handy. But, I think, more useful would be the mindset that allows you to think like a DBA, and I'm afraid I can't really explain that. You either have it, or you don't.

-------
Moo. :)
Go to Top of Page

Vijaykumar_Patil
Posting Yak Master

India
121 Posts

Posted - 01/11/2007 :  08:46:45  Show Profile  Visit Vijaykumar_Patil's Homepage  Click to see Vijaykumar_Patil's MSN Messenger address  Reply with Quote
Thank for the clarification Mr Mist, I will for now only stick with MSSQL. Once I am familiar with the aspects of it , maybe will give a thought to the other Databases. I will also think in terms of learning C# ,atleast the know hows.

And now you started opening me to a new Idea "Thinking like a DBA" I hope I have it, fingers crossed . Since I am not sure what it means as of now. I wish , if I could get a explaination to it. I still will try to explain it someday. If not today.

I will be thankful to anyone , who can explain that to me.


Necessity is the mother of all inventions!
Go to Top of Page
Page: of 5 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.48 seconds. Powered By: Snitz Forums 2000