HM Note: This hybrid role is three (3) days in office
Description:
General Skills: and nbsp; and nbsp;
- Experienceindatabaseadministrationatthespecifiedexperiencelevel and nbsp;
- ExperienceofmanagingOracle19cETL/DatawarehouseExperiencewithUNIXoperatingsystemExperiencewithOracledatabasetechnologies and nbsp;
- Experienceinoneormoreprogramminglanguage and nbsp;
- ExperienceintheuseofinformationretrievalpackagesandproficiencywithquerylanguageExperiencewithoneormorecommunicationsprotocol and nbsp;
- Excellentanalyticalproblemsolvinganddecisionmakingskills;verbalandwritten communicationskills;andinterpersonalskill and nbsp;
- Ateamplayerwithatrackrecordformeetingdeadline and nbsp;
- Experienceinmonitoringandenforcingdatabaserule and nbsp;
- ExperienceinIncidentChangeandConfigurationManagementprocedures and nbsp;
and nbsp;
RequiredSkillsets and nbsp;
- Morethan10yrsOracleDBAexperience and nbsp;
- ApprovedexperienceofOracle12c and amp;19cusingmultitenantarchitecture and nbsp;
- Oracle12cRACGridinfrastructure/ASM and nbsp;
- RMANbackupandRestore and nbsp;
- DataEncryptionusingASO/TDE and nbsp;
- OracleDataguardPhysical/LogicalConfiguration and amp;Administration and nbsp;
- OracleEnterpriseManagerconfiguration and amp;Managementforalerting and amp;reporting and nbsp;
- UNIXshellscripting and nbsp;
- SQLoptimizationtuningandperformanceexperience and nbsp;
- MSSQLServerinstallationConfigurationanddatabasemanagement and nbsp;
and nbsp;
DesirableSkill and nbsp;
- OraclecertificationOCP and nbsp;
- OraclePartitioning and nbsp;
- OracleAdvancedCompression and nbsp;
- OracleGoldenGateExperiencewithdistributeddatasystem and nbsp;
- ExperiencewithDB2databasetechnologies and nbsp;
- DataConversionfromDB2toOracle and nbsp;
- BuildingofOracleRAConconventionalSolarisserver and nbsp;
- OracleEngineeredsolution and nbsp;
- ExperienceofDBwebsearchservice and nbsp;
- OracleDBdataintegrationandevaluation and nbsp;
- Experiencewithmiddlewareandgateways and nbsp;
- AwarenessofemergingITtrendsanddirection and nbsp;
- ExperiencewithinfrastructureserviceswithintheOntariogovernment(e.g.Internal InfrastructureHostingpoliciesandProvisioningpractices) and nbsp;
- KnowledgeoftheGSICsupportorganizationandITSMprocessesadoptedinOPSincluding
Skills
Experience and Skill Set Requirements
Deployment and amp; Operations / Database Administrator / Level 3
- Price 30% and nbsp;
- and nbsp;Dataguard 20% and nbsp;
- and nbsp;Experience designing installing configuring and maintaining an Oracle Dataguard environment Oracle Database Configuration 10% and nbsp;
- Experience planning and designing a new database deployment. Experience installing and configuring an Oracle 19c RAC Database Oracle 19c Enterprise Manager 10% and nbsp;
- Experience with designing building Installing configuring and administering OEM 19c Alerting and Reporting 10% and nbsp;
- Experience installing configuring and administering OEM 19c Alerting and Reporting Oracle Unified Auditing 10% and nbsp;
- Experience installing configuring and administering Oracle 19c Unified Auditing DB performance Tuning (57 years experience perform ongoing monitoring and tuning of database) 5% and nbsp;
- OPS Experience 5% and nbsp;
Must haves:
- Morethan10yrsOracleDBAexperience and nbsp;
- ApprovedexperienceofOracle12c and amp;19cusingmultitenantarchitecture and nbsp;
- Oracle12cRACGridinfrastructure/ASM and nbsp;
- RMANbackupandRestore and nbsp;
- DataEncryptionusingASO/TDE and nbsp;
- OracleDataguardPhysical/LogicalConfiguration and amp;Administration and nbsp;
- OracleEnterpriseManagerconfiguration and amp;Managementforalerting and amp;reporting and nbsp;
- UNIXshellscripting and nbsp;
- SQLoptimizationtuningandperformanceexperience and nbsp;
- MSSQLServerinstallationConfigurationanddatabasemanagement and nbsp;