14 Nov
|
BuzzClan
|
Winnipeg
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. Solid 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 automat
📌 Senior Database Administrator (Winnipeg)
🏢 BuzzClan
📍 Winnipeg