Creates physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery
General Skills
- 01Experience with one or more operating systems
- 02Experience with one or more database technologies
- 03Experience in one or more programming languages
- 04Experience in the use of information retrieval packages and proficiency with query languages
- 05Experience in monitoring and enforcing database rules
- 06Experience in Incident, Change and Configuration Management procedures
- 07Experience with one or more communications protocols
- 08Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills
- 09A team player with a track record for meeting deadlines
Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE
- 10Subject matter expert in database design of the data warehouse or data marts.
Skills
- 11Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning
Additional Skills for Case Management and ERP
- 12Experience in designing/developing an automated data distribution mechanism
- 13Knowledge and understanding of object-oriented analysis and design techniques.
- 14Experience in developing enterprise architecture deliverables (e.g. models) based
- 15Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
- 16Knowledge and understanding of Information Management principles, concepts, policies and practices
- 17Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
- 18Experience in technical design, planning and implementation of specific technology or suite
- 19Experience with database administration and vendor support services
Additional Skills for Cloud Database Administrator
- 20Expertise and experience in Cloud DB Administration, Data Development (DevOps/DataOps) & Operations, Data Integration, Automation tools and technologies.
- 21Further research suggested on a potential need for a role of a Senior DevOps/Cloud DBA at a rate similar to a Senior DevOps/Could Engineer
Additional Skills for Oracle Database Administrator
- 22Experience in e-Business Suite Applications R12.2 and Oracle Data Guard application (installation, configuration, maintenance, patching, upgrade, and cloning)
- 23Knowledge and experience in configuring the latest version of WebLogic, OEM Grid Control
- 24Expert level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x
- 25Expert level knowledge of Advanced Compression, Data partitioning processes
- 26High level knowledge of data masking using Oracle patches and database scripts
- 27Performance tuning of e-Business Suite R12.2/19c in multi-node RAC
- 28Developing database backup and restore strategy utilizing Flash Recovery Area (FRA) for RMAN and ASM.
- 29Expert level knowledge of Oracle 12c/19c database administration, maintenance, security implementation, upgrade and patching, database performance tuning, sizing and capacity planning, database backup and recovery using RMAN
- 30Knowledge of Configuring Oracle E-Business Suite Release 12.2 using Logical Host
- 31Knowledge of Online patching
- 32Knowledge of UNIX OS (Operating System) and Linux OS, utilities, shell scripting
Canada
