How Do I Measure My DBA Skills Part 6
Development DBA II
With the last post, we began talking about the Development DBA and the skills needed at the beginning of this career path. Now it’s time for you to ponder what the next level looks like.
Development DBA II – 2 to 4 Years of Experience
- All competencies from level 1
- Develop basic to intermediately complex stored procedures, triggers, views and other database objects.
- Will have some experience with SSRS, SSIS, and/or SSAS development, deployment and possibly administration.
- May administer source control systems for the environment.
- Promotes SQL changes from Dev up through all environments, including production.
- Contributes to automation, particularly using native SQL Server methods, but could also leverage PowerShell or other languages for automating tasks (Python, C#, etc.)
- Designs pre-prod testing of SQL code prior to production upgrades or migrations. This includes performance and regression testing.
- Basic to mid-level understanding of execution plans, indexes, SQL Server statistics, and query tuning.
- Investigate basic to moderately complex data integrity/repair issues within SQL Server
- May begin leading in knowledge sharing in some capacity in one or more areas from level I or II.
- May take an active interest in leadership and in development of leadership skills, including emotional intelligence.
In years 2 through 4 the Dev DBA will work with more complex T-SQL such as recursive CTE’s, and error handling with TRY CATCH or the THROW syntax will likely be introduced at this stage. You may begin writing database views during this part of your career and leveraging them to make query writing a bit simpler for yourself and others. You are likely to be exposed to T-SQL Triggers and you’ll need to understand them and even maybe write a few triggers of your own.