Junior SQL Server Database Developer (DBA)

Team ASRC Federal is actively seeking a SQL Server Database Developer to join our Scaled Agile Framework (SAFe) Development team. The selected candidate will support a government client in Fort Collins, Colorado.

Would you like to be part of a dynamic team of dedicated software professionals? Are you concerned about protecting our Nation’s natural resources? We need people who are committed to action. People who want to apply their education and experience to make sure that all of us enjoy the benefits of productive soil, clean water, clean air, and abundant wildlife that come from a healthy environment.

Natural resource conservation is an effort of Federal and State agencies, universities, and professional societies to deliver science-based information to landowners. Join us to build the technology to help people understand, preserve, and increase the productivity of our natural resources.

Position Description

The successful candidate will:

Support database design and database development efforts for specific application project teamsPartner with service-layer backend team members and system architects to define resources within a contract-first design paradigmWork with automated TFS and Jenkins based CI/CD pipelines to deploy Visual Studio database solutions to multiple environmentsBuild robust unit, functional, and regression tests as part of a SQL Server value pipelineTroubleshoot database issues in multiple environments as part of a highly collaborative teamPrepare scripts for modifying and maintaining production schemas and dataIntegrate Transact SQL code, SSRS reports, and SSIS packages into source controlMigrate client-provided data into existing database schema in a way that maintains the data integrity of the destination systemParticipate in SAFe ceremonies, including Product Increment (PI) planning. Contribute to maintaining Project Backlogs are required

There are some operational requirements, but the position need is mostly for SQL Server Database Development for Web based .Net. applications. Prior experience implementing large scale relational data warehouse on SQL Server platform a plus. Basic familiarity with C#/.NET coding and web-based development experience would be a plus.

Requirements

Required Skills and Competencies:

SQL Server 2016+ T-SQL development experienceAbility to provision new SQL Server logins and users and apply appropriate database permissionsAbility to import client data into existing databases while maintaining referential integrityFamiliarity with one or more version control systems such as Git, Subversion, or SourceSafeAbility to performance tune T-SQL queriesRelational data architecture skillsExperience in a remote work environmentThe ability to effectively communicate and work independently on a team

Education And Experience

Computer Science or related technology/engineering degree1-3 years of SQL Server Development Experience in an enterprise environment;Candidates without a college degree will be considered, but must have at least 3 years of SQL Server Development Experience in an enterprise environment;

Desired Skills

SQL Server 2016+ Administrative skillsWorking knowledge of Microsoft Visual Studio database projectsAbility to write robust functional and regression tests for T-SQL views, stored procedures, and functionsEntity Relationship Diagramming skillsExperience with Red Gate database toolsSSIS design and implementation experienceSSRS development and deployment experienceSSAS design and implementation experience including writing basic MDX queriesExperience working with databases articles that are utilized in SQL Server replication publications and subscriptions

Successful candidate is subject to a background investigation by the government and must be able to meet the requirements to hold a position of public trust.

U.S. Citizenship or Green Card, with 3-year residency required.

ASRC Federal and its Subsidiaries are Equal Opportunity / Affirmative Action employers. All qualified applicants will receive consideration for employment without regard to race, gender, color, age, sexual orientation, gender identification, national origin, religion, marital status, ancestry, citizenship, disability, protected veteran status, or any other factor prohibited by applicable law.

Key Skills

• SQL