Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist
- 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
Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist
Work Arrangement: Hybrid (3 Days WFO)
Experience Required: 8–10 Years
Role Descriptions
- 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.
- Support production deployment and other maintenance activities over weekends and after office hours on weekdays, as needed.
Required Experience
- 8–10 years of experience in Oracle Database Administration.
- 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.
- 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
Administer and optimize Oracle and cloud databases, including PL/SQL development, query tuning, performance troubleshooting, and database release automation. Collaborate with application, infrastructure, and cloud teams to migrate on-premises databases to AWS and support capacity planning, disaster recovery, and production maintenance.
Requirements
Requires 8–10 years of Oracle Database Administration experience, including advanced PL/SQL, performance diagnostics, and hands-on administration of Amazon RDS, Amazon Aurora, and PostgreSQL. Candidates should have proven AWS database migration experience and familiarity with CI/CD database deployments and Agile teams; Exadata, Bash, Python, and relevant certifications are advantageous.
Skills
- Oracle Database Administration
- Oracle 12c/19c
- PL/SQL
- SQL Query Tuning
- Execution Plan Analysis
- AWR, ASH, And ADDM
- Amazon RDS
- Amazon Aurora
- PostgreSQL
- AWS Database Migration
- AWS DMS
- AWS SCT
- Database CI/CD
- Schema Migration
- Bash Scripting
- Python Automation
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
Keywords
- Oracle Database Administration
- Oracle 12c
- Oracle 19c
- PL/SQL
- SQL Query Tuning
- Execution Plans
- AWR
- ASH
- ADDM
- Amazon RDS
- Amazon Aurora
- PostgreSQL
- AWS
- AWS DMS
- AWS SCT
- Database Migration
- CI/CD
- Schema Design
- Schema Migration
- Agile
- Oracle Exadata
- Smart Scan
- Hybrid Columnar Compression
- Bash
- Python
- Disaster Recovery
- Capacity Planning
- Database Performance Optimization
- AWS Certified Database – Specialty
- Oracle Certifications