Job Role Description

IT and Engineering > Oracle DBA

Salary National Average

Low Medium High
75250.0000 93970.0000 112690.0000

Supply and Demand

Candidate Supply: 454 Job Openings: 133

0 50 100

More Difficult Less Difficult

Salary Variance

Enter City, State to view local salaries and candidate demand.

Short Description:

Install, patch, and maintain all Oracle software. Tune all Oracle instance components, including SQL and PL/SQL. Approve all production schema changes. Approve changes to database design. Control all migrations of Oracle schema objects. Design and implement a backup and recovery system. Implement Oracle failover technology.

Duties / Responsibilities:

  • Creates and maintains all databases required for development, testing, education, and production usage.
  • Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff because computers often have applications or tools in addition to the Oracle Databases.
  • Performs ongoing tuning of the database instances.
  • Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
  • Plans and implements backup and recovery of the Oracle database.
  • Controls migrations of programs, database changes, reference data changes, and menu changes through the development life cycle.
  • Implements and enforces security for all of the Oracle databases.
  • Performs database re-organizations as required to assist performance and ensure maximum uptime.
  • Puts standards in place to ensure that all application design and code is created with proper integrity, security, and performance. The DBA will frequently review the design and code to ensure the site standards are followed.
  • Evaluates releases of Oracle, its tools, and third-party products to ensure that the site runs the most appropriate products.
  • Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
  • Provides technical support to application development teams, typically in the form of help desk assistance. The DBA is usually the point of contact for Oracle Corporation.
  • Enforces and maintains database constraints to ensure the integrity of the database.
  • Administers all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures.
  • Assists with impact analysis of any changes made to the database objects.
  • Troubleshoots problems regarding databases, applications, and development tools.
  • Create new database users as required.
  • Manage sharing of resources amongst applications.
  • The DBA has ultimate responsibility for the physical database design.

Skills / Requirements / Qualifications

  • 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 the performance of yourself, other individuals, or organizations to make improvements or take corrective action.
  • Active Learning: Understanding new information's implications for 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 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 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 concerning 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 system's goals.
  • Time Management: Managing one's own time and the time of others.
  • Writing: Communicating effectively in writing as appropriate for the audience's needs.

Job Zones

  • 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. 
  • Job Training: Employees in these occupations usually need several years of work-related experience, on-the-job training, 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.
  • Specific Vocational Preparation in years: 2-4 years of preparation (7.0 to < 8.0)

Share Role Details

Return to job listings