Senior Software Developer

Role: Senior Software Developer ( .Net, SQL and Azure)
Client: State of Iowa (DHS)
Duration: 12Months
Location: Walnut, IA
Interview Type: In Person Only
 Job Description:
 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 2008 R2, 2012, and 2016.
·         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) 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).
 

Required skills:
·         Experience with working with different versions of SQL server(2008 R2, 2012 and 2016)
·         Expert knowledge of TSQL
·         Database modeling & Design
·         Experience in creating batch packages using SSIS
·         Experience in creating reports using SSRS
·         Experience optimizing SQL queries for improving performance and maintaining data integrity
·         Experience with C#, .NET framework, and object oriented design/development
·         Experience in architecting, writing and maintaining RESTful APIs/Services
·         Experience in using LINQ
·         Experience with Microsoft Azure cloud services

Want to apply later?

Type your email address below to receive a reminder

Apply to Job

ErrorRequired field
ErrorRequired field
ErrorRequired field
Error
Error
insert_drive_file
insert_drive_file