Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Ratio


The Ratio

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36048 Visits: 18736
Comments posted to this topic are about the item The Ratio

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8260 Visits: 6129
I have seen the same sort of ratios. Sometimes the ratios vary with role responsibilities, other times due to system specifics (e.g. where more effort is required) and, as always, vagaries down to role perceptions.

There appears to bee no rule of thumb that is reasonable to apply. Sensible management gages their specific situation, I guess.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Yet Another DBA
Yet Another DBA
SSC Veteran
SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)

Group: General Forum Members
Points: 201 Visits: 1200
Worst 3 dbas supporting 4 developers. The manager just wanted the prestige and the job was more politics then doing any real good.

Typically, I support about 15+ developers, and they aren't always in the same country.
Nakul Vachhrajani
Nakul Vachhrajani
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1823 Visits: 2126
I am currently supporting 7 developers (one of whom works from a remote location). However, we have seen periods where we had 2 DBAs supporting about 24 developers (making for a reasonable ratio of 1:12).

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
victor.girling 17919
victor.girling 17919
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 93
For me it like a scene from the film Zulu... I'm massively outnumbered from an enemy with very blunt instruments. The odd one can shoot but normally misses.

I have 22 developers who all love LinqSQL and 5 systems guys to support. They all call me the Guv'nor.. then I wake up.
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8260 Visits: 6129
victor.girling 17919 (10/4/2013)
For me it like a scene from the film Zulu... I'm massively outnumbered from an enemy with very blunt instruments. The odd one can shoot but normally misses.

I have 22 developers who all love LinqSQL and 5 systems guys to support. They all call me the Guv'nor.. then I wake up.


Don't shoot 'til you see the WHERE of their SELECTs!!!

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
louie1487 78804
louie1487 78804
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 106
I'm a developer that asked for my own server instance. Since I have sysadmin rights to it, I guess I am my own dba. Lol. 1:1?
John Mitchell-245523
John Mitchell-245523
SSCertifiable
SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)

Group: General Forum Members
Points: 7381 Visits: 15095
Two DBAs to about 19 developers. And they insist we handle stuff like backups and restores on development servers for them, "because the DBAs have always done that for us". I said yeah, my mum always used to do my washing, until I grew up and started doing it myself.

John
MKEDataGuy
MKEDataGuy
Old Hand
Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)

Group: General Forum Members
Points: 320 Visits: 108
I've worked in numerous environment, and the ratios have been all over the place. One place I worked we had no DBA, but easily 20+ developers. Although, there was probably only 7 or so of us who did any SQL work. We likely didn't have a DBA because we were developing a product which used SQL Server. So, there wasn't anything for a DBA to maintain, as the databases where all on develop laptops or workstations. There was one place that was on the order of 1:10. Numerous other smaller shops (< 6 devs) we had no DBA. My present employer has 1 DBA. There are 22 "real" developers and I'm not sure how many implementation specialists who also do some simple SQL work. So, the ratio here is 1:22+.

Thanks,
MKE Data Guy
Megistal
Megistal
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1608 Visits: 2555
At one place 1:40
Another place 1:15

However for the latter, the SQL work required is much more intense and it could used another DBA
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search