Movojobs
Back to results

Added

J&M Group

Oracle BBA With (AWS migration)

  • Toronto, ON, Canada

Full-time

Apply About employer

Applications open in a new tab.

Job details

Job type
Full-time
Apply by
Experience
8-10 years of experience in Oracle Database Administration
Posting language
English
Posted

Original job description

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

Mandatory Skills

  • 8-10 years of experience in Oracle Database Administration
  • 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).
  • AWS & Cloud Databases: Practical experience administering managed database services including Amazon RDS (Oracle/PostgreSQL) and Amazon Aurora.
  • PostgreSQL: Hands-on working knowledge of PostgreSQL architecture, schema design, and performance optimization.
  • 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).
  • Collaboration & Release Management: Solid background in CI/CD integration for database deployments and working alongside Agile engineering teams.
Apply About employer
More about this job

Responsibilities

Design and support Oracle database schemas and application components, tune SQL and database performance, and manage database releases and migrations across environments. Monitor production health, resolve database issues, and collaborate with infrastructure and cloud teams on AWS migrations, capacity planning, failover, and disaster recovery.

Requirements

Requires 8–10 years of Oracle Database Administration experience, including at least 8 years specializing in Oracle application support, advanced PL/SQL, and performance diagnostics. Candidates should also have practical experience with AWS managed databases, PostgreSQL, on-premises-to-AWS migrations, and CI/CD database release practices.

Skills

  • Oracle Database Administration
  • Oracle Application DBA
  • 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
  • AWS SCT
  • Database CI/CD
  • Schema Design
  • Performance Optimization

Visa sponsorship

Not detected in the job text

Categories

  • Technology
  • Software
  • Data & Analytics

Keywords

  • Oracle Database Administration
  • Oracle Application DBA
  • Oracle 12c
  • Oracle 19c
  • PL/SQL
  • SQL Query Tuning
  • Execution Plans
  • AWR
  • ASH
  • ADDM
  • Amazon RDS
  • Amazon Aurora
  • PostgreSQL
  • AWS
  • AWS DMS
  • AWS SCT
  • Database Migration
  • Schema Design
  • Database Release Automation
  • CI/CD
  • Agile
  • Performance Diagnostics
  • Index Optimization
  • Lock Contention
  • Deadlock Resolution
  • Capacity Planning
  • Failover Drills
  • Disaster Recovery
  • Production Support

Report this job