IT Specialist
Centre for Addiction and Mental Health
Toronto, ON
The Centre for Addiction and Mental Health (CAMH) is seeking a full time, permanent IT Specialist (Database Administrator) to work in the DATIS department in the Provincial System Support Program. Reporting to Application Development Manager, the Oracle Database Administrator will be primarily responsible for activities related to planning and development of DATIS’ applications and IT infrastructure. DATIS develops, maintains and supports numerous online applications for use in clinical service planning and delivery, quality improvement and system performance reporting. These applications are used to produce reports and analytic products for use by Ontario’s health service providers, health system planners and funders deliver mental health and addictions treatment services across the Province.

The Database Administrator participates in the day to day operations of the Application Development Team (ADT). The DBA also collaborates as needed with members of the Analytics and Reporting Team (ART) and Engagement and Support Team (EST) in support of products and services the DATIS provides to its customers and stakeholders. The Database Administrator will perform a variety of tasks including:

Assist in creation of business and technology plans
Develop technical standards for Oracle databases
Collaborate to model databases to meet business and technical requirements
Prepare detailed data models
Provide technical guidance and direction
Assist developers and analysts build data models and data dictionary documents
Assist in development of data warehousing and analytical reporting repositories
Assist developers build software applications, system integrations and data interchanges
This position is located at 33 Russell St., in Toronto, Ontario.

The successful candidate will have a Bachelor Degree, preferably in computer science, engineering or related field combined with three (3) years of experience with large enterprise healthcare clinical systems and operation of highly complex infrastructure and mission-critical applications.

The ideal candidate will have the following skills and experience in:

Supporting Oracle Enterprise Edition 11 g R2/ 12c/ 18c databases. Similar experience for MS SQL DBs and others is considered an asset.
administering database users accounts and rights a privileges for many users and applications
Designing, implementing, and operating development, test, and production database environments in support of complex enterprise-wide applications including in-depth knowledge of recovery, load balancing, networking, and other related topics.
configuring, monitoring, and optimizing database technologies and applications
Isolating, identifying, and remediating root causes of issues affecting availability and performance of database environments.
Designing and maintaining appropriate security and encryption processes.
Implementing and maintaining DB backups with IT service provider assistance.
Expert knowledge and practical experience with disaster recovery technologies and techniques.
Experience with Oracle Enterprise Linux and Windows Servers operating systems.
Working in an agile environment working in a sprint format, using agile tools proficiently such as JIRA, Confluence and JIRA Service Desk.
Experience understanding agile principles and values and be flexible in adapting to in-flight requests.
Advanced hands-on ability with MS Office products.
Strong analytical and problem solving skills.
Strong oral and written communication skills.
Ability to work collaboratively in a team.
Ability to independently conduct and practically apply research into emerging technologies and trends, standards, products as required.
Please note: This full-time, permanent position is part of the OPSEU bargaining unit.
Salary range: $36.90 - $49.78 per hour.

CAMH is a Tobacco-Free Organization.

CAMH is fully affiliated with the University of Toronto and is a teaching hospital and research institute. As a CAMH employee you will be expected to actively support CAMH’s teaching and research activities, in addition to supporting the clinical work of the hospital.

As an employment equity employer CAMH actively seeks Aboriginal peoples, visible minorities, women, people with disabilities, (including people with who have experienced mental health and substance use challenges), and additional diverse identities for our workforce.

We thank all applicants for their interest, however, only those selected for an interview will be contacted. If contacted for an interview, please inform us should accommodation be required.