RQ09356 - Sr. Specialized IT Consultant

Source Code; Toronto; Hybrid; CAD 120,000 - 150,000; Part time

Job summary

Source Code is seeking a Sr. Specialized IT Consultant with deep Oracle expertise. The role focuses on administering large-scale Oracle databases using RAC, implementing Data Guard and GoldenGate replication, and applying CDC concepts to maintain data integrity across environments.

The candidate will optimize performance and ensure robust replication between on-premises and cloud-based databases, requiring strong SQL/PLSQL proficiency and hands-on experience with complex database architectures.

Qualifications

• Hands-on experience administering large-scale Oracle databases on RAC.
• Experience with Oracle Data Guard and Oracle GoldenGate for replication.
• Understanding of change data capture (CDC) concepts.
• Ability to optimize database performance and ensure data integrity.

Skills

Oracle RAC

Oracle Data Guard

Oracle GoldenGate

CDC concepts

SQL/PLSQL

Performance tuning

Job description

About the job RQ09356 - Sr. Specialized IT Consultant

RQ09356 - Sr. Specialized IT Consultant

5775 Yonge Street
Hyrbid

Contract

Must-Haves:

• Hands-on experience administering large-scale Oracle databases on RAC
• Hands-on experience with Oracle Data Guard and Oracle GoldenGate data replication, including setting up and configuring GoldenGate for data replication from on-premises databases to cloud environments.
• Understanding of change data capture (CDC) concepts and implementation.
• Ability to optimize database performance and ensure data integrity during replication processes.
• Proficiency in SQL and PL/SQL for Oracle databases.