Database Administrator

**Company Description**:

- MEDFAR Clinical Solutions was founded in 2010 by two aeronautical engineers who realized that the healthcare system was not exploiting the full potential of technology. Supported by a large community of medical experts and focused on clinical success and patient safety, MEDFAR was the first company to certify a cloud-based Electronic Medical Record in Canada: MYLE (Make Your Life Easy)._
- Committed to promoting excellence and effectiveness in healthcare worldwide, MEDFAR differentiates itself by offering a unique healthcare management solution for clinics, which replaces inefficient processes with a faster and safer technological alternative._

We’re looking for a **Database Administrator (DBA)** 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.

**Qualifications** Who You Are**

You are a data-savvy professional with an affinity for healthcare, a strong foundation in database architecture and a passion for driving governance and data quality across an organization. You thrive in cross-functional environments where collaboration, structure, and security are key to delivering trusted, compliant, and scalable data ecosystems. You understand that in the real world, solutions often come with compromises, you can see the larger picture and make trade-offs with the long-term success of the system in mind.

You likely have:

- 10+ years of experience in data governance, data architecture, or equivalent experience in a related data management role.
- Demonstrated expertise designing and optimizing relational databases.
- Hands-on experience with no-sql databases.
- Exposure and understanding of data privacy and compliance frameworks in healthcare for Canada and the US.
- Proven ability to develop and implement data governance policies, metadata standards, and access controls
- Strong communication and advisory skills, with a track record of partnering effectively with developers, analysts, security, and product teams
- A methodical and pragmatic mindset, capable of balancing data accessibility, quality, and protection.
- Proficiency in both **English and French** is required, including the ability to hold conversations and lead meetings in both languages, although the exchanges will primarily be conducted in English.

Bonus:

- Experience working with health interoperability standards (HL7 / FHIR, etc.)
- Experience working in a SaaS or regulated environment with cross-team data dependencies

**Environment**:

- ** Backend**:.NET / C# ,API REST
- ** Frontend**:React.JS
- ** Mobile**:React Native
- ** Data Base**: SQL