Canadian Tire Corporation
The Canadian Tire suite of companies offers employees a wealth of challenging and rewarding career opportunities. We are a successful and growing company that values diversity and innovative thinking, and fosters a culture of performance and accountability. We invest in the growth and development of our employees by offering a wide range of career paths, comprehensive training and leadership development opportunities.
Join our talented team of over 50,000 employees and develop your career through our broad and diverse group of businesses which include, Canadian Tire Corporation, Canadian Tire Retail, Canadian Tire Associate Stores, Canadian Tire Petroleum, PartSource, Canadian Tire Financial Services, Forzani Group and Mark’s.
The Database Administration Services team within Enterprise Infrastructure Services (EIS) is responsible for providing the following database-related services to Canadian Tire Bank (CTB), Canadian Tire Retail (CTR), Forzani group/Marks (FGL):
24 x 7 rotational on-call support for production databases
Database technology planning, project support and consulting
IMS, DB2, Oracle, SQL Server, MySQL, Netezza, and MariaDB database design/ maintenance
Database disaster recovery planning and testing
Database security administration
All DBMS environments reside on Z/OS, Windows, Linux, AIX, ESX platforms.
DBA Role Responsibilities:
This role will support both Project work and Operational support activities:
Proactively manage the Oracle, SQL server, and Maria DB (MySQL) database environments to identify performance issues within the environment and assist in tuning, root cause analysis and remediation.
Perform upgrades and security patches to databases as required.
Assist application development with logical & physical database design considerations, database refreshes, cloning, and backups.
Perform database changes and code promotions according to CTC/FGL Change management processes and standards.
Document and communicate database changes.
Contribute to ongoing development of standards and best practices.
Provide service and support determined by the current Service Level Agreements; including 24 x 7 rotational on-call support for production databases.
Other duties as assigned.
Bachelor’s Degree with coursework in computing or information systems.
1-3 + years’ experience as an Oracle DBA (11g/12c), which includes Oracle installations and patching, database migrations and upgrades, troubleshooting and performance tuning, Oracle database replication (Data Guard), and experience with database backup and recovery (including RMAN).
1-3 + years’ experience as a SQL server DBA (SQL 2008, 2012, 2016) which includes replication (Always On).
Experience with AIX and Linux (RHEL)
Experience with windows 2008/2012, including failover clustering
Scripting in Windows PowerShell and Batch, UNIX/Linux shell and perl, SQL and T-SQL
Experience with Enterprise backup software for Oracle and SQL Server databases (IBM TDPO and TDPSQL)
Understanding of all phases of the application development lifecycle and project management disciplines, including Agile.
Must demonstrate proven ability to analyze problems, propose permanent solutions, and resolve/close issues using Oracle OEM and SQL Foglight diagnostic tools.
Candidate must work well in a fast-paced, changing environment and be able to multi-task, projects and initiatives.
Must be willing to take responsibility and be results oriented.
Excellent organization, teamwork, and communication (verbal and written) skills.
Ability to work well with people in all levels of the organization.
Canadian Tire is an equal opportunity employer. We are committed to a diverse and inclusive workplace for all. We recognize that our future success depends on the perspectives and contributions of all our employees — their diverse backgrounds, abilities and experiences make our business stronger. If you are contacted for a job opportunity, please advise us of any accommodations needed to ensure fair and equitable access throughout the recruitment and selection process. All accommodation information provided will be treated as confidential and used only for the purpose of providing an accessible candidate experience. FGL Corporate