SRE II, Database Administrator

SRE II DBA – 1 Presidents Choice Circle, Brampton, Ontario.

The SRE Database Administrator will run the production environment by monitoring availability and taking a holistic view of system health. You will build tools and systems to manage platform infrastructure and applications; improve reliability, quality, and time‑to‑market of our suite of cloud‑native solutions; and measure and optimize system performance – all with an eye toward pushing our capabilities forward, getting ahead of customer needs, and innovating to continually improve.

What You’ll Do

• Design, build, and champion automated solutions to optimize application/service/platform uptime with minimal human intervention.
• Collaborate with diverse agile teams (i.e. Architects, Developers, Security, and other Operations engineers) on designing and implementing highly reliable solutions.
• Embrace Site Reliability Engineering principles of proactivity, automation, cross‑functional collaboration, fast‑and‑safe failing to continually improve our technology and culture.
• Optimize Oracle Cloud Infrastructure for maximum performance, scalability, and reliability. Provide rotating 24x7 on‑call support.
• Automate standard DBA tasks and develop scripts on UNIX platforms as required.
• Lead and contribute to the development of new methods, procedures, processes, or systems and understand the impact of these changes. Responsible for decisions impacting a team and may provide input into the decision‑making process for larger decisions.
• Design, architect, and plan database solutions to meet business needs using comprehensive business processes, application design, and functional knowledge.
• Demonstrate advanced skills in Oracle utilities (AWR, ASH, ADDM, OSWatcher); strong knowledge of OEM management and administration; proficient in problem diagnosis, shell scripting, performance monitoring, tuning, database backup and recovery.
• Support multiple servers and databases of medium to high complexity with multiple concurrent users, ensuring control, integrity, and accessibility of the data.
• Monitor and analyze performance metrics and allocate database resources to achieve optimum database performance.
• Perform switchover, fail‑over testing and demonstrate expert level knowledge of networks, storage, encryption, security, cloud and backup and recovery technologies. Troubleshoot and remediate performance and capacity issues.
• Communicate effectively with all levels of employees, both technical and non‑technical, and establish cooperative relationships with departments.
• Monitor resource utilization and Oracle Compute Unit (OCPU) enablement. Hands‑on experience with Oracle ExaCS in OCI Cloud, managing and creating resources using the cloud dashboard, creating and managing Oracle SR and supporting the team in issue resolution.

What you Bring

• Passionate about ExaCS, Infrastructure as Code, cloud provisioning, automation, and developing solutions that help developers move quickly and safely.
• Strong experience in ExaCS administration, Cloud Service (OCI‑C), patch install and cell node administration.
• Hands‑on with Oracle Database migration/upgrade using Data Pump & RMAN Transportable Tablespaces.
• Experience with database and key‑management tools such as OCI Vault, OEM/GRID Control.
• Experience with enterprise‑level backup & recovery and RMAN.
• Experience with Golden Gate, Broker, and Fast‑Start Failover.
• Excellent experience in Oracle 12c, 18c, and 19c database installations on Linux environments with hands‑on experience in upgrading Oracle databases on ExaCS in OCI cloud.
• Experience with Oracle Multitenant (CDB/PDB).
• Experience with ZFS infrastructure, scale‑up/down, replication, and administration.
• Experience with SRE automation tools (e.g., Terraform, Ansible, GitLab and CI/CD pipeline).
• Knowledge of PostgreSQL, MS SQL Server, and No‑SQL database preferred.
• Experience with Data Guard, creation of physical standby and resolving the physical standby database gap.
• Working knowledge in Oracle RAC database technology, user access controls, installation and configuration of Oracle 12c/19c with RAC using ASM, and configuring Oracle Data Guard.
• Excellent experience in OLTP/DSS database systems, implementing and managing very large Oracle databases (VLDB) in data warehousing environments, and applying Oracle database patches using the opatch utility.
• Excellent experience in migration of databases across various operating systems from Non‑ASM to ASM.
• Nice to have: certification in Goldengate, OEM, OCP DBA and Oracle Cloud (OCP).

What Loblaw Offers You

We offer flexibility and balance, and an environment that sets you up for success no matter where your workspace is located.

Here, you will find a great team to help you achieve your goals as you help us achieve ours! Work in our fast‑paced, exciting Technology environment, helping our stores, colleagues and customers every day.

We are committed to being an equal‑opportunity employer and encourage people from all backgrounds and identities to apply. Accommodation in the recruitment, assessment, and hiring process is available upon request for applicants with disabilities.

We thank all candidates for their interest but please note, those candidates who meet the minimum requirements for the position will be contacted.

We have a long‑standing focus on diversity, equity and inclusion because we know it will make our company a better place to work and shop. Requests for accommodation due to a disability can be made at any stage of application and employment; we encourage applicants to make their accommodation needs known so that we can provide equitable opportunities.

Please note: Candidates who are 18 years or older are required to complete a criminal background check. Details will be provided through the application process.

#J-18808-Ljbffr