Position Summary
The client is seeking an experienced Senior Database Administrator to manage, maintain, optimize, and secure enterprise-level database environments across cloud, hybrid, and on-premises infrastructure.
The ideal candidate should have extensive experience with Oracle and Microsoft SQL Server, cloud database platforms (Azure/AWS), database architecture, performance tuning, backup and recovery, security implementation, and enterprise database migrations.
Candidates with experience supporting large-scale government or public-sector applications, particularly Ontario Public Service (OPS), will be preferred.
Key Responsibilities
-
Design, implement, configure, and maintain enterprise database environments.
-
Administer and optimize Oracle, SQL Server, and other major DBMS platforms.
-
Manage cloud-hosted, hybrid, and on-premises database environments.
-
Perform database performance tuning, capacity planning, installation, upgrades, and migrations.
-
Develop and implement database backup, recovery, and disaster recovery strategies.
-
Implement database security, encryption, role-based access control (RBAC), and data masking.
-
Perform database version upgrades, patching, maintenance, and consolidation projects.
-
Design conceptual, logical, and physical database models.
-
Support database integrations using REST APIs, MuleSoft, and similar technologies.
-
Work with enterprise architecture, application development, and infrastructure teams.
-
Ensure compliance with government data privacy and security requirements.
-
Prepare technical documentation, reports, assessments, and recommendations.
Mandatory Technical Skills
Skill Area
Required Experience
Database Technologies
Oracle, Microsoft SQL Server, PostgreSQL, MySQL, IBM DB2
Cloud Databases
Azure SQL, Amazon RDS, Google Cloud SQL
Cloud Platforms
Microsoft Azure or AWS
Hybrid Infrastructure
Cloud-hosted and legacy on-premises database environments
Database Architecture
Conceptual, logical, physical data modelling and schema design
Security
RBAC, data masking, row-level security, TDE, encryption
Programming
SQL, PL/SQL, T-SQL, Java, Microsoft .NET
Database Integration
MuleSoft or similar integration technologies
Cloud Data Services
Azure SQL MI, Azure Blob Storage, Cosmos DB
Enterprise Systems
Large-scale enterprise and government applications
Additional / Preferred Skills
Oracle Database Administration
-
Oracle Database 12c/19c.
-
Oracle E-Business Suite R12.2.
-
Oracle Data Guard.
-
Oracle RAC and multi-node environments.
-
RMAN, ASM, and Flash Recovery Area (FRA).
-
WebLogic and Oracle Enterprise Manager (OEM).
-
Oracle database patching, upgrades, cloning, and migration.
-
Advanced Compression and Data Partitioning.
-
Oracle performance tuning and capacity planning.
-
Unix/Linux administration and shell scripting.
Cloud & DevOps
-
Azure SQL, Azure SQL MI, Cosmos DB.
-
AWS RDS and cloud database administration.
-
Database automation and DataOps.
-
PowerShell, Python, Bash scripting.
-
Cloud database migration and integration.
-
Disaster recovery and geo-replication.
Other Preferred Skills
-
MuleSoft.
-
REST APIs and application integrations.
-
Dynamics 365 and Power Platform.
-
Agile methodologies and Kanban.
-
Enterprise and Solution Architecture.
-
Ontario Government Enterprise Architecture practices.
-
Information Management principles.
Requirements
Experience Requirements
Candidates should demonstrate:
-
Extensive senior-level database administration experience.
-
Experience managing multiple enterprise DBMS platforms.
-
Experience with cloud and hybrid database environments.
-
Experience supporting large-scale government or enterprise applications.
-
Hands-on experience with database migrations, upgrades, and consolidation.
-
Experience implementing database security and privacy controls.
-
Experience developing backup, recovery, and business continuity strategies.
-
Experience working in Agile environments.
Communication Requirements
-
Excellent verbal and written communication.
-
Ability to prepare technical reports and documentation.
-
Ability to explain complex database architecture and technical solutions.
-
Strong stakeholder management and collaboration skills.
-
Ability to work with technical and non-technical teams.
