CAREERS: Database Administrators
Database administrators typically do the following:
· Ensure that organizational data are secure
· Backup and restore data to prevent data loss
· Identify user needs to create and administer databases
· Ensure that databases operate efficiently and without error
· Make and test modifications to database structure when needed
· Maintain databases and update permissions
· Merge old databases into new ones
Database administrators, often called DBAs, make sure that data analysts and other users can easily use databases to find the information they need and that systems perform as they should. Some DBAs oversee the development of new databases. They have to determine the needs of the database and who will be using it.
They often monitor database performance and conduct performance-tuning support.
Many databases contain personal or financial information, making security important. Database administrators often plan security measures, making sure that data are secure from unauthorized access.
Many database administrators are general-purpose DBAs and have all of 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.