RQ02289 - Specialized IT Consultant - Senior Period: 13 Months Start Date ASAP End Date 2023-03-31 Location Toronto Working Hrs.: 7.25 Hrs. / day Experience and Skill Set Requirements
Oracle Database Administrator/Operational Support - 50% Demonstrated expertise with Oracle Database Enterprise Edition
Demonstrated experience with Solaris and Linux OS's
Demonstrated expertise withOracle RAC, Data Guard, DB Vault
Demonstrated experience with Oracle Enterprise Monitoring (OEM) and performance monitoring
Demonstrated experience installing and testing new versions of Oracle DB EE
Demonstrated experience developing, managing and testing back-up and recovery plans; ensuring that storage, archiving, back-up and recovery procedures are functioning correctly;
Demonstrated experience with capacity planning;
Provision for data security and recovery control (all data is retrievable in an emergency)
Establishing the needs of users and monitoring user access and security;
Monitoring performance and managing parameters to provide fast query responses to front-end users;
Controlling access permissions and privileges;
Liaising with IT specialists and unit leads and working closely with support team members and relevant stakeholders;
Communicating regularly with technical, applications and operational staff to ensure database integrity and security;
Decommissioning and installing new applications and customizing existing applications in order to make them fit for purpose;
Assisting with scheduled operational data store loads as well as performing database backups and restores
Database Modelling and Design - 50% Demonstrates advanced knowledge of BI, data warehousing, data modeling techniques, tools and approaches;
Participates in the analysis, design, development, and unit testing of all the project's database components;
Designs RDBMS, DML and DDL components for Oracle database systems
Maps out the conceptual design for a planned database in outline; considers both back-end organization of data and front-end accessibility for end-users;
Refines the logical design so that it can be translated into a specific data model; further refining the physical design to meet system storage requirements;
Develops and maintains data models using Power Designer as per GO-ITS standards;
Writes technical specifications, including data standards, procedures and definitions for the data dictionary (metadata);
Participating in the design of the overall solution to ensure business needs are met;
Leads and conducts data modelling (conceptual, logical and physical) and data flow modeling sessions with project team members
Developing architecture artifacts (e.g. data models, interface data requirements document, traceability matrix) based on Ontario Government Enterprise Architecture processes and practice
Ensuring project compliance with the Ontario government and the Cluster/Ministry's guidelines, standards and procedures such as:
architecture/technology standards and best practices;
conflict of interest and confidentiality guidelines;
security procedures and practices; and
Ontario Government I&IT Directive, operational policy on the I&IT project gateway process.
Nice to have
Public Sector experience preferred •
Last updated on Jan 24, 2022