Senior Database Administrator

As a Senior Database Administrator, you will play a critical role in supporting large-scale modernization strategies and cloud migration initiatives. This position focuses on migrating products to the Azure Cloud platform while improving and maturing existing processes across IaaS and PaaS environments. You will be responsible for the maintenance, operation, and sustained growth of enterprise-level database platforms, ensuring high performance and security for both on-premises and cloud-based systems.

Pay Rate: $467.06- $504.13/Diem

Advantages
- Take a lead role in high-level Azure and Synapse modernization efforts.

- Work extensively with Azure Synapse, Data Lake, and Serverless environments.

- Utilize and expand your expertise in advanced SQL Server versions (2012–2019) across Windows and Linux.

- Provide operational guidance and leadership within a complex, enterprise-scale environment.

Responsibilities
- Support the migration of database products to the Azure Cloud platform, managing both IaaS and PaaS environments.

- Proactively monitor system activity daily using SQL Management Studio and respond to incidents or performance bottlenecks.

- Design, execute, and analyze database expansions, reorganizations, and data purging strategies.

- Architect and support all databases throughout the development and testing lifecycles.

- Lead long-range planning for database administration, including capacity statistics analysis and verification processes.

- Manage SQL Server builds and provide technical leadership to business representatives and stakeholders.

- Execute robust backup and recovery processes to ensure data integrity and business continuity.

- Perform deep-dive problem analysis and resolution for complex issues such as deadlocks and application recoveries.

- Implement cybersecurity vulnerability remediations and maintain SQL Server security architecture, including Transparent Data Encryption (TDE).

Qualifications
- 7–9 years of proven experience with SQL Server (both Azure and on-premises) across Windows and Linux.

- At least 5 years of experience managing Azure Synapse Analytics, including dedicated pools, Data Lake, and Serverless architectures.

- Strong experience with Azure Managed Instance and Azure SQL Database.

- Demonstrated ability to perform advanced performance tuning and analysis in Microsoft SQL environments.

- Must hold MS Azure Fundamentals (AZ-900), Azure Data Fundamentals (DP-900), and Administering Microsoft Azure SQL Solutions (DP-300).

- Deep understanding of SQL Server authentication, encryption, and backup/recovery within Azure subscriptions and resource groups.

- Proven ability to provide technical leadership, conduct impact analysis, and handle implementation planning for enterprise-level releases.

- Experience within the Public Sector and knowledge of Information Management principles and Ontario Government Enterprise Architecture processes.

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 accessibility@randstad.ca to ensure their ability to fully participate in the interview process.