Database and Applications Developer –Level III at Saltwater Inc

Pascagoula, Mississippi, United States -

Full Time

Start Date

Immediate

Expiry Date

16 Oct, 26

Salary

55.0

Posted On

18 Jul, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle RDBMS, PL/SQL, Oracle APEX, Python, ETL, Database Architecture, Data Modeling, HTML5, CSS3, JavaScript, Git, Role-Based Access Control, Data Validation, API Integration, Technical Documentation, Geospatial Data

Industry

Environmental Services

Description

At Saltwater Inc. we believe that high-quality data is vital to the health of our fisheries and oceans: our mission is to provide that data. We are a Women-Owned Small Business and are constantly seeking new team members who share our passion for innovation and environmental wellness. 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: 1. 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. 1. Enterprise Data Ingestion and Migration (ETL) 1. 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. 2. Develop parsing algorithms to handle inconsistent data formats and ensure data integrity during the migration process. 3. Implement data validation rules to flag anomalies during ingestion. 2. Database Architecture and Management 1. Design and maintain normalized relational database schemas that support complex fishery survey and oceanographic data structures. 2. Optimize database performance through indexing, partitioning, and query tuning. 3. Ensure strict adherence to federal data security standards and PII protection protocols. 3. Application Development (Internal and External) 1. Internal interface: develop a user-friendly web application allowing internal NOAA staff to input, query, and edit live data records. 2. External partner workflow: create a secure portal for external partners to view and input data and propose edits. 3. 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). 2. Support for Other Research Activities: Support other Trawl and Plankton Branch, PEMD, and SEFSC surveys, including but not limited to: 1. Provide support for data analyses and prepare data summaries. 2. 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. 100. Outreach and Education: Participate in public outreach and education efforts, as needed. 500. Scientific Meetings: Contractor may be required to prepare for and present, facilitate, or participate in various workshops, scientific meetings, symposiums, and public forums. Minimum Qualifications: LEVEL III Essential: * 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. * Software proficiency includes, but is not limited to: * Database Engines: Expert-level proficiency in Oracle RDBMS (12c/19c or later). Knowledge of PostgreSQL or SQL Server is a plus. * Development Frameworks: 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. * ETL & Scripting: Python (Pandas/NumPy), PL/SQL, Informatica, or FME. * Front End: HTML5, CSS3, JavaScript, and AJAX techniques for responsive user interfaces. * Version Control: Git/GitHub/GitLab. LEVEL III Desirable: * 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. Salary range is $40 - $55 per hour, dependent upon experience. Saltwater Inc. is proud to be an equal opportunity employer and a VEVRAA Federal Contractor and does not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, parental status, veteran status, or disability status. We strive to create an inclusive workplace culture to attract the best talent and allow each member of our team to achieve their full potential and maximum productivity. Furthermore, Saltwater Inc. highly encourages qualified individuals with disabilities and protected veterans to apply for positions for which they are qualified and to notify us if there are any needs for accommodation throughout the application process and/or upon hire. Only qualified applicants with the requisite experience need to apply. We will honor all requests for application confidentiality.

Responsibilities

Develop and manage centralized databases and web applications to integrate fragmented scientific and administrative fishery data. Design ETL pipelines and secure portals for internal staff and external partners to manage and validate data.