Database Migration Engineer

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.