RQ11860 – Database Administrator – Senior (Onsite)

S M Software Solutions Inc

Toronto

On-site

CAD 120,000 - 150,000

Full time

30 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

The Ministry of Public and Business Service Delivery and Procurement is seeking a Senior Database Administrator to lead the design, implementation, and security of enterprise databases. The role involves optimizing performance, managing cloud-hosted and hybrid databases, and ensuring compliance with enterprise architecture and data privacy requirements.

This is an onsite position at 222 Jarvis Street, Toronto, Ontario.

Qualifications

  • Experience with major DBMS including Oracle, SQL Server, PostgreSQL, MySQL, IBM DB2.

Responsibilities

  • Create physical database designs and operate and administer the DBMS, including optimization, capacity planning, installation and migration, design, performance tuning, backup and recovery.

Skills

Analytical thinking
Problem-solving
Team player
Communication skills
Deadline-driven

Tools

Oracle
SQL Server
PostgreSQL
MySQL
IBM DB2
Azure SQL
AWS RDS
Cosmos DB

Job description

Client: Ministry of Public and Business Service Delivery and Procurement – RQ11860

We are seeking a highly experienced Senior Database Administrator with extensive expertise in database administration, database design, performance optimization, cloud database management, enterprise data architecture, and database security. The ideal candidate will have hands‑on experience with major database management systems, including Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2, along with cloud platforms such as Microsoft Azure and AWS. The successful candidate will be responsible for designing, implementing, maintaining, securing, and optimizing enterprise database environments, supporting cloud‑hosted and hybrid databases, managing database migrations and upgrades, ensuring data availability, and maintaining compliance with enterprise architecture, cybersecurity, and provincial data privacy requirements.

Role Snapshot
  • Job Title: RQ11860 – Database Administrator – Senior
  • Client: Ministry of Public and Business Service Delivery and Procurement
  • Work Location: 222 Jarvis Street, Toronto, Ontario, Canada
  • Work Arrangement: Onsite – 5 Days per Week
  • Estimated Start Date: November 16, 2026
  • Estimated End Date: October 5, 2027
  • Business Days: 254.00
  • Extension: Probable after the initial mandate
  • Hours: 7.25 hours per day
  • Security Level: No Clearance Required
Must Have
  • Experience with major Database Management Systems (DBMS), such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2.
  • Experience managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS, Google Cloud SQL) alongside legacy on-premises mainframes and enterprise servers.
  • Experience with Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, and Microsoft .NET.
  • Experience with SQL Server, Oracle, and Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB, etc.).
Responsibilities
  • Create physical database designs and operate and administer the Database Management System (DBMS), including database optimization, capacity planning, installation and migration, database design, performance tuning, backup, and recovery.
General Skills
  • Experience with one or more operating systems.
  • Experience with one or more database technologies.
  • Experience in one or more programming languages.
  • Experience in the use of information retrieval packages and proficiency with query languages.
  • Experience in monitoring and enforcing database rules.
  • Experience in Incident, Change, and Configuration Management procedures.
  • Experience with one or more communications protocols.
  • Excellent analytical, problem‑solving, and decision‑making skills, along with strong verbal and written communication skills and interpersonal skills.
  • A team player with a track record of meeting deadlines.
Desirable Skills
  • Experience with distributed data systems.
  • Experience with middleware and gateways.
  • Experience researching and implementing cybersecurity vulnerability remediations.
  • Awareness of emerging IT trends and directions.
  • Experience with Computer Aided Software Engineering (CASE) tools.
  • Knowledge and understanding of Information Management principles, concepts, policies, and practices.
  • Experience in Database Administration, Maintenance, and Optimization.
Additional Responsibilities/Skills For Data Warehouse Including Oracle OBIEE
  • Act as a subject matter expert in database design for data warehouses or data marts.
Skills
  • Experience and expert knowledge in the required technology and/or application, including installation, configuration, maintenance, upgrades (technology stack), and cloning.
Additional Skills For Case Management And ERP
  • Experience in designing and developing an automated data distribution mechanism.
  • Knowledge and understanding of object‑oriented analysis and design techniques.
  • Experience in developing enterprise architecture deliverables (e.g., models).
  • Knowledge and understanding of Ontario Government Enterprise Architecture processes and practices.
  • Knowledge and understanding of Information Management principles, concepts, policies, and practices.
  • Experience in impact analysis, implementation planning, and implementation of technology- or suite‑specific patches, maintenance packs, and releases, as well as technology stack patch sets and releases.
  • Experience in technical design, planning, and implementation of specific technology or suites.
  • Experience with database administration and vendor support services.
Additional Skills For Cloud Database Administrator
  • Expertise and experience in Cloud Database Administration, Data Development (DevOps/Data Ops) and Operations, Data Integration, and Automation tools and technologies.
  • Further research suggested on a potential need for a Senior DevOps/Cloud DBA at a rate similar to a Senior DevOps/Cloud Engineer.
Additional Skills For Oracle Database Administrator
  • Experience with e‑Business Suite Applications R12.2 and Oracle Data Guard applications, including installation, configuration, maintenance, patching, upgrades, and cloning.
  • Knowledge and experience in configuring the latest version of WebLogic and OEM Grid Control.
  • Expert-level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x.
  • Expert-level knowledge of Advanced Compression and Data Partitioning processes.
  • High-level knowledge of data masking using Oracle patches and database scripts.
  • Performance tuning of e‑Business Suite R12.2/19c in multi-node RAC.
  • Developing database backup and restore strategies utilizing Flash Recovery Area (FRA) for RMAN and ASM.
  • Expert-level knowledge of Oracle 12c/19c database administration, maintenance, security implementation, upgrades and patching, database performance tuning, sizing and capacity planning, and database backup and recovery using RMAN.
  • Knowledge of configuring Oracle E‑Business Suite Release 12.2 using Logical Host.
  • Knowledge of online patching.
  • Knowledge of UNIX OS (Operating System) and Linux OS, utilities, and shell scripting.
Experience And Skill Set Requirements
  • Technical Skills – 40%
  • Experience with major Database Management Systems (DBMS), such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2.
  • Experience managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS, Google Cloud SQL) alongside legacy on‑premises mainframes and enterprise servers.
  • Experience with Agile methodologies.
  • Experience with conceptual, logical, and physical data modeling, schema design, and enterprise data architecture to support large scale public applications.
  • Experience with on‑premises and cloud connections using MuleSoft or similar tools.
  • Experience with Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, and Microsoft .NET.
  • Experience with SQL Server, Oracle, and Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB, etc.).
  • Experience with REST APIs and integrations, Web/Lite Apps.
  • Experience – 40%
  • Experience with cloud platforms such as Azure, Dynamics 365, and Power Platform.
  • Experience implementing strict role‑based access control (RBAC), data masking, row‑level security, and transparent data encryption (TDE) at rest and in transit.
  • Ensure adherence to provincial data privacy and security mandates.
  • Design, test, and execute enterprise backup strategies, point‑in‑time recovery, geo‑replication, and business continuity failover drills.
  • Experience with Agile methodologies, including using Kanban/task boards.
  • Hands‑on experience leading major database version upgrades, cross‑platform migrations, and consolidation projects without disrupting agency services.
  • Experience with SQL, PL/SQL, T‑SQL, and shell scripting (Bash, PowerShell, Python) for automation, stored procedures, and triggers.
  • Experience with large government applications.
  • Communication Skills – 20%
  • Strong communication skills to prepare documentation, including but not limited to reports, reviews, and assessments.
  • Ability to present ideas and suggestions clearly and effectively in a user-friendly manner, and maintain a high level of customer service to both internal and external clients.
  • Ability to communicate designs and development in a clear and understandable manner.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Database Administrator
Senior Database Administrator

BuzzClan • Toronto

On-site
CAD 83,000 - 165,000
RQ08428 - Database Administrator - Intermediate
RQ08428 - Database Administrator - Intermediate

Rubicon Path • Toronto

On-site
CAD 70,000 - 90,000
RQ11508 - Software Developer - Senior I 1+ Year I Toronto ON
RQ11508 - Software Developer - Senior I 1+ Year I Toronto ON

Analyst Technical Solutions • Toronto

On-site
CAD 131,000 - 139,000
RQ08966 - Specialized IT Consultant - Senior
RQ08966 - Specialized IT Consultant - Senior

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
RQ08648 - Data Architect/Modeller - Senior
RQ08648 - Data Architect/Modeller - Senior

Rubicon Path • Toronto

Hybrid
CAD 100,000 - 130,000
Intermediate DB Admin: Data Warehouse & BI Analytics
Intermediate DB Admin: Data Warehouse & BI Analytics

Rubicon Path • Toronto

On-site
CAD 70,000 - 90,000
RQ09356 - Specialized IT Consultant - Senior
RQ09356 - Specialized IT Consultant - Senior

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 130,000
RQ08186 - Sr. Specialized IT Consultant
RQ08186 - Sr. Specialized IT Consultant

Rubicon Path • Toronto

Hybrid
CAD 80,000 - 120,000
RQ09086 - Software Developer - Senior
RQ09086 - Software Developer - Senior

Rubicon Path • Toronto

On-site
CAD 80,000 - 110,000
Software Developer - ETL - Senior - RQ11635
Software Developer - ETL - Senior - RQ11635

Analyst Technical Solutions • Toronto

On-site
CAD 90,000 - 120,000