IT Specialist - Oracle Database Administrator

At Santé Québec, caring for people is at the heart of our commitment.

That is what unites us and drives us.

We bring together the 30 public health and social services establishments in Quebec and rely on the commitment of nearly 325,000 people who, every day, put their expertise to the service of the well-being of the entire population.

We believe that through collaboration, commitment, respect, kindness, and excellence, a more human, stronger, and fairer network is built.

Working at Santé Québec means contributing to a deeply human mission, in a constantly evolving environment focused on innovation and continuous improvement.

If you share this vision, if you want to contribute to it and make a real difference, your place is here.

Job Title 1124 – IT Specialist

Person who coordinates, manages, and supervises the activities of analysis, implementation, evolution, deployment, support, and operational support of complex, multisite, and cross-sector information systems projects.

They act as an expert in their field of specialization. They coordinate the work of a team of IT analysts and technicians.

Responsibilities

The Digital Solutions (DS) Division is responsible for the development, operation, maintenance, support, and sustainability of over a hundred digital solutions used at Santé Québec, the Ministry of Health and Social Services (MHSS), and several partner organizations, including Family Medicine Groups (FMGs), the Régie de l'assurance maladie du Québec (RAMQ), and the Institut national de santé publique du Québec (INSPQ). These solutions operate 24 hours a day, 7 days a week, 365 days a year, and serve over 300,000 users working in clinical and administrative sectors: frontline services, rehabilitation, home support, public health, youth, medico-administrative, administrative, etc. Through certain applications and telephone services, a potential of 9 million Quebec citizens also benefit from these solutions.

Under the responsibility of the DS Division, the Adjoined Division of Digital Solutions in Health and Administrative Services (DASNHAS) is tasked with ensuring the operation, sustainability, and evolution of the essential DS that support the proper functioning of Santé Québec, the MHSS, and several partner organizations, such as Family Medicine Groups (FMGs) and the Institut national de santé publique (INSPQ). These solutions are used daily by thousands of users in various sectors, from frontline services to youth services, including medico-administrative and administrative services.

The DASNHAS also offers strategic cross-cutting services, including support for the development of digital projects and management of the imaging domain of the Santé Québec Record (SQR).

Under the supervision of the Chief of Service – Digital Solutions and Health Data, the incumbent plays a crucial role in managing, optimizing, securing, and evolving the Oracle databases that support Santé Québec's DS. They ensure the stability, availability, and performance of the data environments, which are at the heart of critical provincial solutions operating 24/7 and used by thousands of users. This position also includes a paid on-call duty obligation in accordance with SPGQ work conditions to ensure the continuity of essential services.

As an expert in their field, they conduct in-depth analyses, design and implement advanced monitoring, backup, restoration, and optimization mechanisms. They ensure the integrity, resilience, and sustainability of the data platforms while respecting security standards, data management best practices, and organizational guidelines.

They collaborate closely with application teams, infrastructure, architecture, security, and deployment teams to ensure a harmonious integration of technological components. They also play an advisory role to project managers, analysts, and architects, informing them of technical, capacity, or performance impacts related to databases.

In the context of application evolution projects, technological migrations, or major incident resolutions, they may be called upon to coordinate work with different technical teams. They thus contribute to prioritizing actions, defining solutions, ensuring the quality of deliverables, and guaranteeing the continuity of essential services.

Finally, they actively participate in the continuous improvement of data environments, the implementation of standards and best practices, and technological vigilance to ensure the modernization, security, and performance of the Oracle platforms supporting Santé Québec's mission.

More specifically, the main areas of action are as follows: Administration, monitoring, and optimization of Oracle databases

• Ensure the daily administration of Oracle databases supporting DS, including configuration, parameter tuning, and environment evolution.
• Continuously monitor database performance, proactively detect anomalies, and recommend necessary adjustments to ensure operational efficiency.
• Perform performance analyses and optimize queries, structures, and storage mechanisms to maintain reliable and performant environments.
• Develop, maintain, and optimize SQL and PL/SQL scripts to meet operational needs and support data integrity and quality.

Security, compliance, and access management

• Ensure the security and integrity of databases by rigorously applying patches, managing vulnerabilities, and implementing preventive measures.
• Manage database access — users, roles, and privileges — in compliance with information security policies, and ensure complete and rigorous tracking of access to sensitive data.

Backup, restoration, and service continuity

• Design, execute, and improve backup and restoration strategies, including process automation and regular recovery procedure validation.
• Participate in the implementation and maintenance of high-availability solutions to ensure the continuity of critical services.

Support, diagnosis, and incident resolution

• Quickly diagnose anomalies and incidents affecting databases, intervene effectively to restore stability, and propose durable solutions.
• Document analyses and actions taken to enrich internal practices and prevent problem recurrence.

Inter-team collaboration and project participation

• Participate in application evolution, modernization, or environment migration projects.
• Work closely with architects, analysts, developers, infrastructure, security, and deployment teams.
• Contribute to planning, estimating, and implementing database-related work within the context of multisite or cross-sector projects.

Technical coordination contribution

• Coordinate, when required, technical work involving multiple teams in database-related aspects (migrations, integrations, major incidents).
• Contribute to action prioritization, solution definition, and deliverable validation to ensure service quality and continuity.
• Continuous improvement, documentation, and technological vigilance
• Document environments, procedures, interventions, and improvements rigorously.
• Participate in the development of standards, operational guidelines, best practice guides, and automation mechanisms.
• Ensure continuous technological vigilance on Oracle solutions, including cloud-related evolutions (Oracle Cloud Infrastructure or related services), and recommend improvements aligned with Santé Québec's guidelines.
• Propose opportunities for optimization, modernization, and migration to cloud solutions.