Job Description

We are seeking a Senior Database Administrator with 10+ years of experience handling Oracle 19C, Oracle RAC, Data Guard, GoldenGate, Informatica, Cognos, and other enterprise technologies. This hybrid role (3 days onsite, 2 days remote) supports a critical IT solution, ensuring optimized data management, performance tuning, and troubleshooting in complex BI/DW environments.

Advantages
•Hybrid Work Setup: Strike a balance between on-site collaboration and remote flexibility.
•High-Impact Projects: Contribute to essential public health solutions with large-scale data warehousing and advanced Oracle technologies.
•Complex & Diverse Tech Stack: Work with Oracle RAC, Active Data Guard, GoldenGate, Informatica PowerCenter, Cognos, and more.
•Professional Growth: Hone leadership, problem-solving, and performance tuning skills in a demanding, mission-critical environment.
•Collaborative Environment: Team up with cross-functional specialists to address data integrity, system optimization, and production issues.

Responsibilities
•Install, configure, and maintain Oracle databases (19C, RAC, Data Guard, GoldenGate), ensuring optimal performance, backup/recovery, and security.

•Administer and support SAP Business Objects, Cognos BI, and Informatica platforms.
•Monitor and optimize BI/DW solutions; address performance issues in Oracle databases and related services.
•Provide root cause analysis and implement preventive measures for recurring problems.
•Develop and maintain data models, schemas, scripts, and build books for higher environment deployments.
•Produce technical documentation, ensuring compliance with standards and best practices.
•Collaborate with cross-functional teams to support system design, code releases, capacity planning, and data migration.
•Liaise with Oracle, Informatica, or Cognos support to resolve complex incidents and ensure system stability.
•Contribute to project plans for database-related activities, including setup, migration, and tuning.
•Follow established processes for incident, change, and configuration management, ensuring seamless integration with other systems.

Qualifications
•10+ years of database administration experience with Oracle products (Oracle 19C, RAC, RMAN, Data Guard, GoldenGate).
•Proven background in BI/DW solution design, using Informatica PowerCenter, Cognos, Business Objects, and Oracle DB in Unix/Linux environments.
•Expertise in diagnosing and resolving server/system issues related to Cognos, BO, Informatica, LDAP, and Oracle DBs.
•Strong knowledge of performance tuning, backup/recovery, partitioning, compression, and security.
•Excellent communication, problem-solving, and organizational skills for complex IT environments.
•Familiarity with large-scale health sector data management.
•Hands-on experience with additional Oracle or BI tools and frameworks.

Summary
Join us as a Senior Database Administrator to manage and enhance mission-critical data solutions. If you excel at configuring Oracle databases, optimizing BI/DW systems, and collaborating with multidisciplinary teams, this hybrid position offers a compelling opportunity to leverage your expertise in a dynamic, high-stakes environment. Apply now to make a significant impact on data-driven public health initiatives!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process. show more

Job Tags

Remote job,

Similar Jobs