86520-1 Database Administrator

Alliance Search Partners; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading company is seeking a DBA - Specialist with expertise in Oracle Golden Gate or SQL Azure for a six-month contract position. The role involves database management, performance optimization, and troubleshooting critical incidents. Candidates should have strong analytical and communication skills, working closely with technical teams to support various business lines.

Benefits

Close-knit team and great technical environment

Strong leadership support for career growth

Flexible work hours

Qualifications

• 5-7 years of experience in Oracle Golden Gate or Azure Cloud.
• Experience in Tuning, Query Optimization, Monitoring and Troubleshooting.
• Cloud migration experience required.

Responsibilities

• Taking ownership of and leading technical resolutions for production incidents.
• Communicating complex technical issues to stakeholders.
• Analyzing recurring incidents for service improvements.

Skills

Database Performance Tuning

Problem Solving

Communication

Critical Thinking

Tools

Oracle Golden Gate

SQL Azure

ServiceNow

SolarWind Performance Tool

Job description

Job DescriptionPosition Title: DBA - Specialist (Oracle Golden Gate or SQL Azure)
Request ID: 86520-1
Start/End Dates: 4/7/2025 - 10/6/2025
Work location: 81 Bay 16th Floor, Hybrid - in office every Tuesday for the time being.
Duration: 6 months
Job Title: IT - Database Administrator - Expert
Rate: $85.00 PH

Job level: L7
No. of Positions: 2
Line of Business: Capital Market, PBBT, and Retail Banking

Potential for this contract to be extended or converted to FTE: Possibility for both but depends on budget and performance

Work Schedule: Monday - Friday, 9:00 am – 5:00 pm. A little flexibility with work hours. 37.5hours/week. Overtime may be required; weekends may be required (on call) *1 person each week is on standby - this will be a rotating person each week.

Interview Process: maximum 2 rounds of technical interview possible with HM + team members; MS Teams and 2nd will be in person on a Tuesday. 2PM to 4PM ideally

Availability to Interview (date/time): flexible

Decisioning process: extending offer within a business day based on the Director's decision.

Reason the role is open: Backfill for a contractor who left to go home for personal reasons

Project the contractor will be working on: providing database support related to Oracle build, migration, performance tuning and incident resolutions.

Group information: 20 DBAs on the team, team is sub divided in 2 teams and support database for various lines of business, doing complex trouble shooting, code deployment, BAU activities

EVP (Employee Value Proposition): Close-knit team, great technical team to learn from. Very independent role where strong initiative is required in this role. Team consists of strong leadership that support career growth and providing mentorship throughout. This is a great opportunity to grow skills and learn. Core values of this team is teamwork, trust, and accountability. Lastly, conversion is very likely.

The Candidate will Be Working with: Solution Design, DB Engineering, Information Security teams and external vendors.

Daily Job Duties/Activities:
- Taking ownership of and leading technical resolutions for production incidents
- Communicating clearly complex technical issues to stakeholders and Lines of Business partners
- Complying with CIBC standards for change control and overall database security policies
- Analyzing recurring incidents and identifying service improvements where possible
- Providing on-call rotational/pager support where required
- Participating in Incidents and Changes as part of BAU Operational activities
- Participating in Scheduled Disaster Recovery or SCM activities
- Participating in post-mortems and RCAs (Root Cause Analysis) of critical incidents

Install, configure, and maintain Oracle and SQL Server databases.
Optimize database performance, including indexing, query tuning, and resource management.
Ensure database security by implementing best practices for user access control, encryption, and auditing.
Implement native security features in Oracle (TDE, Data Redaction, Database Vault) and SQL Server (TDE, Always Encrypted).
RAC, high availability (HA), and disaster recovery (DR) strategies.
Automate database monitoring and maintenance tasks.

Must Haves:
- 5-7 years of experience in Oracle Golden Gate or Azure Cloud database role
- Setup/Installation and configuration of DB products
- Experience in Tuning, Query Optimization, Monitoring and Troubleshooting database issues
- Cloud migration experience
- Exhibit knowledge of DB backup restore and recovery

Nice to have:
- **Strong nice to have PostgreSQL**
- **Strong nice to have MSSQL**
- ServiceNow Ticketing System
- SolarWind Performance Tool
- Azure Certification
- FI experience


Soft Skills:
- Strong critical thinking, problem solving and communication skills
- Demonstrated ability to work collaboratively in a team
- Demonstrated ability to deliver results and provide good customer experience
- Thrive in fast paced environment
- Good integrity