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
18 days ago
Job type
  • Full-time
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

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

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

CCaaS Consultant - richmond hill

Quality IT Resourcingrichmond hill, on, ca
Full-time

Engagement length 6 months; would be looking for someone to start asap.Lead the technical design and implementation of Amazon Connect call flows, routing, IVR/IVA, and integrations.Plan and execute...Show more

 • Promoted

SAS Developer

Affinitymarkham, on, ca
Temporary

Canada's Largest Agricultural Term Lender.Remote, Canada, hours flexible.On behalf of our client, Affinity is looking for SAS Developer to support a large enterprise data migration initiative.This ...Show more

 • Promoted

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

CCaaS Consultant

Quality IT Resourcingmarkham, on, ca
Full-time

Engagement length 6 months; would be looking for someone to start asap.Lead the technical design and implementation of Amazon Connect call flows, routing, IVR/IVA, and integrations.Plan and execute...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

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

Software Business Analyst - Alpha Bravo Development

Alpha Bravo Developmentrichmond hill, on, ca
Full-time

We’re a fast-growing software development agency that helps service-based businesses across the U.Our team values ownership, innovation, and building long-term partnerships with clients.We’re looki...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

Senior AWS DBT Engineer

Mastech Digitalmarkham, 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 - 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

 • Promoted

Contract Oracle DBA with Expertise in Azure and CI/CD

Millennium Software and Staffing IncToronto, ON, CA
Full-time

We're seeking an experienced Oracle Database Administrator for a challenging contract role.Bring your expertise in Azure, PL/SQL, and strong Linux/Unix knowledge to drive database performance.In th...Show more

 • Promoted

Remote Senior Oracle DBA for Federal Financials

CACI International Inc.Toronto, ON, CA
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