Senior Oracle Application Database Administrator
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
Title: Senior Database Administrator
Location: Toronto, ON (Hybrid)
Terms: Full Time
Role Overview
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.
More about this job
Responsibilities
Optimize and maintain mission-critical Oracle application databases, including PL/SQL development, SQL tuning, release automation, schema migrations, and troubleshooting performance and availability issues. Collaborate with development, infrastructure, and cloud teams on AWS migrations, capacity planning, failover testing, and disaster recovery.
Requirements
Requires 8+ years of Oracle application DBA experience, including advanced PL/SQL, performance diagnostics, and Oracle Database support. Candidates should also have practical AWS managed database and PostgreSQL experience, a proven record of migrating databases to AWS, and familiarity with CI/CD and Agile teams.
Skills
- Oracle Database Administration
- PL/SQL Programming
- SQL Performance 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
- Database Release Management
- Disaster Recovery
- Bash And Python Automation
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Engineering
Keywords
- Oracle Database
- Oracle 12c
- Oracle 19c
- PL/SQL
- SQL Tuning
- Execution Plans
- AWR
- ASH
- ADDM
- Amazon RDS
- Amazon Aurora
- PostgreSQL
- AWS
- AWS DMS
- AWS SCT
- Cloud Migration
- Schema Design
- Data Modeling
- Database CI/CD
- Agile
- Database Release Automation
- Schema Migration
- Lock Contention
- Deadlock Troubleshooting
- Capacity Planning
- Failover
- Disaster Recovery
- Oracle Exadata
- Bash
- Python