Job Description
Role: Senior Oracle DBA with AWS RDS & Redshift Toronto 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
- 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 man...