Database Administrator

integrity, and resolving complex database issues. The ideal candidate has hands-on experience with Azure SQL and SQL Managed Instance, Oracle 19c and Exadata (RAC, Data Guard), PostgreSQL on Azure, RMAN, and database migrations. Experience with Oracle Autonomous Database, monitoring and backup tools, and relevant Azure or Oracle certifications is a strong asset.

*** Hybrid: required 12 days on-site per month in Ottawa ***

*** 12 month contract to start ***

*** Full Time contract, 37.5 hours a week ***



Advantages
•Hands-on work with advanced cloud and enterprise database technologies
•Opportunity to support and influence business-critical systems






Responsibilities
•Install, configure and maintain all supported database software (Oracle Database and Microsoft SQL Server) on prem and in Azure cloud-based High Availability environments
•Carry out database performance tuning and analysis
•Implement and review backup and recovery strategy to ensure that business service-level agreements are met
•Conduct database security administration to ensure that data is only available to authorized users
•Ensure data consistency by adhering to data model standards and best practices
•Maintain schema objects and perform production migrations
•Resolve database related technical issues
•Analyze and monitor system performance to identify major performance bottlenecks in the system and identify the impact of administration tasks on core business scenarios
•Participate in the resolution of complex database issues by applying advanced level knowledge
•Provide operational support to database administrators
•Other related activities and deliverables, as required

Qualifications
Required Qualifications & Skills

•A minimum of five (5) years demonstrated experience as a Database Administrator (as a DBA or similar role) with recent demonstrated experience in the following:
oMS Azure SQL and Azure SQL Managed Instance (MI) database and Oracle Exadata database deployed in Azure cloud environments
oOracle 19c and SQL Server 2019 or higher
oCloud SQL PaaS Services, specifically Azure
oOracle Cloud, specifically Oracle Exadata Database Service
oPostgreSQL on Azure
oOracle Exadata, Data Guard, RAC
oDatabase Recovery Manager (RMAN) with backup/restore and point in time recovery.
oData Pump tool for database/data migration
oConcept of Oracle Advanced Security Transparent Data Encryption (TDE)

Additional Qualifications

The following will also be considered:

•Demonstrated ability to organize effectively
•Demonstrated experience with Oracle Autonomous Database
•Demonstrated knowledge of Commvault
•Demonstrated knowledge of Dynatrace
•Any relevant designations/certifications (OCP, Azure, etc.) including:
oMicrosoft Certified: Azure Database Administrator Associate
oMicrosoft Certified: Azure Administrator Associate
oOracle cloud certifications

Summary
If you're interested in learning more please submit your résumé and one of our senior Recruiters would be happy to give you a call to discuss further.

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.

This posting is for existing and upcoming vacancies.