Osler is driven by a strategic Vision to go beyond for our people and communities. As part of this commitment we are embarking on an exciting digital transformation to implement a new modernized hospital information system (HIS). Our dedicated HIS team will collaborate closely with our trusted HIS vendor (Epic) and internal subject matter experts to develop a fully functional system that will empower us to deliver exceptional care and services.
The Database Administrator is responsible to install and administer the Epic database and data warehousing environments ensuring that all database requirements for Epic are fulfilled. This role is part of the HIS project structure with a key responsibility to design deliver and sustain our systems to address both clinical and nonclinical needs ensuring the HIS is utilized effectively and efficiently in patient care.
Accountabilities :
- Create and manage the database environments that serve production reporting disaster recovery training and nonproduction needs
- Install and maintain the administrative and monitoring tools necessary for high levels of availability and performance of Epic
- Configuring and maintaining environment copies according to the environment strategy
- Applying database and application upgrades and updates to production and nonproduction environments
- Understanding performance metrics monitoring system performance and troubleshooting issues
- Engaging in capacity planning exercises to ensure adequate system resources
- Writing and maintaining scripts to improve system management tasks
- Maintaining and testing processes related to business continuity
- Following vendor and Epic best practices for hardware and software configuration
- Participating in change control process for all planned application and technical activities
- Create and maintain documentation to build a repository of key configuration decisions and associated build
- Work closely with the Epic HIS vendor project team and operational subject matter experts to help create the future state workflows by participating and leading site visits working group meetings validation sessions and other related meetings
- Facilitate and participate in meetings to discuss deliverables issues end user concerns and upcoming milestones
- Work closely with HIS team members to identify document and troubleshoot issues to find creative resolutions
- Partner with Epic vendor representatives to maintain communication and help vendor staff understand hospitals operational needs
- Achieve Epic certification and / or accreditation
- Participate in an oncall rotation to provide 24 / 7 support
- Work extended hours (days evenings nights weekends) as required
Qualifications :
Successful completion of either a university degree or college diploma in Computer Science Health Informatics or a related field or equivalent experience is required.Minimum of three years of Microsoft SQL Server development experience including designing implementing and managing SQL solutionsExperience with database administration of InterSystems IRIS database platform is an asset.Experience with data analysis design and implementation including experience working with endusers to gather and interpret requirements.Strong Unix skills using the commandline prompt including navigating directory structures and file manipulation.Proven experience in Database Administration / Developer roles using Microsoft solutions.Experience with Microsoft High Availability technology such as Clustering Database Mirroring and Replication Log shipping Always On etc.Experience in designing implementing and supporting high availability enterprise systems.Experience creating maintaining restoring backup improving performance of existing and future database infrastructures.Proficient in troubleshooting poor performance identify causes for slowness able to read and interpret query execution plans make use of the database engine tuning advisor along with SQL profiler.Previous experience working with a modernized HIS at an EMRAM Stage 6 or higher and / or Epic certification is an asset.Proficiency in designing developing and maintaining SSIS packages for data integration transformation and migration is considered an asset.Experience with implementing and managing database encryption methods such as Transparent Data Encryption (TDE) and columnlevel encryption is considered an asset.Experience with NoSQL databases such as MongoDB and Firebase is an asset.Demonstrated critical thinking skills strong organizational skills and welldeveloped written and verbal communication skills are required.Demonstrated proficiency working with Microsoft Enterprise applications (i.e. Visio Word Excel PowerPoint Outlook SharePoint OneNote) is required.Ability to learn new software and systems demonstrating technical aptitude.Ability to work in an agile environment to deliver an HIS that meets end user needs.Ability to work independently and in collaboration with a team to meet HIS project milestones and ensure successful project delivery.Ability to analyze user requirements and produce creative solutions to meet end user needs.Ability and willingness to support project success in a manner that goes beyond completion of assigned tasks.Ability to persevere in a high intensity project to overcome obstacles and difficult situations within a time sensitive implementation.Ability to travel to the United States as required.Must demonstrate Oslers Values of Respect Excellence Service Compassion Innovation and CollaborationAdditional Information :
Hours : Currently Days (subject to change in accordance with operational requirements)
Salary Range : $85839.00 $107308.50
Application deadline : January 31 2025
LITS1
LIHybrid
Osler values inclusivity and diversity in the workplace. We welcome and encourage applicants from diverse backgrounds. We are committed to providing accessible employment practices that are in compliance with the Accessibility for Ontarians with Disabilities Act. If you require an accommodation at any stage of the recruitment process please notify Human Resources at .
While we thank all applicants only those selected for an interview will be contacted. Any information obtained during the course of recruitment will be used for employment recruitment purposes only and not for any other purpose.
Remote Work : Employment Type :
Fulltime
Key Skills
Databases,Disaster Recovery,SQL,High Availability,Microsoft SQL Server,ssrs,Database Design,Performance Tuning,SSIS,Database Administration,Sybase,Oracle
Vacancy : 1