March 2, 2006 at 12:44 pm
What is the difference between Production DBA and Application DBA?
March 2, 2006 at 4:13 pm
It depends on what an Application DBA is. I would guess that the Application DBA is a development DBA? If this is true, then here are a few possible differences (depending on the company's definitions of the possitions):
Production DBA's are usually more concerned with the following:
1. Performance benchmarking, monitoring, troubleshooting, and tuning of hardware, software, databases, or indexes. Also gathering performance statistics, analyzing performance history and trends and reporting on performance and making tuning recomendations based off of such info.
2. Change Management implementation - production DBA's are usually responsible for applying SQL DDL scripts.
3. Creating/maintaining any sort of production DTS or export mechanisms that the production systems may have. Also handling incomming file feeds.
4. Connectivity issues and user security administration.
Development DBA's are usually more concerned with the following:
1. Database architecture/design. This includes all SQL Server objects from table/contstraint design to stored procedure design and coding.
2. Performance analysis and tuning of SQL code, indexes, triggers, etc. based off of their own observations or recomendations from others (including production DBA's).
3. Creating SQL DDL scripts.
4. Version control / change management.
Again, these are just a few differences and they will vary by shop. I'm sure that other's will be able to point out more differences.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply