Junior SQL Server Database Developer

ASRC Federal is a leading government contractor furthering missions in space, public health and defense. As an Alaska Native owned corporation, our work helps secure an enduring future for our shareholders. Join our team and discover why we are a top veteran employer and Certified Great Place to Work™

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.

Work Location: Fort Collins, CO; Reston, VA; Remote USA (near a USDA facility)

Position Description:

The successful candidate will:

• Support database design and database development efforts for specific application project teams
• Partner with service-layer backend team members and system architects to define resources within a contract-first design paradigm
• Work with automated TFS and Jenkins based CI/CD pipelines to deploy Visual Studio database solutions to multiple environments
• Build robust unit, functional, and regression tests as part of a SQL Server value pipeline
• Troubleshoot database issues in multiple environments as part of a highly collaborative team
• Prepare scripts for modifying and maintaining production schemas and data
• Integrate Transact SQL code, SSRS reports, and SSIS packages into source control
• Migrate client-provided data into existing database schema in a way that maintains the data integrity of the destination system
• Participate 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.

Education and Experience:

• Computer Science or related technology/engineering degree
• 1-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

Required Skills and Competencies:

• SQL Server 2016+ T-SQL development experience
• Ability to provision new SQL Server logins and users and apply appropriate database permissions
• Ability to import client data into existing databases while maintaining referential integrity
• Familiarity with one or more version control systems such as Git, Subversion, or SourceSafe
• Ability to performance tune T-SQL queries
• Relational data architecture skills
• The ability to effectively communicate and work independently on a team
• Experience in a remote work environment

Desired Skills:

• SQL Server 2016+ Administrative skills
• Working knowledge of Microsoft Visual Studio database projects
• Ability to write robust functional and regression tests for T-SQL views, stored procedures, and functions
• Entity Relationship Diagramming skills
• Experience with Red Gate database tools
• SSIS design and implementation experience
• SSRS development and deployment experience
• SSAS design and implementation experience including writing basic MDX queries
• Experience 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 H1B Visa or Green Card, with 3-year residency required

We invest in the lives of our employees, both in and out of the workplace, by providing competitive pay and benefits packages. Benefits offered may include health care, dental, vision, life insurance; 401(k); education assistance; paid time off including PTO, holidays, and any other paid leave required by law.

EEO Statement

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.