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 TechnologiesExtensive 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 AdministrationExperience 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 GovernanceHands-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 AutomationStrong 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 ModernizationExperience 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.
#J-18808-Ljbffr