Job Description of Database Administrator (DBA) or Database Developer
Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
Modify existing databases and database management systems or direct programmers and analysts to make changes.
Test programs or databases, correct errors and make necessary modifications.
Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
Train users and answer questions.
Establish and calculate optimum values for database parameters, using manuals and calculator.
Specify users and user access levels for each segment of database.
Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
Review project requests describing database user needs to estimate time and cost required to accomplish project.
Review procedures in database management system manuals for making changes to database.
Work as part of a project team to coordinate database development and determine project scope and limitations.
Select and enter codes to monitor database performance and to create production database.
Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
Revise company definition of data as defined in data dictionary.
Reference : Pinal Dave (https://blog.sqlauthority.com) , Read more at Job Description for: “Database Administrators”, Find Jobs at SQLAuthority Jobs
4 Comments. Leave new
Hi Pinal,
Thanks for your articles with regards to job descriptions of DBA’s – I find it very interesting.
What I would like to ask you; should you have to break the job description of a DBA (MS SQL) down into levels of competency e.g. Level 1 – Junior DBA, Level 2 – Intermediate DBA, Level 3 – Senior DBA, Level 4 – Specialist and maybe a Level 5 – Master DBA. How would you recommend one go about in doing so?
Thank you so much.
Kind regards,
Pieter Schoeman
From my point of view, there should be only two kind of DBA’s
1. Junior DBA
2. Seinor DBA.
Then comes Database Architect.
Hi,Pinal Dave.
Please Give me a Information About Exams of MCDBA,how can i prepare for MCDBA,any Institute.please give me a all Information.
Thanks in Advance,
Fazal Vahora
Cool site, love the info.