| Author |
Topic |
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
 Posted - 2007-01-10 : 08:24:09
|
| 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 youNecessity is the mother of all inventions! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-01-10 : 08:32:28
|
MCDBA is a good start.then you can show management that you're certified. usualy that means something to the management althoughthat 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 enviromentand open positions. Do they need another DBA?Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-10 : 08:44:44
|
MCDBA acronym is obselete.The new flashy titles areMCITP: Database AdministratorMCITP: Database DeveloperMCITP: Business Intelligence Developerquote:
SQL Server Technical CertificationsEmbraced 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 AdministratorMicrosoft Certified IT Professional: Database DeveloperMicrosoft Certified IT Professional: Business Intelligence DeveloperThe 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 2005The 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.mspxPeter LarssonHelsingborg, Sweden |
|
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-10 : 08:45:54
|
| 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! |
|
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-10 : 08:54:19
|
| 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! |
|
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-10 : 09:01:35
|
| 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! |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-01-10 : 09:18:05
|
| 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 |
|
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-10 : 09:37:55
|
| 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! |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-01-10 : 09:56:17
|
| 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 |
|
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-10 : 10:12:14
|
| 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! |
|
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-10 : 11:43:02
|
| 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! |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-10 : 13:58:38
|
| 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 youNecessity is the mother of all inventions! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-10 : 14:09:33
|
| 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 |
|
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-10 : 14:24:15
|
| 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! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-10 : 14:32:09
|
| 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 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-10 : 14:33:24
|
| 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 |
|
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-10 : 14:59:18
|
| 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! |
|
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-11 : 07:17:34
|
| 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! |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2007-01-11 : 07:32:47
|
| 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. :) |
|
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-11 : 08:46:45
|
| 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! |
|
|
|
Previous Page&nsp;
Next Page
|
How to become a DBA for a career?