Hybrid SQL DB Architect – Data Integrity & Governance

Medisca Pharmaceutique Inc; Ottawa; Hybrid; CAD 100,000 - 135,000; Full time

Benefits offered by this job

Work/Life Balance: 37.50 hour week, Fr

Hybrid work schedule with home office

Health plans and wellness

Professional growth opportunities

Deferred profit sharing plan

Employee referral program

Company events

Job summary

Medisca is seeking a Database Administrator to own data health and performance across multiple systems. You will map data flows between CRM, ERP, e-commerce, and other platforms, ensuring accuracy and compliance while acting as a trusted data steward.

You will design data architecture, optimize T-SQL, and implement HA/DR strategies, with hybrid work options and collaboration across technical and business teams. 5+ years' experience required.

Qualifications

• Bachelors degree 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 migrations or integrations.
• Experience with CRM, ERP, and e-commerce data.
• Understanding of data stewardship, governance, and privacy 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 SQL Server databases.
• Design data architecture and data mapping for system changes, migrations, and integrations.
• Build knowledge of data movement across systems and formats (CSV, JSON, XML, EDI, APIs).
• Support accurate data sharing between platforms and partners.
• Act as a data steward: define and uphold data quality and ownership standards.
• Ensure data handling meets privacy and compliance requirements.
• Wrote and optimize complex T-SQL (procedures, indexing, queries).
• Maintain high-availability and disaster recovery strategies.
• Build and monitor data quality checks and pipelines.
• Set up monitoring/alerting for database and pipeline performance.
• Support CDP and identity resolution initiatives.
• Maintain database security controls and basic automation scripting.
• Document configurations, data flows, mappings, and procedures.

Skills

Data accuracy

SQL Server

T-SQL optimization

Data mapping

CRM/ERP/e-commerce data

Data governance

HA/DR basics

Communication

Education

Bachelor's degree

Tools

PostgreSQL

Azure SQL

Snowflake

Databricks

SSIS

ADF

Airflow

dbt

CI/CD tooling

Job description

Medisca is seeking a Database Administrator to own data health and performance across multiple systems. You will map data flows between CRM, ERP, e-commerce, and other platforms, ensuring accuracy and compliance while acting as a trusted data steward.

You will design data architecture, optimize T-SQL, and implement HA/DR strategies, with hybrid work options and collaboration across technical and business teams. 5+ years' experience required.