Database Developer, Applications Developer

Jobtailor; Pascagoula (MS); On-site; USD 85,000 - 120,000; Full time

Job summary

NOAA SEFSC in Pascagoula, MS, seeks a data engineer to consolidate ecological data, build pipelines for survey data, and design scalable database architectures.

The role emphasizes PL/SQL development, Oracle RDBMS expertise, and web-app development with secure portals for NOAA staff and partners. Travel and field activities are possible across surveys.

Qualifications

• Master of Science in Computer Science, Information Systems, Engineering, or related field (or BS with 5 years experience).
• Ability to translate scientific processes into logical and physical data models, including ER diagrams.
• Ability to write complex PL/SQL stored procedures, triggers, and packages.
• Knowledge of RBAC and data security.
• Prepare technical documentation, data dictionaries, and user manuals.
• Expert-level Oracle RDBMS knowledge (12c/19c or newer).
• Proficiency with Oracle APEX; or Java/Spring Boot, Python/Django/Flask, or .NET.
• ETL and Python scripting including Pandas/NumPy; Informatica or FME.
• Front-end development: HTML5, CSS3, JavaScript, AJAX.
• Experience with Git/GitHub/GitLab.

Responsibilities

• Consolidate scientific and administrative data from legacy platforms, file formats, databases, and isolated environments.
• Build pipelines to centralize plankton and groundfish survey data.
• Design database architecture and normalized relational schemas for fisheries survey and oceanographic data.
• Develop secure internal web applications for NOAA staff to input, query, and edit live data.
• Create secure external portals for data viewing, input, and proposed edits.
• Implement staging-and-commit workflows requiring approval before external edits affect production.
• Analyze flat files, .db3 files, Access databases, legacy SQL databases, and APIs.
• Design ETL workflows to migrate data into a centralized Oracle Enterprise environment.
• Develop parsing algorithms and validation rules to maintain data integrity and identify anomalies.
• Optimize database performance through indexing, partitioning, and query tuning.
• Ensure federal data security and PII protection compliance.
• Support data analyses and prepare data summaries, reports, publications, and presentations.
• Follow SEFSC publication procedures.
• Participate in outreach, education efforts, workshops, scientific meetings, symposiums, and public forums.
• Work at the SEFSC Laboratory and potentially aboard NOAA ships, charter vessels, and small boats.
• Support at-sea surveys, project workshops, and working group meetings, including required travel.

Skills

Entity-Relationship Diagrams

PL/SQL

RBAC

Technical Documentation

Web Application Development

Python Scripting

HTML5

CSS3

JavaScript

AJAX

Education

MS in Computer Science, Information Systems, Engineering, or related field

BS in CS/IS/Engineering with 5 years relevant experience

Tools

Oracle RDBMS 12c/19c

Oracle APEX

Java/Spring Boot

Python/Django/Flask/.NET

Informatica

FME

Git/GitHub/GitLab

PostgreSQL

SQL Server

GIS/ArcGIS

Job description

• Consolidate scientific and administrative data from legacy platforms, file formats, databases, and isolated environments


• Build pipelines to centralize plankton and groundfish survey data


• Design database architecture and normalized relational schemas for fisheries survey and oceanographic data


• Develop secure internal web applications for NOAA staff to input, query, and edit live data


• Create secure external-partner portals for data viewing, input, and proposed edits


• Implement staging-and-commit workflows requiring approval before external edits affect production


• Analyze flat files, .db3 files, Access databases, legacy SQL databases, and APIs


• Design ETL workflows to migrate data into a centralized Oracle Enterprise environment


• Develop parsing algorithms and validation rules to maintain data integrity and identify anomalies


• Optimize database performance through indexing, partitioning, and query tuning


• Ensure federal data security and PII protection compliance


• Support data analyses and prepare data summaries, reports, publications, and presentations


• Follow SEFSC publication procedures


• Participate in outreach, education efforts, workshops, scientific meetings, symposiums, and public forums


• Work at the SEFSC Laboratory and potentially aboard NOAA ships, charter vessels, and small boats


• Support at-sea surveys, project workshops, and working group meetings, including required travel

Requirements

• Master of Science in Computer Science, Information Systems, Engineering, or related field; or Bachelor of Science in one of these fields plus five years of relevant experience


• Ability to translate scientific processes into logical and physical data models, including Entity-Relationship Diagrams


• Ability to write complex PL/SQL stored procedures, triggers, and packages


• Knowledge of Role-Based Access Control (RBAC)


• Skill in preparing technical documentation, data dictionaries, and user manuals


• Expert-level proficiency with Oracle RDBMS 12c/19c or later


• Proficiency with Oracle APEX highly desired; alternatively Java/Spring Boot, Python/Django or Flask, or .NET


• ETL and Python scripting proficiency, including Pandas and NumPy; PL/SQL; Informatica; or FME


• Front-end development proficiency with HTML5, CSS3, JavaScript, and AJAX


• Experience with Git, GitHub, or GitLab


• Preferred: PostgreSQL or SQL Server knowledge


• Preferred: geospatial data experience including GIS, Oracle Spatial, or ArcGIS


• Preferred: database development and administration experience


• Preferred: workflows with approval gates and audit trails


• Ability to communicate with fisheries scientists and translate requirements into technical specifications


• Previous NOAA or federal agency experience preferred


• Employment subject to successful completion of required background checks and customer security processing


• Ability to work five days per week, generally not exceeding 40 hours


• Ability to work outside normal hours and overtime when authorized for surveys and field activities


• Ability to undertake domestic and international travel as required

Core Competencies

Demonstrates expertise in database architecture, ETL workflows, and data integrity management, with a strong focus on Oracle RDBMS and web application development. Proficient in translating scientific data requirements into technical specifications while ensuring compliance with federal data security standards.

Highest-signal resume keywords

• Oracle RDBMS 12c/19c Expertise


• PL/SQL Stored Procedures Development


• ETL Workflow Design


• Web Application Development with Oracle APEX


• Data Security and PII Compliance

ATS Optimization Keywords

Hard Skills

• Database Architecture Design


• PL/SQL


• ETL Processes


• Data Analysis


• Data Modeling


• Python Scripting


• HTML5


• CSS3


• JavaScript


• AJAX

Soft Skills

• Technical Documentation Preparation


• Communication with Scientists


• Collaboration in Workshops

Industry Keywords

• NOAA


• Fisheries Survey


• Oceanographic Data


• Data Integrity


• Role-Based Access Control


• Federal Data Security


• PII Protection


• Scientific Meetings


• Outreach and Education


• Data Summaries

Tools & Technologies

• Oracle APEX


• Informatica


• FME


• Git


• GitHub


• GitLab


• PostgreSQL


• SQL Server


• GIS


• ArcGIS