Job Title

Come make your difference in communities across Canada, where authenticity, trust and making connections is valued as we shape the future of Canadian retail, together. Our unique position as one of the country's largest employers, coupled with our commitment to positively impact the lives of all Canadians, provides our colleagues a range of opportunities and experiences to help Canadians Live Life Well. At Loblaw Companies Limited, we succeed through collaboration and commitment and set a high bar for ourselves and those around us. Whether you are just starting your career, re-entering the workforce, or looking for a new job, this is where you belong. Does working with some of Canadas most talented minds in innovation supporting retail, digital consumer solutions and analytical platforms excite you? Loblaw Technology powers some of Canadas most game-changing retail solutions, giving our customers the ability to live their lives well. Come work with a team that values diverse ideas, fosters a culture of inclusion and develops our talent from within. Loblaw Technology gives you the chance to excel, and helps you to strive for success in a big way. Keep reading to learn more! SRE II, DBA Location: 1 Presidents Choice Circle, Brampton, Ontario, L6Y 5S5 The SRE II, 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 Youll Do - 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+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. - Ability to automate to standard DBA tasks and develop scripts on UNIX platforms as required. - Demonstrate advanced skills in Oracle utilities AWR, ASH, ADDM and 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. - Communicates effectively with all levels of employees, both technical and non-technical. Establishes cooperative relationships with departments. 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 different methodologies 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 Oracle Multitenant (CDB/PDB), Golden Gate, Broker, and Fast-Start Failover. - Excellent experience in Oracle 12c, 18c and 19c database installations on Linux environment with hands-on experience in upgrading the Oracle databases on ExaCS in OCI cloud. - Experience with ZFS infrastructure, scaleup/down, replication, and administration. - Experience with SRE automation tools e.g., Terraform, Ansible, Gitlab and CI/CD pipeline etc. - 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 and user access controls, installation, and configuration of Oracle 12c/19c with RAC using ASM, configuring Oracle Data Guard, the creation of physical standby. - Excellent experience in OLTP/DSS database systems, implementing and managing of very large Oracle databases (VLDB) in data warehousing environments, experience in applying oracle database patches using opatch utility. - 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. Loblaw colleagues also enjoy: - Work Perks Program - On-site Fitness, Basketball & Volleyball courts, Ice Rink, Dry Cleaning services (1PCC Office) - Tuition Reimbursement & Online Learning - Pension & Benefits - Paid Vacation If youre up to the challenge, then we would love to hear from you. Apply today, and get the process started. Loblaw recognizes Canada's diversity as a source of national pride and strength. We have made it a priority to reflect our nations evolving diversity in the products we sell, the people we hire, and the culture we create in our organization. At Loblaw, we celebrate diversity and strive to build a culture of inclusion where differences are embraced, valued and supported. We are committed to being an equal opportunity employer and encourage people from all backgrounds and identities to apply to our jobs. 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. We are committed to creating accessible environments for our colleagues, candidates and customers. Requests for accommodation due to a disability can be made at any stage of application and employment. We encourage candidates 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. #EN #SS #LTnA #ON #J-18808-Ljbffr