emplois.ca
Retour à la recherche
LI
LanceSoft, Inc.Source d’offres vérifiée

Oracle Database Administrator

Offre en anglais

Ensure the reliability, performance, and security of mission-critical Oracle databases and AWS data services. Manage Amazon RDS and Redshift clusters using Infrastructure as Code with AWS CDK and implement CI/CD pipelines.

  • Sur place
  • Toronto, ON
  • Publié 21 août 2026
  • Postuler avant le 20 sept. 2026
  • 1 poste

D’autres postes auxquels postuler directement

Des possibilités semblables publiées par des employeurs qui recrutent sur Jobs.ca, sans formulaire externe.

Voir tous les postes à candidature simplifiée

Résumé du poste

Pay Rate: CAD 50-55/hr 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. 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.

Ce que vous ferez

Ensure the reliability, performance, and security of mission-critical Oracle databases and AWS data services. Manage Amazon RDS and Redshift clusters using Infrastructure as Code with AWS CDK and implement CI/CD pipelines.

Exigences

Requires 4-7+ years of Oracle DBA experience with at least 3 years focusing on AWS data services. Must hold both Oracle (OCP) and AWS certifications and be proficient in AWS CDK and performance tuning.

Compétences indiquées

  • TypeScriptSouhaitée
  • PythonSouhaitée

Autres compétences pertinentes

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

  • Oracle 19c
  • Oracle RAC
  • Data Guard
  • RMAN
  • ASM
  • OEM
  • Amazon RDS
  • Amazon Redshift
  • AWS CDK
  • Performance Tuning
  • CloudWatch
  • CI/CD Pipelines
  • Infrastructure as Code
  • TypeScript
  • Python
  • CloudFormation

Domaines d’emploi

  • Technology
  • Data & Analytics
  • Software
  • Consulting
  • Engineering

Renseignements supplémentaires

Formation minimale
Diplôme professionnel
Expérience minimale
5+ ans
Postuler avant le
20 sept. 2026
Langue de l’offre
anglais
Heures de travail
40 heures par semaine
Niveau d’expérience
Mid-Senior level
Mode de candidature
La candidature directe est offerte