Senior Oracle Application Database Administrator

Epsilon Solutions Ltd.; Toronto; On-site; CAD 120,000 - 160,000; Full time

Job summary

Epsilon Solutions Ltd. in Toronto, Ontario, seeks an experienced Senior Oracle Application DBA to optimize, scale, and maintain mission-critical database applications. You will work with development teams to ensure high availability and performance.

You will lead migrations to AWS, tune PL/SQL, and guide capacity planning and disaster recovery initiatives while collaborating with engineering to modernize our database stack.

Qualifications

• 8+ years in Oracle Database with advanced PL/SQL and performance diagnostics (AWR/ASH/ADDM).
• Experience administering AWS RDS (Oracle/PostgreSQL) and Amazon Aurora.
• Hands-on PostgreSQL architecture and performance optimization.
• Experience migrating on-premises databases to AWS using DMS, SCT, or native tools.
• CI/CD integration for database deployments and collaboration with Agile teams.

Responsibilities

• Collaborate on data modeling and deployment of PL/SQL packages, procedures, triggers, views.
• Analyze execution plans and tune SQL queries; optimize indexes for high-throughput environments.
• Lead database release automation, code reviews, and schema migrations across environments.
• Monitor database health, resolve deadlocks, diagnose latency.
• Partner with infra and cloud teams to migrate on-prem databases to AWS.
• Participate in capacity planning, failover drills, and disaster recovery design.

Skills

Oracle DBA

Advanced PL/SQL

Performance Tuning

AWR/ASH/ADDM

AWS Cloud Databases

PostgreSQL

Cloud Migration

CI/CD for DB

Agile Collaboration

Tools

AWS DMS

SCT

Oracle RMAN

Job description

We are seeking an experienced Senior Oracle Application DBA to optimize, scale, and maintain mission-critical database applications. This role partners closely with development and engineering teams to ensure high availability, optimal SQL/PL-SQL performance, and smooth database operations, while helping drive our database modernization and cloud migration strategy.

Key Responsibilities

• 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.

Required Qualifications & Skills

• 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.

Nice-to-Have Qualifications

• 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.