Oracle Database Administrator
- Toronto, ON, Canada
$60 to $65 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $60 to $65 CAD / hour
- Job type
- Contract
- Apply by
- Experience
- 8-10 years of experience in Oracle Database Administration
- Posting language
- English
- Posted
Original job description
Senior Oracle DBA
Toronto, ON - Hybrid (3 Days WFO)
Contract Duration - 12 months
Oracle Database (12c/19c+), AWS & Cloud Databases, Hands-on working knowledge of PostgreSQL architecture, Cloud Migration experience
Responsibilities:
- Collaborate with application development teams on data modeling| schema design| and deployment of complex PLSQL 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.
Required Skills and Experience:
- 8-10 years of experience in Oracle Database Administration
- Oracle Application DBA Expertise, 8 years specializing in Oracle Database (12c19c) application support| advanced PLSQL programming| execution plan analysis| and performance diagnostics (AWR| ASH| ADDM).
- AWS Cloud Databases Practical experience administering managed database services including Amazon RDS (OraclePostgreSQL) 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).
- CollaborationRelease Management Solid background in CICD integration for database deployments and working alongside Agile engineering teams.
- Ability to work with offshore teams for maintenance and production support activities
NICE TO HAVE :
- 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
Collaborate with application and infrastructure teams on database design, PL/SQL development, performance tuning, release automation, and production support. Lead database migrations from on-premises environments to AWS and contribute to capacity planning, failover testing, and disaster recovery.
Requirements
Requires 8–10 years of Oracle Database Administration experience, including Oracle 12c/19c application support, advanced PL/SQL, and performance diagnostics. Candidates should also have practical AWS managed database and PostgreSQL experience, a proven record of cloud migrations, and experience with CI/CD and Agile teams.
Skills
- Oracle Database Administration
- Oracle 12c/19c
- Oracle Application DBA
- PL/SQL
- SQL Performance Tuning
- Execution Plan Analysis
- AWR/ASH/ADDM
- Amazon RDS
- Amazon Aurora
- PostgreSQL
- AWS Database Migration
- AWS DMS
- AWS SCT
- Database Release Automation
- CI/CD
- Disaster Recovery
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
Keywords
- Oracle Database
- Oracle 12c
- Oracle 19c
- Oracle Application DBA
- PL/SQL
- SQL Tuning
- Execution Plans
- AWR
- ASH
- ADDM
- Amazon RDS
- Amazon Aurora
- PostgreSQL
- AWS
- AWS DMS
- AWS SCT
- Cloud Migration
- Database Schema Design
- Database Release Automation
- CI/CD
- Agile
- Oracle Exadata
- Smart Scan
- Hybrid Columnar Compression
- Bash
- Python
- Capacity Planning
- Disaster Recovery
- Failover Testing
- AWS Certified Database Specialty