dcsimg

How to Become a Database Administrator

How does a bank update your checking account information instantaneously when you pay a utility bill online? How are you able to track the delivery of a parcel containing your new purchase from an electronics factory in Asia? And, how do online retailers know exactly what items you might be interested in purchasing, based on what you've browsed and bought before?

The answer to all of these questions is: somewhere, a database administrator has done their job.

Database administrators (DBAs for short) tackle challenges like these and other critical functions on a regular basis, placing them among the tech elite in many organizations. The relational database has been a tool of the public and private sectors for decades, but the growth of Internet commerce, social networking and online government-citizen interaction over the last two decades has resulted in an explosion of database growth, activity and expanding functionality.

This explosive growth has had a direct impact on the demand for DBAs. It has also created a subset of data management specialties which all stem from the field of database administration.

It takes an extensive amount of IT training and experience to join the prestigious ranks of database admins. But, the effort can result in a highly-rewarding and fulfilling career path.

Ready to start pursuing your tech degree?
Search our school directory to find the right program for you.

  1. SQL Developer
  2. Database Administrator
  3. Database Developer
  4. Database Designer
  5. Database Security Administrator

What does a SQL developer do?

SQL developers are specialized database workers who create and work with the underlying code that makes databases more than just static bins of bits and bytes. SQL, which stands for Structured Query Language, is a programming language used to search, store, and retrieve information from databases. SQL developers use this language to create and maintain databases. Depending on their job scope, a SQL dev might be responsible for the following tasks.

  • Developing SQL databases
  • Creating applications to work with SQL databases
  • Creating and testing modifications to database structures

SQL devs can be employed in a multitude of industries, as well as in various branches of government. Other SQL devs may work in finance, enterprise management, information firms, or education services.

Strong analytical and problem-solving skills are important qualities of SQL devs. Effective communication is also key, as SQL devs may be part of a larger development team, or may have to work closely with business owners or vendors as a part of their job.

Return

What does a database administrator do?

A DBA manages and maintains complex software and file storage systems. Databases drive business. Nearly every company in the United States relies on a database of some kind, ranging from off-the-shelf organizational software to powerful, custom accounting and manufacturing solutions. DBAs perform the following functions:

  • Define the parameters of each database in a company's platform.
  • Ensure access, up-time and data integrity.
  • Manage both the physical equipment and the software required to maintain complex databases.
  • Defend data platforms against threats from external sources and internal failures.

Senior DBAs often act as system architects, envisioning the combination of hardware and software required to meet an employer's needs. Mid-tier DBAs often partner with project teams tasked with digging into complex data for insight into company operations. Entry-level DBAs handle routine chores like archiving, optimizing and backing up large database storage volumes. Most of the work happens at a computer workstation, but DBAs increasingly participate in company planning and project meetings.

Ready to start pursuing your tech degree?
Search our school directory to find the right program for you.

Return

What does a database programmer do?

Database programmers write code, perform quality assurance checks and design the protocols of enterprise access to a database or data warehouse environment. Nearly all companies that make extensive use of a database need a dedicated professional on staff to ensure it stays in proper working order. DB programmers write scripts, functions and stored procedures that define the parameters by which employees access database information. Database development tools can vary, and the specific coding tasks of a DB programmer will differ from framework to framework.

With the rise of data warehousing and the business intelligence field, DB programmers may find themselves working with Online Transaction Processing (OLTP), for traditional relational databases, or Online Analytical Processing (OLAP), for enterprise data warehouse systems. The sets of skills appropriate to these two different types of data environment are nearly opposite, despite the similarity in their titles.

Return

What does a database designer do?

Database designers, also known as database architects, develop strategies for the design, modeling and implementation stages of the database lifecycle. They design database infrastructure and applications -- including interfaces, data partitions, global temporary tables and function-based index mechanics -- to ensure efficient database operation. Many of these designers work to create enterprise solutions, and each business or industry has its own set of IT requirements. Professionals with database designer training often collaborate with software architects and system analysts to understand and best address the particular needs of certain businesses or industries.

DB architects draw the blueprints of a database, which technicians and other specialists then use to put the technology together. Here are some of the key goals that influence the design of strong systems:

  • Demonstrate technical functionality such as reliability, security and performance
  • Provide support for business applications to promote performance and system scalability
  • Organize load-balancing processes for efficient system backup
  • Produce intuitive standardized procedures for query and archiving

DB architects also develop data models, metadata tables and related database structures for applications.

Return

What does a database security administrator do?

Database security admins ensure the safe storage and transfer of vital business and personal information. Basic tasks include managing the availability and confidentiality of data, as well as the installation, troubleshooting and monitoring of core security technologies and network devices. These IT professionals are also known by similar titles such as data security admins or information security analysts, according to the Department of Labor's Occupational Information Network or O*NET website.

DB security admins often work at small or medium-sized companies, since the amount of data is usually manageable enough for the roles of administration and database security personnel to be combined. Enterprise and government data environments that handle large banks of sensitive information generally divide data management and security tasks between teams of professionals specialized to each job class.

Here are a few of the responsibilities that DB security admins handle:

  • Encrypting data transmissions and erecting hardware and software firewalls.
  • Installing and managing software for database security analysis.
  • Monitoring and reviewing violations of database security procedures.
  • Performing risk assessments to determine the effectiveness of security measures.
  • Training database users in secure access procedures.

It's also important for DB security admins to be able to communicate with network and computer systems security specialists, in order to build strong multi-level security infrastructures and policies.

These roles require extensive technological experience, and admins may work with software such as the following:

  1. Authentication server software
  2. Internet directory service software
  3. Network monitoring applications
  4. Network security programs
  5. Transaction security or virus protection tools
  6. Virtual private network (VPN) management tools

Return

Ready to start pursuing your tech degree?
Search our school directory to find the right program for you.

Courses and industry standards

Though BLS data suggest that vendor accreditation is the industry standard for database administration training, IT pros really drive the point home.

Craig Thorstead has more than 14 years of hands-on experience working as a DBA. He recently told Certification Magazine that accreditation is necessary for both entry- and advanced-level database administrators.

"I think in today's world, [certs are] becoming more critical," he said.

Thorstead specifically recommends that those just getting started in database administration training go for CIW Database Design Specialist accreditation. This course provides general introductory training to database specialization while remaining vendor-neutral, making it a good way to prepare for further training, according to CIW information.

The Oracle Certified Associate (OCA) cert is also a good option for those seeking entry-level database administration training. The vendor suggests that this cert is best for "users that know the basics, but have not yet obtained the experience gained by professional MySQL DBAs or Developers." This database administration course includes several exams, including one about SQL and another covering basic database management. There are also a number of more advanced Oracle certs for database administrators, ranging from the mid-level Oracle Certified Master (OCM) and Oracle Certified Professional (OCP) to Oracle Certified Expert (OCE).

Software giant Microsoft is also part of the DBA scene, with Microsoft SQL Server database administration courses and accreditation available ranging from Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) to the terminal Microsoft Certified Master (MCM) certifications.

Additionally, the Certification Magazine report shows that database administration training and certifications are also available for MySQL. Offerings include the entry-level Associate and more advanced DBA and Cluster DBA.

What training is necessary to become a database administrator?

The average education requirement for DBAs is a bachelor's degree in computer science, computer information systems, or a similar computer-related discipline. Some entry-level DBA positions may call for only a two-year certificate program in database administration, while more advanced positions can require a master's degree specializing in database management.

What training is necessary to become a database programmer?

Most DB programmers entering the industry will need to have a bachelor's degree in computer science, computer programming, mathematics, or a similar field. However, there are also a number of shorter associate degrees in database programming/development available from some colleges and technical schools. More advanced positions may call for a master's degree in software engineering.

Most database development courses offer a detailed analysis of database design and function. Here's a list of components that are usually covered:

  • Database architecture
  • Normalization
  • Database security
  • Data modeling
  • Web applications

Alongside these fundamentals, students dive deeply into SQL, including such aspects as error handling, data partitioning and working with user-defined functions.

What training is necessary to become database designer?

The role of DB designer is related to a number of education options. A bachelor's degree in computer engineering, software programming, or information systems are all applicable to this job role. Greater specialization in the form of designing database management software systems may be gained through associate degrees from colleges and technical schools.

What training is necessary to become a database security administrator?

A database security admin is, in essence, a specialized DBA who focuses on database security. As such, the education requirements for these two job roles are similar: a bachelor's degree in computer science, computer engineering, software engineering, or a related field. However, because of the increasing complexity of online attacks, many employers may prefer a specialized technical degree in information system security or advanced information security training.

Return

Ready to start pursuing your tech degree?
Search our school directory to find the right program for you.
*This data is sourced from the 2013 BLS employment report (BLS.gov)

What is the job outlook for DBAs?

According to a Forrester Research report, global businesses spend more than $3.5 trillion on their information technology budgets every year. Even though that figure represents growth in four of the last five years, corporate spending on outsourcing and consulting has slowed as hiring managers focus more of their resources on building a bench of strong internal IT professionals.

Recruiters and hiring managers may take longer to fill an open database job, but they're often more willing to pay for top talent and a long-term commitment. Since few companies have ways to cultivate DBA talent internally, recruiters almost always look outside an organization to fill empty jobs.

Job TitleProjected 2012-2022 Growth
Database Administrators-U.S.15.1
*This data is sourced from the 2013 BLS employment report (BLS.gov)

What is the salary for DBAs?

The most recent salary information from the BLS indicates that many DBAs earn more than workers in other professions. Compensation levels can be further influenced by total education, experience and relevant industry certifications.

*This data is sourced from the 2013 BLS employment report (BLS.gov)

What's the job outlook for database programmers?

According to the BLS, jobs for computer programmers are expected to grow by 8 percent from 2012 to 2022, which is the average for all occupations in the US. DB programmers are a more specialized type of computer programmer, which makes these jobs less vulnerable to being shipped offshore to regions with lower prevailing wages.

Job TitleProjected 2012-2022 Growth
Computer Programmers-U.S.8.3
*This data is sourced from the 2013 BLS employment report (BLS.gov)

What is the salary for database programmers?

Data from the BLS shows the median annual wage for computer programmers (of which database programmers are a subset) is consistent with the larger group of all computer occupations.

*This data is sourced from the 2013 BLS employment report (BLS.gov)

What's the job outlook for database designers?

O*NET data suggests that the largest number of database designers tend to find employment in government positions, designing systems to house several specific types of vital data.

Database designers may find employment in a variety of industries, as in the top five fields listed by the BLS:

  1. Computer systems design and related services
  2. Management of companies and enterprises
  3. Insurance carriers
  4. Colleges, universities and professional schools
  5. Management, scientific and technical consulting agencies

Other information services, including data hosting and processing firms, also represent a large portion of employment for database specialists. Candidates should expect stiff competition for especially lucrative positions, but overall job prospects should be excellent.

Job TitleProjected 2012-2022 Growth
Insurance Claims and Policy Processing Clerks-U.S.8.1
Computer Systems Analysts-U.S.24.5
Management Analysts-U.S.18.6
*This data is sourced from the 2013 BLS employment report (BLS.gov)

What's the salary for database designers?

Some database administrators may be responsible for database design, but usually this task is performed by specialized database designers. The BLS includes these designers in the applications software developer category, and these professionals earned a mean annual salary of:

Job TitleBottom 10% Annual WageAnnual Median WageTop 10% Annual Wage
Insurance Claims and Policy Processing Clerks-U.S.255503674055930
Computer Systems Analysts-U.S.5078082710129980
Management Analysts-U.S.4536080880148110
*This data is sourced from the 2013 BLS employment report (BLS.gov)

What's the job outlook for database security admins?

According to the BLS, job opportunities for database administrators and information security analysts are expected to increase much faster than the nationwide average for all occupations between 2008 and 2018. Some industries employ a higher number of data security administrators than others.

Job Title
Information Security Analysts-U.S.
*This data is sourced from the 2013 BLS employment report (BLS.gov)

What's the salary for database security admins?

Salaries for database security administrator positions can also vary by industry. Typically, job sectors with fewer staffed positions offer higher wages.

*This data is sourced from the 2013 BLS employment report (BLS.gov)

Return

Beyond university education, one method that database professionals can use to distinguish themselves is to earn one or more industry certifications. IT certifications are available from a number of vendors and vendor-neutral organizations. Some of the vendors of database management systems who offer certifications for their products include Microsoft, Oracle and IBM.

The value of IT certification cannot be overstated. One key finding from the "Microsoft Certification Program Satisfaction Study" (published in April 2012) says it best:

"91 percent of hiring managers consider certification as part of their hiring criteria."

Quite simply, earning a database-related certification is one of the best ways to show a potential employer that you have the skills and knowledge necessary to benefit their organization.

Ready to start pursuing your tech degree?
Search our school directory to find the right program for you.

How to Become a Database Administrator

Searching Searching ...

Matching School Ads
1 Program(s) Found
  • Ranked among top Regional Universities in the South by U.S. News and World Report in 2015.
  • Ranked 37th among the Best Colleges for Veterans by U.S. News and World Report in 2015.
  • Stands as the largest private, nonprofit university in the nation with 100,000+ students.
  • Offers over 230 programs online, from the certificate to the doctoral level.
  • Has a student-faculty ratio of 25:1, and 42.3% of its classes have fewer than 20 students.
Show more [+]
  • Accredited
  • Online Courses
  • Financial Aid
  • Transferable Credits
2 Program(s) Found
  • Average class size is 25, allowing for more one-on-one time with instructors.
  • Has a 97% employment rate among available graduates.
  • All  graduates receive Lifetime Employment  Assistance—free and forever.
  • Michigan's largest independent college.
  • Most instructors are working professionals in the fields they teach.
  • Programs are continuously updated to ensure classes are career-relevant and in sync with what's needed in the industry
Show more [+]
Good for Working Adults
  • Accredited
  • Online Courses
  • Flexible Scheduling
  • Accelerated Programs
  • Financial Aid
  • Transferable Credits
4 Program(s) Found
  • 95% alumni satisfaction rate.
  • Currently holds more than 500 professional alliances, including 19 of the top Fortune 100 companies.
  • Courses are taught by expert faculty, with 86% of professors possessing a doctoral degree.
  • Offers credit for prior experience and learning, as well as scholarships, accelerated programs, and several other ways to help reduce tuition costs.
  • Regionally accredited by the Higher Learning Commission (HLC) of the North Central Association (NCA).
Show more [+]
  • Online Courses
  • Financial Aid
  • Transferable Credits
5 Program(s) Found
  • Online school designated as a 2015 Military Friendly School by Victory Media.
  • Commited more than $60 million in tuition savings in 2015 through scholarships.
  • Active-duty military, veterans, and Veteran’s Administration employees can save 15% on tuition.
  • Offers 24/7 student services, including financial aid help, course registration, and career counseling.
  • Regionally accredited by the Higher Learning Commission (HLC) of the North Central Association (NCA).
Show more [+]
  • Online Courses
  • Financial Aid
  • Transferable Credits
3 Program(s) Found
  • Regionally accredited, Florida Tech offers in-demand undergraduate degrees 100% online.
  • No SAT or ACT or application fee required. Special military pricing available.
  • Small class sizes give you ample opportunity to interact one on one with your professors and other students.
  • Earn the same diploma as on-campus students, around your busy schedule. No campus attendance required and no set login times allows you to study anytime, anywhere 24/7 so it is convenient for you.
  • Ranked a Tier 1 Best National University by U.S. News & World Report and ranked as one of the top 200 universities in the world by Times Higher Education.
  • In-demand undergraduate degrees available - 100% online in fields like, aviation management, business administration, criminal justice, marketing and more.
  • Online Courses
1 Program(s) Found
  • Ranked among the Best Grad Schools for Physician Assistants in 2015 by U.S. News and World Report.
  • Dedicated to delivering quality education and personalized attention to students since 1899.
  • Provides a range of campus experiences and services online including advising, tutoring, student community, and career services.
  • Offers counseling services and a 24/7 crisis hotline to students at no extra charge.
  • Gives students and alumni access to career assistants who help with resumes, cover letters, job hunting, and more.
Show more [+]
Good for Working Adults
  • Online Courses
  • Flexible Scheduling
  • Financial Aid
  • Transferable Credits
5 Program(s) Found
ABCO Technology , Los Angeles
  • An accredited computer training academy preparing students to enter the IT industry as Network Engineers, Software Engineers, Web Apps Developer, Website Designers, Programmers, Database Administrators since 2000.
  • Holds A+ certification from CompTIA.
  • Located in Los Angeles, approximately 10 minutes away from LAX.
  • Flexible class schedules offered during day times, evenings and weekends.
  • Helping students start a career in technology within 3 - 9 months.
  • Educates with the mission to serve the needs of the local community and graduates by matching opportunities to skills.
  • Military friendly school.
Show more [+]
  • Financial Aid
2 Program(s) Found
University of Phoenix , Online (campus option available)
  • Provides career services that help students find careers that match their interests and map out a personalized career plan.
  • Offers mentorships and networking opportunities through an Alumni Association of 800,000+ graduates.
  • Has flexible start dates and class schedules.
  • Offers special military rates and special advisors who have a military background.
  • Gives students the chance to earn credits for applicable military training and education.
  • Locations nationwide and online options.
Show more [+]
Good for Working Adults
  • Online Courses
  • Flexible Scheduling
  • Financial Aid
1 Program(s) Found
  • Has students attend one four-week class at a time and take their final exam before moving on to their next class.
  • Offers 24/7 online tech support, with a typical response time of 4 hours or less.
  • Has online help centers that offer assistance with writing, statistics, medical assisting, and more.
  • Provides job placement assistance to all its students and alumni.
  • Researches trends for growing fields to tailor a more effective curriculum.
Show more [+]
Good for Working Adults
  • Accredited
  • Online Courses
  • Flexible Scheduling
  • Financial Aid
  • Transferable Credits
1 Program(s) Found

•     Ranked among the Best Online Bachelor’s Programs and Best Online MBA Programs in 2015 by U.S. News & World Report.

•     Listed among The Princeton Review’s 2015 Best Midwestern Colleges.

•     Student-to-faculty ratio of 11:1, with most classes ranging from 10 to 19 students.

•     Online library offers 75,000 e-Books, 90,000 full-text electronic journals, and 101 databases services, available 24/7.

•     Regionally accredited by the Higher Learning Commission (HLC) of the North Central Association (NCA).

Show more [+]
  • Online Courses
1 Program(s) Found
  • Approved by the Better Business Bureau (BBB) with an A+ rating since 2010.
  • Established its main campus in Fremont, California, with satellite campuses in San Jose and Sacramento.
  • Offers programs in medical assisting, pharmacy technology, vocational nursing, and more.
  • Accredited by the ACCSC, with approval from the California Board of Vocational Nursing and Psychiatric Technicians and the Board of Registered Nursing.
Show more [+]
Good for Working Adults
  • Flexible Scheduling
  • Financial Aid
  • Transferable Credits
1 Program(s) Found
  • Ranked among the 2015 Best Online Graduate Education Programs by U.S. News & World Report.
  • Awarded 21 institutional scholarships in 2013, totaling over $76,000 in tuition.
  • Offers several certificate programs where students can earn credits without committing to a full degree program.
  • Accredited by the Higher Learning Commission (HLC) of the North Central Association (NCA).
  • Part of the Colorado State University System.
Show more [+]
  • Online Courses
  • Financial Aid
  • Transferable Credits
1 Program(s) Found
  • Designated as a 2015 Military Friendly® School by Victory Media, publishers of G.I. Jobs®.
  • Each program is designed to instill the knowledge, ethical values, and interpersonal skills of professional practice and to foster values of social responsibility.
  • Offers several flexible learning options, including a blended format that combines campus and online learning.
  • Several scholarship opportunities are available for students who qualify.
  • Features a competency-based MBA program that allows students to test out of subjects based on prior professional experience.
Show more [+]
Good for Working Adults
  • Online Courses
  • Flexible Scheduling
  • Financial Aid
  • Transferable Credits
  • Ranked among the Best National Universities in 2014 & 2015 by U.S. News & World Report.
  • Ranked #7 Best College for Veterans in 2015 by U.S. News & World Report.
  • Has over 240,000 alumni on record, including Joseph Biden, Stephen Crane, Dick Clark, and Joyce Carol Oates.
  • Offers study abroad programs in several countries all over the world.
  • Has achieved accreditation from the Middle States Commission on Higher Education (MSCHE).
  • Its main campus is located in Syracuse, New York, with extended campuses in a number of major metro cities including Washington, D.C., Los Angeles, New York City, and more.
Show more [+]
Good for Working Adults
  • Accredited
  • Online Courses
  • Flexible Scheduling
  • Accelerated Programs
  • Financial Aid
  • Transferable Credits
  • Founded in Southern California in 1998 by dog training expert Steven Appelbaum.
  • The largest independent dog training company in the United States.
  • Offers 11-stage programs that feature an in-home study component along with a hands-on training module.
  • A member of the MyCAA Financial Assistance program, which offers eligible military spouses up to $4,000 of tuition assistance that can be used towards any of their courses.
  • Helps graduates find employment and coaches those who are looking to start their own business.
Show more [+]
  • Online Courses
  • Ranked 25th among the Best National Universities in 2015 by U.S. News & World Report.
  • One of the world’s leading private research universities.
  • Its student-faculty ratio is 9:1, and 56.8% of its classes have fewer than 20 students.
  • Has an average freshman retention rate, an indicator of student satisfaction, of 96.8 percent.
  • Dedicated to a strong tradition of integrating liberal and professional education since 1880.
  • Its faculty includes National Academy members, Nobel Laureates, MacArthur Fellows, and more.
Show more [+]
  • Online Courses
  • Ranked among the Best National Universities in 2015 by U.S. News & World Report.
  • Designated as a 2014 Military Friendly School by Victory Media.
  • Houses one of the largest library systems in the Pacific Northwest, with 3 libraries on the Pullman campus and a library at each regional campus.
  • Accredited by the Northwest Commission on Colleges and Universities (NWCCU).
  • Has 5 Washington campuses in Pullman, Spokane, Tri-Cities, Vancouver, and Everett.
Show more [+]
  • Accredited
  • Online Courses
  • Financial Aid
  • Transferable Credits
  • Students can complete an entry-level technician program in about a year, and manufacturer training and graduate in as little as 18 months.
  • Provides technical education training programs for automotive, diesel, collision repair, motorcycle, and marine technicians.
  • Partners with many well-known manufacturers, including General Motors, Porsche Cars North America Inc., and BMW of North America LLC.
  • Offers internships to students and alumni for first-hand experience.
  • Accredited by the Accrediting Commission of Career Schools and Colleges (ACCSC).
Show more [+]
  • Financial Aid
  • Some campuses host low-cost medical and dental clinics, where students can get real-world experience.
  • Designated as 2015 Military Friendly School by Victory Media.
  • Approved A+ rating from the Better Business Bureau (BBB) since 1976.
  • Campus-specific accreditation from the Accrediting Council for Independent Colleges and Schools (ACICS), Accrediting Commission of Career Schools and Colleges (ACCSC), and the Council on Occupational Education (COE).
  • 16 campus locations across the United States.
Show more [+]
  • Financial Aid

American University’s Kogod School of Business has been educating business leaders since opening its doors in 1955 as Washington D.C.’s first university-level school of business. Faculty members are scholars who are dedicated to fostering collaborative learning environments.

  • Online Courses
Table of Contents

Ready to Advance your Career
Enroll Now
Connect with Schools & Programs