• Skip to primary navigation
  • Skip to main content
  • Skip to footer

1.844.822.0541

info@nexusgroup.ca

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • English
    • Français
  • Consultant Login
  • Find Your Opportunity
Nexus Systems Group

Nexus Systems Group

  • Home
  • What We Do
    • Staffing Solutions Made Easy
    • Contingent Workforce Management and Payroll Solutions
    • Technology Consulting and Delivery
  • Who We Serve
  • Who We Are
    • Our Team
    • News and Awards
    • Associations and Community
  • Contact Us
  • News

Oracle Database Administrator – Senior

January 28, 2021 by

Job Title: Database Administrator – Senior
Location: Toronto, ON
Duration 24 months

Description

The Public Health I&IT Solutions (PHS) Branch develops and implements innovative I+IT solutions to modernize and improve public health in Ontario so that Ontario's public health units/regional public health entities can improve delivery of mandatory public health programs and services. These services encompass the provision of immunization services, seniors’ dental health program, control of infectious diseases, disease and injury prevention, safe drinking water, school health services and tobacco inspection programs, as prescribed in the Ontario Public Health Standards.

 

The requested FFS resources are required to sustain existing operations through support of the database infrastructure and to development/test environments, pre-production and production environments in the Digital Health Delivery Platform (DHDP) for the DHIR which includes Panorama, Business Object (BO) reports and Panorama Enhanced Analytic Reporting (PEAR), and the extensions such as: Public Health Information Exchange (PHIX), Student Information Exchange (STIX), Immunization Forecaster and the Integrated Public Health Information System (iPHIS). The support work includes modifying the DHDP infrastructure and Docker platform, as well as integration to the Storage Area Network (SAN) to support ongoing updates with Panorama upgrades and patches. The resources will take part in the implementation and integration of the new COVID Vaccine offering to DHIR. In addition, the resources are routinely called upon to support COVID19 related work streams for Case and Contact management (CCM) as well as Vaccination.

 

Deliverables

·  Provide technical expertise with technologies including Oracle T7 Servers, Oracle 12c multi-tenant database/Oracle 12c Active data guard, Oracle 13c Enterprise cloud control (OEM CC), Oracle Golden Gate 12.3, Informatica / Cognos and Shadowbase

·  Produce daily monitoring scripts for entire stack of DTE databases and reviewing them for 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 PowerCenter, Oracle Goldengate and Oracle Active data guard

·  Assist with any performance/functionality issues arising due to recent releases of code to production and proactively implement changes to avoid recurrence

·  Create physical database designs

·  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

·  Provide build books/deployment guides for the deployment to higher environments

·  Assist in change initiatives in planning for data / database design, database setup, migration, optimization and tuning, capacity planning, data conversion and other development and implementation-related activities

·  Produce data and database management project plans. Develop and obtain approval for detailed plans and resource estimates

·  Provide specialized technical expertise in database administration, data warehouse design, 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

·  Coordinate with Oracle support in opening tickets and providing information to find solutions and root cause analysis of ongoing issues

  • Apply Now
  • See All Jobs

Footer

ABOUT NEXUS SYSTEMS GROUP

Nexus is one of North America’s leaders in the provision of technology staff augmentation and strategic resource consulting. With a team of talented professionals using best of breed methodologies, Nexus consistently over delivers with quick, quality and trusted results to its clients and consultants.

LATEST OPPORTUNITIES

  • Expert Project Manager (Customer & Employee Experience) May 19, 2022
  • Financial Analyst May 19, 2022
  • Project Manager – Procurement May 19, 2022
  • React Developer May 19, 2022

SOCIAL

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
Report on Business Canada's Top Growing Companies - Nexus Group
Nexus Group Growth 500 2019
Nexus Systems Group Growth 500 2018
NEXUS GROUP SYSTEMS GROUP INC. NEXUSGROUP.CA
  • Contact Us
  • Terms & Conditions
  • Privacy Policy