Intermediate DBA (Oracle Golden Gate/SQL/Azure) - 95587-1

Our large banking client is looking for an Intermediate DBA with Oracle Golden Gate and Azure Cloud experience.

Duration: 6 months

Work location: Downtown Toronto (Financial District)

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. Hybrid work schedule with 1 day in office for the time being (Tuesdays).

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

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

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 bank's 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
• Experience with PostgreSQL - 2+ years
• 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 Skills:

• Strong nice to have MSSQL
• ServiceNow Ticketing System
• SolarWind Performance Tool
• Azure Certification
• FI experience