Description:
Lynker Technologies on contract to NOAA’s Office for Coastal Management (OCM) is looking for a Database Engineer with the following skill sets. This person can work remotely, but most be located in the Washington, DC metro area due to occasional office visits.
In This Position You Will
-
Provide detailed analysis of problems; prepare detailed design documents with recommendation, support and enhance existing database schemas.
-
Analyze performance of applications and take actions to prevent performance issues. Provide support to QA team with data comparison.
-
Work collaboratively with other developers to design and develop databases and APIs needed for applications
-
Troubleshoot and resolve production support issues.
-
Actively participate in the development and implementation of new processes that improve efficiency and enhance productivity.
-
Expertise in database schema design and maintenance, expertise designing and tuning highly available and high-volume transactional database.
-
Expertise with data replication and data migration tools and knowledge of the programming best practices.
-
Provides input to and collaborates with cross-teams.
-
Assists with planning, designing, documenting, installing, configuring and maintaining database systems
-
Assists with developing, supporting and maintaining SQL PaaS databases in Microsoft Azure
. Requirements:
Skills and Requirements
-
Database modeling, designing and developing experience on MS SQL Server environment
-
Extensive working knowledge of T-SQL
-
Administering MSSQL Instances and Databases (routine maintenance, backups, restores, performance tuning, security best-practices (logins/users/permissions)
-
Working knowledge of constructing and deployment of SSIS and SSRS
-
Experience working alongside application development teams designing database schemas, tables, views, stored procedures, etc.
-
Willingness to learn new technologies and design practices
-
BA/BS (equivalent technical training and/or certifications can be substituted for academic degrees).
-
years minimum experience.
-
You will be expected to complete an on-site and/or take home assignment for this position.
Nice to Have, But Not Required
-
Familiarity with Microsoft Azure
-
Familiarity with Microsoft SharePoint
-
Familiarity with the setup, configuration and operation of the OpenData Protocol utilizing C#
-
Familiarity with PostgreSQL/PostGIS and GIS products
-
Experience with spatial and non- spatial data.
-
REST API design experience with JSON and XML
-
Working knowledge of ApexSQL Suite or similar tools
-
Experience with .NET Entity Frameworks or other ORMs
-
Experience with Node.js frameworks like express is a plus
View Examples of Recently Developed Applications
Adapting Stormwater Management for Coastal Floods
https://coast.noaa.gov/digitalcoast/training/stormwater-floods.html
Sea Level Rise Viewer
https://coast.noaa.gov/digitalcoast/tools/slr.html
Coastal Flood Exposure Mapper
https://coast.noaa.gov/digitalcoast/tools/flood-exposure.html
Historical Hurricane Tracks
https://coast.noaa.gov/digitalcoast/tools/hurricanes.html
Data Access Viewer
https://coast.noaa.gov/dataviewer/#/
About Lynker
Lynker, LLC is a growing, Hub-zone certified small business specializing in professional, scientific and technical services, with offices in Leesburg, VA and Boulder, CO. 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 Technologies is proud to be an Equal Opportunity Employer and encourages women, minorities, individuals with disabilities and veterans to apply.