Database and Applications Developer -Level III

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

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

3.83.8 out of 5 stars Alaska $40 - $55 an hour - Full-time, Salary range is $40 - $55 per hour, dependent upon experience.