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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Which Department?

Author  Topic 

DaleTurley
Yak Posting Veteran

76 Posts

Posted - 2011-02-17 : 12:29:21
Just a quick question, sorry if it's a bit off topic for this section of the forum.

Which department would you place a single MS SQL Server Administrator / Developer within a company without a dedicated department?

1) Development (developing for SQL Server, .Net and ASP.Net)
2) Infrastructure (Networking, hardware etc)
3) Business Process Management (well.. Business Process Management)

Thanks in advance for any replies.

Ifor
Aged Yak Warrior

700 Posts

Posted - 2011-02-17 : 12:48:54
It depends!

Development DBAs would normally go in with the developers and production DBAs with infrastructure.
(A Development DBA and a Production DBA can do very different jobs. eg A development DBA often spends a lot of time working on data access while a production DBA can spend a lot of time managing large DBs with thousands of users.)

You need to work out how much time your DBA is going to spend on development and how much time on production.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-02-17 : 13:01:12
I agree with Ifor.

The DBA/developer should definitely not go in the Business Process Management group.

Could you define what types of things this person would be working on, so we can help you further pick between group 1 and group 2?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

DaleTurley
Yak Posting Veteran

76 Posts

Posted - 2011-02-18 : 07:35:31
Thanks for the replies.

The kinds of things are access problems - new logins permissions etc, performance tuning new and current queries, database backups, monitoring database mirroring, developing new stored procedures / views etc, responding to incorrect data imported, importing / exporting data and controlling roll-outs of new TSQL code to production.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2011-02-19 : 05:30:09
Based on what you're outlining -with Developers ,but possibly with regular meeting with infrastructre. Or a new department called Data Administration?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-02-21 : 20:54:35
I agree with Jack, development team.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

DaleTurley
Yak Posting Veteran

76 Posts

Posted - 2011-02-23 : 09:43:16
Thanks for the replies. That's what i was hoping.
Go to Top of Page
   

- Advertisement -