Senior database administrator to support a database migration initiative from on-prem sql / oracle environments to azure cloud

Our valued crown corporation client is seeking a Senior Database Administrator to support a database migration initiative from on-prem SQL / Oracle environments to Azure cloud!

Initial 1-year contract, with a strong chance of extension. Hybrid schedule of 12 days/month on-site in Ottawa, ON or Calgary, AB. 7.5 hours per day, Monday to Friday. On-Call and Overtime will be required as part of a regular rotational schedule. Selected candidate must have resided in Canada for the last 5+ years to be eligible to apply for security clearance.

As the successful candidate you will install, configure and maintain all supported database software (Oracle Database and Microsoft SQL Server) on prem and in Azure cloud-based High Availability environments

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
• Execute and support database migration initiatives from on-premises environments to:
• Azure SQL Database
• Azure SQL Managed Instance (MI)
• Oracle Database Services in Azure (including Oracle@Azure / Exadata)
• Design and implement cloud-native High Availability and Disaster Recovery solutions to ensure that business service-level agreements are met
• Implement automated deployment and configuration management using Infrastructure-as-Code (e.g., ARM templates, Terraform, Bicep)
• Develop and maintain automated backup, recovery, and monitoring solutions
• Perform advanced performance tuning and cost optimization in Azure environments
• Analyze and monitor system performance to identify major performance bottlenecks in the system and identify the impact of administration tasks on core business scenarios
• Implement and maintain database security controls including encryption (e.g., TDE) and role-based access control
• Provide advanced troubleshooting and technical support for complex cloud database environments
• Resolve database related technical issues
• Provide operational support to database administrators
• Document architecture, migration runbooks, and operational standards

Must-have Skills

• 5+ years of demonstrated enterprise Database Administrator experience
• 5+ years of demonstrated ability in leading and/or executing database migrations to Azure SQL Database, Azure SQL Managed Instance and/or Oracle Exadata database Service
• 5+ years of demonstrated experience administering Oracle workloads in Azure environments, including Oracle Exadata database Service (Oracle@Azure)
• 5+ years of hands-on experience with Oracle 19c and SQL Server 2019 (or newer)
• Demonstrated experience with Azure SQL PaaS Services
• Demonstrated experience with Oracle Exadata, Data Guard, RAC
• Demonstrated experience with Database Recovery Manager (RMAN), including backup/restore and point in time recovery
• Demonstrated recent experience with PostgreSQL on Azure
• Demonstrated recent experience using automation and scripting tools such as PowerShell, Bash, Terraform, ARM, Bicep, Azure CLI
• Demonstrated experience supporting mission-critical production systems in cloud or hybrid environments

Nice-to-have Skills

• Demonstrated knowledge of Commvault
• Demonstrated knowledge of Dynatrace
• Relevant professional certifications and designations, such as:
• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified: Azure Administrator Associate
• Oracle cloud certifications

Disclaimer

AI may be used in evaluating candidates.

This posting is for an existing vacancy. Apply