Oracle Database Administrator

Toronto, ON, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Dec 3, 2026
Experience: 1 - 8-10 years of experience in Oracle Database Administration
Posting language: English
Posted: Nov 3, 2026

Original job description

Job title: Oracle Database Administrator

Location: Toronto, ON

Duration: Long Term Contract

Job Description:

2.Analyze execution plans| perform SQL query tuning| and optimize index structures to eliminate bottlenecks in high-throughput transactional environments.

3.Lead database release automation| code reviews| and schema migrations across development| staging| and production environments

4.Monitor database application health| identify lock contention| resolve deadlocks| and troubleshoot latency issues.

5.Partner with infrastructure and cloud teams to design| test| and execute on-premises to AWS cloud database migrations.

6.Participate in database capacity planning| failover drills| and disaster recovery design.

7.Support production deployment and other maintenance activities over weekend and after office hours on weekdays as needed.

Required Exp

1 - 8-10 years of experience in Oracle Database Administration

3.AWS Cloud Databases Practical experience administering managed database services including Amazon RDS (OraclePostgreSQL) and Amazon Aurora.

4.PostgreSQL Hands-on working knowledge of PostgreSQL architecture| schema design| and performance optimization.

5.Cloud Migration Experience Strong| proven track record of migrating on-premises databases to AWS environments (using tools such as AWS DMS| SCT| or native utilities).

6.Collaboration Release Management Solid background in CICD integration for database deployments and working alongside Agile engineering teams.

7.Ability to work with offshore teams for maintenance and production support activities

NICE TO HAVE skills

Experience with Oracle Exadata administration and performance tuning features (Smart Scan| Hybrid Columnar Compression).Proficiency in shell scripting (Bash) and automation using Python.Relevant AWS (e.g.| AWS Certified Database Specialty) or Oracle certifications

Apply About employer

More about this job

Responsibilities

Collaborate with application development teams on data modeling, schema design, PL/SQL development, database releases, and schema migrations. Monitor and tune database performance, support AWS migrations, and contribute to capacity planning, failover, disaster recovery, and production maintenance.

Requirements

Requires 8–10 years of Oracle Database Administration experience, including Oracle 12c/19c application support, advanced PL/SQL, and performance diagnostics using AWR, ASH, and ADDM. Candidates should also have practical AWS database and PostgreSQL experience, a proven record of on-premises-to-AWS migrations, CI/CD release management experience, and the ability to support offshore teams.

Skills

Oracle Database Administration
Oracle Application DBA
PL/SQL Programming
SQL Query Tuning
Execution Plan Analysis
Database Performance Diagnostics
Amazon RDS
Amazon Aurora
PostgreSQL
AWS Database Migration
Database Migration Service
Schema Conversion Tool
Database Release Automation
CI/CD
Disaster Recovery
Bash Scripting

Visa sponsorship

Not detected in the job text

Keywords

Oracle Database
Oracle 12c
Oracle 19c
Oracle Application DBA
PL/SQL
SQL Query Tuning
Execution Plans
AWR
ASH
ADDM
Amazon RDS
Amazon Aurora
PostgreSQL
AWS Schema Conversion Tool
AWS
Database Release Automation
CI/CD
Agile
Schema Design
Database Performance Optimization
Capacity Planning
Failover
Disaster Recovery
Oracle Exadata
Smart Scan
Hybrid Columnar Compression
Bash
Python

Report this job