Skills

At 5700 Yonge Street

RQ10763

Title:

Client:

HSC

Start Date:

End Date:

Max Extensions:

1 Times

Onsite

Location:

5700 Yonge Street

Closing Date:

, 11:00am

10+ years of experience in the following:

• Databaseadministration using Oracle technologies and products, including Oracle
  19C,Oracle on AWS – RDS, Oracle RAC, RMAN backup/recovery, Data Compression and encryption, Oracle Data Guard, Oracle Golden Gate and Oracle EM
• Experience in complex BI/DW solution design, implementation, maintenance, and support,using Oracle 19C, Oracle Directory Server, Informatica Power Center & Data Quality, IBM Cognos, Business Objects in a Sun Solaris/Red Hat 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 Solution Crossing Data Centers, and multi-tier web-based off-the-shelf solutionstools, including Oracle technologies & products (Oracle Database, Active Data Guard, Golden Gate, etc.) Cognos, Informatica Power Center, Power exchange& Data Quality
• Experience with Cognos, BO, Informatica and LDAP servers

• Provide technical expertise with technologies including Oracle Servers, Oracle 19
  
  Cmulti-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 running smoothly.
• Operate and administer the database management system (DBMS) including database optimization, performance tuning, backup and recovery
• Provide installation, administration, fine-tuning and support for SAP Business objects,Cognos BI, Informatica Power Center, Oracle Goldengate and Oracle Active dataguard
• Assist withany performance/functionality issues arising due to recent releases of code to production and proactively implement changes to avoid recurrence
• Operate and administer the database management system (DBMS) including database optimization, performance tuning, backup and recovery
• Develop and maintain data design models, database schemas and scripts, technical documentation 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 for detailed plans and resource estimates
• Provide specialized technical expertise in database administration, data warehousedesign, data modeling, Extraction, Transformation & Load (ETL), information management, BI solution design, development and maintenance
• Provide Database (Oracle technologies & products) expertise for troubleshooting,problem resolution and performance tuning of the production solutions in operation
• Provide professional opinions and recommendations for technical issues, management,briefings, etc., and provide expertise, offer solutions and lead implementation of approved recommendations

Skills

Experience and Skill Set Requirements

Public Sector Experience

• 5+years of experience working with federal/provincial/broader public-sectorhealthcare providers
• Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices
• Abilityto produce technical documentation that comply with industry standardpractices
• Knowledge and experience with Public Sector Health related projects
• Knowledge and…