job details
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!
