Job Specifications
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 he
About the Company
Our Purpose - Live Life Well
Loblaw Companies Limited is Canada's food and pharmacy leader, the nation's largest retailer, and the majority unit holder of Choice Properties Real Estate Investment Trust. Loblaw - and its portfolio of grocery, health and beauty, financial services and apparel businesses - provides Canadians with an unparalleled mix of value, assortment and convenience, and offers Canadians two of the country's most recognized brands - President's Choice and no name.
The acquisition of Shoppers Drug Mart, alo...
Know more