Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Posting language
- English
- Posted
Original job description
Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist
Location: Toronto, ON
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
The Oracle AWS Cloud DBA at Astra North Infoteck will design and tune Oracle databases, write and review PL/SQL code, and manage releases across environments. The role also plans and runs database migrations to AWS and supports production health, recovery and capacity.
Requirements
Candidates need 8 to 10 years of Oracle DBA experience, deep PL/SQL and performance tuning skills, and hands-on work with Amazon RDS, Aurora and PostgreSQL. A proven record of AWS database migrations and CI/CD for database deployments is required.
Skills
- Oracle Database administration
- PL/SQL programming
- SQL query tuning
- Execution plan analysis
- Index optimization
- AWR
- ASH
- ADDM
- Amazon RDS for Oracle
- Amazon RDS for PostgreSQL
- Amazon Aurora
- PostgreSQL administration
- Database schema design
- Data modeling
- Database release automation
- CI/CD for databases
- Schema migration
- Lock contention troubleshooting
- Deadlock resolution
- Failover testing
- Disaster recovery design
- Capacity planning
- Shell scripting (Bash)
Categories
- Technology
- Data & Analytics
- Software
Keywords
- Oracle DBA
- Oracle Database 19c
- Oracle 12c
- PL/SQL
- SQL tuning
- execution plans
- AWR
- ASH
- ADDM
- Amazon RDS
- Amazon Aurora
- AWS DMS
- AWS SCT
- PostgreSQL
- database migration
- cloud database
- CI/CD
- Agile
- disaster recovery
- Oracle Exadata
Seniority
Senior
Tools
- Oracle Database 12c/19c
- AWR
- ASH
- ADDM
- AWS DMS
- AWS SCT
- Amazon RDS
- Amazon Aurora
- PostgreSQL