What’s worked really well for our small development team is having a development DBA as a part of the development team. Complex queries, stored procedures, etc are developed by DBA. The management of the project content inside the timelines are also handled by DBA so the application developers don’t get the feeling of an 'us versus them' relationship.