Home
|
Overview
|
Candidate Login
|
Post Resume
|
Contact us
Search Jobs
Keywords,Title,Skills,Company
Location,City,State,Zip
Advanced Search
Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets
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
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)
)
DPS-Programmer 5-ATPS-1 (810941)
Create date: 03-Sep-2026
Start date :9/28/2026
End Date :06/30/2027
Submission deadline :9/8/2026
Client Info : DPS
Note:
*15 minute Teams interviews, followed by full interviews onsite.
Description:
The selected Consultants will work closely with the designated I.T. supervisor, project managers and o.... (This job is for -
ASPNet SQL Jobs in OH Columbus Consultant - (in Columbus, OH)
)
Quality Assurance Specialist 2 QAS2 (808953)
Create date: 10-Aug-2026
Start Date: 08/24/2026
End Date: 06/30/2027
Submission Deadline: 08/14/2026
Client info: DCY
Note:
*AM: Ashley Hetman
*Interviews in person
*Hybrid - 3x/week onsite
*Local candidates preffered
DCY - Quality Assurance Specialist 2/QAS2 (Software Tester .Net)
SDLC Jobs in OH Columbus Specialist - (in Columbus, OH))
Software Developer - 70127044
Create date: 15-Jul-2026
Bid URL:https://dir.my.site.com/itsacvendor/s/itsac-vendor-response/a58cs00000PWFonAAH/70127044
Note: Online Submission
Note: RTR form must be signed by the candidate
Note:
*Remote
*LBJ State Office Building, 111 E. 17th Street, Austin, Texas 78711.
*The working position is Telework.
job Jobs in TX Austin Developer - (in Austin, TX))
FCDC Programmer 5 (795784)
Create date: 12-Feb-2026
Start date : 03/02/2026
End Date : 12/31/2026
Submission deadline : 02/17/2026
Client Info : FCDC
Note:
* Onsite Position
*
Description :
Client is seeking a Full Stack .NET Consultant to architect and develop full stack applications.
·The right con.... (This job is for -
HTML CSS Jobs in OH Columbus Consultant - (in Columbus, OH)
)
.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
APEX SOQL Architect (Jobs in Columbus, Ohio)
JavaScript ASP. Consultant (Jobs in Cayce, South Carolina)
Cybersecurity Threat Analyst (Jobs in Austin, Texas)
Quality Assurance Jira Azure Analyst (Jobs in Lansing, Michigan)
EHR Jira Windows Analyst (Jobs in Atlanta, Georgia)
ITSM ServiceNow BMC Jira Developer (Jobs in Atlanta, Georgia)
J2EE Curam Technical Developer (Jobs in Raleigh, North Carolina)
Communication Quality Assurance Tourbleshooting Analyst (Jobs in Tallahass
- - Consultant (Jobs in Tennessee, Tennessee)
Migration Engineer (Jobs in Raleigh, North Carolina)
Search Jobs
Keywords,Title,Skills,Company
Location,City,State,Zip
Advanced Search
About Us
Services
Privacy policy
Legal
Contact us
Copyright JobsInHand.com All Rights Reserved