Site Reliability Engineer II, DBA
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 Canada’s most talented minds in innovation supporting retail, digital consumer solutions and analytical platforms excite you? Loblaw Technology powers some of Canada’s 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 You’ll 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 automation 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 (complexity defined by database size, technology, transaction velocity and volume, system feeds and interfaces) 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 you’re 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 nation’s 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.
Our commitment to Sustainability and Social Impact is an essential part of the way we do business, and we focus our attention on areas where we can have the greatest impact. Our approach to sustainability and social impact is based on three pillars – Environment, Sourcing and Community – and we are constantly looking for ways to demonstrate leadership in these important areas. Our CORE Values – Care, Ownership, Respect and Excellence – guide all our decision-making and come to life through our Blue Culture. We offer our colleagues progressive careers, comprehensive training, flexibility, and other competitive benefits – these are some of the many reasons why we are one of Canada’s Top Employers, Canada’s Best Diversity Employers, Canada’s Greenest Employers & Canada’s Top Employers for Young People.
If you are unsure whether your experience matches every requirement above, we encourage you to apply anyway. We are looking for varied perspectives which include diverse experiences that we can add to our team.
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 (which may be visible or invisible, temporary or permanent) 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