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

📌 Database Administrator 5990 (Oshawa)
🏢 Foilcon
📍 Oshawa