Computer Science Co-op

Job Description

Job Description

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 application's performance remains stable after the migration and document the new architectural schema.

Technical Requirements

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)

Job Posted by ApplicantPro