Senior Oracle DBA

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