Movojobs
Back to results

Added

Closed listing

Zodiac Solutions, Inc

Oracle Database Administrator

  • Toronto, ON, Canada

Full-time

This opening has closed.

The original listing is kept below for reference.

Find open jobsMore jobs with this employer
About employer

Job details

Job type
Full-time
Closing date
Experience
1. 8-10 years of experience in Oracle Database Administration
Posting language
English
Posted

Similar jobs hiring now

Search current openings

Original job description

Archived listing. The details below describe a past opening.

Job Title: Oracle DBA

Location: Toronto Hybrid

Job Type: Full-Time Permanent

Role and Responsibilities

  1. Collaborate with application development teams on data modeling, schema design, and deployment of complex PL/SQL packages, procedures, triggers, and views.
  1. Analyze execution plans, perform SQL query tuning, and optimize index structures to eliminate bottlenecks in high-throughput transactional environments.
  1. Lead database release automation, code reviews, and schema migrations across development, staging, and production environments.
  1. Monitor database application health, identify lock contention, resolve deadlocks, and troubleshoot latency issues.
  1. Partner with infrastructure and cloud teams to design, test, and execute on-premises to AWS cloud database migrations.
  1. Participate in database capacity planning, failover drills, and disaster recovery design.
  1. Support production deployment and other maintenance activities over weekend and “after office” hours on weekdays as needed.

“Mandatory” Skills:

  1. 8-10 years of experience in Oracle Database Administration
  1. Oracle Application DBA Expertise: 8+ years specializing in Oracle Database (12c/19c+) application support, advanced PL/SQL programming, execution plan analysis, and performance diagnostics (AWR, ASH, ADDM).
  1. AWS & Cloud Databases: Practical experience administering managed database services including Amazon RDS (Oracle/PostgreSQL) and Amazon Aurora.
  1. PostgreSQL: Hands-on working knowledge of PostgreSQL architecture, schema design, and performance optimization.
  1. 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).
  1. Collaboration & Release Management: Solid background in CI/CD integration for database deployments and working alongside Agile engineering teams.
  1. 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

Additional Comments:

Candidate needs to work from Client office – minimum 3 days per week.

About employer
More about this job

Responsibilities

Collaborate with application and infrastructure teams on database design, PL/SQL development, performance tuning, release automation, production support, and migrations from on-premises systems to AWS. Monitor database health, resolve performance and concurrency issues, and contribute to capacity planning, failover testing, and disaster recovery.

Requirements

Requires 8–10 years of Oracle database administration experience, including 8+ years supporting Oracle 12c/19c applications, advanced PL/SQL, and performance diagnostics. Candidates should have practical AWS managed database and PostgreSQL experience, a proven record of AWS migrations, database CI/CD and Agile collaboration experience, and the ability to support offshore teams and after-hours maintenance.

Skills

  • Oracle Database Administration
  • Oracle 12c/19c
  • PL/SQL
  • SQL Query Tuning
  • Execution Plan Analysis
  • AWR, ASH, and ADDM
  • Amazon RDS
  • Amazon Aurora
  • PostgreSQL
  • AWS Database Migration
  • AWS DMS and SCT
  • Database CI/CD
  • Schema Design
  • Database Performance Optimization
  • Disaster Recovery
  • Shell Scripting and Python Automation

Visa sponsorship

Not detected in the job text

Categories

  • Technology
  • Software
  • Data & Analytics

Keywords

  • Oracle Database Administration
  • Oracle 12c
  • Oracle 19c
  • PL/SQL
  • SQL Query Tuning
  • Execution Plans
  • AWR
  • ASH
  • ADDM
  • Amazon RDS
  • Amazon Aurora
  • PostgreSQL
  • AWS
  • AWS DMS
  • AWS SCT
  • Cloud Database Migration
  • Schema Design
  • Database Release Automation
  • CI/CD
  • Agile
  • Database Performance Diagnostics
  • Lock Contention
  • Deadlocks
  • Capacity Planning
  • Failover
  • Disaster Recovery
  • Oracle Exadata
  • Smart Scan
  • Hybrid Columnar Compression
  • Bash

Explore similar work

Report this job