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 03, 2013 8:57 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 4:29 PM
Points: 32,819, Visits: 14,965
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 04, 2013 3:18 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:29 AM
Points: 4,884, Visits: 2,274
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 04, 2013 3:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 4:41 AM
Points: 25, Visits: 213
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 04, 2013 4:03 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, April 20, 2014 11:47 PM
Points: 1,382, Visits: 1,775
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: @nakulv_sql
Google Plus: +Nakul
Post #1501502
Posted Friday, October 04, 2013 4:34 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 5:45 AM
Points: 6, Visits: 68
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 04, 2013 5:26 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:29 AM
Points: 4,884, Visits: 2,274
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 04, 2013 5:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 8:10 AM
Points: 17, Visits: 48
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 04, 2013 5:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:58 AM
Points: 5,077, Visits: 8,919
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 04, 2013 6:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 6:04 AM
Points: 284, Visits: 100
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 04, 2013 6:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:09 AM
Points: 1,381, Visits: 2,005
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