Senior Database Administrator

We are seeking a highly accomplished Senior Database Administrator for an enterprise-level contract opportunity based in Toronto. In this role, you will take on a premier database architecture, operational sustainment, and hybrid cloud data administration capacity, specializing in physical database design, cross-platform migrations, performance tuning, and high-availability operations.

Operating fully onsite in Toronto, you will bridge the gap between legacy on-premises systems and modern cloud architectures. You will manage diverse database platforms including Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2, while supporting structured and unstructured cloud data solutions across Microsoft Azure and AWS (such as Azure SQL Managed Instance, Azure Cosmos DB, Azure Blob Storage, and Amazon RDS). This position demands an enterprise data authority with deep expertise in performance optimization, automated backup and recovery architectures, robust cyber security remediations, and high-volume data modeling who can ensure high availability, integrity, and compliance across mission-critical systems.

Location: Toronto, ON

Assignment Type: Onsite (5 days per week)

Contract Duration: 11-month contract (with potential for extension)

Advantages
Multi-Platform DBMS Breadth: Administer Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2 across on-premises and cloud platforms.

Hybrid Cloud Architecture: Build and manage cloud database solutions across Azure SQL MI, Cosmos DB, Azure Blob, and Amazon RDS.

High-Impact Modernization: Lead major cross-platform database migrations, version upgrades, and data consolidation initiatives.

Advanced Security & Resilience: Implement end-to-end data protection, including TDE, data masking, RBAC, and geo-replication failover drills.

Responsibilities
Design, configure, and maintain physical database schemas, data structures, and storage layouts across enterprise platforms.

Administer, monitor, and optimize diverse database management systems (DBMS) including Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2.

Manage cloud-hosted and hybrid database environments across Azure and AWS, including Azure SQL Managed Instance, Azure Cosmos DB, Azure Blob Storage, and Amazon RDS alongside legacy on-premises servers.

Conduct advanced database performance tuning, indexing strategies, query optimization, capacity planning, and resource utilization monitoring.

Formulate, test, and execute robust enterprise backup, recovery, and business continuity plans, utilizing tools such as Oracle RMAN, Flash Recovery Area (FRA), and point-in-time recovery.

Lead database upgrades, patch management, maintenance pack rollouts, and complex cross-platform database migrations.

Support enterprise high-availability and disaster recovery architectures, including Oracle Data Guard, multi-node Real Application Clusters (RAC), and geo-replication.

Implement rigorous database security controls, including Transparent Data Encryption (TDE), data masking, row-level security (RLS), and Role-Based Access Control (RBAC).

Research and implement cyber security vulnerability remediations, audit controls, and database compliance standards.

Develop and maintain automated operational and administrative scripts utilizing SQL, PL/SQL, T-SQL, PowerShell, Bash, and Python.

Support data integration and distribution workflows connecting on-premises databases to cloud services via REST APIs, MuleSoft, and integration gateways.

Manage Incident, Change, and Configuration Management processes in alignment with enterprise IT service standards.

Collaborate with enterprise architects, application developers, and infrastructure engineers across Java, Microsoft .NET, and cloud platform workstreams.

Maintain comprehensive technical documentation, architecture designs, runbooks, and disaster recovery execution procedures.

Qualifications
Core Technical & Database Administration Requirements
DBMS Platforms: Extensive hands-on experience administering major relational database management systems, including Oracle (12c/19c) and Microsoft SQL Server, with proficiency in PostgreSQL, MySQL, or IBM DB2.

Cloud & Hybrid Data: Proven track record managing cloud and hybrid database solutions across Microsoft Azure or AWS, including Azure SQL Managed Instance, Azure Cosmos DB, Azure Blob Storage, or Amazon RDS.

Database Operations & Tuning: Deep expertise in physical database design, capacity planning, query optimization, performance diagnostics, and automated maintenance routines.

Backup, High Availability & Disaster Recovery: Demonstrated experience architecting and testing enterprise backup and recovery routines (e.g., RMAN, ASM), replication, failover drills, and high availability (e.g., Oracle RAC, Data Guard).

Scripting & Query Languages: Advanced proficiency in SQL, PL/SQL, T-SQL, and scripting languages (Bash, PowerShell, Python) for operational automation and stored procedure maintenance.

Security & Governance: Solid experience implementing Role-Based Access Control (RBAC), data masking, Transparent Data Encryption (TDE), and security vulnerability remediations.

Migrations & Upgrades: Proven background leading major database version upgrades, platform consolidations, and complex data migrations with minimal downtime.

Preferred Technical Assets & Capabilities
Data Integration & Architecture: Experience with data modeling, enterprise data warehousing (such as Oracle OBIEE/data marts), and integration platforms like MuleSoft.

Enterprise Application Suites: Familiarity with Oracle E-Business Suite R12.2 maintenance, OEM Grid Control, WebLogic, or Microsoft Dynamics 365.

Modern Development Ecosystems: Practical understanding of CI/CD, DevOps/DataOps principles, and collaboration within Agile delivery frameworks (Kanban/Scrum).

Soft Skills & Delivery Attributes
Analytical Problem Solving: Superior diagnostic and root-cause analysis skills to resolve critical database bottlenecks, deadlocks, and system outages.

Communication & Documentation: Excellent verbal and written communication skills with the ability to convey complex technical architectures clearly and author comprehensive operational documentation.

Customer Service & Collaboration: Strong interpersonal skills to collaborate effectively with cross-functional technical teams, solution architects, and external vendors under tight deadlines.

Summary
If you're interested in the "Senior Database Administrator" role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [email protected] to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies.