Senior Oracle DBA

Overview

Remote
Depends on Experience
Full Time

Skills

Confluence
DBA
Database Administrator
Enterprise Manager
Git
Jira
Linux
Oracle
Oracle PL / SQL
PL / SQL
RDBMS
Research
SQL
SQL Server
Scrum
business processes
code reviews
communication skills
data migration
data modeling
debugging
full life cycle
health checks
oral communication
partitioning
peer review
program development
schema
shell scripting
software development lifecycle
unit testing

Job Details

Senior Oracle DBA 

Previous experience with FAA. 

LCAT: is FAA Senior II - Scientist/Eng/Sys Analyst.

Responsibilities:

·       Design, implement, code, test and maintain Oracle PL/SQL including packages, procedures, triggers and functions in compliance with company standards and best practices

·       Perform modifications to and maintenance of operational programs and procedures.

·       Analyze business processes and procedures to recommend technical system/software solutions, including support for modernization of legacy Oracle environments to PostgreSQL.

·       Prepare documentation of program development, modifications to code as needed.

·       Apply best practice for tuning SQL and PL/SQL for overall system performance, as well as PL/pgSQL in PostgreSQL environments.

·       Support software development and test teams throughout the software development lifecycle. Includes incremental script execution and defect resolution.

·       Review proposed database structure changes by development teams and approve or modify based on company standards and best practices, including PostgreSQL compatibility.

·       Provide support for software releases

·       Research interfaces to identify and code required updates to support integration, particularly with Java-based applications using ORM frameworks like Hibernate or JPA.

·       Leverage AI-based tooling (e.g., AWS SCT, AI Agents) to automate schema conversion, stored procedure translation, and query optimization.

·       Support containerized deployment of PostgreSQL environments (e.g., Docker, Kubernetes).

·       Perform and setup daily environment health checks and generate reports to capture the findings

·       Provide all activities related to the administration of Oracle databases

·       Setup & Monitor DB servers proactively to ensure optimized usage of resources using various monitoring tools like Shell scripts, Oracle jobs, OEM etc.

 

Qualifications:

·       Requires a Bachelor’s Degree in Engineering, Math, or Science and a minimum of 10 years of relevant experience

·       The ability to successfully obtain and maintain a U.S. Suitability/Public Trust Background Clearance

·       Extensive experience and a solid understanding in administering complex database architectures of Oracle 19c & all latest releases

·       Hands-on experience administering and tuning PostgreSQL databases (version 12+ preferred)

·       Experience creating databases from design models and building physical environments

·       Experience with logical and physical data modeling and RDBMS concepts

·       Complete understanding of database partitioning

·       Experience designing, developing, testing, documenting, deploying, implementing and tuning Oracle SQL and PL/SQL Languages code

·       Experience converting PL/SQL to PL/pgSQL for functional equivalence in PostgreSQL

·       Extensive experience with data migration and data loads, often from non-Oracle sources

·       Knowledge of PostgreSQL-native features such as logical replication, pg_dump, foreign data wrappers, and extensions like PostGIS

·       Ability to perform PL/SQL coding assignments including stand-alone SQL scripting and database stored code (triggers, packages, procedures, and functions) in compliance with standards and procedures

·       Strong understanding of PostgreSQL schema design, indexing strategies, and performance tuning

·       Strong shell scripting knowledge is required

·       Firm understanding of the overall architecture required to support common schema based objects used to store data and implement business logic

·       Experience with software development lifecycle and software development common practices (code reviews, unit testing etc.)

·       Ability to provide guidance, oversight, and peer review to more junior database developers and direction to other technical resources as required

·       Working knowledge and ability to support IIS administration

·       Experience working in Linux & Exadata environment

·       Experience supporting PostgreSQL in cloud-native and containerized environments such as Docker, Amazon RDS, and Kubernetes

·       Aptitude for debugging problems in complex, unfamiliar code

·       Have worked closely with applications implementing full life cycle

·       Experience with tools such as TOAD, SQL Developer, pgAdmin, DBeaver, or similar PostgreSQL tooling

·       Strong written and oral communication skills are essential

·       Solid work ethic, self-driven, can function independently with minimal oversight and direction

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.