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
- Solid 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