Posted 4 days ago
Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist
@ Astra North Infoteck Inc.
Toronto, Ontario
Overview
Astra North Infoteck Inc. is hiring a contract Oracle AWS Cloud DBA in Toronto, hybrid with 3 days a week in the office. The role covers Oracle application DBA work, PL/SQL and performance tuning, and on-premises to AWS database migrations involving Amazon RDS and Aurora. Candidates need 8 to 10 years of experience, and weekend and after-hours production support is expected.
Responsibilities:
- Design and tune Oracle databases and PL/SQL code
- Lead release automation and schema migrations
- Monitor database health and resolve performance issues
- Plan and execute on-premises to AWS migrations
- Support capacity planning and disaster recovery drills
Requirements summary:
- 8 to 10 years of Oracle Database administration
- Advanced PL/SQL and execution plan analysis
- Amazon RDS and Aurora administration experience
- Proven AWS database migration track record
- PostgreSQL working knowledge
- CI/CD integration for database deployments
Tools & skills
Source and dates
Source type not verified · zoho
- Employer posting date
- 2026-11-02
- First seen by our source
- 2026-11-03
- Source record updated
- 2026-11-03
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | IT |
| Experience | 8+ years |
| Schedule | evening, weekends |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Astra North Infoteck Inc.
| Field | Value |
|---|---|
| Open jobs on Jobsy | 426 |
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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.