Overview

SIMMS SR SQL DBA Full Time in Toronto, ON

SIMMS

Branch Toronto ON CA

Position:
SR SQL DBA
Location:
Toronto, ON

DBA:. We are a rapidly growing Canadian software company specializing in healthcare and are looking for a Sr SQL DBA….

We are a rapidly growing Canadian software company specializing in healthcare and are looking for a Sr SQL DBA

Main duties:

  • Ensure DB servers are functional and all information is backed up regularly
  • Quickly deploy restoration processes
  • Provide guidance on SQL server operations (stand-alone/clustered)
  • Support versions 05, 08,12 including DB engine & analysis services
  • Implement and execute regular maintenance plans
  • Monitor and ensure fail over mechanisms are available
  • Troubleshoot SQL service outages as they occur including after hours and weekends
  • Evaluate new hardware and software resources to upgrade services
  • Perform comparative analysis of DB options
  • Audit and identify transactions
  • Run DB queries and retrieve information in a systematic order
  • Perform logical and physical modelling for new DB or changes to existing ones
  • Service pack upgrades & hot fixes
  • Monitor environment for stability, performance, availability & recovery
  • Document all hosted environments, procedures and processes
  • Install and configure network components for DB access
  • Implement controls to protect DB and maintain high levels of information security
  • Contribute ideas for best practice improvements
  • Maintain professional knowledge by attending workshops, conferences and seminars, and subscribe/contribute to publications
  • Other duties as required

Candidates will

  • Have a bachelor’s degree in computer science or information systems
  • Microsoft Certifications
  • 5+ years with proven experience in DB management and application development with MS SQL Server
  • Experience in managing windows servers, managing applications, and troubleshooting/support
  • Be able to improve DB performance (indexing/partitioning/archiving)
  • Know how to deploy and support business tools (Internal email, ticketing system, phone system)
  • Have knowledge in cloud infrastructure environments, data warehousing and enterprise IT concepts
  • Possess the ability to prioritize, solve problems, and be detail oriented
  • Demonstrate initiative and organizational skills
  • Adhere to conduct and confidentiality policies
  • Work effectively with technical (QA/Programming) and customer support team
  • Oversee and advance knowledge of Jr System Administrator
  • Have excellent communication abilities
  • Bring a positive and enthusiastic attitude to work
  • Enjoy being a team player

We would like to thank all candidates for their interest in this opportunity, however we will only be able to respond directly to those candidates being selected for an interview.

Job Type: Full-time

Job Location:

  • Toronto, ON

Required education:

  • Diploma/Certificate

Required experience:

  • DBA: 5 years

or proceed with Standard Application Form.

Employment Type: Full Time
Location: Toronto, ON, CA
Posted on: 2016-09-27
Posted by: