• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

SQL Server/Full Stack Developer

In United States

Save this job

SQL Server/Full Stack Developer   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

SQL Server/Full Stack Developer

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Des Moines IA United States

JOB DESCRIPTION:

Location: Des Moines IA

Client: State of Iowa

Duration: 1 Year

Interview: Either Web Cam or In Person

Remote Role

Rate: $55-$60/hr c2c

 

The successful candidate will spend a good portion of their time working with the Systems that support Child Care, Child Welfare, Medicaid, TANF, and SNAP Systems and expected to work in concert with Front End developer(s) troubleshooting system problem reports and processing enhancement requests.
This role will be primarily focused on backend development with MS SQL Server including SSIS and SSRS development.


While working on system enhancements the successful candidate is expected to propose, design, and develop solutions in concert with the front end developer(s) to fulfill the business requirements.
Be able to update and troubleshoot ASP.NET applications including the front-end UI code. Experience with MVC highly preferred.


The successful candidate will be required to follow standard practices for migrating changes to the test and production environments and provide post production support. When not working on enhancement requests or problem reports, the candidate would concentrate on performance tuning.
Individual should work well in a team and independently as needed.


Responsibilities:
• Assist in designing, developing, and enhancing large transaction and reporting databases.
• Assist in converting existing Legacy applications to newer technologies
• Assist in integrating in-house applications with enterprise third party solutions.
• Design, create, and implement database systems based on the end user's requirements.
• Develop database schemas, tables and dictionaries using SQL server 2012, 2016 and 2019.
• Translate business requirements into software applications and models.
• Develop and maintain efficient, well documented custom SQL scripts, stored procedures, triggers using Microsoft T-SQL in accordance with defined business rules and requirements to support application development
• Create and troubleshoot stored procedures and queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands, Database Engine Tuning Advisor and Execution plans. Recommend query and index improvements in application to increase performance.
• Thoroughly test all approved application and database code additions and changes prior to implementing to staging. Request approval from users prior to implementing any additions or changes to the production environment.
• Research, understand and apply best practices, cost-effective solution, policies and procedures towards all assigned tasks, roles and responsibilities.
• Use Microsoft Team Foundation Server (TFS) and/or Azure Dev Ops to manage changes to code.
• Participate in requirement analysis discussions and come up with efficient technical solution
• Develop new and maintain existing reports using SQL Server Reporting Services (SSRS)
• Build and Deploy ETL processes using SQL Server Integration Services (SSIS).
• Guide and share knowledge with other SQL developers when the need arises.
Required Experience/Skills:
• Bachelor's degree in Computer Science or related field or relevant work experience
• Demonstrated experience with relational database design and implementation using MS SQL Server
• Experience optimizing SQL queries for improving performance and maintaining data integrity
• Experience in creating database migration scripts by using schema and data compare tools
• Experience in creating batch packages using SSIS
• Experience in creating reports using SSRS
• Write efficient, consistent and testable code
• Proficiency with using Visual Studio 2012,2015 & 2017
• Ability to understand and analyze the business requirements and come up with efficient technical solution
• Experience in using LINQ
• Being able work with minimal requirements and improve the functionality as requirements are refined
• Technical understanding of infrastructure components, their dependencies, and interactions between servers, virtual systems, networks, databases, web applications, etc.

Required/Desired Skills

 

 

Skill Required/Desired Amount of Experience
Experience with working with different versions of SQL server(2012, 2016, and 2019) Required 5 Years
Expert knowledge of TSQL Required 5 Years
Database modeling & Design Required 5 Years
Experience in creating batch packages using SSIS Required 5 Years
Experience in creating reports using SSRS Required 5 Years
Experience optimizing SQL queries for improving performance and maintaining data integrity Required 5 Years
Experience with C#, .NET framework, and object oriented design/development Required 5 Years
Experience in architecting, writing and maintaining RESTful APIs/Services Required 5 Years
Experience in using LINQ Required 5 Years
Proficiency with different versions of Visual Studio (2012,2015 & 2017) - 5 years Required 5 Years
Experience with Microsoft Azure cloud services Desired 0  
Experience in using Power BI Desired 0  

 

 

 

 

Questions

 

 

 

 

  Description
Question 1 The Contractor must report any disciplinary action, misdemeanor or felony convictions to the State for any temporary IT staff provided. Do you agree to this requirement?
Question 2 Absences greater than two weeks MUST be approved by CAI Management in advance, and contact information must be provided to CAI so that a resource can be reached during his or her absence. The client has the right to dismiss the resource if she or he does not return to work by the agreed upon date. Do you accept this requirement?
Question 3 This requirement falls under the E-RTR process. The candidate MUST submit their Right to Represent electronically following the process to be considered. Do you accept this requirement?
Question 4 Please list candidate's email address.
Question 5 The Vendor Rate for this position is $78.68. Do you accept this requirement?
Question 6 PROVIDE CANDIDATES CURRENT PHYSICAL LOCATION [HERE]
Question 7 IF OFFERED THE POSITION – How much notice does your candidate require before he/she can start working?
Question 8 SHOW YOUR WORK - In the summary of qualifications field under the details tab of the candidate's profile, you should explain why your candidate is the best fit for this position. Please confirm that you have thoroughly validated and attested to the accuracy of the credentials listed throughout this candidate's VectorVMS profile and resume according to Section 5.2.5 of ITS-009440. Do you confirm? Candidates will get rejected if an agency cuts and pastes the candidates' resumes into this field.

 

 

Position Details

POSTED:

Sep 24, 2022

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16560144265862172

LOCATION:

United States

CITY:

Des Moines IA

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

SQL Server/Full Stack Developer    Apply

Click on the below icons to share this job to Linkedin, Twitter!

<p>Location: Des Moines IA</p> <p>Client: State of Iowa</p> <p>Duration: 1 Year</p> <p>Interview: Either Web Cam or In Person</p> <p>Remote Role</p> <p>Rate: $55-$60/hr c2c</p> <p> </p> <p>The successful candidate will spend a good portion of their time working with the Systems that support Child Care, Child Welfare, Medicaid, TANF, and SNAP Systems and expected to work in concert with Front End developer(s) troubleshooting system problem reports and processing enhancement requests.<br /> This role will be primarily focused on backend development with MS SQL Server including SSIS and SSRS development.<br /> <br /> <br /> While working on system enhancements the successful candidate is expected to propose, design, and develop solutions in concert with the front end developer(s) to fulfill the business requirements.<br /> Be able to update and troubleshoot ASP.NET applications including the front-end UI code. Experience with MVC highly preferred.<br /> <br /> <br /> The successful candidate will be required to follow standard practices for migrating changes to the test and production environments and provide post production support. When not working on enhancement requests or problem reports, the candidate would concentrate on performance tuning.<br /> Individual should work well in a team and independently as needed.<br /> <br /> <br /> Responsibilities:<br /> • Assist in designing, developing, and enhancing large transaction and reporting databases.<br /> • Assist in converting existing Legacy applications to newer technologies<br /> • Assist in integrating in-house applications with enterprise third party solutions.<br /> • Design, create, and implement database systems based on the end user's requirements.<br /> • Develop database schemas, tables and dictionaries using SQL server 2012, 2016 and 2019.<br /> • Translate business requirements into software applications and models.<br /> • Develop and maintain efficient, well documented custom SQL scripts, stored procedures, triggers using Microsoft T-SQL in accordance with defined business rules and requirements to support application development<br /> • Create and troubleshoot stored procedures and queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands, Database Engine Tuning Advisor and Execution plans. Recommend query and index improvements in application to increase performance.<br /> • Thoroughly test all approved application and database code additions and changes prior to implementing to staging. Request approval from users prior to implementing any additions or changes to the production environment.<br /> • Research, understand and apply best practices, cost-effective solution, policies and procedures towards all assigned tasks, roles and responsibilities.<br /> • Use Microsoft Team Foundation Server (TFS) and/or Azure Dev Ops to manage changes to code.<br /> • Participate in requirement analysis discussions and come up with efficient technical solution<br /> • Develop new and maintain existing reports using SQL Server Reporting Services (SSRS)<br /> • Build and Deploy ETL processes using SQL Server Integration Services (SSIS).<br /> • Guide and share knowledge with other SQL developers when the need arises.<br /> Required Experience/Skills:<br /> • Bachelor's degree in Computer Science or related field or relevant work experience<br /> • Demonstrated experience with relational database design and implementation using MS SQL Server<br /> • Experience optimizing SQL queries for improving performance and maintaining data integrity<br /> • Experience in creating database migration scripts by using schema and data compare tools<br /> • Experience in creating batch packages using SSIS<br /> • Experience in creating reports using SSRS<br /> • Write efficient, consistent and testable code<br /> • Proficiency with using Visual Studio 2012,2015 & 2017<br /> • Ability to understand and analyze the business requirements and come up with efficient technical solution<br /> • Experience in using LINQ<br /> • Being able work with minimal requirements and improve the functionality as requirements are refined<br /> • Technical understanding of infrastructure components, their dependencies, and interactions between servers, virtual systems, networks, databases, web applications, etc.<br /> <br /> </p> <h5>Required/Desired Skills</h5> <p> </p> <p> </p> <table border="1" style="border-collapse:collapse"> <thead> <tr> <th>Skill</th> <th>Required/Desired</th> <th>Amount</th> <th>of Experience</th> </tr> </thead> <tbody> <tr> <td>Experience with working with different versions of SQL server(2012, 2016, and 2019)</td> <td>Required</td> <td>5</td> <td>Years</td> </tr> <tr> <td>Expert knowledge of TSQL</td> <td>Required</td> <td>5</td> <td>Years</td> </tr> <tr> <td>Database modeling & Design</td> <td>Required</td> <td>5</td> <td>Years</td> </tr> <tr> <td>Experience in creating batch packages using SSIS</td> <td>Required</td> <td>5</td> <td>Years</td> </tr> <tr> <td>Experience in creating reports using SSRS</td> <td>Required</td> <td>5</td> <td>Years</td> </tr> <tr> <td>Experience optimizing SQL queries for improving performance and maintaining data integrity</td> <td>Required</td> <td>5</td> <td>Years</td> </tr> <tr> <td>Experience with C#, .NET framework, and object oriented design/development</td> <td>Required</td> <td>5</td> <td>Years</td> </tr> <tr> <td>Experience in architecting, writing and maintaining RESTful APIs/Services</td> <td>Required</td> <td>5</td> <td>Years</td> </tr> <tr> <td>Experience in using LINQ</td> <td>Required</td> <td>5</td> <td>Years</td> </tr> <tr> <td>Proficiency with different versions of Visual Studio (2012,2015 & 2017) - 5 years</td> <td>Required</td> <td>5</td> <td>Years</td> </tr> <tr> <td>Experience with Microsoft Azure cloud services</td> <td>Desired</td> <td>0</td> <td> </td> </tr> <tr> <td>Experience in using Power BI</td> <td>Desired</td> <td>0</td> <td> </td> </tr> </tbody> </table> <p> </p> <p> </p> <p> </p> <p> </p> <h5>Questions</h5> <p> </p> <p> </p> <p> </p> <p> </p> <table border="1" style="border-collapse:collapse"> <thead> <tr> <th> </th> <th>Description</th> </tr> </thead> <tbody> <tr> <td>Question 1</td> <td>The Contractor must report any disciplinary action, misdemeanor or felony convictions to the State for any temporary IT staff provided. Do you agree to this requirement?</td> </tr> <tr> <td>Question 2</td> <td>Absences greater than two weeks MUST be approved by CAI Management in advance, and contact information must be provided to CAI so that a resource can be reached during his or her absence. The client has the right to dismiss the resource if she or he does not return to work by the agreed upon date. Do you accept this requirement?</td> </tr> <tr> <td>Question 3</td> <td>This requirement falls under the E-RTR process. The candidate MUST submit their Right to Represent electronically following the process to be considered. Do you accept this requirement?</td> </tr> <tr> <td>Question 4</td> <td>Please list candidate's email address.</td> </tr> <tr> <td>Question 5</td> <td>The Vendor Rate for this position is $78.68. Do you accept this requirement?</td> </tr> <tr> <td>Question 6</td> <td>PROVIDE CANDIDATES CURRENT PHYSICAL LOCATION [HERE]</td> </tr> <tr> <td>Question 7</td> <td>IF OFFERED THE POSITION – How much notice does your candidate require before he/she can start working?</td> </tr> <tr> <td>Question 8</td> <td>SHOW YOUR WORK - In the summary of qualifications field under the details tab of the candidate's profile, you should explain why your candidate is the best fit for this position. Please confirm that you have thoroughly validated and attested to the accuracy of the credentials listed throughout this candidate's VectorVMS profile and resume according to Section 5.2.5 of ITS-009440. Do you confirm? Candidates will get rejected if an agency cuts and pastes the candidates' resumes into this field.</td> </tr> </tbody> </table> <p> </p> <p> </p>


Please wait..!!