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