Senior SQL Server DBA

Senior SQL Server DBA

LTR4869

LeverageTek is actively seeking a Senior SQL Server DBA for a 6 month contract for an Ottawa based client.

Qualifications:

  • 5 - 7 years of experience in the following areas:
    • Working technical experience with designing, building, installing, configuring and supporting SQL database servers in a clustered environment
    • SQL Clustering
    • Database Partitioning
    • Database Mirroring
    • SQL Server Security
    • Hands-on database tuning, troubleshooting and monitoring experience
    • Always-On Availability Group
    • VM environment
  • Graduation from a recognized university or community college with an acceptable specialization in computer science or information systems; or equivalent combination of education, training and experience

Assets:

  • 5 - 7 years of experience in the following areas:
    • SQL Server 2014 and 2016
    • Azure SQL Database (PaaS)
    • SQL Server Data Warehouse
    • Quest PI or Redgate monitoring, diagnostic and alerting software
    • SharePoint 2013
    • Working with TFS
    • Microsoft SQL Servers Support (Monitoring and Maintaining)
    • Shell scripting (i.e. PowerShell)

Responsibilities:

  • Monitor production database process to ensure reliable and correct daily operation
  • Perform analysis and troubleshooting of processing errors and data inconsistencies and provide solutions
  • Respond to and resolve database access and performance issues
  • Peer review and implementation of planned changes into UAT and Production
  • Participate in weekly team meetings to provide a status report of work in progress, accomplished and problems / issues encountered
  • Other related duties from a support and project perspective

Security Clearance: Enhanced Reliability preferred

Duration: 6 months

Language: English