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

The Ratio Expand / Collapse
Author
Message
Posted Thursday, October 3, 2013 8:57 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:10 PM
Points: 33,095, Visits: 15,202
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
Post #1501403
Posted Friday, October 4, 2013 3:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 5,200, Visits: 2,831
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!!!
Post #1501482
Posted Friday, October 4, 2013 3:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 12:53 AM
Points: 38, Visits: 301
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.
Post #1501498
Posted Friday, October 4, 2013 4:03 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:52 AM
Points: 1,403, Visits: 1,814
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://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1501502
Posted Friday, October 4, 2013 4:34 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:51 AM
Points: 11, Visits: 79
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.
Post #1501517
Posted Friday, October 4, 2013 5:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 5,200, Visits: 2,831
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!!!
Post #1501531
Posted Friday, October 4, 2013 5:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 25, 2014 11:37 AM
Points: 18, Visits: 56
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?
Post #1501534
Posted Friday, October 4, 2013 5:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 5,233, Visits: 9,476
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
Post #1501540
Posted Friday, October 4, 2013 6:25 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 6, 2014 6:35 AM
Points: 304, Visits: 106
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
Post #1501552
Posted Friday, October 4, 2013 6:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:51 PM
Points: 1,408, Visits: 2,077
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
Post #1501556
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse