Responsibilities:
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:
Experience with one or more operating systems
Experience with one or more database technologies
Experience in one or more programming languages
Experience in the use of information retrieval packages and proficiency with query languages
Experience in monitoring and enforcing database rules
Experience in Incident, Change and Configuration Management procedures
Experience with one or more communications protocols
Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills
A team player with a track record for meeting deadlines
Desirable Skills:
Experience with distributed data systems Experience with middleware and gateways
Experience with researching and implementing cyber security vulnerability remediations
Awareness of emerging IT trends and directions
Experience with Computer Aided Software Engineering (CASE) tools Knowledge and understanding of Information Management principles, concepts, policies and practices
Experience in Database Administration, Maintenance Optimization
Requirements
Experience and Skill Set Requirements:
Must Haves:
More than 10 yrs Oracle DBA experience
Approved experience of Oracle 19c using multi-tenant architecture
RMAN backup and Restore
Data Encryption using ASO/TDE
Oracle Dataguard Physical/Logical Configuration & Administration
Skill Set Requirements:
General Skills:
Experience in database administration at the specified experience level
Experience of managing Oracle 12c/19c ETL/Data warehouse Experience with UNIX operating system Experience with Oracle database technologies
Experience in one or more programming language
Experience in the use of information retrieval packages and proficiency with query language Experience with one or more communications protocol
Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skill
A team player with a track record for meeting deadline
Experience in monitoring and enforcing database rule
Experience in Incident, Change and Configuration Management procedures
Dataguard, Installation
Experience designing, installing, configuring, and maintaining an Oracle Dataguard environment Oracle Database Configuration
Experience planning and designing a new database deployment. Experience installing and configuring an Oracle 12c RAC Database Oracle 12c Enterprise Manage
Experience with designing, building, Installing, configuring, and administering OEM 12c Alerting and Reporting
Experience installing, configuring and administering OEM 12c Alerting and Reporting Oracle Unified Auditing
Experience installing, configuring and administering Oracle 12c Unified Auditing DB performance Tuning (5-7+ years experience perform ongoing monitoring and tuning of database )
OPS Experience
Desirable Skills:
Oracle certification - OCP
Oracle Partitioning
Oracle Advanced Compression
Oracle Golden Gate Experience with distributed data system
Experience with DB2 database technologies
Data Conversion from DB2 to Oracle
Building of Oracle RAC on conventional Solaris server
Oracle Engineered solution
Experience of DB web search service
Oracle DB data integration and evaluation
Experience with middleware and gateways
Awareness of emerging IT trends and direction
Experience with infrastructure services within the Ontario government (e.g. Internal Infrastructure Hosting policies and Provisioning practices)
Knowledge of the GSIC support organization and ITSM processes adopted in OPS including
