Senior Database Administrator

BuzzClan; Toronto; On-site; CAD 83,000 - 165,000; Full time

Job summary

BuzzClan in Toronto, Canada is seeking a Senior Database Administrator to design, implement, and optimize enterprise databases across on‑premises, cloud, and hybrid environments. The role focuses on Oracle, SQL Server, PostgreSQL, MySQL, and IBM DB2, with hands‑on experience in cloud platforms, security, and performance tuning.

The ideal candidate will manage large-scale government and enterprise applications, lead migrations and upgrades, implement disaster recovery, and ensure high

Qualifications

• Extensive experience with enterprise DBMS platforms (Oracle, SQL Server, PostgreSQL, MySQL, IBM DB2).
• Strong expertise in cloud databases and on‑prem/cloud hybrid environments.
• Experience with data modeling and enterprise data architecture.

Responsibilities

• Design, implement, administer, and maintain enterprise DBMS across on‑premises, cloud, and hybrid environments.
• Develop data models and schemas for enterprise data architecture.
• Perform upgrades, migrations, and patching to ensure security and performance.
• Monitor performance, capacity, and create backup, DR, and failover strategies.
• Administer cloud databases (Azure SQL, RDS, Google Cloud SQL, Cosmos DB).
• Ensure RBAC, data masking, TDE, and data privacy compliance.

Skills

Oracle

SQL Server

PostgreSQL

MySQL

IBM DB2

Azure SQL

Cloud databases

Tools

Azure SQL MI

Amazon RDS

Google Cloud SQL

Cosmos DB

MuleSoft

Python

PowerShell

Job description

Position Title - RQ11860 - Senior Database Administrator

Location: Toronto, ON

Mode: Contract

1. Position Overview

The successful candidate will be responsible for designing, implementing, administering, maintaining, and optimizing enterprise database environments across on-premises, cloud, and hybrid infrastructures. The role requires strong expertise in database technologies such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2, along with hands-on experience managing cloud-based database platforms, enterprise data architecture, database security, and performance optimization.

The ideal candidate will have extensive experience supporting large-scale enterprise and government applications, managing database migrations and upgrades, implementing disaster recovery strategies, and ensuring database availability, security, scalability, and performance.

Key Responsibilities

• Design, develop, implement, configure, administer, and maintain enterprise database management systems (DBMS) across on-premises, cloud, and hybrid environments.
• Create and maintain conceptual, logical, and physical database designs, data models, schemas, and enterprise data architecture.
• Perform database installation, configuration, upgrades, migrations, cloning, patching, maintenance, and performance optimization.
• Monitor database performance, conduct capacity planning, identify bottlenecks, and implement solutions to ensure high availability, scalability, and reliability.
• Develop and implement enterprise backup, recovery, disaster recovery, point-in-time recovery, and business continuity strategies.
• Administer cloud database platforms, including Azure SQL, Azure SQL Managed Instance, Amazon RDS, Google Cloud SQL, Azure Blob Storage, and Cosmos DB.
• Manage structured and unstructured data environments while supporting integration between cloud databases and legacy on-premises enterprise systems.
• Implement database security measures, including Role-Based Access Control (RBAC), data masking, row-level security, and Transparent Data Encryption (TDE).
• Ensure compliance with Ontario Government data privacy, information management, cybersecurity, and enterprise security standards.
• Develop and automate database administration activities using SQL, PL/SQL, T-SQL, Python, Bash, and PowerShell scripting.
• Support database connectivity and integrations through REST APIs, MuleSoft, middleware platforms, and other enterprise integration technologies.
• Collaborate with enterprise architects, application developers, infrastructure teams, cybersecurity specialists, and business stakeholders.
• Participate in Agile delivery methodologies, including Kanban boards, task management, sprint planning, and implementation activities.
• Lead database version upgrades, cross-platform migrations, consolidation initiatives, and technology modernization projects while minimizing service disruptions.
• Manage database incidents, changes, configurations, vendor support activities, and production troubleshooting.
• Prepare technical documentation, database architecture designs, implementation plans, assessments, operational procedures, and performance reports.

Required Technical Skills and Qualifications

Database Technologies

• Extensive experience with enterprise DBMS platforms, including Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2.
• Strong expertise in SQL Server, Oracle Database, and cloud database technologies.
• Experience with structured and unstructured databases, Azure SQL Managed Instance, Azure Blob Storage, and Cosmos DB.
• Expertise in conceptual, logical, and physical data modeling, database schema design, and enterprise data architecture.

Cloud and Hybrid Database Administration

• Experience administering cloud-hosted and hybrid database environments using Microsoft Azure and/or AWS.
• Experience with Azure SQL, Amazon RDS, Google Cloud SQL, and other enterprise cloud database services.
• Ability to integrate cloud databases with legacy on-premises mainframes and enterprise servers.
• Experience with cloud connectivity and integration using MuleSoft or similar middleware technologies.
• Understanding of enterprise and solution architecture, cybersecurity, Java, and Microsoft .NET environments.

Database Security and Governance

• Hands-on experience implementing RBAC, data masking, row-level security, and TDE.
• Knowledge of database security, vulnerability remediation, encryption, and access management.
• Experience ensuring compliance with provincial data privacy and security requirements.
• Understanding of Information Management principles, policies, standards, and practices.

Database Development and Automation

• Strong knowledge of SQL, PL/SQL, T-SQL, stored procedures, and database triggers.
• Experience with Bash, PowerShell, and Python scripting for database automation.
• Experience with REST APIs, enterprise integrations, and web-based applications.
• Knowledge of DevOps/DataOps practices and database automation tools.

Database Operations and Modernization

• Experience with database performance tuning, capacity planning, installation, configuration, maintenance, and optimization.
• Expertise in enterprise backup, recovery, geo-replication, point-in-time recovery, and failover strategies.
• Hands-on experience with major database upgrades, cross-platform migrations, and database consolidation.
• Experience supporting large-scale government and enterprise applications.

Additional Specialized Technical Experience

The following specialized capabilities may be required depending on the database environment and project assignment.

A. Oracle Database Administration

• Extensive experience with Oracle Database 12c/19c administration, maintenance, security, upgrades, patching, performance tuning, sizing, and capacity planning.
• Experience with Oracle E-Business Suite Applications R12.2 and Oracle Data Guard installation, configuration, maintenance, patching, upgrading, and cloning.
• Knowledge of Oracle WebLogic and Oracle Enterprise Manager (OEM) Grid Control.
• Experience migrating Oracle technologies from UNIX Solaris to Oracle Enterprise Linux or Red Hat Enterprise Linux.
• Expertise in Oracle Advanced Compression and database partitioning.
• Knowledge of data masking using Oracle patches and database scripts.
• Experience with performance tuning of Oracle E-Business Suite R12.2/19c in multi-node RAC environments.
• Strong knowledge of RMAN, Automatic Storage Management (ASM), Flash Recovery Area (FRA), and database backup and restoration strategies.
• Experience with Oracle E-Business Suite Release 12.2 logical host configuration and online patching.
• Strong knowledge of UNIX/Linux operating systems, utilities, and shell scripting.

B. Cloud Database Administration and DevOps

• Expertise in cloud database administration across Azure and AWS environments.
• Experience with Data Development, DevOps/DataOps, database operations, and data integration.
• Ability to implement database automation solutions using modern tools and technologies.
• Experience managing cloud database performance, availability, security, scalability, and operational reliability.
• Knowledge of cloud modernization and enterprise database migration strategies.

C. Data Warehouse and Oracle OBIEE

• Subject matter expertise in database design and architecture for enterprise data warehouses and data marts.
• Experience with Oracle Business Intelligence Enterprise Edition (OBIEE).
• Hands-on experience installing, configuring, maintaining, upgrading, and cloning database and application technology stacks.

D. Case Management and ERP Systems

• Experience designing and developing automated data distribution mechanisms.
• Knowledge of object-oriented analysis and design methodologies.
• Experience developing enterprise architecture deliverables, including technical models and documentation.
• Understanding of Ontario Government Enterprise Architecture processes and practices.
• Experience conducting impact analysis, implementation planning, and deployment of technology patches, maintenance packs, and releases.
• Experience with technical design, planning, implementation, database administration, and vendor support services.

General and Professional Skills

• Experience working with multiple operating systems and enterprise database technologies.
• Proficiency in programming languages and information retrieval tools.
• Strong understanding of query languages and database governance procedures.
• Experience monitoring and enforcing database standards, rules, and security policies.
• Knowledge of Incident, Change, and Configuration Management processes.
• Familiarity with network communications protocols and enterprise infrastructure.
• Strong analytical, troubleshooting, problem-solving, and decision-making abilities.
• Ability to work independently and collaboratively within multidisciplinary technical teams.
• Strong organizational skills and the ability to manage competing priorities and meet project deadlines.
• Awareness of emerging IT technologies, database trends, and industry best practices.