Description: Responsibilities: Createsphysicaldatabasedesignsandoperatesandadministersthedatabasemanagementsystem(DBMS)includingdatabaseoptimization,capacityplanning,installationandmigration,databasedesign,performancetuning,backupandrecovery General Skills: Experiencewithoneormoreoperatingsystems Experiencewithoneormoredatabasetechnologies Experienceinoneormoreprogramminglanguages Experienceintheuseofinformationretrievalpackagesandproficiencywithquerylanguages Experienceinmonitoringandenforcingdatabaserules Experiencein Incident,Changeand Configuration Managementprocedures Experiencewithoneormorecommunicationsprotocols Excellentanalytical,problem-solvinganddecision-makingskills;verbalandwrittencommunicationskills;andinterpersonalskills Ateamplayerwithatrackrecordformeetingdeadlines Desirable Skills: Experiencewithdistributeddatasystems Experiencewithmiddlewareandgateways Experiencewithresearchingandimplementingcybersecurityvulnerabilityremediations AwarenessofemergingITtrendsanddirections Experiencewith Computer Aided Software
Engineering(CASE)tools Knowledgeandunderstandingof Information Managementprinciples,concepts,policiesandpractices Experiencein Database Administration,Maintenance Optimization Additional Responsibilities/Skillsfor Data Warehouseincluding OracleOBIEESubjectmatterexpertindatabasedesignofthedatawarehouseordatamarts. Skills: Experienceandexpertknowledgeintechnologyand/orapplicationrequiredincludinginstallation,configuration,maintenance,upgrade(technologystack)andcloning Additional Skillsfor Case ManagementandERPExperienceindesigning/developinganautomateddatadistributionmechanism Knowledgeandunderstandingofobject-orientedanalysisanddesigntechniques. Experienceindevelopingenterprisearchitecturedeliverables(e.g.models)based Knowledgeandunderstandingof
Ontario Government Enterprise Architectureprocessesandpractice Knowledgeandunderstandingof Information Managementprinciples,concepts,policiesandpractices Experienceinimpactanalysis,implementationplanningandimplementationoftechnologyorsuitespecificpatches,maintenancepacksandreleases,andtechnologystackpatchsetsandreleases Experienceintechnicaldesign,planningandimplementationofspecifictechnologyorsuite Experiencewithdatabaseadministrationandvendorsupportservices Experience and Skill Set Requirements Experience AndSkill SetRequirements 60% Createsdatabasedesigns,operatesandadministersthe OracledatabaseandMSSQLserver solution,including: Maintaining OracleandMSSQLserversandbackups Provisioningofdatabases Securingdataandaccesstothe OracleandMSSQLServersanddatabases Tuning,capacitymanagementandmonitoringofthedatabases Writedatabasescriptsandcreatetables,storedprocedures,views,etc. Maintaindocumentationforoperations DRsupport,restorationandconfigurationofDRSQLserversandDBs General Skills 25%: Experiencewith Windows Serverand RedHat Linuxoperatingsystems Experiencewithboth Oracleand MicrosoftSQLServerandSQLServer Reporting
Service Experienceintheuseofinformationretrievalpackagesandproficiencywithquery languages Experienceinmonitoringandenforcingdatabaserules Experiencein Incident,Changeand Configuration Managementprocedures Excellentanalytical,problem-solvinganddecision-makingskills;verbalandwritten communicationskills;andinterpersonalskills Ateamplayerwithatrackrecordformeetingdeadlines Desirable Skills 15%: Experiencewithdistributeddatasystems Experiencewithmiddlewareandgateways Experiencewithresearchingandimplementingcybersecurityvulnerability remediations AwarenessofemergingITtrendsanddirections Knowledgeandunderstandingof Information Managementprinciples,concepts, policiesandpractices Must haves: Createsdatabasedesigns,operatesandadministersthe OracledatabaseandMSSQLserver solution,including: Maintaining OracleandMSSQLserversandbackups Provisioningofdatabases Securingdataandaccesstothe OracleandMSSQLServersanddatabases Tuning,capacitymanagementandmonitoringofthedatabases Writedatabasescriptsandcreatetables,storedprocedures,views,etc. Maintaindocumentationforoperations DRsupport,restorationandconfigurationofDRSQLserversandDBs Experiencewith Windows Serverand RedHat Linuxoperatingsystems Apply on Kit Job: kitjob.ca/job/2oc82p