Job Description Summary: The

Database

Administrator(DBA)isresponsibleforprovidingoperationalsupport,administration,maintenance,monitoring,andoptimizationofdatabaseenvironmentssupportingcritical

Ministryapplicationsandservices.

Theroleensurestheavailability,integrity,security,recoverability,andperformanceofdatabasesacrossmultipletechnologyplatforms,including

MicrosoftSQLServer,IBMDB2,and

Oracleenvironments.

TheDBAworkscloselywithapplicationsupportteams,infrastructureteams,developers,vendors,andprojectstakeholderstosupportbothlegacyandmodernizedenterprisesystemsinhighlyavailableandmission-criticalenvironments.

Collaboratesondefiningtheproductsdataarchitecture Workscloselywithdataanalysts,dataengineers,datascientiststobridgethegapsbetweendatascience,dataengineeringandproductreporting Responsibletoensuredataisusedeffectivelyinproductdecisionmaking Providesoversightondatarequirementsanditsimplementation HelpsdefinethedataproductmetricandKPIsalignedwithbusinessgoalsandobjectives Key

Responsibilities: Operational

Database

Support: Provideday-to-dayoperationalsupportfor

Ministryapplicationsandassociateddatabaseenvironments.

Monitordatabasehealth,availability,performance,storageutilization,andsystemreliability.

Performproactivetroubleshootingandresolutionofdatabase-relatedincidentsandservicerequests.

Supportproduction,test,development,disasterrecovery,andhigh-availabilityenvironments.

Participateinon-callsupport,after-hoursmaintenance,andemergencyincidentresolutionasrequired.

Database

Administration&Maintenance;: Administer,configure,patch,upgrade,andmaintaindatabaseplatformsincluding: MicrosoftSQLServer IBMDB2(z/OSand

Windows/Linux) Oracle

Databaseenvironments Performdatabaseinstallations,migrations,refreshes,cloning,andenvironmentsetupactivities.

Maintainbackup,recovery,anddisasterrecoveryprocedurestoensurebusinesscontinuity.

Managedatabasesecurity,useraccess,roles,permissions,encryption,andcompliancerequirements.

Conductdatabasecapacityplanningandstoragemanagementactivities.

Performance

Monitoring&Optimization;: Analyzeandtunedatabaseperformance,queries,indexes,executionplans,andsystemresources.

Identifyandresolvebottlenecksaffectingapplicationperformanceandstability.

Implementmonitoringandalertingsolutionstoproactivelymanagesystemhealth.

Supporthigh-availabilitytechnologiesincludingclustering,failover,andreplicationsolutions.

Change,Release&Environment;

Management: Supportchangemanagement,deployment,andreleaseactivitiesfollowing

MinistrystandardsandITILpractices.

Coordinatedatabasechangeswithinfrastructure,application,andvendorteams.

Developandmaintainoperationaldocumentation,procedures,runbooks,andsupportknowledgearticles.

Participateintechnicalreviews,rootcauseanalysis,andpost-incidentactivities.

Project&Modernization;

Support: Providetechnicalexpertiseforapplicationmodernization,migration,andinfrastructureupgradeinitiatives.

Supportcloud,virtualization,andhybridinfrastructureinitiativeswhereapplicable.

Collaboratewithdevelopmentandarchitectureteamsondatabasedesignandimplementationstrategies.

Assistwithtechnologylifecyclemanagementandplatformupgradeplanning.

Supported

Technologies&Environments;: TheDBAwillprovideoperationalsupportfor

Ministryapplicationsutilizingthefollowingtechnologies: MicrosoftSQLServer

Environments: SQLServer2019,2022and2025 Windows

Serverplatforms SQLClustering Failoverconfigurations Always

OnAvailability

Groups IBMDB2Environments: DB2v13onz/OS(Mainframe) DB2on

Windows DB2on

RedHat

Linux(RHEL) Oracle

Environments: Oracle11gand

Oracle19c Oracle

Multitenant

Architecture Oracle

Enterprise

Manager(OEM) Red

HatLinux(RHEL)platform Required

Skills&Experience;: ExperienceadministeringenterprisedatabaseenvironmentsincludingSQLServer,Oracle,and/orDB2.

Strongknowledgeofdatabasebackup/recovery,performancetuning,monitoring,andtroubleshooting.

Experiencesupportinghigh-availabilityanddisasterrecoverysolutions.

Knowledgeof

Windows

Server,Linux(RHEL),and/or

Mainframeenvironments.





Experiencewithdatabasesecurity,accesscontrols,andoperationalbestpractices.

FamiliaritywithITILprocesses,incidentmanagement,changemanagement,andreleasemanagement.

Stronganalytical,problem-solving,andcommunicationskills.

Abilitytoworkindependentlyandcollaborativelywithincross-functionalteams.

Preferred

Qualifications: Experiencesupportinglarge-scalegovernmentorenterpriseapplications.

Knowledgeofcloudtechnologiesandhybridinfrastructureenvironments.

Experiencewithautomationandscriptingfordatabaseadministrationtasks.

Relevantcertificationsin

MicrosoftSQLServer,Oracle,IBMDB2,orrelatedtechnologies.

Experiencewithmonitoringandenterprisemanagementtools.

Deliverables&Outcomes;: Ensurestable,secure,andreliabledatabaseoperationsforallsupported

Ministryapplications.

Maintaindatabaseavailabilityandperformanceinaccordancewithoperationalservicelevels.

Delivertimelyresolutionofincidents,problems,andoperationalrequests.

Supportongoingmodernizationandcontinuousimprovementinitiatives.

Maintainaccurateoperationaldocumentationandtechnicalprocedures.

Requirements Experience and Skill Set Requirements: Must Haves: Experience in designing and implementing REST API integrations and best practices SQL Server Administration strong hands-on experience with SQL Server 2019, 2022 and 2025 Multi-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 performance Backup & Recovery strong understanding of HA/DR strategies and implementation Skill Set Requirements: Technical

Knowledgeand

Experience: SQLServer

AdministrationstronghandsonexperiencewithSQLServer2019,2022and2025 Failover

ClusteringexperienceinconfiguringandmaintainingSQLServer2019,2022and2025clusterinstances Always

OnAvailability

Groupsdeepknowledgeofsetup,monitoring,failover,andtroubleshooting Performance

Tuningabilitytodiagnoseandoptimizequeries,indexes,andserverperformance Backup&RecoverystrongunderstandingofHA;/DRstrategiesandimplementation SQLServer

Upgradeshandsonexperienceupgrading: SQLServer20192022;SQLServer20222025 MultiDBMSExperiencemusthavehandsonexperiencewithatleastoneof: Oracle19c,DB2/Windows,orDB2/zOS Experiencewithdevelopmentandmainframetechnologies Experiencewithmiddlewareandgateways Experienceinapplicationmonitoringandsupport Experienceinmiddlewaresoftwareinstallation,configuration,tuningandadministration,aswellasexperiencewithapplicationdevelopment Experiencewithchangemanagementandreleasemanagementasprocessessupportingtheimplementationoflargeapplications Experienceinstructuredmethodologiesforthedesign,development,implementationandmaintenanceofapplications Abilitytoanalyzeandsolvedataintegrity,security,configurationandrecoveryissues Assessandtest

Change

Requests(CRQ)withtechnicalcontentandupdateasnecessary Abilitytoparticipateinreleasepromotions/implementationsandpatching Ateamplayerwithatrackrecordofmeetingdeadlines Provideend-to-endsolutiondesign,development,andunittesting,alongwithrecommendationstoachievebusinessoutcomesalignedwithbusinessrequirements,the

Clusterreferencearchitecture,and

Ministry-specificobjectives.

Collaboratewithstakeholderstounderstandbusinessgoalsandsupportdeliveryoutcomes.

ExperienceindesigningandimplementingRESTAPIintegrationsandbestpractices Incorporatesecurityrequirementsintothedesign,understandandcomplywithOPSsecuritystandardsandpolicies.

Communicationandtroubleshooting:



Excellentanalytical,problem-solvinganddecisionmakingskills;verbalandwrittencommunicationskills;interpersonalandnegotiationskills Experienceworkinginanagiledevelopmentenvironment Abilitytoprovideuserandsystemdocumentationasrequired Contributetotheeffectivemanagementofrisksandissuesassociatedwith

Solutiondesigns Collaboratewithcross-functionalanddistributedteams,includingdesigners,developers,architects,projectmanagers,andQA Promotesindustrystandardsandbestpracticeswiththeproductteams.

Performthoroughcodereviews,includingunittestsandensurehighqualityofthesoftware.

Fixdefectsandsupportdevelopers,testersandendusers Planninganddocumentation: Writetechnicaldocumentationthatsupportsandthoroughlyexplainsthearchitecture Deliverknowledgetransfersessionstotheteamontheworkcompleted Producereportsandupdatesasrequired Requirements Experience and Skill Set Requirements: Must Haves: Experience in designing and implementing REST API integrations and best practices SQL Server Administration strong hands-on experience with SQL Server 2019, 2022 and 2025 Multi-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 performance Backup & Recovery strong understanding of HA/DR strategies and implementation Skill Set Requirements: Technical Knowledge and Experience: SQL Server Administration strong hands on experience with SQL Server 2019 , 2022 and 2025 Failover Clustering experience in configuring and maintaining SQL Server 2019, 2022 and 2025 cluster instances Always On Availability Groups deep knowledge of setup, monitoring, failover, and troubleshooting Performance Tuning ability to diagnose and optimize queries, indexes, and server performance Backup & Recovery strong understanding of HA/DR strategies and implementation SQL Server Upgrades hands on experience upgrading: SQL Server 2019 2022; SQL Server 2022 2025 Multi DBMS Experience must have hands on experience with at least one of: Oracle 19c, DB2/Windows, or DB2/zOS Experience with development and mainframe technologies Experience with middleware and gateways Experience in application monitoring and support Experience in middleware software installation, configuration, tuning and administration, as well as experience with application development Experience with change management and release management as processes supporting the implementation of large applications Experience in structured methodologies for the design, development, implementation and maintenance of applications Ability to analyze and solve data integrity, security, configuration and recovery issues Assess and test Change Requests (CRQ) with technical content and update as necessary Ability to participate in release promotions/implementations and patching A team player with a track record of meeting deadlines Provide end-to-end solution design, development, and unit testing, along with recommendations to achieve business outcomes aligned with business requirements, the Cluster reference architecture, and Ministry-specific objectives.

Collaborate with stakeholders to understand business goals and support delivery outcomes.

Experience in designing and implementing REST API integrations and best practices Incorporate security requirements into the design, understand and comply with OPS security standards and policies.

Communication and troubleshooting: Excellent analytical, problem-solving and decision making skills; verbal and written communication skills; interpersonal and negotiation skills Experience working in an agile development setting Ability to provide user and system documentation as required Contribute to the effective management of risks and issues associated with Solution designs Collaborate with cross-functional and distributed teams, including designers, developers, architects, project managers, and QA Promotes industry standards and best practices with the product teams.

Perform thorough code reviews, including unit tests and ensure high quality of the software.

Fix defects and support developers, testers and end users Planning and documentation: Write technical documentation that supports and thoroughly explains the architecture Deliver knowledge transfer sessions to the team on the work completed Produce reports and updates as required

📌 Database Administrator - Senior (Toronto)
🏢 Maarut
📍 Toronto