DiscoverDataScience.org

You are here: Home / Careers / How to become a database administrator in 2020

How to become a database administrator – A complete career guide

In this Guide:

4 steps to become a database administrator
What is a database administrator?
What does a database administrator do?
Database administrator job description
Database administrator skills and experience
Database administrator salary
Database administrator job outlook

With the rapid growth and advancement in information technology in the late 20th century, businesses were accumulating reams of data for historical records. At first, few saw the value of this data, but soon it became widely understood that organizations were amassing an extremely useful and valuable resource. Once that realization spread, the construction, storage, manipulation and management of huge databases became a pivotal function in every organization. Database administrators were at the very heart of this new reality, and still are today.

Database administrators are information technology professionals that ensure the optimal storage and access to an organization’s data. This is done by ensuring software programs are designed, managed and maintained to permit rapid access whenever and however needed by authorized personnel. Database administrators also work with cybersecurity professionals to safeguard the data from unauthorized access and damage. Alternatively, database developers are responsible for the design, programming, and construction of new databases. Some organizations treat these two posts as one job, but for the purposes of this discussion, we have separated them as distinct careers. A career guide for database developers can be viewed here. (insert link when available)

This guide provides an overview of the database administrator role and lists the steps required to begin and maximize a career as a DBA. Included is a detailed list of job responsibilities, background, education, and experience required to be successful professional, as well as salary information, and the future outlook for the database administrator job market.

Four steps to become a Database Administrator

Step 1: Education

Database administrators must be knowledgeable of all aspects of designing, organizing and maintaining information storage needs for any particular company. A strong generalized background in relational database management systems, including an understanding of structured query language (SQL), is a basic prerequisite for all database professionals. More specific and advanced database skills and knowledge are required to operate specific platforms, including various Oracle products (such as the open source MySQL environment and Oracle itself), Microsoft SQL Server, IBM DB2 and more.

Database administration job openings will usually require an undergraduate degree. Degrees in information technology are the norm, and probably the most appropriate course of study. Bachelors degrees in computer science, engineering and even business administration can also gain a candidate entry into database management. Taking as many courses in database administration or management as possible will make the college transcripts more attractive to prospective employers. This may include coursework in several specific database packages, such as Oracle, IBM AS/400, SQL, and ETL. Some employers will hire entry-level database administrators who have a two-year associates’ degree in database administration, or possibly even a certificate in database management or a related IT subject. Some certificates can be acquired even before or during college. And a trade association for IT professionals in training is also available for students – CompTIA Student Membership.

A number of certifications for database administrators are offered by IBM, Microsoft and Oracle. Most of the vendor-specific certifications available are dedicated to the platforms offered by these three companies because they are by far the most popular database software producers today. Some of the certification programs for specific software frameworks include:

Oracle has multiple certifications and multiple expertise levels available for each certification. IBM also has several certifications available, primarily for the DB2, and various levels as well. Even if a current job doesn’t require knowledge of Oracle or Microsoft database programs, future opportunities may, so it’s always a good idea to expand technical horizons and enhance the resume with more certifications.

Vendor-neutral certifications, those not tied to a particular database software product, are not plentiful, but there are a few available. Some examples are:

Several colleges and technical schools also offer similar vendor-neutral database administrator certificate programs, as well as undergraduate and graduate certificate programs.

Step 2: Career Path

Entry-level positions are available for candidates with a bachelors degree, and sometimes even an associates degree or database administration certification. Sometimes called associate database administrator, these entry-level positions can kick off a career in several directions, not just database administrator. If database administration turns out to be the favored path, it can also lead to advancement into these careers:

  • information systems manager
  • computer systems analyst
  • data or database architect
  • database engineer
  • database developer
  • chief information officer

Step 3: Build a network of information technology professionals

As with nearly every profession, networking among industry professionals can be an invaluable aid in building a successful career. This may be especially true in computer science professions due to the constantly changing technologies. Networking and being a member of various industry trade associations can provide countless opportunities to keep current, including conventions, seminars, and other educational offerings often afforded by such organizations. Some of the trade associations relevant to database administration include the following:

Step 4: Keep up with a changing world

Database administrators must at all times be acquainted with the latest innovations in computer programming and database frameworks in order to be effective managers of data storage facilities. The abovementioned trade associations provide excellent access to advancements in technology, as will networking with other professionals. Keeping tabs on the latest announcements and product introductions from the primary database management framework providers, including IBM, Microsoft and Oracle, will mean no surprises with what’s available on the market. Professional certifications may also require period refreshing as products and technologies evolve, so it’s essential to update certifications whenever practical.

What is a database administrator?

DBAs have ultimate responsibility for designing and maintaining all aspects of an organization’s data storage facilities. Database administrators are often tasked with building a new database from the ground up, beginning with the design and construction of application specific customizations to a database platform, and the implementation of the new database. Data input and accumulation methods and protocols must be designed, access permissions granted and monitored, security protocols put in place and monitored, data integrity constantly analyzed, damage repaired, backup methods determined and maintained, program updates implemented, new data sources and data points integrated into the existing database, and new reporting requirements satisfied.

What does a database administrator do?

Database administrators are responsible for the storage, organization, presentation, utilization and analysis an organization’s database and database management software. Whatever the information storage needs of a company are, a database administrator strives to meet them. This can include setting up new computer databases or integrating data from old systems to new systems. And also responding to the changing information needs, whether it be new types of data being accumulated or different reporting or presentation needs of management. The database administrator must adapt the database software to accept new data points and produce new reports whenever necessary.

Responsibility for maintaining a fully functioning database also lies with the database administrator. DBAs must regularly perform routine tests and modifications to ensure that a database is performing and running correctly. If a problem occurs, a database administrator must analyze the programs and hardware to determine the problem, and then perform the necessary repairs or alterations. DBAs also must monitor access privileges, any unauthorized use, and making changes to permissions when required. Coordinating with infosec staff members, database administrators also must update security measures as internal security protocols are adjusted.

Database administrator job description

As the lead caretaker of all things database, a DBA’s responsibilities will include the following:

  • Install, configure, troubleshoot, and maintain a database system
  • Monitor and optimize system performance using index tuning, disk optimization, and other methods
  • Perform regular tests to ensure optimal database performance
  • Manage databases and permissions
  • Replicate and backup databases to ensure data integrity is maintained
  • Perform database mergers when a company transitions to a new system

Database administrator skills and experience

Job openings for database administrators list requirements for applicants that typically include the following:

  • Strong written and oral communication skills
  • Analytical thinker
  • Problem solver
  • Familiarity with one or more of the following relational database frameworks
    • Microsoft
    • IBM
    • Oracle
  • Knowledge of configuration management tools like ETL, BI, Puppet or Chef
  • Understand and formulate meaningful business metrics
  • Experience working with high-volume data platforms
  • Understand cloud storage and communication protocols
  • Knowledge of project management disciplines and methodology and change management
  • Experience with disaster recovery methods

Database administrator salary

According to Payscale.com, the average annual salary for a database administrator is about $73,000 as of October 2019. But experience and expanding skills can increase earning power considerably. Entry-level database administrators make an average of $53,000, while those with 20+ years experience earn nearly $100,000 on average.

Database administrator outlook

According to the U.S. Bureau of Labor Statistics (BLS), database administrator jobs are expected to grow 9% per annum between 2018 and 2028. This is due to the high demand for these professionals across a variety of industries. Information gathering and utilization is more than a growing trend, it’s an essential part of business survival in the 21st century.

Marketers and business leaders are now finding ways to garner much more information from service users and customers, especially from online venues. And the trend of amassing and leveraging more and more data is expected to continue for the foreseeable future. Database administrators (DBAs) will be one of the primary beneficiaries of this voracity for information and its many advantages.