Database Migration Engineer – Fixed Term Contract (6mths Initial) – Haywards Heath
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
