Job Information
US Tech Solutions Database Administrator in Ottawa, Ontario
$50-$55 per hour
Ottawa, ON
Contract
Duration: 12 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)
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
Other related activities and deliverables, as required
Required Skills:
University Degree or College Diploma in a related field
Minimum of five (5) years of demonstrated enterprise Database Administrator experience
Minimum of five (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
Minimum of five (5) years of demonstrated experience administering Oracle workloads in Azure environments, including Oracle Exadata database Service (Oracle@Azure)
Minimum of five (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
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 www.ustechsolutions.com (http://www.ustechsolutionsinc.com) .
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.