Database Migration Engineer
6 days ago
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. 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. • 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