AWS Cloud RDSOracle DBA

Astra North Infoteck Inc.

Job Location:

Toronto - Canada

Monthly Salary: K 10 - 10

Experience Required: 5years

Posted on: 5 hours ago

Vacancies: 1 Vacancy

Job Summary

Role:AWS Cloud RDS/Oracle DBA Position Type: Permanent Total Experience: 6-8 years

Role Description:

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.

Required Skill Sets:

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 CloudWatch 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 (CodePipeline/GitHub Actions) to deploy CDK apps; manage environments (dev/qa/uat/prod).

Implement high availability (Multi-AZ for RDS cross-region snapshots as needed).

47 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 (CloudWatch Performance Insights) performance tuning and cost optimization.

At least one certification in Oracle (OCP) and one in AWS.

Proficiency with AWS CDK (TypeScript or Python) CloudFormation and CI/CD pipelines.

ASM OEM.

Expert-level performance tuning (SQL instance) AWRASH analysis wait events.

Provision and manage RDS instances cluster (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 CloudWatch 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) VACUUMANALYZE query tuning workload isolation.

Build CICD pipelines (Code Pipeline GitHub Actions) to deploy CDK apps manage environments (devqauat prod).

Implement high availability (Multi-AZ for RDS cross-region snapshots as needed)."""

Required Skills:

Sailpoint

Role:AWS Cloud RDS/Oracle DBA Position Type: Permanent Total Experience: 6-8 yearsRole Description: 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 (Or...