Oracle Application Developer/DBA

AIS•Pascagoula, MS

5d•Onsite

About The Position

A.I.S., Inc. (AIS) is seeking an Oracle Application Developer/DBA to support NOAA’s SEFSC. The primary function of this role is to centralize scientific and administrative data currently spread across legacy platforms, file formats, and separate silos. This involves building the database architecture to house centralized plankton and groundfish survey data, and developing front-end applications that allow internal NOAA staff and external partners to securely manage and validate that data. This position is contingent upon contract award and available funding.

Requirements

MS Degree in Computer Science, Information Systems, Engineering, or a related field; or BS Degree in one of these disciplines plus five (5) years of relevant experience.
Ability to translate real-world scientific processes into logical and physical data models (Entity-Relationship Diagrams).
Ability to write complex stored procedures, triggers, and packages (PL/SQL) to handle business logic and the edit-approval workflow.
Knowledge of implementing Role-Based Access Control (RBAC) to differentiate use and access requirements.
Skill in creating technical documentation, data dictionaries, and user manuals.
Expert-level Oracle RDBMS (12c/19c or later) database engine experience.
Experience with PostgreSQL or SQL Server is a plus.
Experience with Oracle APEX for data-centric web apps is highly desired.
Alternatively, experience with Java (Spring Boot), Python (Django/Flask), or .NET.
Experience with ETL and scripting using Python (Pandas/NumPy), PL/SQL, Informatica, or FME.
Experience with front-end technologies: HTML5, CSS3, JavaScript, and AJAX techniques for responsive user interfaces.
Experience with version control: Git/GitHub/GitLab.

Nice To Haves

Documented experience with geospatial data (GIS, Oracle Spatial, ArcGIS).
Documented experience in database development and administration.
Documented experience building workflows with approval gates/audit trails.
Ability to communicate with fishery scientists to understand data needs and translate them into technical specifications.
Previous experience supporting NOAA or other Federal agencies.

Responsibilities

Analyze disparate data sources (flat files, .db3, Access databases, legacy SQL, APIs) and design automated ETL workflows to extract, transform, and load data into a centralized Oracle Enterprise environment.
Develop parsing algorithms to handle inconsistent data formats and preserve data integrity during migration.
Implement data validation rules to flag anomalies during ingestion.
Design and maintain normalized relational database schemas supporting complex fishery survey and oceanographic data structures.
Optimize database performance through indexing, partitioning, and query tuning.
Apply federal data security standards and PII protection protocols.
Develop an internal web application allowing NOAA staff to input, query, and edit live data records.
Build a secure external portal for partners to view and input data and propose edits.
Engineer a staging-and-commit workflow that holds external edits in a review queue until approved by the Database Manager or data steward.
Support other Trawl and Plankton Branch, PEMD, and SEFSC surveys: provide data analyses, prepare data summaries, and assist with data reports, publications, and presentations per SEFSC publication procedures.
Participate in public outreach and education efforts, and in workshops, scientific meetings, symposiums, and public forums as required.