We have one DBA, about 16 developers, and about 10 what I call 'power users'. These 'power' users usually write small queries to get some detail level data from our warehouse. We have our production warehouse, and a 'prod2' copy of that warehouse that we let these 'power' users loose against. in the past they ran against our production warehouse and brought it to it's knees with their code.