General Information
| Job Description | DATABASE ADM 4 | Working Title | Oracle Database Engineer |
|---|---|---|---|
| Job Code | 000597 | Grade | 25 |
| Department Name | Data Base Administration - D02044 | Department Head | |
| Supervisor | Effective Date | 06/22/2020 |
Position(s) Directly Supervised
| Job Code | Title | FTE |
|---|
Generic Scope
| Technical leader with a high degree of knowledge in the overall field and recognized expertise in specific areas; problem-solving frequently requires analysis of unique issues/problems without precedent and/or structure. May manage programs that include formulating strategies and administering policies, processes, and resources; functions with a high degree of autonomy. |
Custom Scope
| Applies advanced database administration concepts and campus/medical center/OP, institutional and/or multi-institutional objectives to resolve highly complex issues of diverse scope where incumbent must assess business needs and technical considerations with minimal direction in order to complete database projects of advanced scope and complexity. Selects methods, techniques and evaluation criteria to obtain results. Implements database solutions from evaluation to implementation of large enterprise level hardware and software. |
Department Custom Scope
| Under the direction of the Manager of Database Engineering, the Oracle Database Engineer will provide oversight for direction of database technologies and disciplines, which include: database administration, database design, standards and procedures, and database development for an Oracle environment that optimizes systems reliability and performance for all the University's customers. This role will manage and deliver database design, performance tuning and hands on administration of server databases, as well as database tools and services supporting Oracle Relational Database Management System (RDBMS), Enterprise Resource Planning (ERP) systems, and business intelligence technologies including Oracle Data Integrator and Oracle Business Intelligence Suite Enterprise Edition (OBIEE). This position will require the ability to work with other Database Engineers, and with the developers in an effective manner. This position works with project and production support teams to plan and implement application and infrastructure requirements. The Oracle Database Engineer will also maintain all environments in support of development, testing, and production in accordance to Information Technology Solutions (ITS) architecture principles. |
Education & Experience Requirements
Education Requirements
| Degree | Requirement |
|---|---|
| Bachelor's degree in related area and/or equivalent experience/training. | Required |
| Advanced degree in a related area and/or equivalent experience/training. | Preferred |
Experience Requirements
| Experience | Requirement |
|---|
License Requirements
Certification Requirements
| Certification | Requirement |
|---|---|
| Oracle Certified Professional (OCP) - Oracle Database Administrator | Preferred |
Educational Condition Requirements
| Condition | Requirement |
|---|
Key Responsibilities
| Description | % Time |
|---|---|
Applies advanced concepts in working on highly complex projects including all aspects of enterprise class database administration, including the management of structured and unstructured content. Initiates, designs and communicates with senior level personnel regarding database administration studies, summary reports and background material including approaches, trends and sources. Interacts with teams of advanced IT professionals as a proactive member. Provides software consulting for database performance and design.
|
40 |
Implements database solutions from evaluation to implementation of large enterprise level hardware and software. Formulates procedures and standards relating to database management.
|
10 |
Develops disaster recovery plans and tests, backup solutions and system security.
|
10 |
| Create, deploy, and maintain operating system scripts/programs as needed to enable and automate database administration services. Administer, monitor, and troubleshoot a 24x7 production environment's database servers and associated infrastructure. Support installation and administration of vendor-supplied systems that are managed by the Data Base Administration (DBA) Group. | 40 |
Knowledge, Skills & Abilities
| Knowledge/Skill/Ability | Requirement |
|---|---|
| Advanced knowledge of database management systems and standards. | Required |
| Knowledge of conceptual database design. | Required |
| Advanced database querying and modeling skills working with moderately complex databases. | Required |
| Knowledge relating to capacity planning and interface specifications. | Required |
| Knowledgeable about professional approaches and relevant standards and technology for management of unstructured data such as text and images. | Required |
| Demonstrates good judgment and decision-making; problem identification and resolution; identifying measures of system performance and the actions to improve performance through application configuration and programming techniques. | Required |
| Has effective written/verbal communication skills. | Required |
| Demonstrates reasoning and ability to develop original ideas to solve problems. | Required |
| Demonstrates interpersonal skills, problem solving skills, service orientation, active listening, effective verbal and written communication skills and organizational skills. | Required |
| Able to multi-task and prioritize tasks. Ability to work independently on complex technical projects as well as on a team of technical professionals and relevant decision-makers. | Required |
| Knowledge of test software code in client server environment. | Required |
| Broad knowledge of the IT environment. | Required |
| Skills necessary to develop procedures and standards relating to database management systems. | Required |
| Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level. | Required |
| Strong security skills for protecting the operating system, software, data and hardware. Technical skills to develop, implement and test disaster recovery functions using backup technologies. | Required |
| Strong background administering Oracle databases using various Oracle and non-Oracle database tools such as Oracle Enterprise Manager, Recovery Manager (RMAN), SQL Loader, Erwin Recovery Manager (ERD) tools, etc. | Required |
| Strong knowledge of Oracle 11g/12c Administration. | Required |
| Ability to manage database replication with Data Guard. | Required |
| Strong understanding of storage technologies, such as Storage Area Network (SAN), device-mapper multipath, and Oracle Automatic Storage Management (ASM). | Required |
| Background in Banner, Peoplesoft, or other three-tier architectures using WebLogic server. | Required |
Special Requirements & Conditions
| Special Condition | Requirement |
|---|---|
| Must pass a background check. | Preferred |
| Occasional travel for university related business meetings, conferences and/or professional development. | Required |
Other Special Requirements & Conditions
|
Level of Supervision Received
| Direction |
Environment
Working Environment
| Campus |
Other Requirements
Items Used
|
Physical Requirements
|
Mental Requirements
|
Environmental Requirements
|
Critical Position
| Is Critical Position: No |