What are the responsibilities and job description for the OCTO Senior Oracle DBA (797739) position at Advanced Network Consulting Inc?
Description
OCTO is seeking a Senior Oracle Database Administrator to manage and maintain the central Oracle environment for the District. The resource must have experience with upgrading core versions of Oracle database and managing a highly available environment. This includes backup and restore, troubleshooting connectivity, performing failovers as planned or in support of unplanned activities, performing maintenance to include optimizing and tuning, reviewing memory, I/O, indexing, queries, access, tablespace, schemas. The resource must have experience with capacity planning, incident response and root cause analysis, and working with cross functional collaboration with teams (developers, architects, security) utilizing the environment.
---------------------------------------------
CONTRACT JOB DESCRIPTION
Responsibilities:
1. Plans, organizes, and implements projects in support of District’s growing information demands.
2. Ensures the effective use of District resources.
3. Contributes to policies for effective process planning as it relates to new requirements.
4. Possesses expert knowledge of the Structured Query Language (SQL) environment with particular emphasis on planning, analysis, design and implementation of reports and report interfaces intended for the end user.
5. Participates in short-term tactical planning implementation.
6. Contributes to long-term strategic planning.
Minimum Education/Certification Requirements:
Bachelor’s degree in IT or related field or equivalent experience
---------------------------------------------
CONTRACT JOB DESCRIPTION
Responsibilities:
1. Plans, organizes, and implements projects in support of District’s growing information demands.
2. Ensures the effective use of District resources.
3. Contributes to policies for effective process planning as it relates to new requirements.
4. Possesses expert knowledge of the Structured Query Language (SQL) environment with particular emphasis on planning, analysis, design and implementation of reports and report interfaces intended for the end user.
5. Participates in short-term tactical planning implementation.
6. Contributes to long-term strategic planning.
Minimum Education/Certification Requirements:
Bachelor’s degree in IT or related field or equivalent experience
Requirements
- Expertise with Oracle database architecture--Required 10 Years
- Expertise with Oracle 12c or higher--Required 10 Years
- Expertise with Oracle RMAN backup and recovery strategies--Required 10 Years
- Expertise with tuning Oracle databases (query/indexes/memory/IO/storage)--Required 10 Years
- Expertise with Oracle RAC and highly available environments--Required 10 Years
- Expertise with Oracle database failovers--Required 10 Years
- Expertise writing complex SQL and functions, triggers and objects--Required 10 Years
- Expertise with tuning Oracle databases (queries/indexes/memory/IO/storage)--Required 10 Years
- Expertise with troubleshooting Oracle databases--Required 10 Years
- Expertise with upgrading Oracle databases--Required 10 Years
- Expertise with security for Oracle databases--Required 10 Years
- Knowledge of operating Oracle databases in cloud environments such as Azure and AWS--Highly desired 5 Years
- Knowledge of automation and DevOps for databases--Nice to have 5 Years
- 11-15 yrs. database design, documentation, and coding--Required 10 Years
- 11-15 yrs. designing and implementing reports and report interfaces--Required 10 Years
- 11-15 yrs. SQL experience--Required 10 Years
- Bachelor’s degree in IT or related field or equivalent experience--Required
- Oracle Certified Professional or higher--Required