Job Description

Type de poste:
Permanent
A la recherche d'une carriere epanouissante qui changera reellement votre vie et celle des autres? Vous etes au bon endroit.
A titre de partenaire national en solutions de sante, nous placons les gens au coeur de tout ce que nous faisons - en commencant par notre equipe de plus de 8 000 employes et employees qui mettent a profit leurs experiences personnelles et professionnelles diversifiees dans le cadre de leur travail a Medavie. Par l'entremise de la collaboration et de l'innovation, notre equipe cree des solutions d'assurance, de soins primaires et de services medicaux d'urgence a l'avant-garde de l'industrie qui viennent en aide a des millions de Canadiens et Canadiennes chaque annee.
Notre mission est d'ameliorer le bien-etre de la population canadienne afin que chaque personne puisse profiter pleinement de la vie, et cela se reflete dans notre culture d'entreprise primee. Nous celebrons l'individualite des membres de notre personnel et accordons de la valeur a la diversite de leurs points de vue et de leurs competences. C'est pourquoi en plus de vous offrir une remuneration concurrentielle et une gamme complete d'avantages sociaux, nous vous donnons acces a des possibilites de croissance professionnelle et personnelle, a des modalites de travail flexibles, a des experiences enrichissantes, ainsi qu'a un leadership bienveillant. A Medavie, chaque personne peut donner le meilleur d'elle-meme, se sentir a sa place et atteindre son plein potentiel. Joignez-vous a nous en postulant un poste des aujourd'hui.
Position Summary
As an Oracle Database Administrator at Medavie Inc., you will oversee and enhance our Oracle, Microsoft SQL, and MySQL environments. You'll manage installations, upgrades, migrations, patching, and configuration changes while ensuring full compliance with established processes and audit standards. Your work will focus on maintaining secure, reliable, and high?performing database services through automation, monitoring, tuning, and continuous improvement.
You'll collaborate closely with development and operational teams to troubleshoot issues, optimize queries, support PL/SQL needs, and assist with application releases and project initiatives. You will also respond to customer and internal service requests with professionalism and clear documentation. In this role, you'll refine automated processes, contribute to database design, evaluate and configure software tools, and support cross?team IT projects. You'll maintain accurate documentation and help shape the ongoing evolution of Medavie's database services.
Success in this position requires the ability to work independently from home or the office, stay composed during high?pressure production issues, manage multiple priorities in a fast?paced environment, and participate in a rotating on?call schedule with reliable remote access.

Key Responsibilities
As an Oracle Database Administrator for Medavie Inc's Oracle, Microsoft SQL, and MYSQL databases, your primary responsibilities include:Perform research, recommendations, database installs, migrations, upgrades, patching and database configuration changes while following processes and remaining compliant with audit standards. Automate, monitor, manage, secure, tune, improve and support database services processes within Medavie Inc's infrastructure and deliver great results while following processes and remaining compliant with audit standards. Support and collaborate with development and operational support teams in troubleshooting, problem solving, query tuning, testing, and deploying application releases, corporate project initiatives and changes. Provide PL/SQL support to end users and developers. Interact with customers, answer questions, and respond to service requests and help desk requests within the required service levels and clearly document actions taken. Analyze, enhance, troubleshoot, and modify automated processes, maintenance activities and procedures and/or improve existing ones. Research, recommend, create, and support databases and database objects. Develop logical and physical database designs. Evaluate, install, and configure database software products and related software. Initiate, plan, and implement projects focused within the Oracle Database Services team as well as across other Information Technology teams. Create and maintain documentation for Medavie Inc.'s database services and software products.


On-Call Rotation: Must be able to participate in a rotating on-call support process with the ability to be remotely connected within the required service level.

Required QualificationsEducation: Bachelor's degree in Computer Science, Business or related field or College Diploma in related filed of study and/or equivalent experience Work Experience: Possess minimum 5 years of Oracle database administration experience or application development experience working with databases. Have experience working with UNIX and Windows operating system, Linux Bash/Shell scripting, Oracle Datapump utility, SQLPlus, and PLSQL. Other Qualifications: Knowledge of GitLab, Discoverer, Oracle reports, ITIL, SOA and RUP methodologies will be considered an asset. Computer Skills: Have experience working with some or all of the following database and reporting products: Oracle database, MSSQL database, MySQL database, SQL Language, PL SQL Developer, Oracle Discoverer, Cognos, Crystal Reports, Hyperion, Oracle Designer and Enterprise Architect.

Language Skills: English (Written and Spoken) is required. French (Spoken) is an asset.
Security Clearance Requirement: In conjunction with our contract with the Federal Government, you will be required to have Reliability Status Clearance (Enhanced Level B). This includes Fingerprinting, Criminal Record Check, Credit Check and you must have resided in Canada for at least 5 years and hold Permanent Resident or Citizenship Status.
#LI-VS1
#CBM2
This posting is for an existing vacancy within our organization / Ce poste est actuellement vacant au sein de notre organisation.
Echelle Salariale:
88,158 - 99,177 CAD
L'echelle salariale de base proposee peut dependre du dossier de candidature de la personne retenue ou d'autres facteurs professionnels comme les connaissances, les competences, la qualification, l'experience et la formation. En plus de recevoir le salaire de base, les employes et employees admissibles de Medavie peuvent participer a divers programmes de bonification fondes sur le rendement. Le versement des paiements associes a ces programmes est discretionnaire et depend des resultats individuels et de ceux de l'entreprise.
Nous croyons que les membres de notre personnel doivent representer les collectivites que nous servons et nous encourageons les personnes de tous les horizons a poser leur candidature. Pour vous offrir la meilleure experience qui soit, nous vous proposons des mesures d'adaptation pour chacune des etapes du processus de recrutement. Il vous suffit d'en faire la demande a l'equipe de recrutement. Nous nous engageons a veiller a ce que le recrutement, la fidelisation et le perfectionnement des employes et employees, de meme que leur remuneration, demeurent equitables, tiennent compte des besoins en matiere d'accessibilite et respectent l'ensemble des droits de la personne et des lois sur la protection de la vie privee qui s'appliquent. Nous remercions toutes les personnes qui ont manifeste de l'interet pour ce poste. Veuillez noter que nous communiquerons seulement avec les personnes retenues pour une entrevue.
Des outils fondes sur l'intelligence artificielle sont utilises dans le cadre de notre processus d'embauche afin d'appuyer l'evaluation des candidatures.
Si vous rencontrez des problemes techniques au cours de votre procedure d'application, veuillez envoyer un courriel a : Medavie.Recruitment@medavie.ca.