Azure PowerShell Scripting ETL Development SSIS Relational Database Analysis And De   Requirement id 119448 Job title Administrator Job location in Madison, WI Skills required Microsoft SQL Server 2016, SQL SERVER Database Performance Monitoring, Azure, PowerShell Scripting ETL Development SSI Open Date 28-Sep-2021 Close Date Job type Contract Duration 20 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Administrator: Microsoft SQL Server 2016, SQL SERVER Database Performance Monitoring, Azure, PowerShell Scripting ETL Development SSI start date:11/8/2021 End date:06/30/2023 submission deadline:10/8/2021 4:00:00 PM client info : DPI Note: * Interview Process: Teams, video on, 1-2 rounds * Duration: Through June 30th with the possibility of extension. * Hybrid schedule as of Nov 1st. 3 days in office/2 days WFH a week. Local candidates or willing to relocate at the candidates expense Description: Provide database support, including security components, for enterprise wide projects and applications including determining hardware specifications related to the database environment as well as space requirements related to our current and future data needs and overseeing the development and organization of databases and implementation of new technologies. Help to develop standards related to the database environment and follow the DET security standards adopted by DPI. Install, configure, manage, administer, and maintain multiple SQL Server environments including prod and non-prod for each project/application. Create and manage SQL Server databases and database files, tables, indexes, views, constraints, etc. Complete performance tuning and optimization. Provide support related to security components of the database environment including policies and procedures. Setup, configure, and maintain all aspects of database security and user access including roles, groups, and users. Support agencys IT daily operations by performing database change management requests and deployments. Monitor availability, performance, and usage of the database environment,create reports and alerts to communicate status, and maintain high performance availability. Troubleshoot issues, review error logs, and perform issue resolution. Create, maintain, and monitor scripts, jobs, and job schedules. Work with the ISSI team on backup and recovery operations. Design new databases and define their relationships with existing databases according to DPI standards. Create and maintain indexes on these databases. Implement and maintain version control and build control/packaging for database objects and etl packages. Administer and organize DPI internal and external reporting environment. Develop and maintain documentation related to the database environment including related protocols, standards, policies, and procedures. Train DPI staff to take advantage of advanced functions provided by the database systems, including consulting with users to provide technical support in queries and reports from the agency database. Assist in administering and maintaining the remaining Oracle database at DPI and move forward with plans to migrate these databases to SQL Server. Maintain technical expertise on relevant IT subjects through periodicals,trade journals, manuals, electronic publications, and social media. Remain current in technological development and advances to identify new and emerging technologies to enhance, improve and expand existing agency database system capabilities. Collaborate closely with ISSI, DevOps, and other teams at DPI and maintain awareness of operating procedures and environments of the Data Warehouse, Applications Development and Information Technologies Teams. Plan and assist in disaster recovery procedures. Help to support agencys business intelligence, reporting, and application programs. Build ETL packages, stored procedures, and/or jobs as needed. Migrate updates for the database and ETL jobs between the secure and public dev, test, and prod environments. Run and monitor dev, test, and prod builds. Troubleshoo   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 119448 while calling.   Other jobs in WI: De Pere (2), Green Bay (8), Kenosha (2), Madidson (1), Madison (36), Menomonee Falls (19), Milwaukee (59), Sun Prarie (1), Unknown (2), Waukesha (2), Microsoft SQL Server 2016 job openings in Madison, WI Jobs List Database Administrator IV - 118192 - SP Create date: 18-May-2023 Start date : 07/01/2023 End Date : 06/30/2024 Submission deadline : 5/22/23 at 4:00PM CST. Client Info :DFI Note: * Interview Process: Teams * Duration of the Contract: 6/30/2024 * Onsite or Remote? Candidate must be a WI resident or willing to relocate to WI at the candid.... (This job is for - Oracle Jobs in WI Madison Administrator - (in Madison, WI))    Microsoft SQL Server 2016 job openings in other states Jobs List Application Developer III - CSR 147-23 Create date: 30-Jun-2023 Start date : 07/24/2023 End Date : 12/31/2023 Submission deadline : 07/10/2023 Client Info : ODFW Note : * Position Location : Hybrid Description : Developer to implement a web based application for the agencys Willamette Wildlife Mitigation Program (WWMP). The applicati.... (This job is for - MVCASPNet Jobs in OR Salem Developer - (in Salem, OR)) DOE SQL Database Administrator (710978) Create date: 26-May-2023 start date : 07/06/2023 End date : 06/30/2024 submission deadline : 06/01/2023 client info : DOE/TS/DMI Note : * Hybrid Description : Conduct the following for Azure SQL/Azure SQL MI/SQL on Azure VM, On Prem SQL Server, SSRS, .... (This job is for - Sql Server 2000 Jobs in GA Atlanta Administrator - (in Atlanta, GA)) Database Architect -59904 Create date: 22-Mar-2023 Start date :04/01/2023 End Date :04/01/2024 Submission deadline : 03/31/2023 Client Info : Fulton County Note: * Position Location On Site Description : Design strategies for Microsoft SQL Server and Oracle enterprise databases, data warehouse systems, and data lakes. Set standard.... (This job is for - Oracle Database Jobs in GA Atlanta Consultant - (in Atlanta, GA)) NCDST - Technical Architect - Expert -704423 Create date: 20-Feb-2023 Start Date : 3/6/2023 End Date : 03/05/2024 Submission Deadline : 02/22/2023 Client Info : NCDST Note: * Onsite Description : ***This position is onsite. The Department of the State Treasurer is seeking a candidate to perform technical a.... (This job is for - Development Jobs in NC Raleigh Consultant - (in Raleigh, NC)) Application Developer IV - 11104-22 Create date: 30-Nov-2022 start date:1/16/2023 End date:07/14/2023 submission deadline:12/06/2022 client info : DHS / OHA Note: * Position Location: Remote Description: The Health & Service Equity Transformation program is focused on addressing health ineq.... (This job is for - JavaScript Jobs in OR Salem Developer - (in Salem, OR))    Microsoft SQL Server 2016 job openings in WI Jobs List Systems Engineer-1 - WISCJP00087641 Create date: 15-Jun-2021 Start Date :07/12/2021 End Date :12/31/2021 Submission Deadline :Due to SCS 06/18/2021 by 8:00 a.m. CT Client Info : Outagamie County – Information Technology Description : This is a repost of 84843, the manager would like to only see new resumes, please do not submit previousl.... (This job is for - Virtualization Jobs in WI Appleton Engineer - (in Appleton, WI)) (Administrator: Microsoft SQL Server 2016, SQL SERVER Database Performance Monitoring, Azure, PowerShell Scripting ETL Development SSI in Madison, WI)

Featured Jobs 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) QA Testing Azure Analyst (Jobs in Lansing, Michigan) Quality Assurance UAT Analyst (Jobs in Madison, Wisconsin) Wireframes Analyst (Jobs in Richmond, Virginia) Change Consultant (Jobs in Raleigh, North Carolina)