October 19, 2012 at 9:58 am
Dreadfully boring i know.
Wonder if you know of work delineating the work and rank names (including or excluding specialties like Developer DBA or Data Warehouse DBA). I would like to be able to distinguish between these role names.
(does anything preceed Junior, like Apprentice?)
Junior DBA
Assistant DBA
Associate DBA
DBA
Senior DBA
Notwithstanding my own stab at the hierarchy, I can see a mini Zachman something like
Security| Availability(BU/Restore) | Monitoring | Replication | ETL | Data Warehousing | Reporting
Junior DBA x x x
Assistant DBA x x x x x
Associate DBA x x x x x
DBA x x x x x x x Senior DBA x x x x x
the trick is, are the Xs in the right spots, and how are they filled in?
thanks a lot
October 19, 2012 at 10:24 am
I'm sure I won't use the appropriate terms, but usually I've seen the break downs something like this:
Junior DBA
DBA
Senior DBA
Data Architect
At my last place of employment they didn't have Data Architect, they had Principal DBA. The designation for a Database Developer as opposed to a DBA could go Junior, Dev, Senior too, but then should/would move to the same Architect position. Data warehousing is a speciality within DBA as is SSIS & SSRS from the SQL Server point of view. But, you could easily have a set of developers whose only job is reports. I've seen them separated out that way. They were not considered DBAs or on the DBA path, in any way.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 19, 2012 at 1:47 pm
Thanks very much;
Is it fair to say that the Senior DBA has command of a specialty, either in the BI world or more traditional?
To clarify, by BI i mean SSAS, SSIS, SSRS. By traditional I mean Clustering, Replication, Full Text (or now + File Table ) or maybe MDM/DQS for instance.
Leave alone the idea of certification...after a hire I get ninety days to kick the tires, so being able to do things counts more than passing exams, though both are nice.
The Senior title means you are the go-to resource for some edge technology important to the operation....some people think it enures to them by tenure.
October 20, 2012 at 5:34 am
Yes, someone who achieves Senior should have special knowledge of parts of SQL Server and should be a go-to resource. I agree.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 26, 2012 at 10:44 am
I've worked places (including my current one) where the designations just show how much overall experience a DBA has. Someone with basic knowledge of SQL Server is a Junior DBA and needs to get assistance frequently, a DBA knows how to administer/work with SQL Server more in-depth, a Senior DBA should rarely need assistance from anyone else.
So not specific areas of SQL Server...just level of knowledge and how often you need to get help from another person.
In other words...
Junior DBA - can't work alone...needs overseeing
DBA - can work alone, but needs assistance/guidance
Senior DBA - can work alone, rarely needs help but is called on to help the lower level DBAs.
-SQLBill
October 26, 2012 at 2:07 pm
a very reasonable heuristic.
thanks very much for your reply.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply