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 12345»»»

How Do You Handle the Stress of Being a DBA? Expand / Collapse
Author
Message
Posted Wednesday, January 20, 2010 8:16 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:06 AM
Points: 176, Visits: 728
Comments posted to this topic are about the item How Do You Handle the Stress of Being a DBA?

Brad M. McGehee
DBA
Post #850971
Posted Wednesday, January 20, 2010 9:23 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 19, 2012 10:25 PM
Points: 1,229, Visits: 3,483
Hi,
A news from new co-worker in the lunch, they have the server in one location and another sister office access the application by the 2mbps RF connection just 40 kms away from headquarters. Most of the time from other location end users says the application found slow in process. Finally they conduct the analysis, in there the application vendors raised the trick questions to them that “is the same bad procedures run quickly in the server location?” .then the ball move to the infra team, they shows the big chart, says the density and other unknown terminology that’s 2 mbps is enough. The ball waiting for the top officials play, most of them in the HQ have the hollow effect on the sister office.
At last what happen you known! He asked,
I say, I don’t know,
"so I am here" he says,
I say to him “Be prepare to mobile!”
Post #850985
Posted Wednesday, January 20, 2010 9:25 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
Hi Brad, interesting topic, but also very relevant!

As the only DBA in our environment, I have the privilige of running the show myself, and everyone else relying on my advice and assistance.....but....things arent always that easy..

I found by coming in a hour earlier than anyone, "prepping" the environment for their use, checking the jobs, making sure our dev environment is updated etc ensures that I am free to monitor all activities through the day.
I constantly check all processes running against the DB's so ensure optimal performance for the end users, but also to make sure the developers arent pushing code that could cause problems, block, delete etc...

On a daily basis I try to send them at least one tip/trick from a best practise point of view...
Myself and the current developers enherited a shaky system, with "weird" procedures, so applying best practise from day one was the only way to go forward..what has been done, cannot be undone (without hours of work, testing - you know the drill).

Stopping anyone who is not playing nice with my DB's is also fun, and I got the clearance from Management to do so ( )

I think it is each DBA's responsibility to look after his DB's as if they were his/her children, and wouldnt let anything bad happen to them, to make sure they are warm (online), not being teased (hammered with "select *'s "), and not being abused....

I feel - the less manual maintenance I have to do through the day, the more time I have to play cop when it matters.
Oh, and lastly, on the subject of Dev's not respecting you.... whenever you try to point out a fault from their side, always, but always back it up with proof, or tests to indicate, that they are wrong indeed, and that will get you some respect...


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #850986
Posted Wednesday, January 20, 2010 10:12 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 2, 2012 2:29 PM
Points: 633, Visits: 256
How to handle the stress? Not sure... but my way of dealing with it is: "keep things in perspective". I am not saying I take my job lightly. In fact, I take it very seriously and I hate to get a SQL notifications telling me one of my jobs has failed but...
Keep in mind what is important in life is absolutely vital to staying sane: pictures of the kids on my desk, running between 50 to 80 miles a week, talking to my parents and surrounding myself with true friends has helped me tremendously to deal with stressful work.
As far as solving issues in a calm and composed manner, listening carefully to issues when they come up, getting advice from very experienced SQL developers and DBA from SQL Server Central, reading very free PDF from Red Gate and Phil Factors' blog, and mentor less experiences developers are keys to keeping a serene piece of mind.
That's my take on it. Eager to read more answers.


"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
Post #851000
Posted Wednesday, January 20, 2010 10:38 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 4:00 PM
Points: 236, Visits: 417
I train tae kwon do 3 times a week. I've found that kicking other people and being kicked by them in a controlled environment relieves all the stress

Oh, and I cook too; but only when I'm in the mood for it
Post #851012
Posted Wednesday, January 20, 2010 10:50 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 18,060, Visits: 16,090
Some good things I like to do include User Group participation like the local PASS chapter, SSC participation, exercise and flat out getting away from work.

There is also the big picture piece of it, knowing that when a project is finished and it runs smoothly - you get the sense of accomplishment for having a piece of the projects success.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #851016
Posted Wednesday, January 20, 2010 10:56 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 19, 2012 10:25 PM
Points: 1,229, Visits: 3,483
Aaron Gonzalez-394690 (1/20/2010)
I train tae kwon do 3 times a week. I've found that kicking other people and being kicked by them in a controlled environment relieves all the stress


Good potential stress controlled by Technical Knock Out, who is the referee in your game?
Post #851020
Posted Thursday, January 21, 2010 1:02 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 3:39 AM
Points: 108, Visits: 171
Compartmentalise: I try to give all I've got but not all the time - when I'm away from the office I grow veg and do the family stuff, separate the home and office and give all you can to each in due course.
Harvey
Post #851064
Posted Thursday, January 21, 2010 1:49 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:11 AM
Points: 171, Visits: 444
I ride a motorbike to and from work which relaxes me nicely on the way home to my family.

Whilst at work though, it became regular practice for me to be given a project and asked for a completion date, only for it to be completely ignored and a much shorter deadline given. I'd then take the stress and try anything to get it done, fail quite a lot of the time and get a bad review as a result.

Now I document what is involved and their individual timescales (x2 to allow for problems) and if they want to shorten the deadline I tell them that some work needs to be removed, because those individual deadlines are not adjustable.

Don't get me wrong - I wouldn't take the micky with the timescales I set, I generally end up finishing a little bit before the deadline. At the same time, I'm no longer taking on the stress because someone's promised someone else that a piece of work will be done in a week.

Post #851079
Posted Thursday, January 21, 2010 2:32 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, December 12, 2014 7:23 AM
Points: 2,128, Visits: 1,487
Harvey Camm (1/21/2010)
Compartmentalise: I try to give all I've got but not all the time - when I'm away from the office I grow veg and do the family stuff, separate the home and office and give all you can to each in due course.
Harvey


I couldn't agree more! I also try to end each working day with a completed task, however small, rather than leaving something mid-flow. To quote Blur 'it gives me an enormous sense of wellbeing'
In my experience a major factor of stress for a DBA is not being taken seriously, not so much as an individual, but in terms of the job we do; sad to say, but the majority of companies I've worked for tend to see DBAs as more of a necessary evil rather than essential members of an IT team.......maybe that's just a reflection on my poor choices of employer though!

Lempster
Post #851093
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse