Database Developer

• Audit and catalog existing database access rights on legacy instances to identify any gaps that need to be addressed before the migration
• Extract and analyze security configurations such as logins, roles, and directory groups to build comprehensive access matrices for both current and future environments
• Execute thorough access cleanup activities prior to migration to eliminate obsolete, redundant, or non-compliant permissions
• Adapt the access matrix to leverage the advanced capabilities of the newest SQL Server edition and meet the requirements of modern cloud ecosystems
• Implement and align standardized role-based access control models to be utilized in the target environment
• Validate database permissions with technical teams and business stakeholders to ensure they accurately reflect actual operational responsibilities
• Engage actively in technical workshops, impact analyses, and validation activities alongside infrastructure and security teams
• Assist in formulating the security migration strategy including the transition to modern directory authentication methods
• Verify post-migration system stability and access compliance to ensure seamless business continuity for critical applications
• Author comprehensive reference documentation detailing final security configurations for operational and support teams

• Extensive expertise in managing database access and security within SQL Server ecosystems
• Proven experience with identity and access management across cloud and hybrid environments including role-based access control
• Deep understanding of database security principles, encryption protocols, permissions management, and corporate compliance standards
• Practical knowledge of database upgrade processes, specifically transitioning to modern SQL Server editions in hybrid setups
• Strong analytical mindset coupled with exceptional attention to detail and documentary rigor
• Complete fluency in English is mandatory

Bilingualism in French and English is considered an asset

• Secure your professional future with a stable contract extending over a year
• Enjoy the flexibility of a remote-first hybrid model with minimal commuting to the Vancouver office
• Play a pivotal technical role in a large-scale enterprise modernization and cloud integration initiative
• Collaborate with a diverse group of technical experts including architects, database administrators, and cybersecurity professionals