September 4, 2015 at 2:23 pm
webrunner (9/4/2015)
Sean Lange (9/2/2015)
Luis Cazares (9/2/2015)
Sean Lange (9/2/2015)
BrainDonor (9/1/2015)
What's the difference between 'None of the above' and 'Other'?Also curious what is the difference between "Development" and "Development DBA".
I understand it as coder and debugger. 😀
Well, maybe Development refers to developers that happen to use SQL Server, while Development DBA refers to people in charge of the code and performance of SQL Server. Would that make sense?
It does but...if Development refers to a developer that happens to use SQL Server they aren't a DBA at all. That would be like asking what kind of watermelon your dog is. 😛
I had the same question, and agree that "Developer" meaning "T-SQL Developer" is a non-DBA category.
BTW my watermelon is a cat - or is that the other way around. 😉
- webrunner
Did you spring for a licensed breeder to get the seedless variety??
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 7, 2015 at 5:04 am
feeling a bit the same!
September 7, 2015 at 5:31 am
Nadrek, how would you define a Systems DBA?
Thanks.
September 7, 2015 at 10:30 am
I can't see 'Great' on the list? 😛
But seriously, pretty much all of them, depending on what day of the week it is!
September 7, 2015 at 1:55 pm
All this confusion over asking what type of DBA we are?
I agree that the term DBA should no longer be used like a generic catch-all title like the term doctors 100 years ago. Unless we start to have some standard way of dividing the role of a DBA we can never effectively communicate outside of IT and start to change this trend.
I cannot pretend to have a solution of this, but I will throw in my 2 cents because its so cheap.
Attempts have been made to formulate more specific job descriptions (like doctors) but that has also created confusion. These specific DBA titles don't scale well outside of large companies where most of the DBAs wear many hats. Assigning titles like Production DBA or Development DBA often fail as well. Perhaps instead of thinking of job titles we should think in terms of roles we perform. I chose each of the roles below because a person could actually have a full-time career dedicated to just that role, but many will have jobs with a percentage in some or most of these roles.
A better DBA job description could list what percentage of time you are expected to dedicate to each role, which would better define the focus of skills required for that job (rather then list you should just know and do everything database related).
DBA Roles
•Architect – system design and deployment with focus on HA, capacity planning, performance and scalability
•Administration – performs backups, maintenance, updates/patches and handles security
•Operations – monitor and troubleshoot performance and data reliability and handles recovery
•Development – designs databases for applications
•Data Warehouse – designs warehouse, builds ETL processes and ensures data quality
•Reporting – builds and maintains business reporting system
•Business Intelligence – builds cubes and works with data extraction and presentation tools
Well, hopefully it's at least a start in the right direction.
It would be interesting to have a poll that let us assign percentages to the choices.
September 8, 2015 at 2:28 am
Working in a small company as their "database expert" I am a "jack of all trades" but as the business grows and we move to the cloud realise that I will have to specialise more and pass some of the responsibilities to A. N. Other!
September 8, 2015 at 7:33 am
In past positions my role was definitely more of a production support role but now working for a smaller organization they wanted me to support data warehousing and I found out how much I don't know and how much there is to that area of being a DBA.
I think now you could make a career out of being a data warehouse specialist so the analogy of the role of a physician having been split into specialties is apt.
September 8, 2015 at 8:37 am
Beatrix Kiddo (9/7/2015)
Nadrek, how would you define a Systems DBA?Thanks.
Very fuzzily!
Craig Mullins is probably the genesis of my use of the term, though my use is not at all the same as his in the fine level (or it is, but I add other DBA types to cover other areas, either way works).
Craig's Article: Types of DBAs
For me, it's a highly technical DBA role focusing on platform design and tuning, and the design and tuning of the integration with other systems - network, SAN, backups, etc.
To put it simply - this is the person who can go from "Is there a slowness issue with index X?" to
"Your request is on the 1Gbps link to the server, then the 8Gbps Active/Passive fiber channel HBA to the fiber switch, then 16Gbps fiber channel to the SAN, and LUN 12 is a dedicated RAID 5 group of short stroked 15k disks which are not shared with any other LUNs. Nothing along the path looks strange."
September 8, 2015 at 10:36 am
I was sorely tempted to tick everything except "none of the above", but eventually left out the BI line because it was such a tiny fraction of my time even when we no-one else to do it.
Tom
September 8, 2015 at 11:54 am
I pretty much do all of the above as well, but I work for the analytics team. So, I stuck with the BI side of things here because there are surely other production level DBA's and so forth on other teams in the company.
September 8, 2015 at 2:46 pm
I manage a small staff, so we do it all. We support four RDBMS platforms, development, production, BI, whatever. If there's a database, we support it.
December 2, 2015 at 3:46 am
Disappointingly few non-DBAs then. I can't be the only non-SQL Server bod here. Can I? No. I am sure that I read in the comments above that someone had a more infrastructure based role.
There should be more developers here. How else can we work together without better understanding???
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
December 2, 2015 at 12:46 pm
Gary Varga (12/2/2015)
Disappointingly few non-DBAs then. I can't be the only non-SQL Server bod here. Can I? No. I am sure that I read in the comments above that someone had a more infrastructure based role.There should be more developers here. How else can we work together without better understanding???
I think most of the non-dba people I ran into have a saying, "A database is a database is a database."
December 2, 2015 at 2:00 pm
xsevensinzx (12/2/2015)
Gary Varga (12/2/2015)
Disappointingly few non-DBAs then. I can't be the only non-SQL Server bod here. Can I? No. I am sure that I read in the comments above that someone had a more infrastructure based role.There should be more developers here. How else can we work together without better understanding???
I think most of the non-dba people I ran into have a saying, "A database is a database is a database."
Shame on them.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
December 2, 2015 at 3:34 pm
Gary Varga (12/2/2015)
Disappointingly few non-DBAs then. I can't be the only non-SQL Server bod here. Can I? No. I am sure that I read in the comments above that someone had a more infrastructure based role.There should be more developers here. How else can we work together without better understanding???
Well, I'm a developer not a DBA, but as a developer I tended to do all the DBA jobs too except when there was someone I could safely delegate them to. You may find that the survey results don't make it clear how many of us are primarily developers.
Tom
Viewing 15 posts - 16 through 29 (of 29 total)
You must be logged in to reply to this topic. Login to reply