Keville Enterprises, Inc. ยท 15 hours ago
Computer Science Co-op
Keville Enterprises Inc. is an established Construction Management Consulting & Inspection firm seeking an intern to help develop a software development project. The role focuses on modernizing data infrastructure by migrating a legacy Microsoft Access application into a robust SQL Server solution.
Building MaterialConsultingReal Estate
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
Qualification
Required
Currently enrolled in a BS or MS in Computer Science, Information Technology, or a related field
Strong understanding of T-SQL (SQL Server) and basic familiarity with PL/SQL (Oracle)
Experience with SQL Server Management Studio (SSMS) and Microsoft Access
Ability to troubleshoot connection strings, permissions, and data conversion errors
Preferred
Previous experience with Linked Servers or Visual Studio (for SSRS development)
At least 1.5 full years of course work completed, in a Computer Science degree - at Wentworth Institute of Technology
Company
Keville Enterprises, Inc.
Keville Enterprises, Inc. is a multi-disciplined construction management & inspection firm.
H1B Sponsorship
Keville Enterprises, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase