[Hiring] Database Administrator @Mackenzie Health

Role Description

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
• Facilitate the successful movement and representation of data around enterprise databases
• Resolve questions related to all areas of Database Administration on all production platforms supported by the enterprise
• Assist project teams with technical issues in the Initiation and Planning phases of our standard Project Management Methodology
• 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 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:

• Creating and managing the ODB environments that serve production, reporting, disaster recovery, training, and non-production needs
• Creating and managing Linux based servers and serving multiple functions
• Installing and maintaining the administrative and monitoring tools necessary for high levels of availability and performance of Mackenzie Health’s Epic EMR system
• Managing the logins for different types of access, including login behavior and working environment configuration
• Applying Linux, Iris and Epic upgrades and updates to production and non-production environments
• Configuring and maintaining environment copies according to the environment strategy
• Responding to emergency and after-hours issues

Qualifications

• B.Sc. in Computer Science or other technical discipline
• 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

Requirements

• 5 years of Data Base experience
• Iris 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, 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 shell scripting
• 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
• PIPEDA/PHIPA compliance experience as it relates to network best practices and security
• Seeking candidates that are good at troubleshooting data issues, self-starter, highly motivated, and can lead projects
• Proven attendance record
• Demonstrate understanding and comply with patient and staff safety policies and procedures
• 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
• You may be required to work at any site of Mackenzie Health

Company Description

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.

Our hiring process does not involve the use of artificial intelligence (AI) to screen, assess or select applicants.

We thank all applicants for their interest; however, only those under consideration for an interview will be contacted.