RQ09755 - Int. Database Administrator

Source Code; Toronto; Hybrid; CAD 120,000 - 160,000; Full time

Job summary

Source Code in Toronto is seeking an experienced International Database Administrator to lead Oracle DBMS design, tuning and operations. The role requires hands-on expertise with Oracle 12c/19c, RMAN backups, DataGuard and multi-tenant configurations, plus strong UNIX knowledge.

The candidate will implement capacity planning, migrations, performance improvements and enforce ITSM processes while collaborating with cross-functional teams.

Qualifications

• 10+ years Oracle DBA experience.
• Oracle 19c multi-tenant architecture knowledge.
• RMAN backup and restore proficiency.
• Oracle DataGuard configuration and administration.
• Experience with DB2 database technologies.
• Data conversion from DB2 to Oracle.

Responsibilities

• Create physical database designs and administer the DBMS, including optimization and capacity planning.
• Implement and maintain database installation, migration and performance tuning.
• Perform backups, recoveries and disaster recovery planning using RMAN and DataGuard.
• Monitor and enforce database rules and ITSM processes.
• Collaborate with teams to ensure data integrity and reliability.

Skills

Oracle DBA

SQL/PLSQL

Unix/Unix-like

Data warehousing

Analytical thinking

Team collaboration

ITSM processes

Education

Oracle certification - OCP

Tools

RMAN

Oracle DataGuard

Oracle GoldenGate

Oracle RAC

Oracle 19c

DB2

Job description

About the job RQ09755 - Int. Database Administrator

RQ09755 - Int. Database Administrator

Toronto (Jarvis St.)

Hybrid: 3 Days onsite / 2 days remote

- From October 20, 2025, the candidate is required to work onsite 4 days a week and 1 day from home

- From January 5, 2026, the candidate is required to work onsite 5 days a week fully

Security Level: CRJMC

Creates physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery

General Skills:

• Experience in database administration at the specified experience level
• Experience of managing Oracle 12c/19c ETL/Data warehouse Experience with UNIX operating system Experience with Oracle database technologies
• Experience in one or more programming language
• Experience in the use of information retrieval packages and proficiency with query language Experience with one or more communications protocol
• Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skill
• A team player with a track record for meeting deadline
• Experience in monitoring and enforcing database rule
• Experience in Incident, Change and Configuration Management procedures

Must Have:

• 10+ yrs Oracle DBA experience
• Approved experience of Oracle 19c using multi-tenant architecture
• RMAN backup and restore
• Oracle Dataguard Physical/Logical Configuration & Administration
• Oracle certification - OCP
• Oracle Advanced Compression
• Oracle Golden Gate Experience with distributed data system
• Experience with DB2 database technologies
• Data Conversion from DB2 to Oracle
• Building of Oracle RAC on conventional Solaris server
• Oracle Engineered solution
• Experience of DB web search service
• Oracle DB data integration and evaluation
• Experience with middleware and gateways
• Awareness of emerging IT trends and direction
• Experience with infrastructure services within the Ontario government (e.g. Internal Infrastructure Hosting policies and Provisioning practices)
• Knowledge of the GSIC support organization and ITSM processes adopted in OPS including