LeesburgRecruiter Since 2001
the smart solution for Leesburg jobs

Database Programmer

Company: Lynker Corporation
Location: Leesburg
Posted on: March 19, 2023

Job Description:

Lynker is seeking a talented Database Programmer to join our team in support of a long term contract with NOAA.

Responsabilities and Duties of Database Programmer:

Uses industry standard tools including MySQL and MS Access to maintain and enhance NOAA's DIVER Data Models and back-end environmental databases.

Manage, standardize and integrate environmental sediment chemistry, tissue contaminant-residue chemistry, field measurements and observations and environmental contaminant toxicity data to conduct or support hazardous waste site investigations, including investigation and sample plan design, ecological risk assessment, cleanup level derivation, develop and evaluate remedial alternatives, develop mitigation strategies, natural resource damage assessment (pathway evaluation, injury determination, restoration project development, and scaling damages), and long-term effectiveness monitoring programs.

Implement regional and case specific calculations and summary of contaminants including Logistic Regression Models, PAH Toxic Units and Toxic Equivalency Factors.

Calculate complex sums and totals including Polycyclic Aromatic Hydrocarbons and Polychlorinated Biphenyls maintaining compatibility with 25+ years of data.

Maintain the environmental data models and regional databases with improvements to the schema (as directed by NOAA).

Refine and document existing automated routines for importing and checking data as they are added to existing systems, and calculating sums and derived values, including continued development and maintenance.

Calculate and integrate probability of toxicity using Logistic Regression Modeling (LRM), Toxic Equivalency Quotients (TEQ) and Polycyclic Aromatic Hydrocarbons (PAH) Toxic Units for regional data needs.

Ensure that data and calculations meet national guidelines and standards including USEPA, ASTM and other protocols.

Maintain the consistency and evolution of common dictionary files to ensure legacy and Client data are compatible.

Maintain and improve the data posting routines which provide finalized data to the DIVER data warehouse for integration and query, and summarize changes and updates.

Development of Field and Laboratory Data Collection and Processing tools (T&M)

Maintain and improve existing Data Templates (Electronic Data Deliverables) including field forms and guidance.

Automate procedures for importing data from NOAA templates for field and laboratory data.

Support training to partners on the use of data delivery tools.

Maintain and expand automation tools for integration and standardization of data from partner databases including EQuIS4 , State managed databases, and project partners data management systems.

Apply chemistry expertise, toxicity testing experience and expertise, fisheries biology background and knowledge, and field data sampling expertise to each of the datasets that are standardized and integrated into the DIVER database.

Prepare review and estimate of level of effort to standardize and ingest new or updated datasets including projected hours, complexity factors and recommendations.

Conducting a high level of Quality Assurance/Quality Control (QA/QC) review on each new data set to ensure that imported data match the original data provided and to identify potential problems (e.g. missing values, inconsistent units or outliers) with the original data.

Develop documentation for each dataset (e.g. project source, analytical methods, coordinate data projection and datum and detailed records and changes and data treatments decisions).

Maintain procedures to track and communicate progress of data sets as they move through the conversion process.

Query and verify that data have been correctly integrated into the DIVER Data Warehouse.

Major Spills Data Management Contingency (T&M) 2.4.1 This is an optional contingency task that may be required in the event of a major spill or environmental emergency. The contractor must have the capacity to ramp up support operations in the event of a major spill or event. The Contractor may be required to redirect activities described under other tasks to support time-critical response and NRDA efforts while maintaining support for other on-going projects.


About Lynker

Lynker is a growing, employee owned, small 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, competitive salaries and benefits, and the opportunity to work in a culture of exceptionally skilled and diverse professionals who embrace sound science and creative solutions.

Lynker is an E-Verify employer.

Lynker is proud to be an Equal Opportunity Employer and encourages women, minorities, individuals with disabilities and veterans to apply.


Keywords: Lynker Corporation, Leesburg , Database Programmer, IT / Software / Systems , Leesburg, Virginia

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Virginia jobs by following @recnetVA on Twitter!

Leesburg RSS job feeds