Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBA Job Description: What type of DBA are you? Expand / Collapse
Author
Message
Posted Sunday, November 4, 2001 12:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
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
Post #1516
Posted Monday, November 5, 2001 7:41 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 22, 2014 12:19 PM
Points: 2,107, Visits: 3,582
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
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Post #23406
Posted Monday, November 5, 2001 11:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 22, 2011 9:03 AM
Points: 171, 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.





Post #23407
Posted Monday, November 5, 2001 1:10 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:53 PM
Points: 33,204, Visits: 15,353
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
Post #23408
Posted Tuesday, November 6, 2001 5:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
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
Post #23409
Posted Tuesday, November 6, 2001 10:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 22, 2011 9:03 AM
Points: 171, 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!




Post #23410
Posted Tuesday, November 6, 2001 11:08 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:53 PM
Points: 33,204, Visits: 15,353
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
Post #23411
Posted Tuesday, November 6, 2001 12:18 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
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
Post #23412
Posted Wednesday, December 10, 2003 1:01 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 11, 2014 3:04 PM
Points: 2,127, Visits: 747
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.




Post #23413
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse