I am curious as to how other DBA’s handle changes to your environments. Specifically changes to your databases.
Say for example that you have an application that has been designed in house. A development team develops the application, the services and the database changes that are required to support those changes. As an operational or “Production DBA” that is not involved in the development process is held responsible for the performance of not only the SQL Server configuration (mirroring, configurations, and the such) but the hardware and the database (locks, indexing and the such) as well.
Goals of the development team are to develop software to support services or product lines that add to the company’s operations.
Goals of the operational team is to ensure availability and stability while maintaining a level of recovery.
The development team works with the agile development methodology and releases once every couple weeks. The stress point that I find in this scenario is as a “Production DBA” the organization has an expectation level that each of the changes are reviewed and approved before release. The speed of the release cycle creates a window that is a very small point in time for these change reviews. We have attempted to make adjustments as to where in the process the DBA does the actual review itself, even when it is done at different stages of development, any changes that the “Production DBA” has creates a serious delay to the release. The goals of the 2 different teams or roles are different, yet both are aimed to the success of the organization.
There is at least what I believe, an obvious point where the “Production DBA” can be involved from the start of the development task. However, the lines of development and production are then blurred. The development staff would prefer to make the decisions on the architecture without this input.
- As a Production DBA, do you review or approve of changes?
- As a Production DBA, how involved in each “Story” are you?
- Where is the line drawn on who makes what decisions?
I know the question is really vague, and that I have not provided a number of specific pieces of information. I did this because I would like to get a range of answers. Each situation is different, and sure it depends… but it depends on what?
Thanks, for any feedback you provide.