foreverloops (6/26/2012)
Hi,I work for an organisation where we have approximately 75 IT staff. We have a development team, an application service team and an infrastructure team who jointly support MS SQL Server. I'm trying to draw up a RACI matrix to show who should do what and I wonder if anyone has any examples they could share?
I appreciate it will be different at other companies but it would make a good starting point. We tend to follow ITIL in terms of the division of roles. We don't have a DBA at the moment but I will probably be recruiting one shortly.
I have searched this forum and the web and can't find anything of much use. I have managed to cobble together some roles for SQL Server e.g. backup, performance monitoring etc and who I think is responsible for them.
I suspect that the roles and responsibilities are similar for other flavours of SQL so please don't be put off if you use Progress or Oracle etc.
Thanks,
Matt 🙂
DBA owns the structure but neither data, code nor infrastructure.
Business owns the data.
Development/Applications team owns the code.
Systems/Networking/Storage team(s) own the infrastructure.
Digging deeper in DBA responsibilities, DBA is responsible for: Database Integrity, Availability, Recoverability, Security and, Performance.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.