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.
- 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 on them 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 of the database.
- Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
- Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate.
- 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. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation.
- Enforces and maintains database constraints to ensure 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 with problems regarding the 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.
- 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.
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)