Re: Help: Database Roles

Chad Laity wrote: > > We are trying to define the responsibilities for the technical people in > my department. > > 1) What are the generic responsibilities of a Database Administrator > (DBA) throughout the industry?? In the shops that I've been around, the DBA is the only one who has "direct access" to the engine, OS (maybe -- depends if you have a separate Unix Adm; or other OS Adm), and the DBA main roles include engine performance, space allocation, tuning, creating databases, etc. > 2) What are the generice responsibilities of a Database Programmer > throughout the industry?? They write the 4GL/ESQL code and that's it. > Currently we have a person that is designated as the DBA. Then we have 2 > other people designated as Database Programmers. The Database > Programmers add new users, perform backups, monitor logicals logs, > monitor the database server in general, and program. The DBA solves any > "business rule" issues between the users and the Programmers. If I were the DBA, the programmers would NOT touch the logs, nor the backups, nor add new users. And I would always monitor the engine. > The above scenario does not seem to follow industry standard. Does > anyone agree? Chad, yes, I would agree! -- David Weis dweis@louisville-i-market.com Louisville Internet Marketing Service 1210 Garvin Place Louisville, KY 40203 USA 502-637-7316 (Voice) 502-636-1553 (FAX) http://www.louisville-i-market.com thank goodness for bookmarks!!