Oracle Database Administrator
Ensure the reliability, performance, and security of mission-critical Oracle databases and AWS data services. Manage Amazon RDS and Redshift clusters using Infrastructure as Code with AWS CDK and implement CI/CD pipelines.
- On-site
- Toronto, ON
- Posted Aug 21, 2026
- Apply by Sep 20, 2026
- 1 position
More jobs you can apply to directly
Similar opportunities posted by employers hiring on Jobs.ca, with no external application form.
Forgeahead Solutions Corporation
Technical Lead and Senior Software Engineer
- On-site
BC Public Schools
Manager, People, Performance and Culture
- On-site
Alcohol and Gaming Commission of Ontario (AGCO)
Information Management Lead / Responsable de la gestion de l’information
- On-site
Job summary
Pay Rate: CAD 50-55/hr We are looking for an experienced Oracle DBA to ensure the reliability, performance, and security of mission-critical Oracle databases, along with an AWS-focused DBA to manage and optimize Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift clusters, with a strong focus on Infrastructure as Code using AWS CDK. Job Description: 1. Strong hands-on with Oracle 19c, RAC, Data Guard, RMAN, ASM, OEM. 2. Expert-level performance tuning (SQL & instance), AWR/ASH analysis, wait events. 3. Provision and manage RDS instances/clusters (instance classes, storage autoscaling, Multi-AZ, parameter/subnet groups). 4. Govern backup/restore (automated backups, snapshots), encryption (KMS), patching, and minor/major version upgrades. 5. Implement monitoring/alerting via CloudWatch, Performance Insights, Enhanced Monitoring; tune connections/queries. 6. Cost management: right-sizing, storage management, Reserved/Compute Savings Plans advisory. 7. Design and operate Redshift clusters; configure WLM, concurrency scaling, queue management. 8. Optimize schema (distribution/sort keys), VACUUM/ANALYZE, query tuning; workload isolation. 9. Build CI/CD pipelines (CodePipeline/GitHub Actions) to deploy CDK apps; manage environments (dev/qa/uat/prod). 10. Implement high availability (Multi-AZ for RDS, cross-region snapshots as needed). Qualifications (Required): 1. 4–7+ years as a Oracle DBA with 3+ years on AWS data services. 2. Hands-on with Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift administration. 3. Expertise in monitoring (CloudWatch, Performance Insights), performance tuning, and cost optimization. 4. At least one certification in Oracle (OCP) and one in AWS. 5. Proficiency with AWS CDK (TypeScript or Python), CloudFormation, and CI/CD pipelines.
What you’ll do
Ensure the reliability, performance, and security of mission-critical Oracle databases and AWS data services. Manage Amazon RDS and Redshift clusters using Infrastructure as Code with AWS CDK and implement CI/CD pipelines.
Requirements
Requires 4-7+ years of Oracle DBA experience with at least 3 years focusing on AWS data services. Must hold both Oracle (OCP) and AWS certifications and be proficient in AWS CDK and performance tuning.
Listed skills
- TypeScriptPreferred
- PythonPreferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Oracle 19c
- Oracle RAC
- Data Guard
- RMAN
- ASM
- OEM
- Amazon RDS
- Amazon Redshift
- AWS CDK
- Performance Tuning
- CloudWatch
- CI/CD Pipelines
- Infrastructure as Code
- TypeScript
- Python
- CloudFormation
Job areas
- Technology
- Data & Analytics
- Software
- Consulting
- Engineering
Additional details
- Minimum education
- Professional degree
- Minimum experience
- 5+ years
- Apply by
- Sep 20, 2026
- Posting language
- English
- Working hours
- 40 hours per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available