Current jobs related to SQL Server Database Administrator - Toronto - Idea Theorem™

  • SQL Server Database Administrator Specialist

    3 days ago

    Toronto, Canada RBC Full time

    SQL Server Database Administrator Specialist Join to apply for the SQL Server Database Administrator Specialist role at RBC What is the opportunity? RBC is looking for an experienced SQL Server DBA specialist with a minimum of 10+ years of working experience. The role requires providing application DBA support and services while also leading initiatives...

  • SQL Server Database Administrator Specialist

    3 days ago

    Toronto, Canada RBC Full time

    SQL Server Database Administrator Specialist Join to apply for the SQL Server Database Administrator Specialist role at RBC What is the opportunity? RBC is looking for an experienced SQL Server DBA specialist with a minimum of 10+ years of working experience. The role requires providing application DBA support and services while also leading initiatives...

  • SQL Database Administrator

    2 weeks ago

    Toronto, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...

  • SQL Server Database Administrator Specialist

    6 days ago

    Toronto, Canada Royal Bank of Canada Full time

    **Job Summary** **What is the opportunity?** **This is an exciting position working with SQL server as leading initiatives in the group as well working with the databases in cloud.** **We are looking for someone within local Toronto area as this is Hybrid working from office position.** **What will you do?** - Lead in the support of database and...

  • SQL Server Database Administrator Specialist

    1 week ago

    Toronto, Canada Royal Bank of Canada Full time

    **What is the opportunity?** **This is an exciting position working with SQL server as leading initiatives in the group as well working with the databases in cloud.** **What will you do?** - Lead in the support of database and transaction management technology and it’s deployment and usage standards. - Provide leadership in ensuring all database and...

  • SQL Server Database Administrator Specialist

    1 week ago

    Toronto, Canada Royal Bank of Canada Full time

    **Job Summary** **What is the opportunity?** **This is an exciting position working with SQL server as leading initiatives in the group as well working with the databases in cloud.** **We are looking for someone within local Toronto area as this is Hybrid working from office position.** **What will you do?** - Lead in the support of database and...

  • SQL Server Database Administrator Specialist

    6 days ago

    TORONTO, Canada Royal Bank of Canada Full time

    Job Description What is the opportunity? RBC is looking for an experienced SQL server DBA specialist with minimum of 10+ years of working experience. We are looking for someone provide application DBA support and services but also lead initiatives across the group. This is an exciting position working with SQL server as leading initiatives in the group as...

  • SQL Server Database Administrator Specialist

    5 days ago

    Toronto, Canada Royal Bank of Canada Full time

    Job Description What is the opportunity?RBC is looking for an experienced SQL server DBA specialist with minimum of 10+ years of working experience. We are looking for someone provide application DBA support and services but also lead initiatives across the group. This is an exciting position working with SQL server as leading initiatives in the group as...

  • SQL Server Database Administrator Specialist

    3 days ago

    Toronto, Canada RBC Full time

    Job DescriptionWhat is the opportunity?RBC is looking for an experienced SQL Server DBA specialist with a minimum of 10+ years of working experience. We are looking for someone to provide application DBA support and services and also lead initiatives across the group.This is an exciting position working with SQL Server as leading initiatives in the group as...

  • SQL Server Database Administrator Specialist

    3 days ago

    Toronto, Canada RBC Full time

    Job Description What is the opportunity? RBC is looking for an experienced SQL Server DBA specialist with a minimum of 10+ years of working experience. We are looking for someone to provide application DBA support and services and also lead initiatives across the group. This is an exciting position working with SQL Server as leading initiatives in the group...

SQL Server Database Administrator

1 month ago

Toronto, Canada Idea Theorem™ Full time

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.

-