Canada DBA Job


DBA Resources



Database Analyst - Shoppers Drug Mart

More Database and SAP Jobs in Toronto, Ontario


Toronto, ON, CANADA
Posted Mar 24, 2011 1 Position(s)

Shoppers Drug Mart is one of the most recognized and trusted names in Canadian retailing. The Company is the licensor of full-service retail drug stores operating under the name Shoppers Drug Mart (Pharmaprix in Québec). With over 1,000 Shoppers Drug Mart and Pharmaprix stores operating in prime locations in each province and three territories, the Company is one of the most convenient retailers in Canada.

At Shoppers Drug Mart, we have always remained true to our belief that the root of our success lies with our people.  We pride ourselves on the quality and commitment of our employees who thrive on exciting challenges.  
Database Analyst


Reporting to the Application Support Manager, the Database Analyst is responsible to provide, under general supervision, technical and administrative support for the companys database infrastructure.  As well as supporting the day-to-day operation of the systems, this position will undertake projects and activities related to the design, selection, evaluation, and implementation of new applications and technology within the company under the supervision of more senior staff.


  • Provide timely support to ensure efficient and reliable operation of all corporate database infrastructures, including backups, break / fix support, patching, upgrading, database server tuning and replacement as required.
  • Support and monitor database performance and identify the need for adding, changing or removing indices, reorganization of indices and/or data, new or changed aggregates, new functionality, sql tuning, etc.
  • Maintain proper documentation and support internal IT processes. Documentation to include internal team support documents, database design standards published for developers and any other documents as needed.  Support SDM IT processes such as change management, incident management, problem management, time sheets including implement all changes, upgrades, etc. according to Company change control procedures. 
  • Act as a consultant to both application groups and other departments on the selection, evaluation, implementation and use of database related technology. 
  • Undertake projects related to the design, selection, acquisition, and implementation of database systems and tools
  • Maintain an up-to-date understanding of database technology and determine how advances in this technology can be utilized within Shoppers Drug Mart
  • Evaluate database and related software as directed, preparing reports and recommendations
  • Coordinate, lead and direct members from support teams within Production Services to ensure timely and successful implementation of projects and enhancements to production as they pertain to databases.


  • Minimum 4 years experience in an enterprise UNIX environment as a database analyst or administrator
  • Post-secondary education in business, information systems or related discipline
  • Working knowledge of database design and data modeling principles
  • UNIX scripting experience
  • Database analyst certification an asset (Oracle preferred with DB2 or SQL Server or Informix)
  • Previous experience with data warehouses/data marts and ETL tool experience an asset
  • Analytic, diagnostic and problem solving skills
  • Able to work with minimum supervision, taking ownership for the successful completion of work assignments
  • Detail oriented
  • Self motivated with a strong desire to improve personal skills and knowledge
  • Strong verbal and written skills

For internal applicants:

Please note, staff cannot be approached directly for the purpose of recruitment/interviews without prior knowledge of the Associate or Department Head.  A minimum of four (4) weeks notice must be provided unless otherwise agreed upon by the Associate or Department Head.

Please apply through this link:: Apply Here

Last updated on March 25, 2011