28 Aug
|
Maarut
|
Toronto
RQ11438 - Database Administrator - Senior Posted On 24/08/2026 Job Information Term 250+89 days Assigned Recruiter(s) Margret Tinitha Job Opening ID 11417 Technology Number of Positions 1 Work Experience 7-10 Years City Toronto State/Province Ontario M4C Job Description Summary :TheDatabaseAdministrator(DBA)isresponsibleforprovidingoperationalsupport,administration,maintenance,monitoring,andoptimizationofdatabaseenvironmentssupportingcriticalMinistryapplicationsandservices.Theroleensurestheavailability,integrity,security,recoverability,andperformanceofdatabasesacrossmultipletechnologyplatforms,includingMicrosoftSQLServer,IBMDB2,andOracleenvironments.TheDBAworkscloselywithapplicationsupportteams,infrastructureteams,developers,vendors,andprojectstakeholderstosupportbothlegacyandmodernizedenterprisesystemsinhighlyavailableandmission-criticalenvironments.Collaboratesondefiningtheproduct’sdataarchitectureWorkscloselywithdataanalysts,dataengineers,datascientiststobridgethegapsbetweendatascience,dataengineeringandproductreportingResponsibletoensuredataisusedeffectivelyinproductdecisionmakingProvidesoversightondatarequirementsanditsimplementationHelpsdefinethedataproductmetricandKPIsalignedwithbusinessgoalsandobjectives KeyResponsibilities :OperationalDatabaseSupport:Provideday-to-dayoperationalsupportforMinistryapplicationsandassociateddatabaseenvironments.Monitordatabasehealth,availability,performance,storageutilization,andsystemreliability.Performproactivetroubleshootingandresolutionofdatabase-relatedincidentsandservicerequests.Supportproduction,test,development,disasterrecovery,andhigh-availabilityenvironments.Participateinon-callsupport,after-hoursmaintenance,andemergencyincidentresolutionasrequired. DatabaseAdministration&Maintenance:Administer,configure,patch,upgrade,andmaintaindatabaseplatformsincluding:MicrosoftSQLServerIBMDB2(z/OSandWindows/Linux)Performdatabaseinstallations,migrations,refreshes,cloning,andenvironmentsetupactivities.Maintainbackup,recovery,anddisasterrecoveryprocedurestoensurebusinesscontinuity.Managedatabasesecurity,useraccess,roles,permissions,encryption,andcompliancerequirements.Conductdatabasecapacityplanningandstoragemanagementactivities. PerformanceMonitoring&Optimization:Analyzeandtunedatabaseperformance,queries,indexes,executionplans,andsystemresources.Identifyandresolvebottlenecksaffectingapplicationperformanceandstability.Implementmonitoringandalertingsolutionstoproactivelymanagesystemhealth.Supporthigh-availabilitytechnologiesincludingclustering,failover,andreplicationsolutions.
Change,Release&EnvironmentManagement:Supportchangemanagement,deployment,andreleaseactivitiesfollowingMinistrystandardsandITILpractices.Coordinatedatabasechangeswithinfrastructure,application,andvendorteams.Developandmaintainoperationaldocumentation,procedures,runbooks,andsupportknowledgearticles.Participateintechnicalreviews,rootcauseanalysis,andpost-incidentactivities. Project&ModernizationSupport:Providetechnicalexpertiseforapplicationmodernization,migration,andinfrastructureupgradeinitiatives.Supportcloud,virtualization,andhybridinfrastructureinitiativeswhereapplicable.Collaboratewithdevelopmentandarchitectureteamsondatabasedesignandimplementationstrategies.Assistwithtechnologylifecyclemanagementandplatformupgradeplanning. TheDBAwillprovideoperationalsupportforMinistryapplicationsutilizingthefollowingtechnologies:SQLServer2019,2022and2025WindowsServerplatformsFailoverconfigurationsAlwaysOnAvailabilityGroupsDB2onWindowsOracle11gandOracle19cOracleEnterpriseManager(OEM) RequiredSkills&Experience: ExperienceadministeringenterprisedatabaseenvironmentsincludingSQLServer,Oracle,and/orDB2.Strongknowledgeofdatabasebackup/recovery,performancetuning,monitoring,andtroubleshooting.Experiencesupportinghigh-availabilityanddisasterrecoverysolutions.KnowledgeofWindowsServer,Linux(RHEL),and/orMainframeenvironments.Experiencewithdatabasesecurity,accesscontrols,andoperationalbestpractices.FamiliaritywithITILprocesses,incidentmanagement,changemanagement,andreleasemanagement.Stronganalytical,problem-solving,andcommunicationskills.Abilitytoworkindependentlyandcollaborativelywithincross-functionalteams. PreferredQualifications: Experiencesupportinglarge-scalegovernmentorenterpriseapplications.Knowledgeofcloudtechnologiesandhybridinfrastructureenvironments.Experiencewithautomationandscriptingfordatabaseadministrationtasks.RelevantcertificationsinMicrosoftSQLServer,Oracle,IBMDB2,orrelatedtechnologies.Experiencewithmonitoringandenterprisemanagementtools.Ensurestable,secure,andreliabledatabaseoperationsforallsupportedMinistryapplications.Maintaindatabaseavailabilityandperformanceinaccordancewithoperationalservicelevels.Delivertimelyresolutionofincidents,problems,andoperationalrequests.Supportongoingmodernizationandcontinuousimprovementinitiatives.Maintainaccurateoperationaldocumentationandtechnicalprocedures. Requirements Experience and Skill Set Requirements: Must Haves: Experience in designing and implementing REST API integrations and best practicesSQL Server Administration — robust hands-on experience with SQL Server 2019, 2022 and 2025Multi-DBMS Experience — must have hands-on experience with at least one of: Oracle 19c, DB2/Windows, or DB2/zOS Nice to Have:
Performance Tuning — ability to diagnose and optimize queries, indexes, and server performanceBackup & Recovery — strong understanding of HA/DR strategies and implementation Skill Set Requirements: TechnicalKnowledgeandExperience: SQLServerAdministration—stronghandsonexperiencewithSQLServer2019,2022and2025FailoverClustering—experienceinconfiguringandmaintainingSQLServer2019,2022and2025clusterinstancesAlwaysOnAvailabilityGroups—deepknowledgeofsetup,monitoring,failover,andtroubleshootingPerformanceTuning—abilitytodiagnoseandoptimizequeries,indexes,andserverperformanceBackup&Recovery—strongunderstandingofHA/DRstrategiesandimplementationMultiDBMSExperience—musthavehandsonexperiencewithatleastoneof:Oracle19c,DB2/Windows,orDB2/zOSExperiencewithdevelopmentandmainframetechnologiesExperiencewithmiddlewareandgatewaysExperienceinapplicationmonitoringandsupportExperienceinmiddlewaresoftwareinstallation,configuration,tuningandadministration,aswellasexperiencewithapplicationdevelopmentExperiencewithchangemanagementandreleasemanagementasprocessessupportingtheimplementationoflargeapplicationsExperienceinstructuredmethodologiesforthedesign,development,implementationandmaintenanceofapplicationsAbilitytoanalyzeandsolvedataintegrity,security,configurationandrecoveryissuesAssessandtestChangeRequests(CRQ)withtechnicalcontentandupdateasnecessaryAbilitytoparticipateinreleasepromotions/implementationsandpatchingAteamplayerwithatrackrecordofmeetingdeadlinesProvideend-to-endsolutiondesign,development,andunittesting,alongwithrecommendationstoachievebusinessoutcomesalignedwithbusinessrequirements,theClusterreferencearchitecture,andMinistry-specificobjectives.Collaboratewithstakeholderstounderstandbusinessgoalsandsupportdeliveryoutcomes.ExperienceindesigningandimplementingRESTAPIintegrationsandbestpracticesIncorporatesecurityrequirementsintothedesign,understandandcomplywithOPSsecuritystandardsandpolicies. Communicationandtroubleshooting: Excellentanalytical,problem-solvinganddecisionmakingskills; Verbalandwrittencommunicationskills; InterpersonalandnegotiationskillsExperienceworkinginanagiledevelopmentenvironmentAbilitytoprovideuserandsystemdocumentationasrequiredContributetotheeffectivemanagementofrisksandissuesassociatedwithSolutiondesignsCollaboratewithcross-functionalanddistributedteams,includingdesigners,developers,architects,projectmanagers,andQAPromotesindustrystandardsandbestpracticeswiththeproductteams.Performthoroughcodereviews,includingunittestsandensurehighqualityofthesoftware.Fixdefectsandsupportdevelopers,testersandendusers Planninganddocumentation: WritetechnicaldocumentationthatsupportsandthoroughlyexplainsthearchitectureDeliverknowledgetransfersessionstotheteamontheworkcompleted #J-18808-Ljbffr
📌 Rq11438 - Database Administrator - Senior (Toronto)
🏢 Maarut
📍 Toronto