InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 21:13:26 GMT20http://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspxFlavours of DBA? No wonder I felt the strain for many years juggling the Admin side, the dev side AND the BI side! Sometimes my brain melts when I read up a new area of SQL that I've never touched yet seems to be used by everyone.Thu, 19 Jan 2012 14:08:06 GMTShark Energyhttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspxThat is one of the better comments I have seen on any tech forum. I agree and I appreciate the feedback.SteveTue, 06 Dec 2011 00:18:28 GMTSQL-DBAhttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspxThe Database Administration group stands alone. The DBA cannot report directly to the manager of software development. This creates a conflict of interest. This alignment allows the manager of development to direct the duties of the DBA. A software manager may desire to bypass change management or override the recommendations of the Database Management team. Tasks and projects need to be discussed rather than assigned. The Database Administration group should also not be under networking. A Networking Manager typically does not understand enough about databases to accurately plan for projects and tasks. The database group works WITH all groups and needs to stand alone in the organizational structure reporting to IT Management. In large meetings, the database group needs accurate representation for proper planning. If they do not stand alone in the org, who will be able to discuss what type of hardware is warranted? DR issues? availability? Scalability? These issues differ dramatically when you are dealing with a file server, mail server or database server. Certainly the software engineers are NOT qualified to speak on behalf of the database backend.Mon, 05 Dec 2011 13:53:24 GMTjanetkeithhttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspx[quote][b]Ninja's_RGR'us (11/17/2011)[/b][hr][quote][b]SQLRNNR (11/17/2011)[/b][hr]This topic covers a lot of ground.[/quote]I'm so glad you qualified what covered that much ground. I had a totally different picture in my head at first :sick:[/quote]And the very notificaton in my box is by "Tom Brown".What else could it have been, really?:hehe:Thu, 17 Nov 2011 08:28:42 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspxAh, I can always count on SSC for a laugh.The work from home DBA is what I aspire to be. Hopefully that will happen soon. I don't have to change diapers though, my kids are older than that now. I'll be the next one in diapers in my house.:w00t:Thu, 17 Nov 2011 08:23:56 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspx[quote][b]SQLRNNR (11/17/2011)[/b][hr]This topic covers a lot of ground.[/quote]I'm so glad you qualified what covered that much ground. I had a totally different picture in my head at first :sick:Thu, 17 Nov 2011 08:20:17 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspx[quote][b]Ninja's_RGR'us (11/17/2011)[/b][hr][quote][b]SQLRNNR (11/17/2011)[/b][hr][quote][b]Jack Corbett (11/17/2011)[/b][hr]To get back to the original question, Jason and Remi :-P.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.[/quote]Don't forget the work from home dba. Part of their duties is to do the dishes.;-)[/quote]And laundry, mow the lawn, BBQ. Go fish, etc.Busy days around here on the lake :cool::-D.Glad we're back on topic. :hehe:[/quote]Watch the kidsChange diapersThis topic covers a lot of ground.Thu, 17 Nov 2011 08:18:35 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspx[quote][b]SQLRNNR (11/17/2011)[/b][hr][quote][b]Jack Corbett (11/17/2011)[/b][hr]To get back to the original question, Jason and Remi :-P.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.[/quote]Don't forget the work from home dba. Part of their duties is to do the dishes.;-)[/quote]And laundry, mow the lawn, BBQ. Go fish, etc.Busy days around here on the lake :cool::-D.Glad we're back on topic. :hehe:Thu, 17 Nov 2011 08:16:48 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspx[quote][b]Jack Corbett (11/17/2011)[/b][hr]To get back to the original question, Jason and Remi :-P.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.[/quote]Don't forget the work from home dba. Part of their duties is to do the dishes.;-)Thu, 17 Nov 2011 08:15:46 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspxTo get back to the original question, Jason and Remi :-P.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.Thu, 17 Nov 2011 08:13:46 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspx[quote][b]SQLRNNR (11/17/2011)[/b][hr][quote][b]Ninja's_RGR'us (11/17/2011)[/b][hr][quote][b]SQLRNNR (11/17/2011)[/b][hr][quote][b]Lowell (11/17/2011)[/b][hr][quote][b]SQLRNNR (11/17/2011)[/b][hr]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 ;) ).[/quote]Jason is that your kind of shop, by chance? mine's not a one man show, but i did make the coffee this morning :-)[/quote]Not currently, but I did work in a shop like that about 8yrs ago. I was the dev, dba, net admin, and yes - janitor.[/quote]Hey that's me!At least one of the other it guys thinks I'm the janitor & that my desk is a dump site. :pinch:[/quote]i guess that is true of all consultants - crap[/quote]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! :-PThu, 17 Nov 2011 07:07:49 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspx[quote][b]Ninja's_RGR'us (11/17/2011)[/b][hr][quote][b]SQLRNNR (11/17/2011)[/b][hr][quote][b]Lowell (11/17/2011)[/b][hr][quote][b]SQLRNNR (11/17/2011)[/b][hr]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 ;) ).[/quote]Jason is that your kind of shop, by chance? mine's not a one man show, but i did make the coffee this morning :-)[/quote]Not currently, but I did work in a shop like that about 8yrs ago. I was the dev, dba, net admin, and yes - janitor.[/quote]Hey that's me!At least one of the other it guys thinks I'm the janitor & that my desk is a dump site. :pinch:[/quote]i guess that is true of all consultants - crapThu, 17 Nov 2011 07:04:06 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspx[quote][b]SQLRNNR (11/17/2011)[/b][hr][quote][b]Lowell (11/17/2011)[/b][hr][quote][b]SQLRNNR (11/17/2011)[/b][hr]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 ;) ).[/quote]Jason is that your kind of shop, by chance? mine's not a one man show, but i did make the coffee this morning :-)[/quote]Not currently, but I did work in a shop like that about 8yrs ago. I was the dev, dba, net admin, and yes - janitor.[/quote]Hey that's me!At least one of the other it guys thinks I'm the janitor & that my desk is a dump site. :pinch:Thu, 17 Nov 2011 06:05:02 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspx[quote][b]Lowell (11/17/2011)[/b][hr][quote][b]SQLRNNR (11/17/2011)[/b][hr]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 ;) ).[/quote]Jason is that your kind of shop, by chance? mine's not a one man show, but i did make the coffee this morning :-)[/quote]Not currently, but I did work in a shop like that about 8yrs ago. I was the dev, dba, net admin, and yes - janitor.Thu, 17 Nov 2011 06:03:07 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspx[quote][b]SQLRNNR (11/17/2011)[/b][hr]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 ;) ).[/quote]Jason is that your kind of shop, by chance? mine's not a one man show, but i did make the coffee this morning :-)Thu, 17 Nov 2011 05:55:28 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspxThere 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 ;) ).Thu, 17 Nov 2011 05:42:26 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspxfor 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.Thu, 17 Nov 2011 05:38:43 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1207414-334-1.aspxI 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.SteveThu, 17 Nov 2011 05:29:11 GMTSQL-DBA