Database and Applications Developer
Lynker Corporation
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
Lynker Corporation is seeking a Database and Applications Developer to support NOAA Fisheries’ PEMD and SEAMAP. The role focuses on centralizing scientific data, developing database architecture, and building secure applications for NOAA staff and external partners.
The candidate will create automated data pipelines, design relational schemas, and implement data validation, governance, and compliance while collaborating with multidisciplinary teams at Lynker.
Qualifications
- Translate real-world scientific processes into logical data models.
- Write complex stored procedures, triggers, and packages to support workflows.
- Implement RBAC to differentiate user access requirements.
- Prepare technical documentation, data dictionaries, and user manuals.
Responsibilities
- Consolidate data from legacy sources into centralized enterprise datasets.
- Build data pipelines to centralize survey data.
- Design database architectures for centralized data storage.
- Develop secure front-end apps for internal and external users.
- Create ETL workflows to migrate data to Oracle environment.
- Validate data and maintain data integrity during migration.
- Support data analyses, reports, and presentations.
Skills
Education
Tools
Job description
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.
- 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.
- 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.
- 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.
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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
