Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Successful DBA Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2007 7:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 8, 2008 4:02 AM
Points: 163, Visits: 129
Hi,

Could anyone please help me out...
How can one prove themself to be a successful DBA as a fresher.How is it possible to work as a DBA without any prior experience after having got training.How can one convince the organization that they will be a successful DBA.

Thanks in advance..:)
Post #414413
Posted Wednesday, October 24, 2007 7:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:34 AM
Points: 1,116, Visits: 6,455
Tough question :)

Taking classes in SQL Server really only teaches you the fundamentals of administration and design. And yes, you could jump straight from these classes into a job.

That said, if you are joining a company as the only DBA, you'll have a steep learning curve ahead of you. If the previous DBA left the environment in a healthy state, then it buys you some time to get to grips and learn (a lot) more about SQL Server. On the other hand, if the previous DBA left the environment with performance problems, bad database designs etc then you really are trying to run before you can walk and I would not advise this for a new DBA.

If I was in your position, however, I would be more interested in looking for junior roles. This site is a fantastic medium for learning and you also cannot beat having experienced DBA's sitting across the room from you.

Good luck
Post #414427
Posted Wednesday, October 24, 2007 7:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:34 AM
Points: 1,116, Visits: 6,455
Oh, and as a fresher - I assume you mean just out of college or university?

If I was looking to hire someone just out of university, I'd want to get a feel for your knowledge around administration, database design and t-sql, but, I'd also be looking at your potential and how I feel you can develop as DBA.

So, for an interview, if a DBA is what you want to be and that is the career path you have chosen, let the employer know about it...
Post #414438
Posted Wednesday, October 24, 2007 7:50 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: Banned Members
Last Login: Sunday, September 7, 2014 11:11 PM
Points: 2,622, Visits: 328
Accdng to me, initially 1 has to work around with the databases as a developer and to the most extent use the same as a back end for developing application.
During that stage itself, he has to read/get information about more administration stuff with the databases. Then only chances of becoming a professional DBA will be valid. Now-a-days, DBA has to play vital role by also doing development activity with related to databases especially since the introduction of SSIS,SSAS & SSRS...
Post #414441
Posted Wednesday, October 24, 2007 8:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 8, 2008 4:02 AM
Points: 163, Visits: 129
Yes I am fresher just out of college.
I had undergone training for some months but have never worked on live projects.
But they have put me in a project and asked me to convince them as a DBA.How can I convince them?
I have never worked til now on live servers.

Thanks
Post #414450
Posted Wednesday, October 24, 2007 8:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: Banned Members
Last Login: Sunday, September 7, 2014 11:11 PM
Points: 2,622, Visits: 328
Better talk to yur PM and understand how best your services are required to play a role for DBA. Being a fresher, I'm not sure the volume of the data thats getting transmitted here and there and how gonna you handle stuff like that... Have a discussion with him and find out how is next person really having expertise on the database side. Take inputs from them and slowly start off with your tasks..
Post #414457
Posted Wednesday, October 24, 2007 11:58 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 10:50 AM
Points: 22, Visits: 292
Well not to sound rude, but I wonder how you got the job in the first place. Most companies ask a lot of questions, but then again some dont. All I can say is learn, learn, and read, and read. Otherwise you will have big problems. I know 2 people who went right from school into a job both never working on servers before, and both got their MCSDBA but had never been in a prod environment, or designed anything.. Sadly both got fired very quickly, one because the previous DBA left the system in a bad state and they didnt have the background to keep up. And the second one because they made a stupid mistake. If you are the sole DBA then its a tough question, and there is no easy answer to prove to them. Just be careful because what you design for them now will stick with them for a long time and if its not right
Post #414566
Posted Wednesday, October 24, 2007 8:07 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Monday, September 15, 2014 8:57 AM
Points: 6,634, Visits: 1,872
Nisha N.Kumar (10/24/2007)
Yes I am fresher just out of college.
I had undergone training for some months but have never worked on live projects.
But they have put me in a project and asked me to convince them as a DBA.How can I convince them?
I have never worked til now on live servers.


Grab highly recommended books, read and study like mad. Since you're playing catch-up, you're going to have to spend a lot of your own time to come up to speed.

Anything that is operational related, security, backup/restore, make sure you understand exactly what you're doing before you do it. Double check your steps before starting. Make sure you have your sources identified (Books Online, MVP blogs, forums like here) and well-researched so if something goes wrong, it's not because you haven't tried to cover every detail.

With respect to development work, look at your query plans. Find out which ones don't perform well. Run the traces to determine how the app is performing. Bring forward recommendations of what to fix, as well as how to fix it. Quantify improvement where possible (test a fix on a dev server and show the difference in query plans, for instance).

In other words, seek to at least satisfy whenever anything is asked of you. Look to excel whenever possible. You're trying to prove to them that they aren't making a mistake letting you take the reins. Therefore, you have to show you do your research, you are meticulous in your planning, you have good analysis skills, and you are working hard to make the project succeed.

That's how you prove yourself if you're green.


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #414728
Posted Thursday, October 25, 2007 5:04 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,789, Visits: 1,014
I guess it really depends on what the company defines as a good DBA . In my Previous company i worked mainly as a developer but was then slowly pushed into the role as a part time DBA. I started of by trying to get the basic tasks right , Every DBA role has some amount of routine Tasks that are part and parcel of the job. get them right , the rest are one off issues that your better of learning by trail and error.

I am not a fully qualified DBA but the people in my company feel i am good at it



Jayanth Kurup
Post #414881
Posted Thursday, October 25, 2007 6:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 8, 2008 4:02 AM
Points: 163, Visits: 129
Thanks a lot everyone for your replies
Post #414913
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse