Our downtown client, the Ministry of Education has a hybrid remote contract opportunity for an Oracle Database Administrator / Designer.....
Experience and Skill Set Requirements
Oracle Database Administrator/Operational Support - 50%
• Demonstrated expertise with Oracle Database Enterprise Edition
• Demonstrated experience with Linux OS
• Demonstrated expertise with Oracle 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.
MUST Haves:
• Demonstrated expertise with Oracle Database Enterprise Edition
• Demonstrated experience with Linux OS
• Demonstrated expertise with Oracle RAC, Data Guard, DB Vault
• Demonstrated experience with Oracle Enterprise Monitoring (OEM) and performance monitoring
Demonstrated experience developing, managing and testing back-up and recovery plans; ensuring that storage, archiving, back-up and recovery procedures are functioning correctly;
• 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;
Job Types: Full-time, Fixed term contract
Salary: $95.00 per hour
Flexible Language Requirement:
• French not required
Schedule:
• Day shift
• Monday to Friday
• No weekends
Work Location: Hybrid remote in Toronto, ON M5G 2C8
