Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Developement DBA / Production DBA
- Thread starter tapks
- Start date
tlbroadbent
MIS
Development DBAs assist in the design of databases. They work with developers in normalizing data, creation of tables, indexes, views, procedures, and triggers. They may write SQL and advise developers how to write good SQL. They participate in performance testing.
Production DBAs maintain databases after they've been implemented. They are responsible to make sure the databases are secure, backups are made and adequate disk space is available. They monitor servers to make sure they perform well. They reindex, reorganize and defragment databases. They correct and try to prevent errors. They make sure jobs run as scheduled. They apply software updates or service packs.
In many shops, like the one where I work, there is no clear delineation between development and production DBAs. There are two DBAs in our shop and both of us wear both hats, though I readily admit that my coworker is a much better Production DBA than I am. I defer to his judgment in matters such as backup and recovery strategy, scheduled maintenance and job scheduling.
If you want more information, I suggest doing a web search for "production DBA" and "development DBA." You're sure to find some excellent definitions and explanations.
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
Some shops even use different terms DBA and DBD (database developer) to differentiate between the two roles.
As Terry said, in many shops a person may perform duties commonly associated with either. At my last employer, I was the sole database person, so I did everything. At my current employer, there are four of us doing development (database design and implementation and stored procedure development) and one person doing the traditional admin work (database setup, user management, etc); we all officially have the title "DBA". -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:
As Terry said, in many shops a person may perform duties commonly associated with either. At my last employer, I was the sole database person, so I did everything. At my current employer, there are four of us doing development (database design and implementation and stored procedure development) and one person doing the traditional admin work (database setup, user management, etc); we all officially have the title "DBA". -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question