Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

DBA is too large a concept

By Felipe Maurer,

I find the term DBA to cover too much and describe too little. More and more we find that the responsibilities of a DBA, as we conceived the term 15 to 20 years ago, are divided among 2 or more persons. Commonly, these persons specialize in a particular aspect of the DBA tasks: Data design, ETL, SQL development, support, etc.

I would like to propose that the concept of a DBA be divided at least in 2 major areas:

  • Development and design
  • Support

These two roles are becoming very different. The person in charge of support does not need to know how the database and associated applications work and how they interact with the business (although it doesn’t hurt). His primary concern should be to keep the database up and running and to secure the availability of backups, for disaster recovery or regulatory purposes. He should be very involved in the design and construction of a DRP and a BCP.

On the other hand, the person in charge of design/development should be very much involved with the business. He or she should participate in strategy meetings, in order to better design the data structures to accommodate for future developments in the company. He or she should know, for example, if the company is changing from dealing primarily with other businesses to dealing with the general public. This person should always be learning about the new developments in the development language (T-SQL, PL-SQL, etc.).

There are some areas that will require the participation of both these areas, for example:

  • Performance tuning. This activity requires skills both from the support and the development teams.
  • Developing a Best Practices document. Ideally, every company should have a Best Practices for SQL Development document, describing the naming conventions, coding practices, security considerations, etc. This document should be co-written by both areas.

There are some companies where these two concepts are part of the culture, but I think we, as a community, should try to make them more universally accepted.

Total article views: 206 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Personal Development

Steve Jones thinks that a personal development plan is important and talks today a little about how ...

BLOG

Does Your Company Make You a Better Person?

Successful organizations place personal development front and center. from HBR.org http://ift.tt/1a...

BLOG

Database Design Guidelines For Developers

One of the developers that I work with asked me to write a “brief” (really brief) guide on database ...

FORUM

Designing a Database to Contain data for Multiple Clients/Companies

Need insight/opinions on designing a Database to Contain data for Multiple Clients/Companies

ARTICLE

Specialists or Generalists: Who are best as Developers?

Should we have specialists or generalists working as developers in our companies? A guest editorial ...

Tags
editorial    
responsibilities    
terminology    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones