|Recommended Degree Level||Bachelor|
|Number of Jobs, 2012||111,590|
|Annual Job Growth Rate||4.1%|
|Job Openings per Year (est.)||5,270|
- Database administrators, also known as DBAs, often have a bachelor’s degree in computer science, information systems, or a business field.
- Some positions involving complex business databases favor candidates with an MBA along with technical experience.
- Database administrators advance by assuming more management responsibility, learning emerging technologies, and demonstrating an understanding of business concerns.
What you study:
Study topics include:
- Database languages
- Database design and architecture
- Systems administration
- Networking technologies
- Information security
- Web technologies
Briefly summarizes the work of database administrators. Slightly out of date but still a useful overview. Produced for the US Department of Labor.
A Day in the Life
As a database administrator, you safeguard an organization’s critical data. When database applications are running smoothly, you may feel almost invisible to co-workers. This morning, however, the human resources manager flags you down outside of your office. She explains in a panicked tone that the employee database has crashed, and her staff is paralyzed until you fix it. You log in to the database back end and see SQL errors indicating massive data corruption. Keeping your expression neutral, you politely see her out and promise to call shortly with an update. You then contact your manager, who is working from home today, with a heads up.
An hour later, you have isolated the problem to gibberish injected into the one of the database tables. It is unlike any string you have seen before, so you consult with the IT security expert. She pokes around and confirms your suspicion that a malicious attack rather than a system failure is the likely culprit. She warns you to prepare to do a full database restore from backups and disappears into her office, affectionately called Fort Knox, to work hacker magic.
Two hours later, you are cleared for a database restore from yesterday’s backup prior to the attack. After locking out all users from the application, you shut it down. You have done nightly backups and regular test restores, so you are confident of success. Nonetheless, a full restore is an exacting process with several critical steps. Afterward, you must check the integrity of the database, its records, and connections to other systems. You verify user access and then ask the HR manager to log in to her application and test common functions.
By the time you break for a hasty sandwich, people are starting to leave. Only the IT team stays to wrap up the day’s events. Around 9 p.m., you and the security expert split a pizza while plugging the security hole that threatened your co-workers now relaxing at home.
Certifications and Licensing
Database administrators usually work with vendor applications and may find vendor certification useful or even required. As information security has become top priority, DBAs should also consider vendor-neutral security certifications from the SANS Institute, CompTIA and other recognized providers. DBAs specializing in certain applications such as healthcare databases might obtain industry certificates of knowledge.
Full-time versus part-time:
Most database administrators are employed full time, and 25 percent regularly work overtime. They may handle emergency fixes or upgrades during evenings and weekends when users do not need system access.
Almost all industries have need of database administrators. About 15 percent work for computer systems design companies offering IT services to clients. Many other DBAs are found in the data-intensive fields of finance, insurance, information management, and education. Most DBAs work on site in offices and server rooms though they may travel for training or to assist other sites.
- U.S. Department of Labor, Occupational Outlook Handbook – The site explains the unique role that database administrators play on the IT team. Readers exploring IT career options should gain a clear sense of general duties and helpful personal qualities. For more information about database administration, also visit other reputable websites about information technology.
- IEEE Computer Society – The IEEE Computer Society is a worldwide membership organization for computing professionals. The site features a useful student section with information on technical classes, scholarships and grants, and IEEE employer partners.
- SANS Institute – The SANS Institute promotes information security research and education. It offers a wealth of free resources, such as training and security bulletins, which provide good background for those considering the IT field. The site also describes the highly regarded SANS security certifications.
- Association for Computing Machinery – The ACM is a membership organization that promotes education and interest in computer-related fields. The site offers excellent resources for students and career changers investigating IT career options.