For a typical team of 20 .net developers how many sql developers and DBA's should be allocated ?

Question

For a typical team of 20 .net developers how many sql developers and DBA's should be allocated ?

Answer 1

Generally it depends if the project is too-much data driven or not. For a typical project two sql developers and one DBA should be sufficient.

This too deviates depending the stage of the project i.e. development stage or maintenance stage. Its is generally seen that during the maintenance phase the demand for DBA's is more and in development phase the demand of sql developers is more.

Answer 2

Agree with HotTester. It also depends on the software design the developers come up with. I can imagine that if they employ SQL stored procedures a lot (as opposed to solving issues in C#-space) you would require more sql developers.

Usually developers should not defer too much application logic to stored procedures though.

Easiest solution: ask your lead developer what he thinks :)

Answer 3

Depending on how much Database Administrative type work you need to perform, you may actually be better off outsourcing this function. The company I consult for, Santech Solutions, provide this very service.

For SQL Development work however, you will most likely require on site full time resource available and so the previous posters recommendations stand.

Answer 4

The traditional number is actually zero!