Data Services Specialist

Date: May 13, 2022

Location: North York, ON, CA, M9L 1N7

Company: Apotex


About Apotex Inc.

Apotex Inc. is a proudly Canadian, global pharmaceutical company that produces high-quality, affordable medicines for patients around the world. Apotex employs almost 8,000 people worldwide in manufacturing, R&D, and commercial operations.  Apotex Inc. exports to more than 100 countries and territories and operates in more than 45 countries, with a significant presence in Canada, the US, Mexico, and India. Through vertical integration, Apotex is comprised of multiple divisions and affiliates including Apotex Inc., focused on generics; Apobiologix, a division of Apotex Inc. focused on biosimilar development; Aveva, an affiliate of Apotex Inc. fully integrated global developer and manufacturer of complete transdermal solutions; Apotex Consumer Products, a division of Apotex Inc. focused on brand name products; and Global Active Pharmaceutical Ingredients (GAPI), a division of Apotex Inc. focused on the manufacturing of active pharmaceutical ingredients (API) for Apotex and third parties. For more information visit:

Job Summary


Plan and design, build and deploy, support, and administer a) Oracle and SQL database technologies and the database systems. B) ETL services.

Job Responsibilities


  • Database
    • Holds responsibility for the installation, administration, and support of enterprise database software – includes maintenance, installation of patches, software upgrade, performance tuning.
    • Responsible for the overall database health and uptime monitoring, database related incidents, errors, slowness, connection issues. Including performance tuning, backup and recovery, operations and security incident investigation and remediation, access management, database audit, capacity planning.
    • Provide level 2 to level 3 support for all enterprise database platform and the databases to meet established KPIs and ensure service level is met, deficiencies are addressed, and improvements are implemented effectively.
  • Data Services
    • Responsible for Data Extraction, Transformation, and Loading (ETL) services, business intelligence, queries and requests for database reports, visualizations, and dashboards.
    • Develop and maintain efficient, well-documented ETL processes for bulk data loads, ongoing data synchronization routines.
    • Provision and support ETL processes and jobs, conduct data analysis, manage job scheduling.
    • Support and administer enterprise data hub, data warehouse and data platform technologies. Including data pipelines and data analytic services.
  • Integration
    • Holds responsibility for the installation, administration and support of enterprise integration platform and the associated software – includes maintenance, installation of patches, software upgrade, performance tuning.
    • Provide level 2 to level 3 support for enterprise integration platform and technologies to meet established KPIs and ensure service level is met, deficiencies are being addressed, and improvements are implemented effectively.
    • Monitor, configure, administer integration platform to ensure it is operating efficiently. Availability meets or exceeds SLA or SLO, secure and reliable, for both on-premise and in Cloud services.
    • Working with the Integration team, to review, improve and optimize the end to end integration design and workflow, and automate and optimize the API deployment and administration processes.
  • Collaborating with other GIS teams to develop, maintain and champion the adoption of strategy, roadmap, standards for the Data Services Platform.
  • Provides technical advice and consultation to GIS management, business users and colleagues in the understanding of technology trends, enterprise standards and best practices to ensure optimal performance, operations and cost efficiency, security standards are followed.
  • Ensures all assigned projects, work tasks, change and service requests are performed in compliance with the established GIS ITSM processes.
  • Works in a safe manner collaborating as a team member to achieve all outcomes.
  • Demonstrate Behaviours that exhibit our organizational Values: Collaboration, Courage, Perseverance, and Passion.
  • Ensure personal adherence with all compliance programs including the Global Business Ethics and Compliance Program, Global Quality policies and procedures, Safety and Environment policies, and HR policies.
  • Be available for on-call on a 7 by 24 basis.
  • All other relevant duties as assigned.

Job Requirements


  • Hands on experience as an Infrastructure DBA in support and managing Oracle and SQL databases, and in ETL services using SSIS and SAP data services.
  • Knowledge and experience with Microsoft Azure data services including Synapse and Data Factory.


COVID-19 VACCINATION POLICY: In accordance with Apotex Inc. (“Apotex”) policy, as of November 15, 2021, all individuals entering a Canadian site (including but not limited to employees, visitors, contractors and agency workers) must be fully vaccinated against COVID-19 in accordance with the current government requirements.  Further, all employees must maintain all future booster vaccines as approved and recommended by Health Canada.  Accommodation from these requirements for reasons pursuant to the Ontario Human Rights Code, or any other applicable law (most commonly for medical and/or religious reasons) will be reviewed and considered by Apotex.


At Apotex, we are committed to fostering an inclusive, accessible work environment, where all employees feel valued, respected and supported.

Apotex offers accommodation for applicants with disabilities as part of its recruitment process.  If you are contacted to arrange for an interview or testing, please advise us if you require an accommodation.