We're looking for a Database Architecture Specialist \& Data Governance to join our team and take ownership of the policies, practices, and architectural guidance that ensure our data remains secure, high-quality, and accessible across the organization. This role combines strategic data governance leadership with deep technical knowledge of database architecture --- ideal for someone who wants to shape how the largest primary care EMR handles health information!
What You'll Do:
-
Review and establish database structure and architecture while ensuring performance and scalability across all platforms. Precisely, you'll be tasked with
-
Reviewing and approving database schema changes across teams, with a focus on minimizing long-term risk and maintaining consistency across shared models.
-
Optimizing query performance and tuning database configurations to ensure reliable, low-latency access to critical data.
-
Profiling and resolving performance bottlenecks in collaboration with engineering teams---this includes slow queries, locking issues, indexing problems, and inefficient data access patterns.
-
Monitoring database health and usage patterns, proactively identifying areas for refactoring or architectural improvements.
-
Enforcing governance standards around data ownership, versioning, and change control to prevent data sprawl and maintain integrity.
-
Supporting infrastructure and SRE teams in capacity planning, replication strategy, and backup/recovery policies for critical databases.
-
Lead Data Governance Initiatives: Develop, maintain, and evolve governance policies to support data accessibility, integrity, quality, security and compliance across systems.
-
Enable Data Accessibility with Guardrails: Partner closely with Analytics and Interoperability teams to enable access to data that is consistent, governed, and performant.
-
Define Access Policies with the Application Security \& SRE teams: Work with the security and site reliability engineering teams to define access roles and levels, ensuring appropriate controls based on users' roles and responsibilities.
-
Maintain Legal \& Regulatory Compliance: Review and adjust governance policies to align with evolving compliance requirements, internal standards and provincial laws. (e.g., HIPAA, PIPEDA, PHIPA, QC-Law 25, etc.)
-
Promote a Culture of Responsible Data Use:Help embed governance practices into development workflows, promote shared accountability for data quality, and foster alignment across cross-functional teams.
