22 Nov
|
emergiTEL
|
Toronto
Microsoft Access modernization and SQL migration are central to this Business Intelligence Specialist position in Toronto, Ontario, with hybrid remote work. emergiTEL’s client seeks a permanent specialist to manage complex Access environments while transitioning back-end data to SQL Server, MySQL, or MariaDB. You will assess undocumented databases, design relational schemas, validate migrations, and maintain reporting solutions. The position combines hands-on database development with application modernization. Key Responsibilities:
Maintain Access front-end, back-end, and global code bases Inventory database objects and assess migration dependencies Design normalized schemas with keys, constraints, and relationships Plan migration mapping, validation, testing, cutover,
and rollback Optimize queries, indexes, and database performance Requirements:
Proven experience maintaining complex Microsoft Access databases Strong knowledge of Access forms, reports, macros, and VBA Experience migrating Access databases to SQL platforms Advanced SQL skills and relational database design experience Robust analytical, troubleshooting, and problem-solving abilities Bring Access development, SQL optimization, and migration expertise to strengthen database reliability and modernization for Toronto operations.
📌 Access Database Migration Specialist (Toronto)
🏢 emergiTEL
📍 Toronto