RE: DBA to Developer ratio

For your own projects you need to work with your project managers to get your projects on the table too.

Items to maintain, monitor, upgrade systems are just as important as some of the development work.  

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Jeff Chirco Sent: Monday, January 28, 2019 10:11 AM
To: Dimensional DBA <dimensional.dba_at_comcast.net> Cc: oracle-l-freelist <oracle-l_at_freelists.org> Subject: Re: DBA to Developer ratio  

Thank for your input. We keep up with their needs (for the most part) but our own projects lag behind big time. We are working on getting the developers to be less depended but there is always things and we like being in the know of what is going on.  

On Mon, Jan 28, 2019 at 9:27 AM <dimensional.dba_at_comcast.net <mailto:dimensional.dba_at_comcast.net> > wrote:

Those numbers are based off of the developers who are tied to a database in some fashion. The numbers are much higher when you look at all developers on the teams you may support who do no development against a database.    

From: oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> > On Behalf Of dimensional.dba_at_comcast.net <mailto:dimensional.dba_at_comcast.net> Sent: Monday, January 28, 2019 9:23 AM
To: backseatdba_at_gmail.com <mailto:backseatdba_at_gmail.com> ; 'oracle-l-freelist' <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org> > Subject: RE: DBA to Developer ratio  

As you said it really depends.

In the consulting world for contracts I have seen 4 to 1, when calculating DBA to Developers.

In the commercial world I have seen upwards of 75 developers to 1 DBA. And a low of about 6 Developers to 1 DBA.

Really depends on how much help the Developers need or how much control of them you need.

Can you keep up with the project time lines based on your ratio and their/your needs.      

From: oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> > On Behalf Of Jeff Chirco Sent: Monday, January 28, 2019 9:12 AM
To: oracle-l-freelist <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org> > Subject: DBA to Developer ratio  

I know this is not an exact science and every company is different and a lot of factors goes into this. But just curious how many DBA's you have compared to how many developers? We do mostly custom development of many applications for the company. We have 20 developers that do .Net, Web, Cobol, VB, and just starting APEX. They all also do their own PL/SQL, which we review. There is 2 of us as DBA's who also do development. We support 5 Oracle databases and a bunch of MSQL databases but those are all third party systems.  

Is there a common or magic number?    

Jeff

--
http://www.freelists.org/webpage/oracle-l