Senior Database Administrator & Data Architect — Hybrid

Medisca Pharmaceutique Inc; Vancouver; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid work schedule

Health plan

PTO and vacation policy

Telemedicine

RRSP/DFP contributions

Employee referral program

Job summary

Medisca is seeking a Database Administrator to own the health, accuracy, and performance of databases across our multi-location business. The role will map data flows between CRM, ERP, e-commerce, and other platforms, ensuring accuracy and compliance every step of the way and act as a trusted steward of the company's data.

You will design data architecture, optimize T-SQL, ensure HA/DR, and bridge technical and business teams with a strong focus on privacy, data quality, and cross-border

Qualifications

• Bachelor's degree or equivalent in a related field.
• 5+ years in a DBA or data architecture/engineering role.
• Strong SQL Server experience and advanced T-SQL/query optimization skills.
• Experience with data mapping across system migrations or integrations.
• Experience with CRM, ERP, and e-commerce data.
• Understanding of data stewardship, governance, and privacy/compliance basics.
• Experience with HA/DR and database security fundamentals.
• Strong communicator, able to bridge technical and business audiences.

Responsibilities

• Maintain the performance, accuracy, and availability of our SQL Server databases.
• Design data architecture and data mapping for system changes, migrations, and integrations (for CRM, ERP, etc.).
• Build deep knowledge of our data — where it lives, how it's structured, and how it moves across systems and formats (CSV, JSON, XML, EDI, APIs, etc.).
• Support accurate data sharing between our platforms, tools, and business partners, using various transfer methods.
• Act as a data steward: define, document, and uphold data quality and ownership standards.
• Ensure data handling meets privacy and compliance requirements.
• Write and optimize complex T-SQL (stored procedures, functions, indexing, query plans).
• Maintain high-availability and disaster recovery strategies, including backups and failovers.
• Build and monitor data quality checks and pipeline orchestration across systems.
• Set up monitoring/alerting for database and pipeline performance.
• Support CDP and identity resolution initiatives.
• Maintain database security controls (access, encryption, auditing) and basic automation scripting).
• Document configurations, data flows, mappings, and procedures.

Skills

SQL Server

T-SQL optimization

Data governance

Communication

Data architecture

Education

Bachelor’s degree

Tools

PostgreSQL

Azure SQL

Snowflake

Databricks

SSIS

ADF

Airflow

dbt

Flyway

Liquibase

Azure DevOps

Job description

Medisca is seeking a Database Administrator to own the health, accuracy, and performance of databases across our multi-location business. The role will map data flows between CRM, ERP, e-commerce, and other platforms, ensuring accuracy and compliance every step of the way and act as a trusted steward of the company's data.

You will design data architecture, optimize T-SQL, ensure HA/DR, and bridge technical and business teams with a strong focus on privacy, data quality, and cross-border