Database and Applications Developer –Level III

Database and Applications Developer – Level III

We are currently recruiting for Database and Applications Developer –Level III
. See below Requirements for each Level. These Survey Support positions will work as a contractor for NOAA’s Southeast Fisheries Science Center (SEFSC) Population & Ecosystems Monitoring Division (PEMD) providing support for the below Tasks.

Please note that we are recruiting proactively and do not yet have this position available. If awarded the work, this will be a full-time position. The Contractor shall work at the SEFSC Laboratory in Pascagoula, MS. The Contractor may also be required to work on NOAA Ships, charter vessels, and/or small boats to carry out required duties and responsibilities. The contract has a one-year base period with a potential of three option periods.

TASKS:

A. Database and Applications Development: 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. Duties include (but are not limited to) building pipelines to centralize data from plankton and groundfish surveys; designing the database architecture to house the centralized survey data; and developing front-end applications that allow internal staff and external partners to securely manage and validate the data.

• Enterprise Data Ingestion and Migration (ETL)
• 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.
• Database Architecture and Management
• 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.
• Application Development (Internal and External)
• Internal interface: develop a user-friendly web application allowing internal NOAA staff to input, query, and edit live data records.
• External partner workflow: create a secure portal for external partners to view and input data and propose edits.
• Approval logic: 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).

B. Support for Other Research

Activities:

Support other Trawl and Plankton Branch, PEMD, and SEFSC surveys, including but not limited to:

• 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.

C. Outreach and

Education:

Participate in public outreach and education efforts, as needed.

D. Scientific Meetings: Contractor may be required to prepare for and present, facilitate, or participate in various workshops, scientific meetings, symposiums, and public forums.

Saltwater Inc. is proud to be an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

• 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…