Skills

Problem Solving Visual Studio SQL SQL Server Software Development PL/SQL ETL Processes Server Management

Job Specifications

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

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)

Job Posted by ApplicantPro

About the Company

Keville Enterprises, Inc. (KEI) is a 150 person multi-disciplined Construction Management & Inspection firm based in Marshfield, Massachusetts, with offices in MA, CT, NY, VA, MD, FL and TX . KEI specializes in providing owner’s representative services on public projects. We are certified as a Woman-owned Business Enterprise (WBE/DBE) by over 30 agencies and authorities. We have provided our services on public projects totaling more than $16 billion in value. We pride ourselves on our commitment to client satisfaction which ... Know more