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 12»»

Where should the DBA position be in the IT structure? Expand / Collapse
Author
Message
Posted Thursday, November 17, 2011 5:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:13 PM
Points: 80, Visits: 331

I know there are a lot of answers depending on the size and type of organization, so let me qualify the question as a DBA working for a non-profit institution with around 500 employees. Meaning, the DBA does db admin, server admin, some development, and some reporting - both of the later for various departments.

Right now I am in the Server & Network group, meaning I am a Domain Admin and I do a lot of non-database work like setting up servers, administering AD, scripting, ordering hardware, etc. This has many advantages, but I get derailed from my real job fairly often.

So I am wondering if I should be in more of an Applications group, or some other area. I would like to know where others are in their organizational hierarchy. Thanks.

Steve
Post #1207414
Posted Thursday, November 17, 2011 5:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 12,887, Visits: 31,835
for me, there's serveral flavors of DBA's..there sthe DBA that does what yuo are probably doing...mostly administrative, handling backups, traces and the servers themselves.

a Development DBA, which (for me anyway) works closly witht eh developers, and writes SQL's, procs and table definitions, then helps tune them.

other flavors of DBAs might be someone more oriented with BI, or someone who specializes more in reporting, wether with SSRS or otherwise.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1207423
Posted Thursday, November 17, 2011 5:42 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:09 PM
Points: 21,252, Visits: 14,960
There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.
It really depends on the organization as to where the DBA falls in the "Tree."

It is easier to just focus on the DBA work and only have access to those things you really need (i.e. not being a domain admin ;) ).




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1207425
Posted Thursday, November 17, 2011 5:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 12,887, Visits: 31,835
SQLRNNR (11/17/2011)
There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.
It really depends on the organization as to where the DBA falls in the "Tree."

It is easier to just focus on the DBA work and only have access to those things you really need (i.e. not being a domain admin ;) ).


Jason is that your kind of shop, by chance? mine's not a one man show, but i did make the coffee this morning


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1207434
Posted Thursday, November 17, 2011 6:03 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:09 PM
Points: 21,252, Visits: 14,960
Lowell (11/17/2011)
SQLRNNR (11/17/2011)
There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.
It really depends on the organization as to where the DBA falls in the "Tree."

It is easier to just focus on the DBA work and only have access to those things you really need (i.e. not being a domain admin ;) ).


Jason is that your kind of shop, by chance? mine's not a one man show, but i did make the coffee this morning


Not currently, but I did work in a shop like that about 8yrs ago. I was the dev, dba, net admin, and yes - janitor.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1207438
Posted Thursday, November 17, 2011 6:05 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:14 AM
Points: 21,385, Visits: 9,603
SQLRNNR (11/17/2011)
Lowell (11/17/2011)
SQLRNNR (11/17/2011)
There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.
It really depends on the organization as to where the DBA falls in the "Tree."

It is easier to just focus on the DBA work and only have access to those things you really need (i.e. not being a domain admin ;) ).


Jason is that your kind of shop, by chance? mine's not a one man show, but i did make the coffee this morning


Not currently, but I did work in a shop like that about 8yrs ago. I was the dev, dba, net admin, and yes - janitor.


Hey that's me!


At least one of the other it guys thinks I'm the janitor & that my desk is a dump site.
Post #1207442
Posted Thursday, November 17, 2011 7:04 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:09 PM
Points: 21,252, Visits: 14,960
Ninja's_RGR'us (11/17/2011)
SQLRNNR (11/17/2011)
Lowell (11/17/2011)
SQLRNNR (11/17/2011)
There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.
It really depends on the organization as to where the DBA falls in the "Tree."

It is easier to just focus on the DBA work and only have access to those things you really need (i.e. not being a domain admin ;) ).


Jason is that your kind of shop, by chance? mine's not a one man show, but i did make the coffee this morning


Not currently, but I did work in a shop like that about 8yrs ago. I was the dev, dba, net admin, and yes - janitor.


Hey that's me!


At least one of the other it guys thinks I'm the janitor & that my desk is a dump site.


i guess that is true of all consultants - crap




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1207486
Posted Thursday, November 17, 2011 7:07 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:14 AM
Points: 21,385, Visits: 9,603
SQLRNNR (11/17/2011)
Ninja's_RGR'us (11/17/2011)
SQLRNNR (11/17/2011)
Lowell (11/17/2011)
SQLRNNR (11/17/2011)
There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.
It really depends on the organization as to where the DBA falls in the "Tree."

It is easier to just focus on the DBA work and only have access to those things you really need (i.e. not being a domain admin ;) ).


Jason is that your kind of shop, by chance? mine's not a one man show, but i did make the coffee this morning


Not currently, but I did work in a shop like that about 8yrs ago. I was the dev, dba, net admin, and yes - janitor.


Hey that's me!


At least one of the other it guys thinks I'm the janitor & that my desk is a dump site.


i guess that is true of all consultants - crap


They don't think of you as an employee so it's their space & stuff.


That being said, you'd think that after 3 years non-stop they would quit with that crap!
Post #1207487
Posted Thursday, November 17, 2011 8:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:07 AM
Points: 11,157, Visits: 12,899
To get back to the original question, Jason and Remi .

I think we need more information about what your job duties are supposed to be before anyone can really say where you should be.

If you are an operational DBA, meaning mostly backups, monitoring, patches, applying best practices, security, then I think you should be in the Server & Network group, but not necessarily a domain admin.

If you are doing more development (sp's, database design, etc...) and T-SQL tuning then you should be more closely aligned with the application development group.

If you have to do it all, then you really should be your own group and report directly to the head of the IT department.

These are just my opinions and how I'd want to be aligned based on duties. Ideally I'd like to be in the last option.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1207558
Posted Thursday, November 17, 2011 8:15 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:09 PM
Points: 21,252, Visits: 14,960
Jack Corbett (11/17/2011)
To get back to the original question, Jason and Remi .

I think we need more information about what your job duties are supposed to be before anyone can really say where you should be.

If you are an operational DBA, meaning mostly backups, monitoring, patches, applying best practices, security, then I think you should be in the Server & Network group, but not necessarily a domain admin.

If you are doing more development (sp's, database design, etc...) and T-SQL tuning then you should be more closely aligned with the application development group.

If you have to do it all, then you really should be your own group and report directly to the head of the IT department.

These are just my opinions and how I'd want to be aligned based on duties. Ideally I'd like to be in the last option.


Don't forget the work from home dba. Part of their duties is to do the dishes.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1207561
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse