Talent.com
Oracle DBA - RAC, Data Guard, AWS RDS, Redshift
Oracle DBA - RAC, Data Guard, AWS RDS, RedshiftAstra North Infoteck Inc. • Scarborough, ON, ca
Oracle DBA - RAC, Data Guard, AWS RDS, Redshift

Oracle DBA - RAC, Data Guard, AWS RDS, Redshift

Astra North Infoteck Inc. • Scarborough, ON, ca
25 days ago
Job type
  • Full-time
Job description
Job Description
Detailed Job Description: 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.


Top 3 Required Skills:
1. Strong hands-on with Oracle 19c, RAC, Data Guard, RMAN, ASM, OEM.
2. Hands-on with Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift administration) 3. Provision and manage RDS instances/clusters (instance classes, storage autoscaling, Multi-AZ, parameter/subnet groups).

Top 3 Preferred Skills:
1. Oracle 19C, 26i
2. AWS RDS
3. Dataguard, RMAN, RAC


Requirements
Oracle DBA
Create a job alert for this search

Oracle DBA - RAC, Data Guard, AWS RDS, Redshift • Scarborough, ON, ca

Similar jobs

Oracle DBA / OCAC

BULL-IT SOLUTIONS LTDToronto, ON, CA
Full-time

Oracle 19c db version Candidate should have 3-5 years of experience working on OCAC ( Oracle Cloud At Customer) and Oracle Exadata including a full understanding of its architecture Candidate shoul...Show more

 • Promoted

Oracle EBS Admin(26-12836) - newmarket

Russell Tobinnewmarket, on, ca
Full-time

Russell Tobin & Associates is hiring on behalf of one of its esteemed clients.Location: Toronto, Ontario, Canada (Onsite).Duration: 11 Months (possible extension).Pay Rate: CAD $70-$80 per hour.Ora...Show more

 • Promoted • New!

Senior Oracle DBA: Exadata, RAC & Cloud (Contract)

BuzzClanToronto, ON, CA
Full-time

A leading IT consulting firm in Toronto is seeking a Senior Database Administrator with extensive experience in Oracle DB for a long-term contract.This role demands expertise in complex database ma...Show more

 • Promoted

Oracle DBA - RAC, Data Guard, AWS RDS, Redshift

Astra North Infoteck Inc.Scarborough, ON, ca
Full-time
Quick Apply

Detailed Job Description: 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 Amaz...Show more

IBM Security Access Manager (ISAM)/ Java/ Cloud Consultant - Q1 Technologies, Inc.

Q1 Technologies, Inc.toronto, on, ca
Full-time

Toronto, ON- 4 days a week ONSITE MUST.Strong experience implementing and supporting IBM Security Access Manager (ISAM), including:.WebSEAL configuration, junctions, ACLs, protected object space (P...Show more

 • Promoted

Senior DBA

Insight Globalrichmond hill, on, ca
Full-time

We are looking for a Senior DBA to join a top client in the technology and secure communications industry.They are currently taking on a project to migrate MS SQL from windows to Linux.REQUIRED SKI...Show more

 • Promoted • New!

Senior Oracle DBA for Cloud Architecture Solutions

BeaconsoftwareToronto, ON, CA
Full-time

Shape the future of cloud computing as a Senior Oracle DBA.Spearhead critical Oracle database management and cloud migrations to enhance operational efficiency in a fully remote role.In this strate...Show more

 • Promoted

Senior Oracle Db Engineer: Rac, Goldengate & Cdc

Source CodeToronto, Canada
Full-time

A tech consulting firm in Toronto is looking for a Sr.Specialized IT Consultant with deep expertise in Oracle databases and data replication.The ideal candidate will have hands-on experience with O...Show more

 • Promoted

Senior DBA - richmond hill

Insight Globalrichmond hill, on, ca
Full-time

We are looking for a Senior DBA to join a top client in the technology and secure communications industry.They are currently taking on a project to migrate MS SQL from windows to Linux.REQUIRED SKI...Show more

 • Promoted • New!

Senior AWS DBT Engineer

Mastech Digitalrichmond hill, on, ca
Full-time

We are seeking a Senior AWS DBT Engineer to play a critical role in transforming an existing analytics ecosystem into a modern, scalable Databricks + dbt architecture (Bronze → Silver → Gold).This ...Show more

 • Promoted

Oracle DBA: ZDLRA, RAC, Data Guard & DR Automation

Tata Consultancy ServicesToronto, ON, CA
Full-time

A leading IT services and consulting firm in Toronto is seeking a professional to manage and maintain the Oracle Zero Data Loss Recovery Appliance.The role involves setting up protection policies, ...Show more

 • Promoted

Remote Senior Oracle DBA for Federal Financials

CACI International Inc.Toronto, Ontario, Canada
Remote
Full-time

A leading technology company is seeking an experienced Senior Database Administrator to support the Department of Veterans Affairs.The ideal candidate will have over 10 years of experience with Ora...Show more

 • Promoted

Senior Oracle DB Engineer: RAC, GoldenGate & CDC

Source CodeToronto
Full-time

A tech consulting firm in Toronto is looking for a Sr.Specialized IT Consultant with deep expertise in Oracle databases and data replication.The ideal candidate will have hands-on experience with O...Show more

 • Promoted

IBM Security Access Manager (ISAM)/ Java/ Cloud Consultant - toronto

Q1 Technologies, Inc.toronto, on, ca
Full-time

Toronto, ON- 4 days a week ONSITE MUST.Strong experience implementing and supporting IBM Security Access Manager (ISAM), including:.WebSEAL configuration, junctions, ACLs, protected object space (P...Show more

 • Promoted

Oracle DBA

TEEMA Solutions GroupToronto, ON, CA
Temporary

Our client is seeking an experienced Oracle Database Administrator (DBA) to join their Data Center Engineering team as a Level 3 Site Reliability Engineer (SRE).This role is designed for a technica...Show more

 • Promoted

Senior Oracle Dba For Cloud Architecture Solutions

BeaconsoftwareToronto, Canada
Full-time

Shape the future of cloud computing as a Senior Oracle DBA.Spearhead critical Oracle database management and cloud migrations to enhance operational efficiency in a fully remote role.In this strate...Show more

 • Promoted

Oracle EBS Admin(26-12836) - richmond hill

Russell Tobinrichmond hill, on, ca
Full-time

Russell Tobin & Associates is hiring on behalf of one of its esteemed clients.Location: Toronto, Ontario, Canada (Onsite).Duration: 11 Months (possible extension).Pay Rate: CAD $70-$80 per hour.Ora...Show more

 • Promoted • New!

Oracle DBA - Canada

Saransh IncToronto, ON, CA
Full-time

Install, configure, and upgrade Oracle databases and related tools.Perform database administration tasks including backup, recovery, and disaster recovery planning.Monitor database performance and ...Show more