Senior Database Administrator to support and maintain Oracle Database and Microsoft SQL Server (DBMS) software for a financial enterprise client's High Availability (HA) environment!

Our valued financial 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) in Ottawa, ON! (Hybrid - Minimum of 5 days/month on-site)

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 a High Availability (HA) environment
• Upgrade existing databases and prepare patch management strategy database based on software vendor's recommendations as approved by the Bank
• Oversee resolution of database-related technical issues
• 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
• Oversee schema objects and perform production migrations
• Carry out database performance tuning and analysis
• 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 to coordinate database migration activities and disaster recovery testing, and enhance disaster recovery procedures
• Provide operational support for the middle tier environment

Must-have Skills

• 5+ years’ experience as a Database Administrator
• Demonstrated experience working with Oracle version 11g or higher
• 3+ years of demonstrated Database Recovery Manager (RMAN) experience with backup/restore and point in time recovery
• 3+ years of demonstrated experience with datapump tool for database/data migration
• Demonstrated understanding of the concept of Oracle Advanced Security Transparent Data Encryption (TDE)

Nice-to-have Skills

• Oracle Certified Professional (OCP) designation
• Demonstrated experience working with Oracle DB version 19c
• Demonstrated experience working with SQL Server 2008 or higher
• MS Certified Solutions Associate
• Microsoft Certified Azure Database Administrator
• Demonstrated knowledge of Oracle Exadata
• Demonstrated knowledge of DataGuard, RAC
• Demonstrated knowledge of GoldenGate
• Demonstrated MySQL Database Administrator experience