OCTO Senior Oracle DBA (797739) at Advanced Network Consulting Inc

, District of Columbia, United States -

Full Time

Start Date

Immediate

Expiry Date

26 Jun, 26

Salary

0.0

Posted On

28 Mar, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle Database Administration, Oracle RMAN, Oracle RAC, Database Tuning, Failovers, SQL, Capacity Planning, Incident Response, Root Cause Analysis, Oracle 12c, Backup and Restore, Troubleshooting, Schema Management, Indexing, Query Optimization, Database Security

Industry

Description

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

Responsibilities

The Senior Oracle DBA will manage and maintain the central Oracle environment, focusing on upgrading core versions and ensuring high availability through tasks like backup, restore, and planned or unplanned failovers. Responsibilities also include planning, organizing, and implementing projects to support growing information demands and contributing to both tactical and strategic planning.