Logo
job logo

Senior Oracle DBA - Onsite,In Person Interview

MSys Inc, Washington, District of Columbia, United States


Both Webcam and In Person interview

W2 or 1099 or c2c

Long term project; usually the project goes for multiple years with this customer;Onsite

Job 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.

Responsibilities

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

Contract Job Description Responsibilities

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

Skills/Requirements

Skill Required Years

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 5 Years

Knowledge of automation and DevOps for databases 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