Job: Database Administrator level 3

Title Database Administrator level 3
Categories Contract
Start Date 2017-10-02
End Date 2018-10-01
Location Toronto, Ontario
Job Information

DBA Skills

  • 10+ years of experience in database administration, maintenance, optimization and fine tuning of databases
  • 3-5 years of experience with creating data flow diagrams, entity relationship modeling and techniques
  • 5+ years of experience in database development using SQL, SQL Plus, Stored Procedures, transitional databases
  • Experienced with Extract, Load and Transform (ETL) processes and technologies
  • Working knowledge of MS SQL Server 2005, 2008 and 2012 maintenance, setup, configuration, deployment, troubleshooting
  • Experience with building, troubleshooting and maintaining SQL query scripts
  • Experience with deployment and maintenance of distributed data warehouse environments and associated reporting tools

Technical Skills

  • Experience in the use of information retrieval packages and working knowledge of query languages
  • Experience in monitoring and enforcing database rules
  • Experience in Incident, Change and Configuration Management procedures
  • Working knowledge of Cognos and Crystal Reports reporting tools
  • Experience with Enterprise Content Management
  • Experience with Business Intelligence (BI) tools and methodologies

Theory and Principles

  • Working knowledge of database normalization theory, STAR schema theory; data warehouse principles and cubes design
  • Working knowledge of information security principles, techniques and tools

General Skills

  • Proven and demonstrable troubleshooting and analytical skills
  • Able to understand impact of work from a business perspective
  • Strong verbal and written communication skills
  • Strong Interpersonal and negotiation skills
  • Strong consulting skills to engage with all stakeholders
  • A demonstrated team player with a track record for meeting deadline
  • Government experience an asset

 

Apply Now