Database administrators typically do the following:
Database administrators, often called DBAs, make sure that data analysts can easily use the database to find the information they need and that the system performs as it should. DBAs sometimes work with an organization's management to understand the company's data needs and to plan the goals of the database. They also may work with computer and information systems managers to provide database solutions. Database administrators are responsible for backing up systems to prevent data loss in case of a power outage or other disaster. They also ensure the integrity of the database, guaranteeing that the data stored in it come from reliable sources.
Some DBAs oversee the development of new databases. They have to determine what the needs of the database are and who will be using it. They often monitor database performance and conduct performance-tuning support. Database administrators often plan security measures, making sure that data are secure from unauthorized access. Many databases contain personal or financial information, making security important.
Many database administrators are general-purpose DBAs and have all these duties. However, some DBAs specialize in certain tasks that vary with an organization and its needs. Two common specialties are as follows:
System DBAs are responsible for the physical and technical aspects of a database, such as installing upgrades and patches to fix program bugs. They typically have a background in system architecture and ensure that the firm's database management systems work properly.
Application DBAs support a database that has been designed for a specific application or a set of applications, such as customer-service software. Using complex programming languages, they may write or debug programs and must be able to manage the applications that work with the database. They also do all the tasks of a general DBA, but only for their particular application.