Senior Database Administrator (Oracle Application DBA / Cloud)

Astra-North Infoteck Inc.

Toronto

On-site

CAD 110,000 - 160,000

Full time

12 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Astra-North Infoteck Inc. is seeking a Senior Oracle Application DBA to optimize and scale mission-critical database applications.

You will work with development and engineering teams to ensure high availability, fast SQL/PL-SQL performance, and smooth operations, while driving database modernization and cloud migration initiatives. Your role involves leading release automation, performance tuning, and coordinating migrations from on‑premises to AWS, with a focus on DR, failover, and capacity

Qualifications

  • 8+ years Oracle Database administration with advanced PL/SQL
  • Experience migrating on‑prem databases to AWS (DMS/SCT)
  • Strong diagnostic skills with AWR/ASH/ADDM
  • CI/CD integration for database deployments
  • Disaster recovery planning and failover experience

Responsibilities

  • Optimize SQL/PL-SQL performance and maintain high availability
  • Lead on‑premiseto‑AWS cloud migrations and testing
  • Collaborate with dev/engineering on data modeling and schema changes
  • Automate releases and schema migrations across environments
  • Monitor health, resolve deadlocks, and troubleshoot latency
  • Participate in capacity planning and DR drills

Skills

Oracle DBA
PL/SQL
Performance tuning
AWS cloud
Database migrations
CI/CD for DB
Scripting (Bash/Python)

Tools

AWS RDS/Aurora
PostgreSQL
CI/CD tooling

Job description

Senior Database Administrator (Oracle Application DBA / Cloud)

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 database modernization and cloud migration initiatives.

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Database Administrator (Oracle Application DBA / Cloud)
Senior Database Administrator (Oracle Application DBA / Cloud)

Astra-North Infoteck Inc. • Toronto

On-site
CAD 120,000 - 180,000
Senior Oracle Application Database Administrator
Senior Oracle Application Database Administrator

Epsilon Solutions Ltd. • Toronto

On-site
CAD 120,000 - 160,000
Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist
Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 120,000 - 160,000
Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist
Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 120,000 - 170,000
Senior Oracle DBA - Cloud & Migration Lead
Senior Oracle DBA - Cloud & Migration Lead

Astra-North Infoteck Inc. • Toronto

On-site
CAD 110,000 - 160,000
Database Administrator – Oracle, SQL Server, AWS RDS
Database Administrator – Oracle, SQL Server, AWS RDS

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 95,000 - 130,000
AWS Cloud RDS/Oracle DBA
AWS Cloud RDS/Oracle DBA

Astra-North Infoteck Inc. • Toronto

On-site
CAD 90,000 - 150,000
Database Administrator - Senior
Database Administrator - Senior

The Code Crackers Inc. • Toronto

On-site
CAD 90,000 - 130,000
Database Admin - Oracle, Postgressql
Database Admin - Oracle, Postgressql

Astra-North Infoteck Inc. • Toronto

On-site
CAD 90,000 - 120,000
Senior Oracle DBA & Cloud Migration Lead
Senior Oracle DBA & Cloud Migration Lead

Astra-North Infoteck Inc. • Toronto

On-site
CAD 120,000 - 180,000