T-SQL Database Admin SSRS And SSIS SQL Queries Data Integration Visual Studio C# Tec   Requirement id 118883 Job title Developer Job location in Des Moines, IA Skills required SQL Server 2012, T-SQL, Database Admin, SSRS And SSIS SQL Queries Data Integrati Open Date 31-Aug-2021 Close Date Job type Contract Duration 10 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: SQL Server 2012, T-SQL, Database Admin, SSRS And SSIS SQL Queries Data Integrati Start Date :09/15/2021 End Date :06/30/2022 Submission Deadline :09/6/2021 Client Info : DHS-CWIS: Department of Human Services Note : * Agency Interview Type: Web Cam Interview Only Description : The successful candidate will spend a good portion of their time working with the Systems that support Medicaid, TANF, SNAP, Child Care and Child Welfare Systems; expected to work in concert with Front End developer(s) troubleshooting system problem reports and processing enhancement requests. This position will assist in enhancements of existing systems and/or entire end-to-end new system development 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 users requirements. • Develop database schemas, tables and dictionaries using SQL server 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) 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). Required Experience/Skills: • Bachelors 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   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 118883 while calling.   Other jobs in IA: Des Moines (16), West Des Moines (2), West Desmoines (1), SQL Server 2012 job openings in Des Moines, IA Jobs List IA-OCIO-IDR-TS2-SR SQL Server DBA/SSIS Developer - (635045) Create date: 31-Aug-2020 Start Date : 9/21/2020 End Date : 9/21/2021 Submission Deadline : Client Info : OCIO: Office of the Chief Information Officer Note: * Interview Type : Web Cam Interview Only Description : Senior SQL Server DBA/SSIS Developer is needed to suppor.... (This job is for - DBA SSIS Jobs in IA DesMoines Developer - (in Des Moines, IA))    SQL Server 2012 job openings in other states Jobs List Programmer-Analyst IV - 94835 - SP Create date: 01-Nov-2021 start date:11/22/2021 End date:06/30/2022 submission deadline:11/8/2021 4:00:00 PM client info : DPI Note: * Interview Process: Microsoft TEAMS with video on, 1-2 rounds * Duration: through 6/30/2022 with possibility of extension to renew up to an additional 2 years .... (This job is for - Transact SQL Jobs in WI Madison Analyst - (in Madison, WI)) Programmer-Analyst IV - 92992 - SP Create date: 28-Sep-2021 start date:11/1/2021 End date:06/30/2022 submission deadline:October 6, 2021 at 4:00PM CST. client info : DPI Note: * Interview Process: Microsoft TEAMS with video on, 1-2 rounds * Duration: through 6/30/2022 with possibility of extension to renew up to an additional 2 years .... (This job is for - Transact SQL Jobs in WI Madison Analyst - (in Madison, WI)) SR .NET Developer Create date: 11-Jun-2021 Job Description: The project will be developed using some of the latest tools and technologies including Visual Studio 2015, MVC, J-Query, Bootstrap, .NET Framework 4.0 and above, Entity Framework 4.0 and SQL 2012 and above. The resource must be highly motivated, result-oriented, and qualified in development of large web based solutions.... (This job is for - MVC4 Jobs in KY Frankfort Developer - (in Frankfort, KY)) SRF Project And Loan Tracking System - 110.7-21-012 - NSPO Create date: 19-Apr-2021 Start Date :05/17/2021 Submission Deadline :05/10/2021 03:00 PM CT Client Info : Environmental Quality, ND Department of Description : SCOPE OF WORK : The STATE is soliciting proposals for IT professional services to design/configure and implement a system that will be used to.... (This job is for - job Jobs in ND Bismarck Consultant - (in Bismarck, ND)) DHHS- DHSR IT Enterprise Tester (644436) Create date: 21-Jan-2021 Start Date :01/25/2021 End Date :01/24/2022 Submission Deadline :01/27/2021 Client Info : NCDHHS-AM Note : * Agency Interview Type : Webcam Interview Only Description : It is actively developing a web-based software product using Agile, Lean, and Scrum dev.... (This job is for - job Jobs in NC Raleigh Tester - (in Raleigh, NC))     (Developer: SQL Server 2012, T-SQL, Database Admin, SSRS And SSIS SQL Queries Data Integrati in Des Moines, IA)

Featured Jobs Troubleshooting Engineer (Jobs in Des Moines, Iowa) Application Developer (Jobs in Richmond, Virginia) Business Analyst Business Analyst (Jobs in Richmond, Virginia) Consultant (Jobs in Murfreesboro, Tennessee) TFS Automation Analyst (Jobs in Dimondale, Michigan) Cloud Architect (Jobs in Lansing, Michigan) GitHub Consultant (Jobs in Lansing, Michigan) IT Developer (Jobs in Atlanta, Georgia) Microsoft Consultant (Jobs in ANDERSON, South Carolina) Business Analyst JAD SQL Analyst (Jobs in Lansing, Michigan)