Database Administrator

QA Consultants; Ottawa; On-site; CAD 80,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled Database Administrator to enhance their database management capabilities in the Banking sector. In this pivotal role, you will be responsible for installing, configuring, and maintaining Oracle and SQL Server databases, ensuring high availability and performance tuning. Your expertise in cloud SQL services and database recovery strategies will be crucial in meeting business service-level agreements. Join a dynamic team where your contributions will directly impact the efficiency and security of critical banking operations. This is an exciting opportunity to leverage your technical skills in a fast-paced environment and make a significant difference.

Qualifications

• 5+ years experience in Database Administration with Oracle and SQL Server.
• Strong knowledge of Cloud SQL PaaS Services and database recovery strategies.

Responsibilities

• Install and maintain Oracle and SQL Server databases for High Availability.
• Conduct performance tuning and implement backup strategies.

Skills

Database Administration

Oracle 19c

SQL Server 2019

Cloud SQL PaaS Services

Oracle Exadata

Data Guard

RAC

Database Recovery Manager (RMAN)

Transparent Data Encryption (TDE)

Monitoring with EMCC and SCOM

MySQL

Azure Cosmos DB

Commvault

Job description

Database Administrator

Duration: 1 year

We are hiring for an experienced Database Administrator for our client in the Banking sector.

Must Haves:

• 5 years demonstrated experience with Database Administration (as a DBA or similar role) with experience in the following: Oracle 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.
• Concept of Oracle Advanced Security Transparent Data Encryption (TDE)
• Monitoring database operations with EMCC (Oracle) and SCOM (Microsoft)
• Demonstrated experience with MySQL, Azure Cosmos DB
• Demonstrated knowledge of Commvault

Responsibilities:

• 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.