Job Description

Position Type: Contract – Support & Maintenance Engagement

Location: Remote (Canada-based; occasional collaboration with client IT teams)

Duration: January 2026 – December 2027 (with option to renew)

Reports to: Technical Lead / Project Manager

Position Overview

The SQL Server Database Administrator (DBA) will oversee the integrity, performance, and reliability of enterprise database environments.

The DBA ensures continuous operation of Microsoft SQL Server 2016 instances, maintains replication between systems, and provides database-level support for application maintenance, reporting, and enhancement activities.

Key Responsibilities

Administer and optimize Microsoft SQL Server 2016 databases.
Maintain SQL Server Replication ensuring synchronized data flow between systems.
Perform database backups, restores, indexing, and integrity checks.
Monitor database health, storage, and performance; resolve locking, blocking, and bottlenecks.
Develop and maintain T-SQL scripts, stored procedures, triggers, and views.
Support SQL Server Reporting Services (SSRS) and Report Builder report creation.
Participate in contingency and disaster recovery planning.
Collaborate with system administrators and developers on deployments and schema updates.
Produce and maintain documentation including data dictionaries, change logs, and deployment scripts.
Ensure all activities comply with data security and privacy standards.

Required Skills and Experience

7+ years of experience as a SQL Server DBA, including SQL Server 2016.
Strong T-SQL development and optimization skills.
Experience configuring and troubleshooting SQL Server Replication and SQL Agent jobs.
Expertise in SSRS, Report Builder, and query performance tuning.
Understanding of .NET data access and integration with web applications.
Experience with backup/recovery, database patching, and version control.
Familiarity with Windows Server 2016 / IIS environments.
Strong documentation and analytical skills.

Preferred Assets

Microsoft Certified: SQL Server Database Administrator or Data Analyst Associate.
Experience in public-sector or large-scale enterprise environments.
Familiarity with Azure SQL or hybrid cloud reporting setups.
Understanding of data governance and compliance best practices.

Job Tags

Contract work, Remote work,

Similar Jobs

Randstad

fp&a - open to strategy consulting and non japanese candidates. Job at Randstad

... financial modeling and forecasting processes.Conduct insightful analyses of business performance and identify key drivers of success.Develop and implement strategies for improving financial performance.Present key financial insights an...

Larouche Raymond Headhunters

Magasinier entrepôt bâtiment (H/F) Job at Larouche Raymond Headhunters

SUIVEZ-NOUS POUR NOS AUTRES OFFRES D'EMPLOIS : Larouche Raymond Headhunters: Overview | LinkedIn Description de lentreprise En activit depuis plus de 75 ans , notre client est reconnu comme lun des entrepreneurs lectriciens les plus rputs au Qubec . Avec...

Sleep Number Corporation

Senior Financial Analyst - Supply Chain Operations Job at Sleep Number Corporation

...key member of Sleep Number's Corporate FP&A team, the Senior Financial Analyst provides financial leadership, decision support and influence... ...a hybrid work environment that supports a flexible blend of remote work and in-office collaboration at our corporate headquarters...

First Nations Education Steering Committee

Work from home | Speech-Language Pathologist (full time, permanent) Job at First Nations Education Steering Committee

...a lasting impact! An excellent work-life balance is waiting for you... ...weeks of vacation at Christmas time (with the latter being subject... ...~ The potential for work-from-home; ~ Career advancement opportunities... ...techniques. We offer full-time meaningful work in a professional...

People First HR Services

Chief Executive Officer - CLWR Job at People First HR Services

...with over 75 years of experience challenging injustice and responding to human suffering and poverty. CLWR works to create a world where people live in peace with hope, justice, dignity, and equality, empowered to achieve universal rights to a quality life. CLWRs work is...

SQL Server Database Administrator (DBA) Job at Idea Theorem™, Toronto, ON

Tk1ERUdOMnZJWmw2WXlXRHBHbG5wWnBRS0E9PQ==