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%
*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%
*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%
Computer Systems Analysts - U.S.24%
Management Analysts - U.S.18%
*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.254003623054190
Computer Systems Analysts - U.S.5029081190125460
Management Analysts - U.S.4520079870145920
*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
2 Program(s) Found
ECPI University , Greenville
  • Named a Best for Vets school by the Military Times in 2014.
  • Has specialized in student-centered technology, business, criminal justice, health science, and culinary education for over 45 years.
  • Makes it possible for students to earn a bachelor’s degree in 2.5 years or an associate’s in 1.5 years by providing a year-round schedule.
  • Offers externships and clinical experience that help students prepare for life after they graduate.
  • Has 10 campuses across the mid-Atlantic, plus online degree programs.
Show more [+]
Good for Working Adults
  • Flexible Scheduling
  • Accelerated Programs
  • Financial Aid
  • Transferable Credits
1 Program(s) Found
  • Offers a career-focused education with instructors who are professionals in their field.  
  • Dedicated Student Services Coordinators provide guidance and support throughout the program.
  • Provides a career services department that assists students and graduates with job placement, interviewing techniques, as well as resume and cover letter writing.
  • Offers a 24/7 technical hotline available to assist students whenever they need help.
  • Accredited by the Accrediting Council for Independent Colleges. 
Show more [+]
  • Online Courses
2 Program(s) Found
  • Students who qualify may apply for the Opportunity Scholarship, which can help lower education costs.
  • Offers career-focused, degree programs to over 70,000 students at over 140 ITT Technical Institutes in 35 states.
  • Classes are offered year-round, with day and evening course options.
  • Online courses can be accessed from anywhere, 24 hours a day.
  • Nationally accredited by the Accrediting Council for Independent Colleges and Schools.
Show more [+]
  • Financial Aid
  • Transferable Credits
1 Program(s) Found
Westwood College , Annandale
  • Dedicated to providing a hands-on, career-focused education since 1953.
  • Offers classes online, as well as at 14 campuses across California, Colorado, Georgia, Illinois and Virginia.
  • Develops curriculum with input from employers, subject matter experts.
  • Has small class sizes to promote one-on-one, student-teacher interaction.
  • Makes no-cost tutoring available in every subject to every enrolled student.
Show more [+]
  • Accredited
  • Accelerated Programs
  • Financial Aid
5 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.
  • Has 100+ locations and online options.
Show more [+]
Good for Working Adults
  • Online Courses
  • Flexible Scheduling
  • Financial Aid
2 Program(s) Found
MyComputerCareer.com , Indianapolis
  • Website features a free career evaluation to determine a student’s best course of study.
  • Offers certifications program with Microsoft, CompTIA, and Cisco.
  • Offers career assistance services to students.
  • Accredited by the Accrediting Council for Continuing Education and Training (ACCET).
  • 5 campuses located in Ohio, Texas, Indiana, and North Carolina.
Show more [+]
Good for Working Adults
  • Flexible Scheduling
  • Financial Aid
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
1 Program(s) Found
TrainACE , Greenbelt
  • Has grown to become one of the leading IT training organizations in the industry since its founding in Greenbelt, MD in 2001.
  • Recognized in 2013 for the EC-Council Circle of Excellence Award, an honor given to the top five accredited training centers in each region of the world.
  • Provides free resources, training and networking events, and downloadable webinars on its website.
  • Offers customized training for companies in 25 regions.
  • Approved or accredited by Maryland Higher Education Commission (MHEC).
Show more [+]
1 Program(s) Found
  • Instructors are industry-experienced professionals who offer their real-world expertise and give you insight into the current job market.
  • Offers career placement assistance, helping students prepare their resume, conduct job searches, and find employment after graduation.
  • Class sizes range from 10-25 students at a time allowing for more one-on-one instruction.
  • Curriculum developed and based on input from professionals in the areas of business, education, healthcare, art and design, legal studies, and various trades.
  • 6 campus locations across British Columbia.
Show more [+]
5 Program(s) Found
  • Ranked one of the Best Online Bachelor’s Programs in 2014 by U.S. News & World Report.
  • Offers a no-obligation, 3-week trial period where students may determine if the university is right for them before they commit to it.
  • Strives to be a student’s partner in lifelong learning; committed to helping them achieve their goals.
  • Serves students of all ages, from first-graders learning to read to professionals seeking postgraduate training.
  • Provides career-oriented diploma through master’s programs in fields such as healthcare, business, legal and paralegal services, information technology, criminal justice and design.
Show more [+]
5 Program(s) Found
  • Official training partner for technology leaders such as Microsoft, Cisco, CompTIA and VMware.
  • Flexible class options are available, including online options, private classes, on-site training, and traditional classroom learning.
  • World’s largest independent IT training company with 300 centers in 70 countries.
  • Became the first company to offer desktop application training in 1982.
  • The largest authorized provider of CompTIA training and certification in the world.
Show more [+]
5 Program(s) Found
ABCO Technology , Los Angeles
  • Prepares students to be employable in the field of IT as office managers, technicians, network administrators, developers, and webmasters.
  • Limits class sizes to no more than 8 students to ensure an efficient, thorough learning experience.
  • Offers employee training solutions to large companies.
  • Specializes in IT and Computer training programs.
  • Holds A+ certification from CompTIA.
  • Located in Los Angeles, approximately 10 minutes away from LAX.
Show more [+]
  • Financial Aid
5 Program(s) Found
  • Dedicated to providing high quality and cost effective training to the Detroit Metropolitan area since 1999.
  • Provides free seminars regularly to keep up with latest technology, as well a free digital copy of a career pathway guide.
  • Offers students help with their resume, interview techniques, networking opportunities, job search strategies, and more.
  • Has technical partners, including Microsoft, Cisco Systems, CompTIA, ORACLE, and IBM.
  • Accredited A+ rating from the Better Business Bureau (BBB).
Show more [+]
3 Program(s) Found
  • Ranked among the Best Online Bachelor's Programs in 2015 by U.S. News & World Report.
  • Designated as a 2015Military Friendy School by Victory Media.
  • Listed amongst the Best for Vets Colleges by Military Times 2 years in a row
  • Offers a network of technologically advanced campuses and online degree programs designed to provide a unique higher education.
  • 5 campuses located across Colorado.
Show more [+]
Good for Working Adults
  • Flexible Scheduling
  • Financial Aid
  • Transferable Credits
2 Program(s) Found
  • Offers computer training certification across several platforms, including computer repair, wireless computer training, IT consulting services, with database development covering Microsoft, Cisco, VMWare, Oracle, Java, and Linux.
  • Provides a variety of computer classes to people living in the metro Detroit, Michigan community.
  • Delivers numerous computer training classes for corporations throughout the United States, onsite at their location.   
  • Distributes complete technology services and solutions to companies all over the Detroit area.
  • Facility is located in Farmington Hills, Michigan.
Show more [+]
1 Program(s) Found

• Founded in 1984 by Dr. Harry L. Beck.
• Offers programs with various degree levels in allied health, business & technology, criminal justice, paralegal studies, and nursing.
• Career services help students and graduates with job search assistance, resume development, interview coaching, personalized career planning, and more.
• 2 campuses located in Tri-County Cincinnati, Ohio and Florence, Kentucky, with online options as well.
• Approved A+ rating from the Better Business Bureau (BBB) since 2008.

Show more [+]
  • Accredited
  • Financial Aid
  • Transferable Credits
1 Program(s) Found
  • Recognized on the President's Higher Education Community Service Honor Roll every year from 2010-2014
  • Day and evening classes are available for flexible scheduling.
  • Offers bachelor’s, associate, and diploma programs in business, culinary arts, criminal justice, cosmetology, and more.
  • Takes a unique “Focused Learning” approach, where students typically take only one class per month to concentrate on one subject with one faculty member at a time.
  • Accredited by the Accrediting Council on Independent Colleges and Schools (ACICS).
Show more [+]
Good for Working Adults
  • Accredited
  • Flexible Scheduling
  • Financial Aid
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
1 Program(s) Found
Vatterott College , Saint Charles
  • Dedicated to providing career training to students since 1969.
  • Ranks in the top 15% of all U.S. schools providing military educational services.
  • Offers programs in  19 locations in 9 states, as well as online.
  • Provides a career services team to help students with resume review, mock interviewing, campus career fairs, and more.
  • Gives students the opportunity to study business, personal fitness, cosmetology, and more.
Show more [+]
Good for Working Adults
  • Accredited
  • Flexible Scheduling
  • Financial Aid
  • Transferable Credits
1 Program(s) Found
  • Offers classes built around small teams, so students get personal, one-on-one skills training.
  • Has 100 campuses— many of which are on or near public transportation routes.
  • Provides trained student finance planners to assist students seeking financial aid.
  • Incorporates hands-on training into all programs to provide students with important experience.
  • Provides day, evening, and weekend classes. (Classes offered may vary by location.)
Show more [+]
  • Accredited
  • Financial Aid
Computer Training Centers Finder
Certifications Training Degrees
Connect with Schools & Programs