Database Administrator Job Ottawa area,Ontario Canada,IT/Tech

Duration: months contract with possibility of extension

Job Description:

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)

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 (, 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 (, 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

Other related activities and deliverables, as required

Required Skills:

University Degree or College Diploma in a related field

Minimum of five () years of demonstrated enterprise Database Administrator experience

Minimum of five () 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

Minimum of five () years of hands-on experience with Oracle c and SQL Server (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 Postgre

SQL on Azure

Demonstrated recent experience using automation and scripting tools such as Power Shell, Bash, Terraform, ARM, Bicep, Azure CLI

Demonstrated experience supporting mission-critical production systems in cloud or hybrid environments

Desired

Skills:

Demonstrated ability to organize tasks efficiently

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

About US Tech Solutions:
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit .

US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.