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.
