Responsibilities:
Creates physical database designs and operates and administers 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 for meeting deadlines
Desirable Skills:
Experience with distributed data systems
Experience with middleware and gateways
Experience with 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 Optimization
Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE
Subject matter expert in database design of the data warehouse or data marts.
Skills:
Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning
Additional Skills for Case Management and ERP
Experience in designing/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) based
Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
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, and 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) & Operations, Data Integration, 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/Could 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, 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, 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 strategy 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, 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, shell scripting

• Skills

• 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 onPrem and Cloud connections using Mulesoft or similar tools
Experience Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, Microsoft .Net,
Experience with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB etc.)
Experience with Rest APIs & Integrations, Web/Lite Apps


Experience (40%)
Experience with cloud platforms such as Azure, Dynamics 365, 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
Ensuring adherence to provincial data privacy and security mandates
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, assessments
Ability to present ideas and suggestions clearly and effectively and 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 clear and understandable manner

• Supplier Comments
Closing Date/Time: 2026-11-12, 12:00 p.m.
Max submission: 1 (one)
5 days onsite

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 Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, Microsoft .Net,
Experience with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB etc.)