As part of the larger ICAT team, works under indirect supervision, assists in the maintenance, and control of enterprise databases;
monitor databases; maintain database backup and recovery system; control user access to and all security aspects of enterprise databases.
The incumbent will also work to facilitate the successful movement and representation of data around enterprise databases, as well as to resolve questions related to all areas of Database Administration on all production platforms supported by the enterprise.
Experience with designing databases as well as integration between third party systems is required.
This individual will assist project teams with technical issues in the Initiation and Planning phases of our standard Project Management Methodology.
These activities include the definition of needs, benefits, and technical strategy; research & development within the project life-cycle;
technical analysis and design; and support of operations staff in executing, testing and rolling-out the solutions. Participation on projects is focused on smoothing the transition of projects from development staff to production staff by performing operations activities within the project life-cycle.
Create and manage the ODB environments that serve production, reporting, disaster recovery, training, and non-production needs.
Installs and maintains the administrative and monitoring tools necessary for high levels of availability and performance of Mackenzie Health’s Epic EMR system.
Manages the logins for different types of access, including login behavior and working environment configuration.
Applies Caché and Epic upgrades and updates to production and non-production environments.
Configures and maintains environment copies according to the environment strategy.
Responds to emergency and after-hours issues.
BS / BA in Computer Science or other technical discipline with 10 years of Data Base experience.
Cache System Management Experience.
Expertise in designing, implementing and maintaining High Availability solutions.
Experience in designing database applications and integrating with third party systems.
Expertise in core SQL Server concepts - performance monitoring / tuning, replication, partitioning.
Expertise in all aspects of SQL Server database security; familiarity with security best practices.
Experience with Microsoft Dynamics.
Expertise with design and implementation of both OLTP and OLAP database solutions.
Experience with Microsoft 2008R2 / 2012 / 2016 Business Intelligence stack - expertise with SQL Server Integration Services;
familiarity / proficiency with SQL Server Analysis and Reporting Services.
Familiarity with data modeling and data mining.
Strong written and verbal communications skills required. Ability to interact with management and business application owners to communicate status and collect requirements.
Production support responsibilities including some on-call rotating scheduling.
Seeking candidate that is good at troubleshooting data issues, self-starter, highly motivated, and can lead projects
Proven attendance record.
Demonstrates understanding and complies with patient and staff safety policies and procedures that foster a safe and inclusive environment for all.
Ability to perform the essential duties of the job.
Effectively uses empathy in interactions with others.
Demonstrates behaviours consistent with Mackenzie Health’s Commitment to Caring.
Models behaviour that is aligned with the values of Mackenzie Health Excellence, Leadership and Empathy.
Commitment to providing an exceptional experience for staff and clients within a challenging and exciting health care environment.
You may be required to work at any site of Mackenzie Health
Mackenzie Health is an inclusive and equal opportunity employer committed to providing accommodations for applicants upon request at any stage of the recruitment process in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code.