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

What is a Database Administrator today? Expand / Collapse
Author
Message
Posted Thursday, December 5, 2013 9:58 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 2:39 PM
Points: 82, Visits: 302
Comments posted to this topic are about the item What is a Database Administrator today?
Post #1520406
Posted Friday, December 6, 2013 1:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:23 PM
Points: 2,907, Visits: 1,830
As you noted, in different organisations they have had very different perspectives on what a senior DBA is/does.

Hard depends on what a business expects you to do. SQL Server 2012 is a huge product compared to SQL Server 6.5.

On SQL6.5 you had to do a lot of stuff that has either gone away or been replaced by an infinitely simpler alternative. It was possible to cluster SQL6.5 but you had to know your way around the Windows registry to do it. You had to be a lot more sensitive to the underlying infrastructure than you can get away with today.

On the other hand if you are expected to cover the breadth of SQL2012 then Jeez that's a lot.

Then there is the role beyond SQL Server. Perhaps your role is as a data tech expert rather than just a SQL Server DBA. I think it is possible to have a much broader role these days in terms of tech and data.
I also think that if you have a "this is what I do and this is all I want to do" attitude you are at risk of becoming obsolete.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1520443
Posted Friday, December 6, 2013 1:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 8:54 AM
Points: 5, Visits: 59
Our organisation traditionally had two SQL elements, one dealt with setting up databases, permissions, managing the introduction of thrid party system databases into our environment, clust performance etc, whilst the other SQL element dealt with managing data extracts (ODS, SSIS, DTS), along with managing the databases for our locally built applications which involved a lot of SP (T-SQL) script writing etc.

A few years ago they merged both elements into one team. However it has become apparent that the skills are really very different. As a result they are now on the cusp of splitting them both out again into separate teams where the SQL DBA looks after the clusters, backups, permissions, setting up third party databases etc and the SQL Developers handle the SQL script writing, SSIS packages, ODS creation etc.

There is a lot of confusion about what a SQL DBA should be doing as this is often confused with SQL Developer work which I believe is a different role. This confusion is really happenning at the top level in organisations where team structures and job roles are decided.
Post #1520451
Posted Friday, December 6, 2013 2:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 6, 2013 8:45 AM
Points: 1, Visits: 13
Over time I've learned that the role seems to encompass various disciplines, not just traditional DBA type tasks. In fact todays' DBA seems to have/require a massive skillset including production DBA skills, Dev DBA/DB Dev skills, BI Dev skills (SSRS,SSIS,SSAS for MS types) as well as having some .net/java/programming skills for good measure.

I've only worked for companies with sub 1000 end users, and in these sites we didn't have the resource in the Data team to have people focussed purely on one area of responsibility, and so I deliberately cross trained new data team members as hybrids in both Production DBA/DB Dev/BI disciplines. This kept their work interesting and gave more flexibility in the team.

Of course in a much bigger organisation having specific people to be "production DBA" or "Development DBA" might be necessity, but in my experience a hybrid approach works very well.
Post #1520463
Posted Friday, December 6, 2013 3:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 5,470, Visits: 3,255
This issue exists throughout IT. Just ask a developer/programmer/software engineer etc

Different companies have different structural setups both with regards to IT infrastructure and team responsibilities. Also it depends on what is outsourced/insourced, offshored/onshored, on premises/in the cloud etc.

Then there is the inconsistencies in the terms used to describe roles...[can opener replaced into the draw ]


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1520477
Posted Friday, December 6, 2013 6:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 9:03 AM
Points: 4, Visits: 53
OMG, this is exactly what I went through when I was contracting, so I stopped contracting... I'm now doing one thing (well many things in relation to) SQL Development and BI. Which is why I decided to find a perm job, do one thing and one thing well. I was told once by a professor: "You can be a 'Jack of all trades, and a master of NONE' if you want. "
Post #1520547
Posted Friday, December 6, 2013 6:19 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, September 25, 2014 5:42 AM
Points: 136, Visits: 252
Gary Varga (12/6/2013)
This issue exists throughout IT. Just ask a developer/programmer/software engineer etc

It's not unique to IT, but it does seem to be a bit more acute there, likely due to the fact that in terms of business organization, IT is still very new as compared to functions like HR, Accounting, etc. Many roles that were once rolled into one position (because that was pretty much all that was needed at the time) have diversified due to the maturing of the IT field as a whole.

Part of me wonders if there isn't some marketing strategy with regard to job titles as a bit of a psychological "filter" for applicants.


____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
Post #1520549
Posted Friday, December 6, 2013 6:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 6:44 AM
Points: 3, Visits: 12
I prefer the role I appear to have slotted into. Whereby I set up the databases (design and develop), give staff permissions ie access levels, set up audit logs / procedures / triggers. Set up data management information on the company KPI's. Backup and restore databases. Do a little php programming for web forms. Set up and maintain main systems. I have network people to install the servers and hardware etc. So I appear to have developed into the things I'm strong at and which I prefer. Luckily I have people working with me who prefer to do other things which I either haven't got the knowledge or inclination.

I agree with an earlier comment that you can't be jack of all trades and I would definitely want to be the master of one (or 2) which I clearly am specialising in.

Post #1520565
Posted Friday, December 6, 2013 6:57 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, September 20, 2014 11:37 AM
Points: 79, Visits: 753
Titles are meaningless, particularly in IT. I've had DBA titles where I never performed a backup/restore and I've had Developer and Architect titles where I spent way too much time with FileGroups, Snapshots, Replication, etc.

To the Business a DBA signifies a person who can get them reliable information when they ask it.

To the Developers a DBA is their worst nightmare.

To the Network OPS a DBA is the person who thinks they know more about networking than they do (and we often do ). We at least are savvy enough to plan for the fact that no network yet has been up 365x24x7.

To Recruiters a DBA is their meal ticket!



Post #1520568
Posted Friday, December 6, 2013 7:00 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:17 AM
Points: 1,677, Visits: 4,783
What should the job duties of a Senior Database Administrator (DBA) be? If you started a new job as a Sr. DBA what would you expect to be doing and what would you not?

It really boils to: From an organizational perspective, what is the database?
Is it just the logical model, objects, and data; or is it the hardware, network, SQL, and ETL processes too?

Strictly speaking, I think the DBA should be someone who manages the objects and data within one or more databases, but not necessarily the system administrator of the server instance or operating system. Also, one can be the administrator for database [Sales] but not the database [HumanResources], even if both are contained in the same server instance. For example, administrating the PeopleSoft, SharePoint, and MS Exchange databases can be a specialized full-time job by itself, while the proprietary databases built in-house that support the organization's line of business are something else entirely. In the SQL Server, this would be a member of the DBO role, perhaps with some additional granted permissions so they can manage jobs, view execution plans, etc.

Ideally, the system administrator (members of SYSADMIN role), should be confined to a much smaller group of people who manage the hardware, operating system, and networking environment. In a large organziation, their role is at the enterprise level, and they should not necessarily be familiar with the data model and processes any database. Their job is to make sure the databases are available, secure, and backed up.

If someone is expected to wear both hats, then their job description should include both Database and System Administrator.
Post #1520571
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse