Canada DBA Job


DBA Resources



Senior Database Architect - Totem Communications Group Inc.

More Database and SAP Jobs in Toronto, Ontario

Company Profile:

Totem Communications Group Inc. | A Transcontinental Company - Toronto, Ontario; We are North America's most dynamic custom media communications company; Past job postings: Senior Database Architect ; DBMS: SQL Server ; Current Career Opportunities .

Senior Database Architect

Requisition # 1555695
Job Location Canada-Ontario-Toronto
Additional Location Details Downtown Toronto
Job Stream Information Technology
Job Type Permanent, Full-Time
Number of Positions Open 1
Start Date of Employment ASAP
Posting Date 28-Jun-2011
Travel Required Not Required
Educational Requirements Bachelors Degree
Languages Required English
Job Description


Senior Database Architect



  • Innate sense of respect for peers and clients alike
  • Superb listening skills
  • Keen desire to learn from peers and clients
  • Well organized
  • Work efficiently in a project driven environment
  • Enjoys working with people and technology



  • Develop reusable ETL and supporting workflow processes to process our clients’ data
  • Focusing on replacing manual processes with operationally sound automated processes.
  • Work with team to establish best practices for development, testing, deployment of ETL processes primarily utilizing SQL Server’s SSIS
  • Work with both internal and external clients to interpret database aspects of project requirements to generate appropriate DB specific requirements, design and development.
  • Work with technology group to refine common elements of data processing system for reuse with existing and new clients


Technical Skills and Experience

  • Must have minimum of 5 years of  RDBMS (primarily SQL Server) experience including:
    • Intermediate DBA skills
    • Advanced T-SQL development skills
    • Advanced SSIS development skills
  • Must have SQL Server development support knowledge including:
    • development best practices
    • version control
    • configuration management and promotion processes
  • Must have min 3 years advanced data modeling:
    • Building and validating logical and physical models (experience with ERWin or other ER modeling tool)
  • Business Intelligence tool experience would be an asset:
    • Building of Datawarehose or Datamarts
    • Building OLAP cubes (nice to have)
    • Integration of BI Suite (e.g. Cognos, Databeacon, SQL Server OLAP Services, SAS/MDDB, etc)
  • Must have fundamental OS Skills:
    • Basic Windows 2k Server administration
    • UNIX/LINUX User
  • Other development skills:
    • Visual Basic (required)
    • VBScripting skills (required)
    • C (nice to have)
    • Java (nice to have)
    • Shell/Batch (nice to have)
  • Operations automation experience would be an asset:
    • Job scheduling
    • Workflow logging, monitoring and alerting
    • Data transfer automation  (e.g. automating FTP, HTTP, email)


  • University Bachelor degree or equivalent (preferably Computer Science, Engineering, or Math)
  • Any technical accreditations an asset

Last updated on August 22, 2011