Data Migration Developer (MS Access/VBA Oracle APEX)

About the role

This is the most specialized of the three profiles: an experienced developer who migrates legacy MS Access/VBA and MS SQL Server applications and their data into modern Oracle APEX-based platforms, while keeping the legacy systems running during the transition.

What you'll do
Analyze, interpret, and translate legacy source datasets — including MS Excel, MS Access, and other file- or system-based sources — into structures compatible with Oracle database and Oracle APEX environments.
Plan and perform end-to-end ETL activities: staging, transforming, validating, and loading datasets from legacy sources into Oracle settings using Oracle SQL, PL/SQL, and APEX utilities.
Troubleshoot, debug, and enhance legacy MS Access–based and/or MS SQL Server–based applications to sustain them during migration, using MS Access, T-SQL, and Microsoft VBA as needed.
Document data mappings, transformation logic, business rules, profiling results, and data-quality findings for transparency and repeatability.
At the discretion of the Technical Authority,



may also support broader software development activities: bug and change request development, peer code reviews, testing and test script development.

Must-have
Hands-on experience with MS Access and Microsoft VBA in a production/legacy-application context.
Experience migrating legacy data (Access, Excel, SQL Server) into a contemporary platform — ETL design and execution.
Working knowledge of Oracle SQL / PL-SQL and, ideally, Oracle APEX.
Fluent English, spoken and written, with minimal errors.
Must be a Canadian citizen — a requirement for eligibility for the Government of Canada Secret-level personnel security screening this role needs to start work.
Able to work in office at 455 Boulevard de la Carrière, Gatineau, QC, on a primarily in-person basis.

Nice-to-have
Already holds an active Government of Canada Secret-level clearance
T-SQL experience specific to MS SQL Server legacy applications.
Exposure to software testing / test script development.

📌 Data Migration Developer Ms Access/vba → Oracle Apex Gatineau
🏢 Insi
📍 Gatineau