Specialist, Data Services

**About Apotex Inc.**

Apotex Inc. is a Canadian-based global health company that produces high-quality, affordable medicines for patients around the world. Apotex employs almost 7,200 people worldwide in manufacturing, R&D, and commercial operations. Apotex medicines are accessible to patients in more than 75 countries globally. Through vertical integration, the Apotex group is focused on the development and sale of generic, biosimilar and specialty products.

**Job Summary**:
The Specialist, Data Services is responsible for the technical administration, maintenance and support of Apotex’s enterprise “Data Services Platform”. This includes but is not limited to technologies and platform for database software and databases, ETL services, data, and integration services, for on-premise, in the Cloud and in external service providers. The activities include but are not limited to - plan and design, build and deploy, support, and administer the **Data Services Platform**.

**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**:

- **Education**
- Minimum undergraduate degree in a related field (Business, Computer Science/Engineering or equivalent) in established and accepted universities and colleges. Or combination of academic and equivalent professional experiences in the same areas and practices.
- **Knowledge, Skills and Abilities**
- **Database**:

- Solid working experiences with the design principles, best practices, industry standards, administration approaches for relational database software (Oracle, MS-SQL) and common open source databases (e.g. PostgreSQL, MongoDB).
- Solid hands-on experiences in Oracle, SQL database design, administration and, support.
- Advanced knowledge and strong hands-on experiences in using Structured Query Language (SQL) and proce