Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBA Job Description: What type of DBA are you?


DBA Job Description: What type of DBA are you?

Author
Message
Brian Knight
Brian Knight
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: Moderators
Points: 1987 Visits: 235
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp

Brian Knight
Free SQL Server Training Webinars
David Benoit
David Benoit
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2286 Visits: 3650
Brian,

Great article. One which I will use to now define my job better with management. Just hope that the "Hybrid" title does not stick in the industry. Maybe their should be a discussion to come up with something flashier?!.


David

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
jamyer
jamyer
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 16
My production team does all the tasks you mention for production. We also work with, but do not have the primary responsibility for, all the tasks you mention on the development side. We are a large Site so the division is natural and works well most of the time.

Some of the Development DBAs will work on a production DBA task from time to time, but their funding is project specific so they tend to have a much narrower focus than the production team does.

We have other contracts that we support that are much smaller than our main IT contract. In the small shops hybrid DBAs are more common. Of course those environments tend to be more chaotic since they often lack formal change control. Configuration management is left up to the individual technical person doing the work. Generally, nobody checks the work of a hybrid. This can be cheaper in the short run, but generally costs more in the long run as each generation of "hybrid" cowboy gets to figure it all out all over again.



Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: Administrators
Points: 40500 Visits: 18846
I like the article. We need a standard view of our jobs for it to be more accepted in all industries.

I think that the production DBA should report to an operatiosn person becuase it forces the development group to adhere to better change control and separates the environment. This is like the QA person reporting to the development manager - BAD idea. People are pushed to short one area to advance another.

Problem is that in too many places, the division is by application or department rather than job title.

Perhaps PASS can help to create, define and advocate some standard roles for SQL Server

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Brian Knight
Brian Knight
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: Moderators
Points: 1987 Visits: 235
quote:

Perhaps PASS can help to create, define and advocate some standard roles for SQL Server



I like the idea. The notion that nobody checks the work of a hybrid can be countered by peer-review committees. Each of us at my company works in a small project-driven team. Each person knows everything the other is doing so they can effectivily back each other up. The goal there is to hopefully catch most of what you're speaking of. For smaller companies that can do this though, this can be a concern. Some check would be needed possibily from an architecture person. Great comments!

Brian Knight
bknight@sqlservercentral.com
http://www.sqlservercentral.com/columnists/bknight

Brian Knight
Free SQL Server Training Webinars
jamyer
jamyer
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 16
I would like to see PASS take a stab at the staffing level issue. Once you define DBA then please provide some guidance on how many an organization should have. A complex but worthy subject!



Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: Administrators
Points: 40500 Visits: 18846
brian,

perhaps PASS would create an after hours forum at the conference on this? Maybe a poll?

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Brian Knight
Brian Knight
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: Moderators
Points: 1987 Visits: 235
These would be great topics. I've sent a message to the PASS board members.

Brian Knight
bknight@sqlservercentral.com
http://www.sqlservercentral.com/columnists/bknight

Brian Knight
Free SQL Server Training Webinars
andersg98
andersg98
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2178 Visits: 776
I like where you are going with this. I work in a small MIS shop supporting a collections center for a large bank. We started using SQL server a couple years ago to replace some of our Access db that outgrew that platform. The management team was of the opinion the SQL server did not need a formal DBA and started building databases as if they were still in Access, each project had its own database and was owned by virtualy all team members. Security is a nightmare, there is very little documentation and we have since built 5 more servers with only a general "idea" of how we would like the environment to look.

I would like to see this discussion expanded to try and define the various roles involved in building/supporting SQL server applications.

I'll stop here so this doesn't turn into a rant about my current environment.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search