Senior Database Administrator to install, configure and maintain all supported Oracle Database and Microsoft SQL Server (DBMS) software for a High Availabi

Our valued crown corporation client is seeking a Senior Database Administrator to install, configure and maintain all supported Oracle Database and Microsoft SQL Server (DBMS) software for a High Availability (HA) environment!

Initial 1-year contract, with a strong chance of extension up to a maximum term of 3 years. Hybrid schedule of 10 days/month on-site in Ottawa, ON. 7.5 hours per day, Monday to Friday. On-Call and Overtime will be required as part of a regular rotational schedule.

As the successful candidate you will install, configure and maintain all supported DBMS software (Oracle Database and Microsoft SQL Server) and oversee resolution of various database-related technical issues within a High Availability environment.

Responsibilities:

• Install, configure and maintain all supported Oracle Database and Microsoft SQL Server (DBMS) software for High Availability (HA) 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.
• Collaborate with development Database Administrators (DBA’s) to coordinate database migration activities and disaster recovery testing and enhance disaster recovery procedures.
• Participate in the resolution of complex database issues by applying advanced level knowledge.
• Provide operational support to database administrators.

Must-have Skills

• 5+ years’ experience as a Database Administrator, with demonstrated experience working with Oracle 19c and SQL Server 2019 or higher
• Demonstrated experience working with Azure Cloud SQL PaaS Services
• Demonstrated experience working with Oracle Exadata, Oracle Data Guard, and Oracle RAC
• Demonstrated experience with datapump tool for database/data migration
• Demonstrated experience with Database Recovery Manager (RMAN) with backup/restore and point in time recovery.
• Experience with monitoring database operations with EMCC (Oracle) and SCOM (Microsoft)
• Demonstrated experience with Postgres SQL
• Demonstrated understanding of the concept of Oracle Advanced Security Transparent Data Encryption (TDE)

Nice-to-have Skills

• Demonstrated experience with MySQL, Azure Cosmos DB
• Demonstrated knowledge of Commvault
• Any relevant designations/certifications (OCP, Azure, etc.)