Administrateur de bases de données l Database Administrator

Medisca • Montreal, QC

8d • Hybrid

About The Position

The Database Administrator will own the health, accuracy, and performance of databases across a multi-system, multi-location business. The Database Administrator will map how data flows between our CRM, ERP, e-commerce, and other platforms, keeping them accurate and compliant every step of the way, and act as a trusted steward of the company's data.

Requirements

• 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.
• French and English communication skills required. English is necessary for regular oral and written communication with international teams and business partners located outside Québec.

Nice To Haves

• Experience with PostgreSQL, Azure SQL, Snowflake, or Databricks.
• Pipeline orchestration tools (SSIS, ADF, Airflow, dbt, or similar).
• Awareness of cross-border privacy rules (e.g., GDPR, Quebec's Law 25).
• Exposure to CI/CD for database changes (Flyway, Liquibase, Azure DevOps).

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.

Benefits

• 37.50 hour workweek with early Fridays all year long
• PTO and vacation policy
• Choice of modular health plans
• Health spending account
• Free Telemedicine
• Hybrid work schedule with home office reimbursement program
• Opportunities to learn and grow within Medisca
• Medisca contributes to a deferred profit sharing plan (DPSP) when you invest in RRSPs
• Employee Referral Program
• Company events throughout the year

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level