- Company Name
- Loblaw Companies Limited
- Job Title
- Site Reliability Engineer II, DBA
- Job Description
-
**Job Title:** Site Reliability Engineer II, DBA
**Role Summary:**
Responsible for operating and enhancing the production database environment, ensuring high availability, performance, and reliability of cloud‑native solutions. Drives automation, collaborates with cross‑functional agile teams, and provides 24 × 7 on‑call support for Oracle Cloud Infrastructure (OCI) databases.
**Expectations:**
- Apply SRE principles to proactively improve system reliability and reduce manual effort.
- Deliver automation for routine DBA tasks and infrastructure provisioning.
- Maintain on‑call rotation and respond to incidents quickly and effectively.
- Communicate clearly with technical and non‑technical stakeholders.
**Key Responsibilities:**
- Design, implement, and support highly reliable Oracle database solutions in OCI.
- Optimize OCI resources for performance, scalability, and cost efficiency.
- Develop and maintain automation scripts (UNIX shell, Terraform, Ansible, GitLab CI/CD).
- Perform database monitoring, tuning, backup/recovery, and disaster‑recovery using OEM, AWR, ASH, ADDM, OSWatcher, RMAN, and Data Guard.
- Manage Oracle Multitenant (CDB/PDB), Exadata Cloud Service (ExaCS), RAC, and related technologies.
- Execute database migrations/upgrades (Data Pump, RMAN Transportable Tablespaces).
- Support enterprise‑level backup strategies and key management via OCI Vault.
- Provide performance analysis, resource allocation, and capacity planning for medium to large‑scale databases.
**Required Skills:**
- Deep expertise with Oracle 12c/18c/19c on Linux, ExaCS, and OCI.
- Strong command of Oracle utilities (AWR, ASH, ADDM, OEM/GRID Control, RMAN, opatch).
- Experience with Oracle Multitenant, RAC, Data Guard, GoldenGate, Broker, Fast‑Start Failover.
- Proficiency in scripting (UNIX shell) and infrastructure‑as‑code tools (Terraform, Ansible).
- Familiarity with CI/CD pipelines (GitLab) and automation frameworks.
- Knowledge of ZFS, replication, and scale‑up/down concepts.
- Understanding of PostgreSQL, MS SQL Server, and NoSQL databases (preferred).
- Ability to analyze performance metrics and implement tuning recommendations.
**Required Education & Certifications:**
- Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
- Preferred certifications: Oracle Certified Professional (OCP) – DBA, Oracle Cloud Infrastructure (OCI) certification, GoldenGate certification, OEM certification.