We are looking for a skilled Database Migration Engineer / Full-Stack JavaScript Developer to lead the complete overhaul and modernisation of our legacy Microsoft Access database infrastructure.
Role Overview
The successful candidate will own the end-to-end migration process. This includes extracting relational schemas and embedded VBA logic from MS Access, designing a modern target database architecture, writing custom ETL scripts in JavaScript, and developing modern APIs to serve the data to our applications.
🔧 Key Responsibilities
Legacy Analysis: Audit existing MS Access databases (.mdb/.accdb), documenting relational schemas, indexing strategies, complex queries, and custom VBA modules.
Database Architecture & Design: Design, implement, and optimize a modern target database system (e.g., PostgreSQL, MySQL, or MongoDB) suited for a JavaScript-centric application environment.
Data Migration (ETL): Write resilient, well-tested data pipeline scripts using Node.js to extract, transform, clean, and load legacy data into the new modern database structure while maintaining full data integrity.
API Development: Replace old Access forms and reporting mechanisms by building secure, high-performance RESTful or GraphQL APIs using Node.js (Express, NestJS) and JavaScript/TypeScript.
Integration & Testing: Write comprehensive unit and integration tests to validate that migrated data and new backend services fully replicate (and improve upon) legacy business rules.
If this exciting opportunity could be of interest – please contact me ASAP to discuss further
We use essential cookies to make this site work. With your permission we would also like to use the optional cookies below. Nothing optional is set until you choose, and you can change your mind at any time from "Cookie settings" at the bottom of every page. Cookie policy.
Essential — keep the site working and secure, and remember the choice you make here. Always on.