Hybrid (This position will be required to follow the Bank’s Hybrid work policy (currently required a minimum of 10 days on-site per month) Services The Consultant will be responsible for providing the following Services to the Bank: Under the direction of the Assistant Director or Database and Middleware Services
Install, configure and maintain all supported database software (Oracle Database and Microsoft SQL Server) for High Availability 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.
Other related activities and deliverables, as required Required Qualifications & Skills The Consultant should have the following qualifications and skills:
A minimum of five (5) years demonstrated experience with Database Administration (as a DBA or similar role) with experience in the following: oOracle 19c and SQL Server 2019 or higher
Cloud SQL PaaS Services, specifically Azure
Oracle Exadata, Data Guard, RAC
Database Recovery Manager (RMAN) with backup/restore and point in time recovery.
Datapump tool for database/data migration
Concept of Oracle Advanced Security Transparent Data Encryption (TDE)
Monitoring database operations with EMCC (Oracle) and SCOM (Microsoft)oPostgres SQL The following will also be considered:
Demonstrated ability to organize effectively
Demonstrated experience with MySQL, Azure Cosmos DB
Demonstrated knowledge of Commvault
Any relevant designations/certifications (OCP, Azure, etc.)
