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!
|