As a DBA, we have a lot to work on and also we have a lot to learn about. The asset that makes us as a DBA is our professional knowledge and skills, and as such, from time to time, we need to review our knowledge/skill portfolio and how we want to invest ourselves (time / energy) into managing this asset.
To me, in general, there are two directions,
- go deeper into one field, such as db engines, t-sql techniques or SSAS / SSIS etc, or
- go broader to understand not only the database itself but also the ecosystem of the database.
There is overlap in the two directions, but they are different in essence. For “go deeper” direction, we will focus on one topic and spare no efforts to become the specialist of this topic. For “go broader” direction, we will spend 20% of our energy to know the 80% of the topic (of course this 80% is much easier to master than the remaining 20%), and we will try to be familiar with as many fields as possible to be a “generalist” DBA.
The scenery of the career path in the two directions may be quite different in that we may look for or be offered different opportunities, and thus harvest different joys and satisfactions (/ pains as well).
I always feel that to have a successful DBA team to tackle various challenges, we need a mix of these two types of DBAs.
The specialist DBAs can provide much needed insight to solve the most difficult questions, such as how much CPU usage reduction have we achieved in the whole system by changing the order of an index column sequence, and why, with the proof of quantitative data and theory explanation.
The generalist DBAs can be put into almost any technical environments to solve majority of problems, one key advantage of the generalist DBA is that this type of DBA may do good integration of various components of the database ecosystem, and may come up with innovative solutions toward a specific problem, such as using SSIS as a database administration platform for multiple server management.
Personally, I feel each DBA may experience / try one direction at different career phases, partly because of work requirement and partly because of self interests. In theory, the destination of either direction will be the same spot — a DBA specialist in every field of SQL Server technology.