Career growth - Production Support SQL Server DBA

  • I have just started as a Production Support SQL Server DBA . Earlier as I Was working as a development dba.

    Personally I enjoyed work as a development dba but then ..as they say...Grass is always greener on the other side..I switched to Production support... but now I think....life is miserable for production support...as one needs to work in odd hours too !!

    I would now stick to the career path which is going to be more n demand and would yeild good benefits too, in terms of $$$$ !:D

    Please advise.

  • life is miserable for production support...as one needs to work in odd hours too !!

    Do you go to different clients site to fix when they have issues?

    Or do you "look after" the production server of one particular client?

    Other than odd hours, do you face any other issues?

  • I support all production servers of a particular client. There are about 40 servers. All of them are being used in different timings , i.e. round the clock.

    The other thing which I fear is that .. whether being in production support is good career option or not as compared to a development DBA's profile ?

    Which of the two is in demand these days..and what is predicted for the furture ?

  • Both of them are going to be in demand in the future, it really depends on the size of the organisation you work for. Quite often the same dba does both, as well as designing and developing the database.

    You really have to look at what you enjoy doing, if you say that doing production support is making your life miserable then maybe it is not for you.

    Though i don't think it will hurt your career to do get some production support experience.

    If you want to make a career out of being a development DBA then it would be good to learn about all aspects of software development and it wouldn't hurt to learn a specifc dev language like c# or vb.net

    SQL careers can vary greatly and you should look at working the field that you enjoy or no matter how many £££ you make you will still be miserable.

  • I think it all depends on the company you work for and how they define your responsibilities. I just went to work as a Prod. Support DBA and work in a team where I am only on call once a month for a week. If you are on call 24/7/365 with the company and no comp time or compensation for the extra hours then that would suck, but maybe it's time to look for a better company environment.

    You are the only one who can determine if you prefer development work or prod support work better. Both are viable career paths and there should be plenty of opportunity for both.

  • http://www.salary.com has data on pay and benefits for various careers/jobs on a per-location basis. Plug in your data, get a comparison. If it's just about the money, that's where I'd go for data.

    From what I've seen, production support often gets higher pay right now, but also has the highest stress and off-hours stuff. Dev often has a slightly lower payscale, but requires less weekends and evenings (except during crunch time, if your company works that way).

    I do both, and don't mind the odd hours they sometimes require. I like working for small/medium companies, where I can have some variety in my duties on any given day, instead of doing the same thing all the time. I make less money that way, but it's worth it to me.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • There are more and more companies offering production dba support as a service. Thus I think this class of employee will be less in demand with laid-off types bloating supply. Not a good career path IMHO.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • I myself have always been the "jack of all trades" DBA, production, development, data architect and even some programming. I have been of the belief that the production DBA is slowly being phased out. I've worked a lot places where the System Admins maintained backups and routine maintenance and just used me as a reference as I focused on other things. I have always considered by wealth of different experience to be an asset, but at times it leads me to tasks that I don't feel are that of a DBA, but in the end get to learn something new and of value seems to be a good tradeoff. Having said all that, you should definitely take advantage of this opportunity as long as you can stand it and then hopefully move up and on to something that excites you and is even maybe a little less stressful. I have found stress in every area at sometime in my career.

  • How many database servers do you support? How many DBAs your company has?

    I am not particularly a jack of all trades but do different things and do both production and development. One DBA for too many servers.

    ~Leon

  • Personally I wud prefer being a production DBA but you should be ready to ->

    1) work under pressure

    2) should be having a depth knowledge on Database structure and

    3) ready to pick the calls at anytime :hehe:

  • Interesting thread.

    I have done both and continue to do both in some sense.

    I think which one is for you depends on what you like to do.

    Production Support DBA can be ugly. Users can blast a table where a restore is required...unfortunately because you cannot restore just a table from a backup, well...you have to restore a database on a server which has enough space...and then bcp out the data.

    While this seems easy -- you'll just have people calling you left and right wondering when it will get done.

    Performance and Tuning can all of a sudden become a big issue on a given day. You have to grudgingly hack through bad code and determine why some sproc that ran "well" is taking a hit all of a sudden.

    ...on the bright side, doing this kind of prod support makes you into a better "developer DBA" -- you'll know for your app what tables to "backup" through BCP cause you'll understand how long a restore can take.

    You'll write better sprocs, and more importantly create better indexes after having gone through tuning somebody else's bad sproc.

    Personally - I prefer being a dev DBA because I like seeing the data -- and understanding how it can tell a story. Understand the data, and you can create a good db structure. Also - while you may encounter similar thing as a Prod DBA...for a dev dba...well...different types of data kind of make your job more interesting.

    my two rupees 🙂

  • Being a production support DBA is like any other 'niche' title/occupation within IT. There are always tradeoffs in salary, working hours and benefits both within a given company and between your company and others.

    I personally have been a DBA for 28+ years, all but 5 of them as a 'pure' production support DBA. My limited development DBA time was rewarding but was too political and schedule driven basically leading to tremendous swings in stress based on where things were in relation to the project life cycle. As a production support DBA things are actually more predictable. Sure there are cycles related to business activities, scheduled maintenance and upgrades. Needles to say the potentially ever present, all important issue of dealing with outages that can crop up at any time. But how is that different from issues that a development DBA faces ? Sure, both have 'expenses' associated with them for the company's bottom line. In production, outages cost revenue. In development bad queries, tuning and other issues cost developer/development time which is also money. Missed deadlines, over scheduling and long hours during 'project cram time' also ramp up the 'cost' paid by the company. Oh, did I mention that 'stress' is a given no matter what since you are the DBA.

    The real question to ask is 'Will this role be fulfilling for me ?'

    Above all, 'Know Thyself' !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • It depends on where you are a Production DBA. Production DBA is not the same thing from company to company. The depends part, comes down to how well you like it at the company where you are a Production DBA.

    Is it a worthwhile career choice - IMHO - yes.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • I know a production DBA who just moved to a new job because he had gotten his former company so stable and everything running so routinely that he became bored and unchallenged.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • ..

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply