Overview

SI Systems Intermediate DBA with SQL Server 2008R2, 2012, 2014 or 2016 Experience Contract in Edmonton, AB

SI Systems

Branch Edmonton AB CA

Position:
Intermediate DBA with SQL Server 2008R2, 2012, 2014 or 2016 Experience
Location:
Edmonton, AB

DBA. Albert based client is looking for an Intermediate DBA for a 12 month contract! Code, test and document related script modifications….

Our St. Albert based client is looking for an Intermediate DBA for a 12 month contract!

Description:

  • Code, test and document related script modifications.
  • Perform DBMS software installations, plan and test upgrades.
  • Plan, test and implement software patches and application updates or upgrades.
  • Disaster recovery preparation and testing.
  • Develop and maintain technical documentation.
  • Develop and automate system related procedures.
  • Perform problem diagnosis, troubleshooting and resolution.
  • Monitor on-going operations and perform on-going system administration tasks: release new versions; database tuning; capacity planning; historical archiving; database consistency and integrity checking; log file analysis; job scheduling; shell scripting; change control; and server requirements analysis.

Mandatory Requirements:
University graduation in computer science or a related discipline; OR two-year diploma in computer systems or a related discipline from a recognized post-secondary; OR a currently active professional certification or accreditation in a related discipline from a recognized issuing body

Demonstrated DBA experience within a large complex environment of similar size and complexity to our client

Demonstrated experience with SQL Server 2008R2, 2012, 2014 or 2016 in a database administrator role

Demonstrated experience with T-SQL

Demonstrated experience of setup best practices for Microsoft SQL Server as well as setting up and implementing database maintenance jobs either with the built in maintenance plans or with custom scripting

Nice to have requirements:
Demonstrated experience developing for OR administering: Microsoft SQL Server Reporting Services (SSRS) and/or Microsoft SQL Server Integration Services (SSIS) and/or Microsoft SQL Server Analysis Services (SSAS)

Demonstrated working experience with the following technologies: Windows Server 2012, 2012R2 and/or 2016, Active Directory including Kerberos, Windows Failover Clustering

Demonstrated working experience with the following SQL Server Technologies:

Log Shipping, Failover Clustered Instances, Availability Groups, Replication

Demonstrated working experience within the last 3 years with the following toolsets/processes:

Erwin Data Modelling Tool or another data modelling tool, Visual Studio Data Tools/Business Intelligence Development Studio, source control, Continuous Integration/Continuous Deployment/DevOps, Active Batch Scheduler, Hyper-V/VMware

Demonstrated working experience other database platforms such as:

Oracle and/or DB2 and/or Hadoop and/or MongoDB

Specialization and Skills:
DBA

MS SQL Server

5 – 7 years

Priority Requirements:
Do you meet all of the Mandatories as stated above, please explain
(Must-have)

Do you meet any of the “nice to have” skills as stated above, please specify which
(Nice-to-have)

or proceed with Standard Application Form.

Employment Type: Freelance
Location: Edmonton, AB, CA
Posted on: 2017-03-31
Posted by: