Database and Applications Developer –Level III
Saltwater Inc•Pascagoula, MS
•$40 - $55•Onsite
About The Position
Saltwater Inc. is seeking a Database and Applications Developer – Level III to work as a contractor for NOAA’s Southeast Fisheries Science Center (SEFSC) Population & Ecosystems Monitoring Division (PEMD). This role is part of a critical enterprise data management initiative to centralize scientific and administrative data. The position will involve developing pipelines, designing database architecture, and creating front-end applications for data management and validation. The work will be performed at the SEFSC Laboratory in Pascagoula, MS, with potential requirements to work on NOAA Ships, charter vessels, and/or small boats. This is a full-time position with a one-year base period and potential for three option periods.
Requirements
- MS Degree in Computer Science, Information Systems, Engineering, or a related field of study; or BS Degree in one of these disciplines, 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 between different use and access requirements.
- Skill in creating technical documentation, data dictionaries, and user manuals.
- Expert-level proficiency in Oracle RDBMS (12c/19c or later).
- Proficiency in Oracle APEX (Application Express) is highly desired for rapid development of data-centric web apps.
- Alternatively: Java (Spring Boot), Python (Django/Flask), or .NET.
- Proficiency in Python (Pandas/NumPy), PL/SQL, Informatica, or FME.
- Proficiency in HTML5, CSS3, JavaScript, and AJAX techniques for responsive user interfaces.
- Proficiency in Git/GitHub/GitLab.
Nice To Haves
- Knowledge of PostgreSQL or SQL Server is a plus.
- Documented experience working 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 their data needs and translate them into technical specifications.
- Previous experience supporting NOAA or other Federal Agencies.
Responsibilities
- Bring together scientific and administrative data currently fragmented across various legacy platforms, file formats, and isolated silos as part of a critical enterprise data management initiative.
- Build pipelines to centralize data from plankton and groundfish surveys.
- Design the database architecture to house the centralized survey data.
- Develop front-end applications that allow internal staff and external partners to securely manage and validate the data.
- Analyze disparate data sources (flat files, .db3, Access databases, legacy SQL, APIs) and design automated workflows to extract, transform, and load (ETL) data into a centralized Oracle Enterprise environment.
- Develop parsing algorithms to handle inconsistent data formats and ensure data integrity during the migration process.
- Implement data validation rules to flag anomalies during ingestion.
- Design and maintain normalized relational database schemas that support complex fishery survey and oceanographic data structures.
- Optimize database performance through indexing, partitioning, and query tuning.
- Ensure strict adherence to federal data security standards and PII protection protocols.
- Develop a user-friendly web application allowing internal NOAA staff to input, query, and edit live data records.
- Create a secure portal for external partners to view and input data and propose edits.
- Engineer a "staging and commit" workflow where external edits are held in a review queue (edits do not affect the production database until reviewed and approved by the Database Manager or appropriate data steward).
- Provide support for data analyses and prepare data summaries.
- Assist with the development of data reports, publications, and presentations, as needed; adhere to SEFSC publication procedures prior to publication of any abstracts or manuscripts.
- Participate in public outreach and education efforts, as needed.
- Prepare for and present, facilitate, or participate in various workshops, scientific meetings, symposiums, and public forums.
Benefits
- The contract has a one-year base period with a potential of three option periods.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
