PowerShell SSRS SSIS SSAS ETL SQL 2008 R2 Data Migration Consultant (Jobs in Bois   Requirement id 92232 Job title Consultant Job location in Boise, ID Skills required .Net, PowerShell, SSRS, SSIS SSAS ETL SQL 2008 R2 Data Migration Open Date 10-May-2019 Close Date Job type Contract Duration 2 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Consultant: .Net, PowerShell, SSRS, SSIS SSAS ETL SQL 2008 R2 Data Migration Start Date : 05/20/2019 End Date : 06/30/2019 Submission Dead Line : 05/16/2019 Client Info :State Board of Education Description : Agency Project Scope (Description of Work Needed - Additional background check requirements are to be added here) We have a virtual SQL Server 2008R2 environment that needs moved to a physical server and upgraded to SQL Server SQL 2017 (14.0.1000.169). There is an ETL process that sits on a web server that utilizes SQL Server Integration Services that needs relocated and upgraded as well. The existing environment utilizes SQL Server Reporting Services (SSRS), that must be reinstalled and configured on the new server as well. (there are only 3 users with access to SSRS) There are existing SQL Server Integration Services (SSIS) packages along with a powershell script that sorts ETL data that will need to be relocated from a web server and the SSIS packages converted to run under SQL 2017. There is also an existing .net application on the web server that we wish to move to the database server and run locally on it. (we are relocating the file transfer off the web server and will stage the import files on the database server) Work with Office of the State Board of Education (OSBE) staff to test ETL and SSRS. Configure Microsoft Visual Studio on OSBE computer and walk staff through the SSIS packages to ensure we can make any changes to them going forward. Agency Expected Deliverables Move virtual SQL 2008R2 instance (multiple databases) to a physical SQL 2008R2 server (on a different domain) Move SSRS and SSIS to new server Upgrade everything to SQL 2017 Convert .net application to run locally on the SQL server Configure Visual Studio on OSBE computer to maintain SSIS packages Test and verify that ETL process is functioning Verify SSRS is working properly. Our goal is to have this completed by June 30, 2018. The physical server is dedicated to this project, we have full admin access to that server to make any necessary changes. Specific Skills Required (Programming languages, databases, operating systems, etc.) Strong knowledge of SQL Server 2008R2 BIDS SSIS SSRS SSAS and experience migrating to SQL Server 2017. Also .NET and powershell will be necessary. The information in the databases is confidential, a non-disclosure and confidentiality agreement will need to be signed by anyone that is granted access. Our preference is the work is done onsite (via remote desktop). If that is not possible, we can configure VPN access but that may delay starting the project.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 92232 while calling.   Other jobs in ID: Boise (11), .Net job openings in Boise, ID Jobs List Software Engineer 3 - ASP.Net Developer- 22-05 Create date: 25-Aug-2021 Start Date :09/20/2021 End Date :09/19/2022 Submission Deadline :09/01/2021 Client Info : Idaho Department Of Labor Description : It needs 1 experienced .Net Software Engineer to work with the Idaho team to help build/maintain the Idaho Unemployment Insurance (iUS) Tax System. .... (This job is for - job Jobs in ID Boise Developer - (in Boise, ID)) Software Engineer 2 ASP.Net Developer - 2020-07-02 Create date: 02-Jun-2020 Start Date :07/01/2020 End Date :06/30/2021 Submission Deadline:06/08/2020 Client Info: Idaho Department of Labor Description: Agency Project Scope (Description of Work Needed - Additional background check requirements are to be added here) IDOL needs two (2)experienced .Net develope.... (This job is for - JavaScript Jobs in ID Boise Developer - (in Boise, ID)) Software Engineer (SE3) - 270-041420-202 Create date: 15-Apr-2020 Start Date :05/11/2020 End Date :12/31/2017 Submission Deadline :05/10/2021 Client Info: Department of Health & Welfare Description : Agency Project Scope (Description of Work Needed - Additional background check requirements are to be added here) The software engineer is respo.... (This job is for - job Jobs in ID Boise Engineer - (in Boise, ID)) Software Architect - TAMSSWArch2019 Create date: 16-May-2019 Start Date : 06/03/2019 End Date : 02/28/2020 Submission Dead Line : 05/22/2019 Client Info : Idaho Transportation Department (ITD) Description : Agency Project Scope & General Requirements General Requirements Interviews for these positions may be conducted.... (This job is for - job Jobs in ID Boise Architect - (in Boise, ID)) CRM Developer - 46814 Create date: 02-May-2019 Candidate must be your W2 Employee. We should submitt only GC, GC EAD, L2 EAD, H4 EAD and Citizen. Job Description : The software engineer is responsible for analysis, design, coding, component and assembly testing of software. Software Engineers typically are involved in maintenance (including producti.... (This job is for - ASPNet Jobs in ID Boise Developer - (in Boise, ID))    .Net job openings in other states Jobs List Salesforce Developer - 66413 Create date: 27-Oct-2026 Start date :10/14/2026 End Date :10/28/2027 Submission deadline :11/06/2026 Client Info : CT DCF Note: *Hybrid *Candidate must be local or willing to commute or relocate. *Please note that the first and second round interviews will be held IN PERSON *Candidate MUST be located in Connecti.... (This job is for - job Jobs in CT Hartford Developer - (in Hartford, CT)) Software Architect - Consultant- 14152 Create date: 19-Oct-2026 Start date: 12/01/2026 End Date : 12 Months from projected start date Submission deadline: 10/26/2026 5:00:00 PM Client Info: SCDOR Note: *Interview Process: 1 Round of Onsite Interviews *Work Location: Hybrid, 3 Days Onsite per Week *Candidate location: Candidate must be a CURREN.... (This job is for - job Jobs in SC Columbia Consultant - (in Columbia, SC)) Programmer Analyst 5 -166800 Create date: 15-Oct-2026 Start date :11/11/2026 End Date : 6 Months from projected start date Submission deadline :10/20/2026 10:00:00 AM Client Info : DNR Note: *-Interview Process: 1 round on-site interview *-Hybrid work Schedule (non-negotiable); Position will be hybrid, in office 2 days a week upon sta.... (This job is for - MSQL Software Jobs in MI Lansing Analyst - (in Lansing, MI)) VDOT .Net Programmer Analyst 4 (804813) Create date: 22-Sep-2026 Start date :6/30/2026 End Date :06/30/2027 Submission deadline :9/24/2026 Client Info : VDOT Note: * Work Arrangement: Hybrid * Agency Interview Type: Both Phone and In Person Description: The .NET Developer will support the modernization of an enterpr.... (This job is for - job Jobs in VA Mechnacisville Analyst - (in Mechnacisville, VA)) System Software Programmer - Project Lead 13554 Create date: 08-Sep-2026 Start Date: 10/17/2026 End Date: 6 Months from projected start date Submission Deadline: 9/15/2026 5:00:00 PM Client info: SCDPPPS Note: *Interview Process: 1 Round of Virtual Interviews *Possibility for Extension: Yes *Work Location: Hybrid (2 days onsite per week) *Candidate location: Ca.... (This job is for - JSON Jobs in SC Columbia Consultant - (in Columbia, SC))    .Net job openings in ID Jobs List Programming Analyst - 57541 Create date: 09-Jan-2020 Job Description : Programmer Analyst Job Description Summary This position is responsible development of software for Strategic Initiatives that require delivering well-tested applications, scripts and batches to provide for the delivery, reception and processing of healthcare EDI data feeds (both X12 fil.... (This job is for - EDI Jobs in ID Meridian Analyst - (in Meridian, ID)) (Consultant: .Net, PowerShell, SSRS, SSIS SSAS ETL SQL 2008 R2 Data Migration in Boise, ID)

Featured Jobs Cobol NaturalONE JCL VSAM Developer (Jobs in Columbia, South Carolina) Snowflake Analyst (Jobs in Richmond, Virginia) Java J2EE EJB JSF Analyst (Jobs in Glen Allen, Virginia) ADABAS/Natural SNAP Relational Developer (Jobs in Jackson, Mississippi) Dashboards Troubleshooting IP Specialist (Jobs in Raleigh, North Carolina) Python SAS Analyst (Jobs in Austin, Texas) PMP Dashboards Consultant (Jobs in Raleigh, North Carolina) Medicaid Analyst (Jobs in Columbia, South Carolina) Helpdesk Security Consultant (Jobs in Madison, Wisconsin) GCP Ansible Kubernetes Architect (Jobs in Taylorsville, Utah)