Computer Science Co-op Boston, MA

Boston, NH - USA

Hourly Salary: USD 20 - 25

Posted on: 12 hours ago

Vacancies: 1 Vacancy

Job Summary

Computer Science Co-op: Database Migration & Integration Specialist

Keville Enterprises Inc. an established Construction Management Consulting & Inspection firm is seeking an intern to help us develop an exciting software development project with our partnership with Wentworth Institute of Technology. Ideal candidate is a motivated Computer Science Co-op student for a one-semester project focused on modernizing our data infrastructure. You will play a key role in transitioning a legacy Microsoft Access application into a robust enterprise-grade solution.

Co-op term ---

JAN-26 to APR-26

Project Overview

The primary goal of this internship is to decouple the front-end of a Microsoft Access database from its local storage and migrate the backend to SQL Server. Additionally you will implement enterprise reporting and create cross-platform data integrations with our Oracle environment.

Key Responsibilities

Database Migration: Upsize existing Access tables to SQL Server ensuring data integrity proper data type mapping and primary/foreign key preservation.
Backend Optimization: Re-link Access front-end forms and logic to the new SQL Server backend using ODBC connections.
Reporting Services: Migrate legacy Access reports to SQL Server Reporting Services (SSRS) to provide web-based automated reporting capabilities.
Systems Integration: Develop queries or ETL processes to pull and synchronize data from an Oracle Database into the SQL Server environment.
Testing & Documentation: Conduct unit testing to ensure the applications performance remains stable after the migration and document the new architectural schema.

Technical Requirements

Education: Currently enrolled in a BS or MS in Computer Science Information Technology or a related field.
SQL Proficiency: Strong understanding of T-SQL (SQL Server) and basic familiarity with PL/SQL (Oracle).
Database Tools: Experience with SQL Server Management Studio (SSMS) and Microsoft Access.
Problem Solving: Ability to troubleshoot connection strings permissions and data conversion errors.

Bonus Skills: Previous experience with Linked Servers or Visual Studio (for SSRS development).

Additional experience preferred -

At least 1.5 full years of course work completed in a Computer Science degree - at Wentworth Institute of Technology.

Keville Enterprises Inc. is An Affirmative Action/Equal Opportunity Employer/Veteran/Disability

Background checks required. Pre-employment (post-offer)

Computer Science Co-op: Database Migration & Integration SpecialistKeville Enterprises Inc. an established Construction Management Consulting & Inspection firm is seeking an intern to help us develop an exciting software development project with our partnership with Wentworth Institute of Technology...