Database and Applications Developer

Lynker; Pascagoula, Northern (MS, KY); On-site; USD 95,000 - 130,000; Full time

Benefits offered by this job

Healthcare benefits

401(k) with company match

Employee stock ownership plan (ESOP)

Tuition assistance

Paid holidays

Spot bonuses

Learning management system

Job summary

Lynker seeks a Database and Applications Developer to modernize NOAA Fisheries data management. You will unify data from diverse sources, design centralized schemas, and build secure, user-friendly applications for NOAA staff and external partners.

The role involves ETL workflow design, data validation, and RBAC across a secure Oracle-based environment. Occasional travel to support field activities may be required.

Qualifications

• Master of Science in Computer Science, Information Systems, Engineering, or related field (or BS + 5 years of relevant experience).
• Experience translating scientific processes into data models (ER diagrams).
• Ability to write complex stored procedures, triggers, and packages using PL/SQL.
• RBAC knowledge to differentiate user access.
• Experience with Oracle RDBMS 12c/19c or later.

Responsibilities

• Consolidate data from legacy platforms and disparate sources.
• Build data pipelines to centralize survey data.
• Design centralized database architecture for NOAA data.
• Develop secure front-end applications for internal and external users.
• Create ETL workflows to migrate data into Oracle Enterprise environment.
• Implement data validation and ensure PIIs protection.

Skills

Oracle

PL/SQL

Python

SQL

ETL

JavaScript

Git

Education

MS in Computer Science/Information Systems

BS in Computer Science/Engineering + 5 years experience

Tools

Oracle RDBMS

APEX

Java/Spring Boot

Python/Django/Flask

.NET

Job description

Overview

Lynker Corporation is seeking a Database and Applications Developer to support NOAA Fisheries’ SEFSC, Population & Ecosystems Monitoring Division (PEMD), and Southeast Area Monitoring and Assessment Program (SEAMAP). This proposed role will support an enterprise data management initiative focused on centralizing scientific and administrative data, developing database architecture, creating automated data pipelines, and building secure applications for NOAA staff and external partners. Hiring for this position will be contingent on contract award.

The SEFSC Population & Ecosystems Monitoring Division conducts large-scale fishery-independent surveys and applied research supporting stock assessments, ecosystem-based fisheries management, and protected species management. This position will support the modernization and integration of scientific data currently distributed across legacy platforms, file formats, databases, and isolated data environments.

Duties of the Database and Applications Developer will include the following:

• Bring together scientific and administrative data currently distributed across legacy platforms, file formats, and isolated data environments.
• Build data pipelines to centralize plankton and groundfish survey data.
• Design database architecture to house centralized survey data.
• Develop front-end applications that allow internal NOAA staff and external partners to securely manage and validate data.
• Analyze disparate data sources, including flat files, .db3 files, Access databases, legacy SQL databases, and APIs.
• Design automated extract, transform, and load (ETL) workflows to migrate data into a centralized Oracle Enterprise environment.
• Develop parsing algorithms to address inconsistent data formats and maintain data integrity during migration.
• Implement data validation rules to identify anomalies during data ingestion.
• Design and maintain normalized relational database schemas supporting complex fisheries survey and oceanographic data structures.
• Optimize database performance using indexing, partitioning, and query tuning.
• Ensure adherence to federal data security standards and personally identifiable information (PII) protection protocols.
• Develop a user-friendly internal web application allowing NOAA staff to input, query, and edit live data records.
• Create a secure portal allowing external partners to view and input data and propose edits.
• Engineer a staging-and-commit workflow in which proposed external edits are held for review and do not affect the production database until approved by the Database Manager or appropriate data steward.
• Support data analyses and prepare data summaries.
• Assist with development of data reports, publications, and presentations as needed.
• Follow SEFSC publication procedures before publication of abstracts or manuscripts.
• Participate in public outreach and education efforts as needed.
• Prepare for and potentially present, facilitate, or participate in workshops, scientific meetings, symposiums, and public forums.

The Database and Applications Developer should have the following:

• Master of Science degree in Computer Science, Information Systems, Engineering, or a related field of study; or
• Bachelor of Science degree in Computer Science, Information Systems, Engineering, or a related field of study plus five years of relevant experience.
• Ability to translate real-world scientific processes into logical and physical data models, including Entity-Relationship Diagrams.
• Ability to write complex stored procedures, triggers, and packages using PL/SQL to support business logic and edit-approval workflows.
• Knowledge of implementing Role-Based Access Control (RBAC) to differentiate user and access requirements.
• Skill in preparing technical documentation, data dictionaries, and user manuals.
• Expert-level proficiency with Oracle RDBMS 12c/19c or later.
• Proficiency with Oracle Application Express (APEX) is highly desired; alternatively, proficiency with Java/Spring Boot, Python/Django or Flask, or .NET.
• ETL and scripting proficiency using Python, including Pandas and NumPy; PL/SQL; Informatica; or FME.
• Front-end development proficiency using HTML5, CSS3, JavaScript, and AJAX techniques for responsive user interfaces.
• Experience with Git, GitHub, or GitLab for version control.

The ideal Database and Applications Developer will have the following preferred qualifications:

• Knowledge of PostgreSQL or SQL Server.
• Documented experience working with geospatial data, including GIS, Oracle Spatial, or ArcGIS.
• Documented experience in database development and administration.
• Documented experience building workflows incorporating approval gates and audit trails.
• Ability to communicate with fisheries scientists to understand their data requirements and translate those requirements into technical specifications.
• Previous experience supporting NOAA or other federal agencies.

Work Environment

The position is based at the SEFSC Laboratory in Pascagoula, Mississippi. The contractor may also be required to work aboard NOAA ships, charter vessels, and/or small boats to support required duties and responsibilities.

Facility access is generally available from 6:00 a.m. to 6:00 p.m., Monday through Friday. Work is generally performed five days per week and does not normally exceed 40 hours per week. Work outside normal operating hours and overtime may be required in connection with at-sea surveys and other field-based activities and must be authorized in accordance with contract requirements.

Domestic and international travel may be required for or in support of at-sea surveys, project-related workshops, and working group meetings.

About Lynker

Lynker is a growing, employee owned business, specializing in professional, scientific and technical services. Our continually expanding team combines scientific expertise with mature, results-driven processes and tools to achieve technically sound, cost effective solutions in hydrology/water sciences, geospatial analysis, information technology, resource management, conservation, and management and business process improvement.

We focus on putting the right people in the right place to be effective. And having the right people is critical for success. Our streamlined organization enables and empowers our talented professionals to tackle our customers' scientific and technical priorities – creatively and effectively.

Lynker offers a team-oriented work environment, and the opportunity to work in a culture of exceptionally skilled professionals who embrace sound science and creative solutions. Lynker's benefits include the following:

• Comprehensive healthcare for the employee at no monthly cost
• Healthcare benefit covers medical, prescription drug, dental, and vision
• Personal Time Off (PTO) Policy plus paid holidays
• Highly competitive compensation plan regularly calibrated against industry and location benchmarks
• 401(k) retirement plan with company-matching
• Employee Stock Ownership Plan (ESOP) – we\'re all company owners!
• Flexible spending accounts
• Employee assistance program (EAP)
• Short- and long-term disability insurance
• Life and accident insurance
• Tuition assistance/Training/Workforce improvement reimbursement per year
• Spot bonuses for exceptional performance
• Annual Employee Recognition Awards with bonuses
• Employee Referral Program
• Free centralized, self-directed Learning Management System to learn at your own pace
• Personalized career growth plans for every employee

Lynker is an E-Verify employer.

Lynker is an equal opportunity employer and makes all employment decisions based on merit, qualifications, and business needs. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, marital status, veteran status, or any other legally protected status under federal, state, or local laws.

This position is not currently funded and is contingent upon contract award. Employment is subject to successful completion of any required background checks and security processing required by the customer.