22 Nov
|
emergiTEL
|
Winnipeg
22 Nov
emergiTEL
Winnipeg
Microsoft Access modernization and SQL migration are central to this Business Intelligence Specialist position in Toronto, Ontario, with hybrid work from home.
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 basesInventory database objects and assess migration dependenciesDesign normalized schemas with keys, constraints, and relationshipsPlan migration mapping, validation, testing, cutover,
and rollbackOptimize queries, indexes, and database performanceRequirements:
Proven experience maintaining complex Microsoft Access databasesStrong knowledge of Access forms, reports, macros, and VBAExperience migrating Access databases to SQL platformsAdvanced SQL skills and relational database design experienceStrong analytical, troubleshooting, and problem-solving abilitiesBring Access development, SQL optimization, and migration expertise to strengthen database reliability and modernization for Toronto operations.
#J-18808-Ljbffr
📌 Access Database Migration Specialist (Winnipeg)
🏢 emergiTEL
📍 Winnipeg