SQL Server Database Developer

Arctic Slope Regional Corporation - Richmond, VA

Full-time - Mid Level

Remote - Richmond, VA

Support Activities for Mining

About the position

ASRC Federal is actively seeking an experienced Senior SQL Server Database Developer to join our development team. The selected candidate will support a government client in Fort Collins, Colorado. This position is crucial for those who are passionate about protecting our Nation's natural resources and want to apply their education and experience to ensure the sustainability of our environment. The successful candidate will lead the database design and development efforts for specific application project teams, working closely with internal stakeholders to accurately design relational data models. In this role, you will support database needs across multiple environments including development, test, QA, and UAT, all within a highly collaborative team environment. You will be responsible for preparing scripts for modifying and maintaining production schemas and data, utilizing source control to deploy database solutions through Visual Studio database projects. Additionally, you will manage SSIS, SQL Code, and Transact SQL routines, and assist with SSRS report development and deployment. Familiarity with back-end .NET development, particularly in web service development and managing the data access tier, is also essential. The position primarily focuses on SQL Server Database Development for web-based .NET applications and integration with commercial off-the-shelf (COTS) applications. Prior experience implementing large-scale relational data warehouses on the SQL Server platform is a plus. The role may also involve some C#/.NET work, so prior enterprise-class web-based development experience would be beneficial.

Responsibilities

• Lead the database design and development efforts for specific application project teams.
• Work with internal stakeholders to accurately design relational data models.
• Support database needs for multiple environments (development, test, QA, UAT) in a highly collaborative team environment.
• Prepare scripts for modifying and maintaining production schemas and data.
• Utilize source control to deploy database solutions through Visual Studio database projects.
• Be responsible for SSIS, SQL Code, and Transact SQL routines.
• Assist with SSRS report development and deployment.
• Be familiar with back-end .NET development with skills in web service development and managing the data access tier.

Requirements

• SQL Server 2016/2019+ development and administration experience
• SSIS design and implementation experience
• Transact SQL development experience/analysis in an environment that may or may not be using ORM tools
• Familiarity with one or more version control systems such as Subversion, Git, and/or SourceSafe
• Experience writing performant TSQL and keeping current on industry best practices
• Entity Relationship Diagramming skills
• Excellent data analyst and architecture skills
• Experience with data modeling and schema design techniques
• Experience in a remote work environment
• Possess excellent communication skills, the drive to succeed and work independently and on a team, with the ability to multi-task, and deliver quality results
• Bachelors degree in Computer Science or related technical discipline
• 5+ years of SQL Server Database Design and Administration Experience in an enterprise environment

Nice-to-haves

• Experience with Red Gate database tools
• Working knowledge of Microsoft Visual Studio database projects
• PowerDesigner experience
• SSRS development and deployment experience
• SSAS design and implementation experience
• Document and Records Management experience
• Experience with data replication, synchronization, and data provisioning
• Experience with mobile and disconnected data stores
• Familiarity with common enterprise analysis methods
• Experience with writing web services and data access classes in .Net