Canada DBA Job


DBA Resources



Database Administrator - Rexall

More Database and SAP Jobs in Markham , Ontario

Company Profile:

Rexall - Markham , Ontario; The Rexall family of pharmacies are members of Katz Group Canada Ltd., Canada's largest and leading integrated retail pharmacy network. With more than 1,800 corporate, franchise, and independent pharmacies, Katz Group Canada comprises more pharmacies than any other retail pharmacy network in Canada; Past job postings: Database Administrator ; DBMS: SQL server; Career Opportunities .

Job Title: Database Administrator

City: Markham, Ontario

Posted Date: 15-Aug-2011


Katz Group Canada Ltd. is Canada's leading integrated retail pharmacy network encompassing more than 1,800 corporate, franchise and independent pharmacies. Katz Group Canada comprises more pharmacies than any other retail pharmacy network in Canada.  Pharmacy banners include Pharma Plus Drugmarts, Rexall Drug Stores, Medicine Shoppe Canada, Guardian, I.D.A. For more information on Katz Group Canada pharmacies visit

Job Purpose: 
To perform development, support, integration and project delivery on large, complex database application in a distributed environment. To maximize the availability, security, and performance of databases. To provide technical expertise to members of the development, QA and support teams. This role involves remote dial-in support in response to routine monitoring alerts and scheduled & unscheduled tasks occurring after hours and on weekends as required.

Principal Responsibilities: 

  • Manage database changes related to schema, procedures, views, functions, triggers
  • Collaborate with development team to review design changes and third party integrations
  • Closely work with production support team to resolve critical/complex database problems
  • Establish and maintain appropriate database access level based on corporate security standards
  • Manage database application for capacity, availability, performance, and data integrity
  • Install, configure and clone environments for development, testing and production
  • Apply release updates on all database environments
  • Write scripts and routines to automate day-to-day administrative tasks
  • Assist developers in writing and troubleshooting queries
  • Create and manage database backup/recovery procedures
  • Maintain up-to-date documentation on database schema, installation and maintenance
  • Report on weekly progress and production issues
  • Evaluate products/tools and recommend technical direction
  • Keep abreast of technology industry and market trends
  • Perform other duties as assigned to support Katz Group Canada Ltd.

Knowledge, skills and experience:

  • Bachelor’s degree in Computer Science or related field
  • Seven (7) or more years relevant work experience with RDBMS (SQL Server or Sybase) in distributed environment
  • Demonstrated knowledge of relational data modeling and database design
  • Strong T-SQL skills and ability to design complex routines and triggers
  • Advanced analytical, troubleshooting, debugging and diagnostic skills
  • Proven expertise in backup/recovery, security/encryption and indexing/performance tuning
  • Experience with ETL tools, database partitioning and replication
  • Experience with DOS scripting, XML and Web Services
  • Understanding of all aspects of Software Development Lifecycle
  • Strong sense of ownership and accountability
  • Strong written and verbal communication skills
  • Ability to work well independently under minimum supervision and in a team environment
  • Ability to effectively communicate and work collaboratively with interdepartmental teams
  • Ability to make decision and work well under pressure
  • Ability to manage multiple projects simultaneously
  • Ability to prioritize and escalate issues as needed
  • Experience with PCI DSS compliance an asset
  • Experience with datawarehouse reporting an asset

Internal candidates: submit your resume on-line and complete your Internal Candidate Application (ICA)

Backcheck note
Successful applicants may be required to complete a criminal record screening before commencing employment with Katz Group Canada Ltd., Additionally; Katz Group Canada Ltd. has the right to require any employee to consent to a criminal record check at any time during the course of employment with reasonable cause.



Last updated on September 12, 2011