OCTO Senior Oracle DBA (797739)

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.

Responsibilities:

CONTRACT JOB DESCRIPTION

• Plans, organizes, and implements projects in support of District’s growing information demands.
• Ensures the effective use of District resources.
• Contributes to policies for effective process planning as it relates to new requirements.
• 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.
• Participates in short-term tactical planning implementation.
• Contributes to long-term strategic planning.

Minimum Education/Certification Requirements:

Bachelor’s degree in IT or related field or equivalent experience

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