DBA SSIS SSRS Stored Procedure Development TroubleShooting Skills Query Optimization   Requirement id 109652 Job title Developer Job location in Des Moines, IA Skills required SQL Server 2012, DBA, SSIS, SSRS Stored Procedure Development Troubl Open Date 31-Aug-2020 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: SQL Server 2012, DBA, SSIS, SSRS Stored Procedure Development Troubl 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 support the Iowa Department of Revenue systems Modernization Project is looking for someone who has a strong understanding of SQL Server database administration, with experience developing in SSIS and XML. This position will be an addition to our database support team of three SQL Server DBAs. This person will help shape the departments future SQL Server vision from database standards and policies to automation efforts for deployment. The ideal candidate will have experience implementing databases in the cloud and will have experience with continuous integration and automation concepts. Responsibilities: • Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.). • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. • Refine and automate regular processes, track issues, and document changes. • Effectively prioritize and manage concurrent projects, demonstrate initiative, and work independently with minimal supervision. • Drive results and leverage past experiences to improve the environment and related processes. • Coordinate with other agency departments to update and integrate processes as necessary. • Demonstrate leadership skills (foster a spirit of teamwork, mentor peers, and take ownership of assigned project work). • Install and configure SQL Server, applying service packs and feature packs. • Apply data modeling techniques to ensure integration and performance expectations are met as well as allow for future flexibility to meet changing business needs. • Assist developers with complex query tuning and schema refinement. • Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps. REQUIRED SKILLS: • SQL Server DBA experience with 2012 or newer [8 years – REQUIRED] • SQL Server Integration Services (SSIS) [8 years – REQUIRED] • SQL Server Reporting Services (SSRS) [8 years – REQUIRED] • SQL Server Stored Procedure Design and implementation [8 years – REQUIRED] • SQL Server database troubleshooting and query optimization [8 years – REQUIRED] • SQL Server Database Performance monitoring [8 years – REQUIRED] • SQL Server Database Design [8 years – REQUIRED] • Expert understanding of Database best practices [8 years – REQUIRED] • Experience upgrading databases from lower to latest versions [8 years – REQUIRED] • Data Warehousing concepts [3 years – REQUIRED] • Operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred) [2 years – REQUIRED] • Databases migration using Azure &/or AWS [HIGHLY DESIRED] • Experience in performing DR techniques - Always On, Clustering, Replication, Database mirroring, etc. [HIGHLY DESIRED]   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 109652 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-DHS-DBA5-SQL Developer (658680) Create date: 31-Aug-2021 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 thei.... (This job is for - T SQL Database Admin 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, DBA, SSIS, SSRS Stored Procedure Development Troubl in Des Moines, IA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)