Database Engineer

Lynker Technologies on contract to NOAA's Office for Coastal Management (OCM) is looking for a Database Engineer with the following skill sets.

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

Skills and Requirements of the Database Engineer

• 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).

• 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 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 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, and the opportunity to work in a culture of exceptionally skilled and diverse professionals who embrace sound science and creative solutions. Lynker's benefits include the following:

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.