Senior Oracle Database Administrator
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Position: Senior Oracle DBA
Location: Toronto, ON (3 days hybrid)
Contract: Long term (12+ months)
Role Descriptions:
1.Collaborate with application development teams on data modeling| schema design| and deployment of complex PLSQL packages| procedures| triggers| and views.
2.Analyze execution plans| perform SQL query tuning| and optimize index structures to eliminate bottlenecks in high-throughput transactional environments.
3.Lead database release automation| code reviews| and schema migrations across development| staging| and production environments 4.Monitor database application health| identify lock contention| resolve deadlocks| and troubleshoot latency issues.
5.Partner with infrastructure and cloud teams to design| test| and execute on-premises to AWS cloud database migrations.
6.Participate in database capacity planning| failover drills| and disaster recovery design.
7.Support production deployment and other maintenance activities over weekend and after office hours on weekdays as needed.
Required Exp
1 - 8-10 years of experience in Oracle Database Administration 2.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).
3.AWS Cloud Databases Practical experience administering managed database services including Amazon RDS (Oracle PostgreSQL) and Amazon Aurora.
4.PostgreSQL Hands-on working knowledge of PostgreSQL architecture| schema design| and performance optimization.
5.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).
6.Collaboration Release Management Solid background in CICD integration for database deployments and working alongside Agile engineering teams.
7.Ability to work with offshore teams for maintenance and production support activities
NICE TO HAVE skills
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 development teams on database design, PL/SQL development, performance tuning, release automation, and schema migrations across environments. Monitor production database health, support AWS migrations, and contribute to capacity planning, failover, disaster recovery, and after-hours maintenance.
Requirements
Requires 8–10 years of Oracle Database Administration experience, including Oracle 12c/19c application support, advanced PL/SQL, and performance diagnostics using AWR, ASH, and ADDM. Candidates should also have practical AWS managed database and PostgreSQL experience, proven on-premises-to-AWS migration experience, CI/CD and release management experience, and the ability to collaborate with offshore teams.
Skills
- Oracle Database Administration
- Oracle Application DBA
- PL/SQL Programming
- SQL Query Tuning
- Execution Plan Analysis
- Performance Diagnostics
- Amazon RDS
- Amazon Aurora
- PostgreSQL
- AWS Database Migration
- AWS DMS
- AWS Schema Conversion Tool
- CI/CD
- Database Release Management
- Disaster Recovery
- Shell Scripting
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 Query Tuning
- Execution Plans
- AWR
- ASH
- ADDM
- Amazon RDS
- Amazon Aurora
- PostgreSQL
- AWS
- AWS DMS
- AWS Schema Conversion Tool
- CI/CD
- Database Release Automation
- Schema Migration
- Data Modeling
- Schema Design
- Database Performance Optimization
- Capacity Planning
- Failover
- Disaster Recovery
- Oracle Exadata
- Smart Scan
- Hybrid Columnar Compression
- Bash