DBA SQL SQL SERVER Database Performance Monitoring Monitoring Troubleshooting Quer   Requirement id 111523 Job title Team Lead Job location in Des Moines, IA Skills required Management Skills, Strong Written And Verbal Communication Skills, Data Warehouse Concepts, DBA SQL SQL SERVER Database Performance Open Date 11-Nov-2020 Close Date Job type Contract Duration 11 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Team Lead: Management Skills, Strong Written And Verbal Communication Skills, Data Warehouse Concepts, DBA SQL SQL SERVER Database Performance Start Date : 11/30/2020 End Date : 10/24/2021 Submission Deadline : 11/16/2020 * Client Info : OCIO: Office of the Chief Information * Note : Web Cam Interview Only The State of Iowa 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 supporting the Iowa Department of Public Health, joining a team of three. The ideal candidate will have experience implementing databases in the cloud and establishing operational procedures to maximize utilization. Project: SQL Server DBA Support for IDPH. Description: Ongoing DBA support, SSIS development and technical leadership for the SQL Server DBA staff. Function as a Team Lead / Mentor to oversee and instruct less senior staff. Provide Data Warehouse Administration of source files and develops changes to Cubes and Dimensions. Business Case: Support Iowa Department of Public Health SQL Server DBMS and associated ETL (SSIS) and Reporting needs (SSRS). Also, Data Warehouse Administrator. Deliverables: Database installs, SSIS & SSRS development, performance tuning and troubleshooting. Data Warehouse maintenance changes. • MS SQL 2016+ • SSRS 2015+ • SSIS for ETL • T SQL for stored procedures • Microsoft Window Server 2019 Datacenter, Microsoft Window Server 2016 • Datacenter and Microsoft Window Server 2012R2 • AWS Always On Availability Group Responsibilities: • Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.). • 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. • Demonstrated leadership skills (foster a spirit of teamwork, mentor peers and take ownership of assigned project work). • Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps. • Coordinate with other agency departments to update and integrate processes as necessary. REQUIRED SKILLS: • Expert understanding of Database best practices 8 YEARS • Strong technical and project management skills, as well as the willingness to engage in a hands-on way, to provide specific technical guidance and leadership to the team - 6 YEARS • Strong written and verbal communication skills 6 YEARS • Data Warehousing concepts (Cubes and Dimensions) 3 YEARS • SQL Server DBA experience with 2012 or newer 8 YEARS • SQL Server Database Design 8 YEARS • SQL Server Database Performance monitoring 8 YEARS • SQL Server database troubleshooting and query optimization 8 YEARS • SQL Server Stored Procedure Design and implementation (T-SQL) 8 YEARS • SQL Server Integration Services (SSIS) 8 YEARS • SQL Server Reporting Services (SSRS) 8 YEARS • Experience in implementing operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred). 2 YEARS • Familiarity with Agile (Scrum and/or Kanban) methodology 2 YEARS • AWS Always On Availability Groups 2 YEARS • Experience migrating databases to the Cloud using Azure & AWS Highly Desired • Architecture Planning experience   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 111523 while calling.   Other jobs in IA: Des Moines (16), West Des Moines (2), West Desmoines (1), Management Skills job openings in Des Moines, IA Jobs List Scrum Master Create date: 18-May-2020 Job Description: Note: * Only (Locals and former Nationwides please) Facilitates high performing, self-organized Scrum Team, guides software delivery from user story creation to implementation, leverages appropriate software delivery practices to continuously improve software delivery, efficiency and quality. Perfor.... (This job is for - Facilitator Jobs in IA DesMoines Consultant - (in Des Moines, IA))    Management Skills job openings in other states Jobs List Technical Writer III - FR0000102148 Create date: 12-May-2023 Start date :06/01/2023 End Date :11/30/2023 Submission deadline : 05/15/2023 Client Info :OIT Note: * Position Location Remote Description : The position will be writing various documents (standard operating procedures, how-to instructions, user guides, etc.) for the Governors Office.... (This job is for - MS Office Jobs in CO Denver TechLead - (in Denver, CO)) Technical Writer III - FR0000101681 Create date: 12-May-2023 Start date :06/01/2023 End Date :11/30/2023 Submission deadline : 05/15/2023 Client Info :OIT Note: * Position Location Remote Description : The position will be writing various documents (standard operating procedures, how-to instructions, user guides, etc.) for the Governors Office of I.... (This job is for - Technology Jobs in CO Denver TechLead - (in Denver, CO)) Project Manager - 60604 Create date: 05-May-2023 Start date :05/11/2023 End Date :06/30/2024 Submission deadline :05/09/2023 Client Info : CO CDLE Note: * Position Location Remote Description : The role of the Project Manager is to plan, execute, and finalize projects according to defined timelines and within the allocated budget..... (This job is for - Project Manager Jobs in CO Denver Manager - (in Denver, CO)) NJ Transit HCM Benefit Systems Analyst (710171) Create date: 02-May-2023 Hybrid Start date :05/22/2023 End Date :08/31/2023 Submission deadline :5/5/2023 Client Info :TRANSIT Description : Note: Position is Hybrid requiring 2-3 Days / Week Onsite. Please DO NOT submit candidates previously submitted to Req 703444 HCM Benefits Analyst. The .... (This job is for - Requirements Hybrid Jobs in NJ Trenton Analyst - (in Trenton, NJ)) Business Systems Analyst IV-20230313063350 Create date: 14-Mar-2023 Start date :3/29/2023 End Date :1+years from the start date Submission deadline :03-15-2023 Note: * Job Site On-Site Description : Summary: The main function of a business systems analyst is to perform the analysis, design, implementation, modification, and daily functional support of all .... (This job is for - Automation Jobs in NC Durham Analyst - (in Durham, NC))     (Team Lead: Management Skills, Strong Written And Verbal Communication Skills, Data Warehouse Concepts, DBA SQL SQL SERVER Database Performance in Des Moines, IA)

Featured Jobs Self Developer (Jobs in Atlanta, Georgia) Cisco Routers Network Consultant (Jobs in Virginia Beach, Virginia) Java J2EE HTML/CSS SQL Consultant (Jobs in Richmond, Virginia) Troubleshoot Analyst (Jobs in Hamilton, New Jersey) Stakeholders Project Consultant (Jobs in Hartford, Connecticut) Cybersecurity SIEM Linux Analyst (Jobs in Jackson, Mississippi) VLAN Cisco Routers Routing Consultant (Jobs in Fairfax, Virginia) Project Consultant (Jobs in Lincoln, Nebraska) JavaScript Spring Analyst (Jobs in Richmond, Virginia) Strong Analyst (Jobs in North Chesterfield, Virginia)