21 Nov
|
emergiTEL
|
Ontario
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.
#J-18808-Ljbffr
📌 Access Database Migration Specialist (Ontario)
🏢 emergiTEL
📍 Ontario