Oracle DBA with AWS RDS

Oracle DBA with AWS RDS

Toronto, ON

Hybrid - 2 days per week in office

Skills:

Digital :
Python:

Digital :
Amazon Web Service(AWS) Cloud Computing:

Oracle DBA

Experience

Required:

6-8 Years

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.

• Strong hands-on with Oracle 19c, RAC, Data Guard, RMAN, ASM, OEM.
• Expert-level performance tuning (SQL & instance), AWR/ASH analysis, wait events.
• Provision and manage RDS instances/clusters (instance classes, storage autoscaling, Multi-AZ, parameter/subnet groups).
• Govern backup/restore (automated backups, snapshots), encryption (KMS), patching, and minor/major version upgrades.
• Implement monitoring/alerting via Cloud Watch, Performance Insights, Enhanced Monitoring; tune connections/queries.
• Cost management: right-sizing, storage management, Reserved/Compute Savings Plans advisory.
• Design and operate Redshift clusters; configure WLM, concurrency scaling, queue management.
• Optimize schema (distribution/sort keys), VACUUM/ANALYZE, query tuning; workload isolation.
• Build CI/CD pipelines (Code Pipeline/Git Hub Actions) to deploy CDK apps; manage environments (dev/qa/uat/prod).
• Implement high availability (Multi-AZ for RDS, cross-region snapshots as needed).

• 4–7+ years as a Oracle DBA with 3+ years on AWS data services.
• Hands-on with Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift administration.
• Expertise in monitoring (Cloud Watch, Performance Insights), performance tuning, and cost optimization.
• At least one certification in Oracle (OCP) and one in AWS.
• Proficiency with AWS CDK (Type Script or Python), Cloud Formation, and CI/CD pipelines.