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 Friday, October 4, 2013 6:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:15 PM
Points: 2,517, Visits: 3,712
I have never worked in a shop that had even one DBA. My entire career of 30+ years has been small shops with four developers at most. I am the sole developer and we have two net admins. I am what some have called an accidental DBA. I've been pulled kicking and screaming into the DBA world.

Tom
Post #1501558
Posted Friday, October 4, 2013 6:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 10, 2014 12:42 PM
Points: 19, Visits: 105
We currently have 4 developers and I'm the 1 DBA, which seems like a good ratio. The last company I was at had 8 DBA's and 30-40 developers.

Of course, there is a pretty broad spectrum of what duties are assigned to a DBA. I tend to notice that when you get past a 4:1 ratio, you see the developers writing their own DDL and the DBA tends to be more of a systems administrator. I find that I'm mostly writing SSIS packages and troubleshooting performance issues these days, and I dole out advise on data modeling and the finer points of writing SQL, but very little actual code writing.
Post #1501569
Posted Friday, October 4, 2013 7:17 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:06 AM
Points: 142, Visits: 430
Mostly always being working on small companies with no DBA's and around 5-10 dev. But lat two positions on bigger companies I've seen awfull situation: one DBA for an horde of developers. First place, around 30 developers, 3 or 4 servers and many more instances. Second place, and current work, 4 servers, +20 instances, one DBA and +100 developers. From what I've seen so far, no too much tSQL interest on dev's side and the brand new idea is "MS SQL Server can't scale, let's try NoSQL"
Post #1501585
Posted Friday, October 4, 2013 7:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:31 PM
Points: 1,296, Visits: 761
Anywhere between 1:7 and 1:40. The later was a pure admin type DBA job, the ones with the lower ratio tended to also involve a lot more development and architecture work.

My previous company was most likely the worst. 82 production databases, with dev and test environments for each, 22 developers in house AND supporting an off shore team that could be anything between 5 and 40 people depending on what project was going on. With me as the only DBA (most of the time, for a while had a backup DBA). I was the architect and production DBA, luckily the developers had pretty good T-SQL skills. I quit because of the hours needed to support both on and off shore.
Post #1501588
Posted Friday, October 4, 2013 8:24 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 3:21 PM
Points: 156, Visits: 368
I think the ratio you've seen, of 1 DBA to 10 developers is about right. I'd say it's either that or 1 DBA to 8 developers.


Rod
Post #1501620
Posted Friday, October 4, 2013 8:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:30 PM
Points: 10, Visits: 219
We have around 10 people in development and one DBA [me] but the real question is how many DBAs take care of how many database/servers? We have around 130 servers with SQL and my last guess was around 700 databases.
Post #1501629
Posted Friday, October 4, 2013 9:21 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:54 PM
Points: 326, Visits: 926
One DBA (me) supporting one developer (me) servicing around 30 users, running 3 servers. Yes, I'm up to *** in alligators.
Post #1501638
Posted Friday, October 4, 2013 9:22 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 11:42 AM
Points: 1,322, Visits: 793
Nice topic, Steve, and I have to say I'm not at all surprised at the numbers people are reporting.

An interesting related question - for those that are "development dba's" or "database developers" (whatever you want to call it - a person that focuses on db design and software development primarily in the db itself, maybe with some DAL and ETL work thrown in), what ratios have you seen? For me, it's usually 1 database specialist per about 10-20 people (although I have been the db specialist on a small team of 5 before).



Post #1501639
Posted Friday, October 4, 2013 9:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 4, 2013 12:17 PM
Points: 1, Visits: 13

We're about 15:1 (Dev&QA/Dedicated DBA) 75:5

Breaking it down further (although everyone pitches in):
1 - Architect
2 - Admin/Performance DBAs
2 - BI/ETL Designers

We do train our devs and QA to handle basic admin of their own environments.

I find that the number of concurrent projects is more challenging than simple numbers. 1 DBA can easily handle a large team (25) working a single product. We see challenges with (25) if they're on multiple teams and schedules collide.



Post #1501645
Posted Friday, October 4, 2013 9:33 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:48 PM
Points: 1,296, Visits: 1,814
I was the accidental DBA and the developer at my last job, so 1:1.

At my current job it's 1:7.
Post #1501646
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse