Overview
Skills
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