Database Migration Engineer
WHD • Haywards Heath, ENG, GB
7 days ago
Job type
- Temporary
Job description
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.
#J-18808-Ljbffr