Senior Database Administrator

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.