Database Administrator - Digital Information Systems (EPIC)

Mackenzie Health

2d • Onsite

About The Position

As part of the larger Digital Information Systems team, works under indirect supervision, assists in the maintenance, and control of Epic 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 in projects is focused on smoothing the transition of projects from development staff to production staff by performing operations activities within the project life cycle. Applicants will either need to have valid Epic ODBA certification or will need to complete and pass the required Epic courses. Contribute to safe, quality care by: Create and manage the ODB environments that serve production, reporting, disaster recovery, training, and non-production needs. Create and manage Linux based servers and serve multiple functions. 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 Linux, Iris 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.

Requirements

• B.Sc. in Computer Science or other technical discipline.
• Valid Epic ODBA certification or commitment to complete and pass the required Epic courses.
• ITIL certification is required or commitment to complete within six (6) months from the date of hire.
• Linux certificate is required or commitment to complete within six (6) months from the date of hire.
• MS SQL DBA certificate is required or commitment to complete within six (6) months from the date of hire.
• Experience with designing databases.
• Experience with integration between third party systems.
• Production support responsibilities including some on-call rotating scheduling.
• PIPEDA/PHIPA compliance experience as it relates to network best practices and security as well as managing and complying with PIPEDA/PHIPA network controls.
• Proven attendance record.
• Demonstrate understanding and comply 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 behaviors consistent with Mackenzie Health’s Commitment to Caring.
• Models’ behavior that is aligned with the values of Mackenzie Health – Excellence, Leadership and Empathy.
• Commitment to providing exceptional experience for staff and clients within a challenging and exciting health care environment.

Nice To Haves

• Iris System Management Experience.
• Expertise in designing, implementing and maintaining High Availability solutions.
• Expertise in core SQL Server concepts - performance monitoring/tuning, replication, partitioning, clustering.
• Expertise in all aspects of SQL Server database security; familiarity with security best practices.
• Expertise with design and implementation of both OLTP and OLAP database solutions.
• Familiarity with data modeling and data mining.
• Familiarity with shelling scripting.
• Strong written and verbal communications skills required.
• Ability to interact with management and business application owners to communicate status and collect requirements.
• Seeking candidates that is good at troubleshooting data issues, self-starter, highly motivated, and can lead projects.

Responsibilities

• Create and manage the ODB environments that serve production, reporting, disaster recovery, training, and non-production needs.
• Create and manage Linux based servers and serve multiple functions.
• Install and maintain the administrative and monitoring tools necessary for high levels of availability and performance of Mackenzie Health’s Epic EMR system.
• Manage the logins for different types of access, including login behavior and working environment configuration.
• Apply Linux, Iris and Epic upgrades and updates to production and non-production environments.
• Configure and maintain environment copies according to the environment strategy.
• Respond to emergency and after-hours issues.
• Assist project teams with technical issues in the Initiation and Planning phases of our standard Project Management Methodology.
• Perform operations activities within the project life cycle to smooth the transition of projects from development staff to production staff.

What This Job Offers

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