Talent.com

Dba Jobs in Markham, ON

Create a job alert for this search

Dba • markham on

Last updated: 18 days ago

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

Senior Database Administrator

BMO Financial GroupScarborough, ON
Temporary

BMO is an organization driven by a shared Purpose: Boldly Grow the Good in business and life.It calls on members of its team, to create lasting, positive change for its customers, its communities, ...Show more

Oracle DBA

E-SolutionsNorth York, ON
Full-time

Location: North York, ON (Hybrid).Install, configure, and upgrade Oracle databases and related tools.Perform database administration tasks including backup, recovery, and disaster recovery planning...Show more

Enterprise Database Architect DBA

Computer TalkMarkham, Ontario
Full-time

Enterprise Database Architect DBA.ComputerTalk is growing at a rapid rate and we are looking for exceptional talent to add to our team.The environment is dynamic, challenging, exciting, and rewardi...Show more

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
  • Quick Apply
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