At 5700 Yonge Street RQ10763 Title: Client: HSC Start Date: 2026-04-01 End Date: 2027-10-05 Max Extensions: 1 Times Onsite Location: 5700 Yonge Street Closing Date: 2026-03-12, 11:00am Must Have

10+ years ofexperience in the following: Databaseadministration using Oracle technologies and products, including Oracle19C,Oracle on AWS – RDS, Oracle RAC, RMAN backup/recovery, DataCompression and encryption, Oracle Data Guard, Oracle GoldenGate and Oracle EM Experiencein complex BI/DW solution design, implementation, maintenance, and support,using Oracle 19C, Oracle Directory Server, Informatica PowerCenter & DataQuality, IBM Cognos, Business Objects in a Sun Solaris/RedHat environment Superiortechnical expertise in: enterprise data warehouse database configuration,optimization and tuning, support and maintenance with Oracle database in aSun Solaris environment for complex Business Intelligence/Data Warehouse(BI/DW) solutions, Bi-Directional Data Replication for Active-Active SolutionCrossing Data Centers, and multi-tier web-based off-the-shelf solutionstools, including Oracle technologies & products (Oracle Database, ActiveData Guard, GoldenGate, etc.) Cognos, Informatica PowerCenter, Power exchange& Data Quality Experiencewith Cognos, BO, Informatica and LDAP servers Description

Providetechnical expertise with technologies including Oracle Servers, Oracle 19Cmulti-tenant database/Oracle, Oracle on AWS - RDS Active dataguard, Oracle Enterprise cloud control (OEM CC), Oracle Golden Gate,Informatica / Cognos Producedaily monitoring scripts for entire stack of DTE databases and reviewing themfor any potential issues and pro-actively fixing them to keep things runningsmoothly. Operate andadminister the database management system (DBMS) including databaseoptimization, performance tuning, backup and recovery Provideinstallation, administration, fine-tuning and support for SAP Business objects,Cognos BI, Informatica PowerCenter, Oracle Goldengate and Oracle Active dataguard Assist withany performance/functionality issues arising due to recent releases of code toproduction and proactively implement changes to avoid recurrence Operate andadminister the database management system (DBMS) including databaseoptimization, performance tuning, backup and recovery Develop andmaintain data design models, database schemas and scripts, technicaldocumentation and specifications Providebuild books/deployment guides for the deployment to higher environments Assist inchange initiatives in planning for data / database design, database setup,migration, optimization and tuning, capacity planning, data conversion andother development and implementation-related activities Producedata and database management project plans. Develop and obtain approval fordetailed plans and resource estimates Providespecialized technical expertise in database administration,



data warehousedesign, data modeling, Extraction, Transformation & Load (ETL), informationmanagement, BI solution design, development and maintenance ProvideDatabase (Oracle technologies & products) expertise for troubleshooting,problem resolution and performance tuning of the production solutions inoperation Provideprofessional opinions and recommendations for technical issues, management,briefings, etc., and provide expertise, offer solutions and lead implementationof approved recommendations Skills Experienceand Skill Set Requirements PublicSector Experience 5+years of experience working with federal/provincial/broader public-sectorhealthcare providers Knowledgeof Public Sector Enterprise Architecture artifacts (or similar), processesand practices Abilityto produce technical documentation that comply with industry standardpractices Knowledgeand experience with Public Sector Health related projects Knowledgeand understanding of Ministry policy and IT project approval processes andrequirements would be an asset Experienceadopting and adhering to Public Sector Unified I⁢ Project Methodology,Public Sector Enterprise Architecture and Public Sector Gating process, andPublic Sector Standard Systems Development Methodologies Experiencewith large complex IT Health-related projects. 5 points TechnicalSkills 10+ yearsof experience in the following: Databaseadministration using Oracle technologies and products, including Oracle19C,Oracle on AWS – RDS, Oracle RAC, RMAN backup/recovery, DataCompression and encryption, Oracle Data Guard, Oracle GoldenGate and Oracle EM Experiencein complex BI/DW solution design, implementation, maintenance, and support,using Oracle 19C, Oracle Directory Server, Informatica PowerCenter & DataQuality, IBM Cognos, Business Objects in a Sun Solaris/RedHat environment Superiortechnical expertise in: enterprise data warehouse database configuration,optimization and tuning, support and maintenance with Oracle database in aSun Solaris setting for complex Business Intelligence/Data Warehouse(BI/DW) solutions, Bi-Directional Data Replication for Active-Active SolutionCrossing Data Centers, and multi-tier web-based off-the-shelf solutionstools, including Oracle technologies & products (Oracle Database, ActiveData Guard, GoldenGate, etc.) Cognos, Informatica PowerCenter, Power exchange& Data Quality Experiencewith Cognos, BO,



Informatica and LDAP servers 50 points CoreSkills and Experience 10+ yearsexperience in the following: Administeringand supporting and troubleshooting server/system issues related to Cognos,BO, Informatica, LDAP and Oracle DBs Experiencewith physical database designs, operation and administration of databasemanagement system (DBMS), including database optimization, performancetuning, backup and recovery, partitioning, compression, and security Developingand maintaining data design models, database schemas and scripts, technicaldocumentation and specifications Providingbuild books/deployment guides for the deployment to higher environments Experiencewith database setup, migration, tuning capacity planning, and data conversion in a large operation with multiple environments Maintainingdata design models, database schemas and scripts, technical documentation andspecifications Providingspecialized technical expertise in database administration, data warehousedesign, data modeling, Extraction, Transformation & Load (ETL),information management, BI solution design, development and maintenance ProvidingDatabase (Oracle technologies & products) expertise for troubleshooting,problem resolution and performance tuning of the production solutions inoperation Providingprofessional opinions and recommendations for technical issues, management,briefings, etc., and provide expertise, offer solutions and leadimplementation of approved recommendations Coordinatingwith Oracle support, Informatica support and Cognos support in openingtickets and providing information to find solutions and root cause analysisof ongoing issues Experiencewith middleware, gateways and reporting systems Experiencein Incident, Change and Configuration Management procedures Experiencewith use of information retrieval packages and proficiency with querylanguages. 35 points GeneralSkills Proventechnical leadership skills with ability to identify areas for improvement,and recommend solutions Exceptionalanalytical, problem solving and decision-making skills Demonstratedstrong interpersonal, verbal and written communication, and presentationskills Proventroubleshooting and critical thinking experience Demonstratedability to apply strong listening skills to facilitate issue resolution Effectiveconsulting skills to engage with all stakeholders with proven track recordfor building strong working relationships Stronginterpersonal, facilitation and negotiation skills with ability to buildrapport with stakeholders and drive negotiations to a successful outcome Excellentcustomer service skills, including tact and diplomacy to ensure client needsare managed effectively Amotivated, flexible, detail-oriented and creative team player withperseverance, excellent organization and multi-tasking abilities, and aproven track record for meeting strict deadlines. 10 points

#J-18808-Ljbffr

📌 Must Have Skills (Toronto)
🏢 SharpITS
📍 Toronto