Summary Report for:
15-1141.00 - Database Administrators
Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases.
Sample of reported job titles: Database Administration Manager, Database Administrator (DBA), Database Analyst, Database Coordinator, Database Programmer, Information Systems Manager, Management Information Systems Director (MIS Director), Programmer Analyst, Systems Manager
Tasks | Tools & Technology | Knowledge | Skills | Abilities | Work Activities | Detailed Work Activities | Work Context | Job Zone | Education | Credentials | Interests | Work Styles | Work Values | Related Occupations | Wages & Employment | Job Openings | Additional Information
- Test programs or databases, correct errors, and make necessary modifications.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
- Work as part of a project team to coordinate database development and determine project scope and limitations.
- Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
- Train users and answer questions.
- Specify users and user access levels for each segment of database.
- Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.
- Review project requests describing database user needs to estimate time and cost required to accomplish project.
- Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
- Review procedures in database management system manuals for making changes to database.
- Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
- Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
- Select and enter codes to monitor database performance and to create production database.
- Establish and calculate optimum values for database parameters, using manuals and calculator.
Tools & Technology
Tools used in this occupation:
- Desktop computers
- Hard disk arrays — Redundant array of independent disks RAID systems
- Hard disk drives
- Mainframe computers
- Notebook computers
- Tape arrays — Tape libraries
Technology used in this occupation:
- Access software — Access management software; Citrix software
- Analytical or scientific software — SAS software; StataCorp Stata; Test data generator software; The MathWorks MATLAB (see all 7 examples)
- Application server software — Oracle WebLogic Server; Red Hat WildFly
- Backup or archival software — Acronis Recovery Expert; BMC Software Control-M software; Oracle Data Guard; VERITAS NetBackup (see all 11 examples)
- Business intelligence and data analysis software — IBM Cognos Impromptu; MicroStrategy software; Oracle Business Intelligence Enterprise Edition; Tableau software (see all 6 examples)
- Clustering software — Cluster server software; Oracle Real Application Cluster RAC
- Communications server software — IBM Domino
- Computer based training software
- Configuration management software — Deployment software; Puppet
- Data base management system software — Apache Cassandra; Apache Hadoop; MongoDB; Sybase Replication Server (see all 23 examples)
- Data base reporting software — Microsoft SQL Server Reporting Services; Oracle SQL Plus; ReCrystallize Crystal Reports; SAP Crystal Reports (see all 6 examples)
- Data base user interface and query software — Microsoft Access; Oracle JDBC; Structured query language SQL; Teradata Active Enterprise Data Warehouse (see all 9 examples)
- Desktop publishing software — Microsoft Publisher
- Development environment software — Eclipse software; Microsoft .NET Framework; Microsoft Visual Basic; Prolog (see all 10 examples)
- Electronic mail software — IBM Notes; Microsoft Exchange Server; Microsoft Outlook
- Enterprise application integration software — Extensible markup language XML; IBM InfoSphere DataStage; IBM WebSphere; Microsoft SQL Server Integration Services SSIS
- Enterprise resource planning ERP software — Microsoft Dynamics software; Oracle Hyperion software; Oracle JD Edwards EnterpriseOne; SAP BusinessObjects software (see all 8 examples)
- Enterprise system management software — IBM Power Systems software; Splunk Enterprise
- Financial analysis software — Delphi software; Oracle E-Business Suite Financials
- Graphics or photo imaging software — Adobe Systems Adobe Flash; Microsoft Visio
- Human resources software — Human resource management software HRMS; Oracle Learning Management OLM software
- Information retrieval or search software — Data validation software
- Metadata management software — CA Erwin Data Modeler; Data mapping software; Data modeling software; Visual Paradigm DB Visual ARCHITECT (see all 6 examples)
- Network monitoring software — Nagios; Wireshark
- Network security and virtual private network VPN equipment software — Virtual private networking VPN software
- Network security or virtual private network VPN management software — Database security software
- Object or component oriented development software — Advanced business application programming ABAP; Microsoft ActiveX; Python; Sybase PowerBuilder (see all 11 examples)
- Object oriented data base management software — Hibernate ORM; Object database management system ODBMS software; PostgreSQL software; Transact-SQL (see all 5 examples)
- Office suite software — Microsoft Office software
- Operating system software — Hewlett Packard HP-UX; Job control language JCL; Red Hat Enterprise Linux; UNIX (see all 11 examples)
- Portal server software — Apache HTTP Server
- Presentation software — Microsoft PowerPoint
- Program testing software — Computer Associates Log Analyzer; Database testing software
- Project management software — Microsoft Project; Microsoft SharePoint software; Oracle Primavera Enterprise Project Portfolio Management software
- Requirements analysis and system architecture software — Database capacity planning software; Unified modeling language UML
- Spreadsheet software — Microsoft Excel
- Storage networking software — Storage area network SAN software
- Transaction security and virus protection software — Encryption software; McAfee software; Symantec security software
- Transaction server software — Customer information control system CCIS
- Web page creation and editing software — Adobe Systems Adobe Dreamweaver
- Web platform development software — Apache Tomcat; Dynamic hypertext markup language DHTML; Oracle JavaServer Pages JSP; Spring Framework (see all 16 examples)
- Word processing software — Microsoft Word
- Computers and Electronics — Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
- Customer and Personal Service — Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
- English Language — Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
- Mathematics — Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
- Clerical — Knowledge of administrative and clerical procedures and systems such as word processing, managing files and records, stenography and transcription, designing forms, and other office procedures and terminology.
- Complex Problem Solving — Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
- Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
- Monitoring — Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
- Active Learning — Understanding the implications of new information for both current and future problem-solving and decision-making.
- Active Listening — Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
- Reading Comprehension — Understanding written sentences and paragraphs in work related documents.
- Judgment and Decision Making — Considering the relative costs and benefits of potential actions to choose the most appropriate one.
- Operations Analysis — Analyzing needs and product requirements to create a design.
- Speaking — Talking to others to convey information effectively.
- Systems Analysis — Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
- Coordination — Adjusting actions in relation to others' actions.
- Programming — Writing computer programs for various purposes.
- Systems Evaluation — Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
- Time Management — Managing one's own time and the time of others.
- Writing — Communicating effectively in writing as appropriate for the needs of the audience.
- Instructing — Teaching others how to do something.
- Social Perceptiveness — Being aware of others' reactions and understanding why they react as they do.
- Problem Sensitivity — The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem.
- Information Ordering — The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).
- Deductive Reasoning — The ability to apply general rules to specific problems to produce answers that make sense.
- Inductive Reasoning — The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
- Oral Comprehension — The ability to listen to and understand information and ideas presented through spoken words and sentences.
- Category Flexibility — The ability to generate or use different sets of rules for combining or grouping things in different ways.
- Near Vision — The ability to see details at close range (within a few feet of the observer).
- Oral Expression — The ability to communicate information and ideas in speaking so others will understand.
- Speech Clarity — The ability to speak clearly so others can understand you.
- Written Comprehension — The ability to read and understand information and ideas presented in writing.
- Flexibility of Closure — The ability to identify or detect a known pattern (a figure, object, word, or sound) that is hidden in other distracting material.
- Selective Attention — The ability to concentrate on a task over a period of time without being distracted.
- Fluency of Ideas — The ability to come up with a number of ideas about a topic (the number of ideas is important, not their quality, correctness, or creativity).
- Mathematical Reasoning — The ability to choose the right mathematical methods or formulas to solve a problem.
- Speech Recognition — The ability to identify and understand the speech of another person.
- Written Expression — The ability to communicate information and ideas in writing so others will understand.
- Originality — The ability to come up with unusual or clever ideas about a given topic or situation, or to develop creative ways to solve a problem.
- Perceptual Speed — The ability to quickly and accurately compare similarities and differences among sets of letters, numbers, objects, pictures, or patterns. The things to be compared may be presented at the same time or one after the other. This ability also includes comparing a presented object with a remembered object.
- Interacting With Computers — Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
- Analyzing Data or Information — Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
- Processing Information — Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
- Getting Information — Observing, receiving, and otherwise obtaining information from all relevant sources.
- Documenting/Recording Information — Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form.
- Making Decisions and Solving Problems — Analyzing information and evaluating results to choose the best solution and solve problems.
- Organizing, Planning, and Prioritizing Work — Developing specific goals and plans to prioritize, organize, and accomplish your work.
- Communicating with Supervisors, Peers, or Subordinates — Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
- Updating and Using Relevant Knowledge — Keeping up-to-date technically and applying new knowledge to your job.
- Provide Consultation and Advice to Others — Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.
- Evaluating Information to Determine Compliance with Standards — Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.
- Monitor Processes, Materials, or Surroundings — Monitoring and reviewing information from materials, events, or the environment, to detect or assess problems.
- Thinking Creatively — Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
- Interpreting the Meaning of Information for Others — Translating or explaining what information means and how it can be used.
- Training and Teaching Others — Identifying the educational needs of others, developing formal educational or training programs or classes, and teaching or instructing others.
- Establishing and Maintaining Interpersonal Relationships — Developing constructive and cooperative working relationships with others, and maintaining them over time.
- Identifying Objects, Actions, and Events — Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
- Coaching and Developing Others — Identifying the developmental needs of others and coaching, mentoring, or otherwise helping others to improve their knowledge or skills.
- Developing Objectives and Strategies — Establishing long-range objectives and specifying the strategies and actions to achieve them.
- Developing and Building Teams — Encouraging and building mutual trust, respect, and cooperation among team members.
- Judging the Qualities of Things, Services, or People — Assessing the value, importance, or quality of things or people.
Detailed Work Activities
- Analyze data to identify trends or relationships among variables.
- Analyze market or customer related data.
- Develop performance metrics or standards related to information technology.
- Develop detailed project plans.
- Create databases to store electronic data.
- Implement security measures for computer or information systems.
- Modify software programs to improve performance.
- Coordinate project activities with other personnel or departments.
- Update computer database information.
- Develop computer or information security policies or procedures.
- Develop models of information or communications systems.
- Read documents to gather technical information.
- Assess database performance.
- Develop database parameters or specifications.
- Write computer programming code.
- Coordinate software or hardware installation.
- Develop guidelines for system implementation.
- Train others in computer interface or software use.
- Estimate time or monetary resources needed to complete projects.
- Electronic Mail — 100% responded “Every day.”
- Telephone — 97% responded “Every day.”
- Indoors, Environmentally Controlled — 95% responded “Every day.”
- Contact With Others — 79% responded “Constant contact with others.”
- Spend Time Sitting — 70% responded “Continually or almost continually.”
- Face-to-Face Discussions — 57% responded “Every day.”
- Importance of Being Exact or Accurate
- Structured versus Unstructured Work — 54% responded “Some freedom.”
- Freedom to Make Decisions — 54% responded “Some freedom.”
- Work With Work Group or Team — 43% responded “Extremely important.”
- Spend Time Making Repetitive Motions — 48% responded “More than half the time.”
- Importance of Repeating Same Tasks — 35% responded “Very important.”
- Spend Time Using Your Hands to Handle, Control, or Feel Objects, Tools, or Controls — 37% responded “Continually or almost continually.”
- Deal With External Customers — 62% responded “Very important.”
- Duration of Typical Work Week — 73% responded “40 hours.”
- Time Pressure — 58% responded “Once a month or more but not every week.”
- Coordinate or Lead Others — 22% responded “Important.”
- Consequence of Error — 32% responded “Extremely serious.”
- Letters and Memos — 21% responded “Every day.”
- Responsibility for Outcomes and Results — 44% responded “Moderate responsibility.”
- Sounds, Noise Levels Are Distracting or Uncomfortable — 34% responded “Never.”
|Title||Job Zone Four: Considerable Preparation Needed|
|Education||Most of these occupations require a four-year bachelor's degree, but some do not.|
|Related Experience||A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to be considered qualified.|
|Job Training||Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.|
|Job Zone Examples||Many of these occupations involve coordinating, supervising, managing, or training others. Examples include accountants, sales managers, database administrators, teachers, chemists, art directors, and cost estimators.|
|SVP Range||(7.0 to < 8.0)|
Percentage of Respondents
|Education Level Required|
|20||Some college, no degree|
This occupation may require a background in the following science, technology, engineering, and mathematics (STEM) educational disciplines:
Interest code: CI
- Conventional — Conventional occupations frequently involve following set procedures and routines. These occupations can include working with data and details more than with ideas. Usually there is a clear line of authority to follow.
- Investigative — Investigative occupations frequently involve working with ideas, and require an extensive amount of thinking. These occupations can involve searching for facts and figuring out problems mentally.
- Attention to Detail — Job requires being careful about detail and thorough in completing work tasks.
- Integrity — Job requires being honest and ethical.
- Analytical Thinking — Job requires analyzing information and using logic to address work-related issues and problems.
- Dependability — Job requires being reliable, responsible, and dependable, and fulfilling obligations.
- Adaptability/Flexibility — Job requires being open to change (positive or negative) and to considerable variety in the workplace.
- Initiative — Job requires a willingness to take on responsibilities and challenges.
- Stress Tolerance — Job requires accepting criticism and dealing calmly and effectively with high stress situations.
- Persistence — Job requires persistence in the face of obstacles.
- Innovation — Job requires creativity and alternative thinking to develop new ideas for and answers to work-related problems.
- Achievement/Effort — Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.
- Cooperation — Job requires being pleasant with others on the job and displaying a good-natured, cooperative attitude.
- Independence — Job requires developing one's own ways of doing things, guiding oneself with little or no supervision, and depending on oneself to get things done.
- Self Control — Job requires maintaining composure, keeping emotions in check, controlling anger, and avoiding aggressive behavior, even in very difficult situations.
- Concern for Others — Job requires being sensitive to others' needs and feelings and being understanding and helpful on the job.
- Social Orientation — Job requires preferring to work with others rather than alone, and being personally connected with others on the job.
- Working Conditions — Occupations that satisfy this work value offer job security and good working conditions. Corresponding needs are Activity, Compensation, Independence, Security, Variety and Working Conditions.
- Support — Occupations that satisfy this work value offer supportive management that stands behind employees. Corresponding needs are Company Policies, Supervision: Human Relations and Supervision: Technical.
- Achievement — Occupations that satisfy this work value are results oriented and allow employees to use their strongest abilities, giving them a feeling of accomplishment. Corresponding needs are Ability Utilization and Achievement.
Wages & Employment Trends
|Median wages (2014)||$38.60 hourly, $80,280 annual|
|Employment (2014)||120,000 employees|
|Projected growth (2014-2024)||Faster than average (9% to 13%)|
|Projected job openings (2014-2024)||39,200|
|Top industries (2014)|
Source: Bureau of Labor Statistics 2014 wage data and 2014-2024 employment projections . "Projected growth" represents the estimated change in total employment over the projections period (2014-2024). "Projected job openings" represent openings due to growth and replacement.
Job Openings on the Web
Sources of Additional Information
Disclaimer: Sources are listed to provide additional information on related jobs, specialties, and/or industries. Links to non-DOL Internet sites are provided for your convenience and do not constitute an endorsement.
- Database administrators . Bureau of Labor Statistics, U.S. Department of Labor. Occupational Outlook Handbook, 2016-17 Edition.
- Association for Computing Machinery (ACM) , 2 Penn Plaza, Suite 701, New York, NY 10121-0701. Phone: (800) 342-6626.
- Computing Technology Industry Association (CompTIA) , 1815 S. Meyers Rd., Suite 300, Oakbrook Terrace, IL 60181-5228. Phone: (630) 678-8300. Fax: (630) 268-1384.
- IEEE Computer Society , 1730 Massachusetts Ave. NW, Washington, DC 20036-1992. Phone: (202) 371-0101. Fax: (202) 728-9614.
- Institute for Certification of Computing Professionals (ICCP) , 2350 E. Devon Ave., Suite 115, Des Plaines, IL 60018-4610. Phone: (847) 299-4227. Fax: (847) 299-4280.
- National Workforce Center for Emerging Technologies (NWCET) , Bellevue Community College, 3000 Landerholm Circle SE, N258, Bellevue, WA 98007-6484. Phone: (425) 564-4229. Fax: (425) 564-6193.