Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
New_DBA
Starting Member
1 Post |
 Posted - 2015-04-23 : 14:27:55
|
| I work for a central IT facility which provides services to all the departments in the organisation. Management are proposing to extend the current database hosting service to a full blown DBA service as well. The role is to be split between the hosting team, who had also been providing high level functions like replication, and a dba team who will take on the database administration. There is to be a strict delineation of responsibilities with the hosting team looking after everything at the instance level and the database team managing the databases. The hosting team will retain the sysadmin role and grant sql permissions to the database team as and when they need them. Would be very interested to hear the thoughts of experienced DBAs on this arrangement. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-04-23 : 14:30:59
|
| I don't think I'd call myself a DBA if I didn't have sysadmin on the production environments I'm supporting. Places I've worked at call those roles Database Engineers or similar.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-04-24 : 01:09:25
|
| The DBA responsibility in most organisations includes end - to - end management of the Database Server Instances .This could include Disaster Recovery and Production Support.To be effective a DBA needs elevated privileges.Of course , there are different flavours of DBA , which may result in a subset of security.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Splitting the DBA Role at instance level