RQ11860 – Database Administrator – Senior

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

We are seeking a highly experienced Senior Database Administrator with strong expertise in enterprise database administration, cloud database management, database architecture, performance optimization, data security, and hybrid database environments. 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, optimizing, and supporting enterprise database environments, including cloud-hosted, hybrid, and legacy on-premises systems. Experience with Oracle Database Administration, Cloud DB Administration, DevOps/DataOps, database migrations, backup and recovery, enterprise architecture, and large-scale government applications will be highly valuable.

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.).
  
  

Description

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; 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 cyber security 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

• Subject matter expert in database design of the data warehouse or data marts.
• Experience and expert knowledge in the required technology and/or application, including installation, configuration, maintenance, upgrade (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 suite.
• Experience with database administration and vendor support services.
  
  

Additional Skills For Cloud Database Administrator

• Expertise and experience in Cloud DB Administration, Data Development (DevOps/DataOps) and Operations, Data Integration, and Automation tools and technologies.
• Further research suggested on a potential need for a role of a Senior DevOps/Cloud DBA at a rate similar to a Senior DevOps/Cloud Engineer.
  
  

Additional Skills For Oracle Database Administrator

• Experience in e-Business Suite Applications R12.2 and Oracle Data Guard application (installation, configuration, maintenance, patching, upgrade, 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, upgrade 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, 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.
• Experience designing, testing, and executing 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; 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.
  
  

How to Apply

If you are interested and your profile matches the requirements, kindly send the following mandatory documents to hrsmss@smsoftconsulting.com by Thursday, November 12, 2026, at 10:00 AM EST.

Mandatory Documents

• Updated Resume in Word format (Mandatory)
• References (Mandatory)
• Expected Hourly Rate (Mandatory)
• Visa Status (Mandatory)
• LinkedIn ID (Mandatory)
  
  

Without the mandatory documents, we cannot submit a candidate.

WhatsApp Group

For daily job updates, you can also join our WhatsApp group using the link below:

Join our WhatsApp Group

Additional Information

• Work Arrangement: Onsite – 5 days per week.
  
  

Email is the best way to reach us.

You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.