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 Business Analyst - Advanced-11427-1 Create date: 22-Oct-2024 No of Submissions : 2 Start date : 11/19/2024 Submission deadline : 10/30/2024 Client Info : Department of Health and Human Services Note: Q) INTERVIEW PROCESS(who will conduct i/v, phone or in-person, how many rounds of i/v)? A) The interviews will be conducted by the MMRP team mem.... (This job is for - AnalysisTracking Jobs in SC Columbia Analyst - (in Columbia, SC)) RFP 216716 To Provide Programs And Services - NSPO Create date: 30-Sep-2024 Bid URL: https://www.rampla.org/s/opportunity-details?id=006Ql00000D6StOIAV Note: Online Submission Submission Deadline: 11/22/2024, 07:00 PM EST Start Date:12/9/2024 End Date: 12/9/2025 Client: City of Los Angeles * Request for Proposals to Provide Programs and Services at the Northeast Valley .... (This job is for - job Jobs in CA LosAngeles Consultant - (in Los Angeles, CA)) 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))     (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 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)