Database Administrator - Senior

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.