Senior Oracle DBA (Onsite)
Serigor Inc, Washington, District of Columbia, United States
Job Title:
Senior Oracle DBA (Onsite)
Location:
Washington, DC
Duration:
05 Months with possible extension
Job Description:
The Client is seeking a Senior Oracle Database Administrator to manage and maintain the central Oracle environment. 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 the client growing information demands. Ensures the effective use of the client 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.
Skills:
Skills
Required / Desired
Amount
of Experience
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
Database design, documentation, and coding
Required
10
Years
Designing and implementing reports and report interfaces
Required
10
Years
SQL experience
Required
10
Years
Bachelor's degree in IT or related field or equivalent experience
Required
Oracle Certified Professional or higher
Required
Senior Oracle DBA (Onsite)
Location:
Washington, DC
Duration:
05 Months with possible extension
Job Description:
The Client is seeking a Senior Oracle Database Administrator to manage and maintain the central Oracle environment. 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 the client growing information demands. Ensures the effective use of the client 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.
Skills:
Skills
Required / Desired
Amount
of Experience
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
Database design, documentation, and coding
Required
10
Years
Designing and implementing reports and report interfaces
Required
10
Years
SQL experience
Required
10
Years
Bachelor's degree in IT or related field or equivalent experience
Required
Oracle Certified Professional or higher
Required