Talent.com
SQL Server Database Administrator Specialist
SQL Server Database Administrator SpecialistRBC • Toronto, ON, CA
SQL Server Database Administrator Specialist

SQL Server Database Administrator Specialist

RBC • Toronto, ON, CA
17 days ago
Job type
  • Full-time
Job description

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 across the group.

This is an exciting position working with SQL Server and leading initiatives in the group while also working with cloud databases. The Data and Analytics (DNA) team is looking for a SQL Server DBA Specialist. The DBA will oversee predominantly on‑prem and some Azure SQL the creation and maintenance of database and transaction processing environments for application testing, pre‑production verification, and production operation. You will provide technical leadership in the area of enterprise‑level database design, performance tuning, database access, database recovery, HA / DR design for multiple business‑critical applications. The ideal candidate will demonstrate proven success in a fast‑paced dynamic environment and demonstrate critical thinking, agility, and innovation while executing on multiple complex projects and supporting multiple business‑critical applications. This role will provide thoughtful leadership in delivering a holistic, best‑in‑class DBA service to a portfolio of applications across lines of business and across the whole RBC enterprise.

What will you do?

  • Lead in the support of database and transaction management technology and its deployment and usage standards.
  • Lead application development and support teams in optimal use of database and transaction management technology through creation and communication of standards and walkthrough of critical application components.
  • Ensure that databases are optimally designed so that applications meet their defined SLAs, reuse of existing database structures is maximized and operational costs are minimized.
  • Provide leadership in ensuring all database and environmental changes are appropriately tested and implemented in such a manner that there is no impact to RBC systems and clients.
  • Provide strong technical knowledge and business subject matter expertise across a wide range of database technologies, with primary focus on SQL Server. Provide database‑related technical support for development and production environments including required level of 7×24 on‑call support.
  • Define, develop and meet various SLAs for multiple database platforms used in the company. Improve and optimize database administration and management with coding and automation with a focus on performance, high availability, reliability, and reduce TOIL using SRE practices.
  • Build self‑service and self‑managing capabilities of the database‑as‑a‑service infrastructure.

What do you need to succeed?

Must‑have

  • Minimum 10+ years of IT operation with strong understanding of SQL Server database architecture, structures, theories, principles, and practices. Proven working experience in Microsoft SQL Server technology at database administrator specialist capacity and current on SQL Server releases (i.e. SQL Server 2012, 2014, 2016, 2017, 2019).
  • Knowledge of database architecture and ability to redesign as per best practices.
  • Expert knowledge to analyse performance issues, identify tuning opportunities, implement improvements and advise developers on SQL Server as well as support and maintain SQL Server on Windows platform.
  • Proficiency in SQL query tuning and slow query optimisation with rewrite in an optimised way.
  • Propose and build automated solutions with automation expertise. Experience with High Availability (i.e. FCI, Always On), data management and data processing flowcharting techniques.
  • Deep knowledge of database architecture for workload‑specific configurations.
  • Good understanding of organisational goals, objectives, interpersonal, written, and oral communication skills.
  • Ability to present ideas in user‑friendly language. Strong root‑cause analysis, self‑motivated and directed, with keen attention to detail. TSQL, PowerShell, CLI and coding expertise.
  • Ability to prioritise and execute tasks in a high‑pressure environment.
  • Experience working in a team‑oriented, collaborative environment.
  • Ability to work towards proactive solutions.
  • Expert knowledge of indexes and index management. Ability to use Performance Monitor to gather metrics to define baselines.
  • Experience using SQL Profiler and examining execution plans. Willingness to learn new technologies.
  • Nice‑to‑have

  • Some knowledge of public cloud (i.e. Azure, AWS RDS) and containerisation.
  • Managing SQL Server on container (i.e. Docker, Kubernetes, OpenShift).
  • Other NoSQL database platforms, knowledge of DevOps pipeline (i.e. Git and JIRA).
  • Coaching / mentoring skills, good verbal and written communication skills. Attention to client focus and client service.
  • What’s in it for you?

  • A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable.
  • Leaders who support your development through coaching and managing opportunities.
  • Ability to make a difference and lasting impact.
  • Work in a dynamic, collaborative, progressive, and high‑performing team.
  • A world‑class training program in financial services.
  • Opportunities to do challenging work.
  • Opportunities to take on progressively greater accountabilities.
  • Opportunities to build close relationships with clients.
  • Access to a variety of job opportunities across business and geographies.
  • Job Skills

    Customer Service, Customer Service Management, Detail‑Oriented, Industry Knowledge, Information Technology Trends, IT Standards, IT Systems Integration, Resource Coordination, Service Platforms, Time Management

    Additional Job Details

    Address : RBC WATERPARK PLACE, 88 QUEENS QUAY W : TORONTO

    City : Toronto

    Country : Canada

    Work hours / week : 37.5

    Employment Type : Full time

    Platform : TECHNOLOGY AND OPERATIONS

    Job Type : Regular

    Pay Type : Salaried

    Posted Date : 2025‑10‑08

    Application Deadline : 2025‑12‑22

    Note : Applications will be accepted until 11 : 59 PM on the day prior to the application deadline date above.

    Inclusion and Equal Opportunity Employment

    At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

    Join our Talent Community

    Stay in‑the‑know about great career opportunities at RBC. Sign up and get customised info on our latest jobs, career tips and recruitment events that matter to you.

    Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well‑being of our clients and communities at jobs.rbc.com

    Seniority level

  • Not Applicable
  • Employment type

  • Full‑time
  • Job function

  • Information Technology
  • Industries

  • Banking and Financial Services
  • Referrals increase your chances of interviewing at RBC by 2x

    #J-18808-Ljbffr

    Create a job alert for this search

    Database Administrator • Toronto, ON, CA

    Similar jobs
    Senior Systems Administrator

    Senior Systems Administrator

    Guru Studio • Toronto, ON, Canada
    Full-time
    Guru Studio is a creative-driven entertainment company and an industry leader in animated storytelling.For over twenty years, our studio has brought to life some of the most recognizable and belove...Show more
    Last updated: 30+ days ago • Promoted
    Senior Architect — Distributed Database Systems

    Senior Architect — Distributed Database Systems

    Huawei Technologies Canada Co., Ltd. • Markham
    Full-time
    A global technology company in Markham is seeking a Distinguished Architect for their Distributed Data Storage and Management Lab. This role involves leading R&D on transaction processing database m...Show more
    Last updated: 14 days ago • Promoted
    Senior Database Architect & Data Modeling Lead

    Senior Database Architect & Data Modeling Lead

    Scotiabank • Toronto
    Full-time
    A leading bank in the Americas is seeking a Database Architect in Toronto.This role involves designing and maintaining scalable database solutions and data modeling to enhance business performance....Show more
    Last updated: 9 days ago • Promoted
    System Administrator

    System Administrator

    Hiring Help • Toronto, ON, Canada
    Full-time +1
    We are seeking a System Administrator.Ideally, we are looking for someone who can come onsite in our downtown Toronto office. We are looking for someone who is looking for a very long-term role.As a...Show more
    Last updated: 11 days ago • Promoted
    MSSQL Database Administrator

    MSSQL Database Administrator

    NPO USA • Toronto, ON, Canada
    Full-time
    Senior DBA (Microsoft SQL Server).Lead installation, configuration, maintenance, performance tuning, and troubleshooting of SQL Server instances. Design and operate HA / DR solutions (Failover Cluster...Show more
    Last updated: 21 days ago • Promoted
    ERP Senior Systems Administrator - toronto

    ERP Senior Systems Administrator - toronto

    The Crump Group, Inc. • toronto, on, ca
    Full-time
    Started in 2006, we have successfully established 3 market leading brands (Caledon Farms, Crumps Naturals and Dog Delights) distributed throughout Canada and the United States.We officially started...Show more
    Last updated: 25 days ago • Promoted
    Senior Software Engineer - Databases

    Senior Software Engineer - Databases

    Theory Ventures • Toronto, Canada
    Full-time
    From Fivetran’s founding until now, our mission has remained the same : to make access to data as simple and reliable as electricity. With Fivetran, customer data arrives in their warehouses, canonic...Show more
    Last updated: 8 days ago • Promoted
    Oracle Cloud Infrastructure DBA - ZDLRA, DDBOOST

    Oracle Cloud Infrastructure DBA - ZDLRA, DDBOOST

    Astra North Infoteck Inc. • Toronto, ON, ca
    Full-time
    Quick Apply
    Required Skill : Digital : EAS : Oracle Cloud Infrastructure~Oracle DBA.Essential Skills : Financial Services IT experience. Broad experience with IP networking concepts - routers, firewalls, etcSQL S...Show more
    Last updated: 12 days ago
    Legal Operations Administrator

    Legal Operations Administrator

    Ledn • Greater Toronto Area, Canada
    Full-time
    Legal Operations Administrators, Ledn is interested in hearing from you!.Bitcoin holders while building generational wealth for the future. We offer a suite of egalitarian lending, savings and tradi...Show more
    Last updated: 18 days ago • Promoted
    System Administrator

    System Administrator

    Picton Mahoney Asset Management • Toronto, ON, Canada
    Full-time
    Best Workplaces in Canada 2020 - 2025 | Best Workplaces with Most Trusted Executive Teams 2024, 2025 | Best Workplaces in Financial Services & Insurance 2020 - 2025 | Best Workplaces for Mental...Show more
    Last updated: 20 days ago • Promoted
    Server

    Server

    Jack Astor's • Newmarket, ON, Canada
    Full-time
    At Jack Astor’s it’s all about personality, yes, we’re all about a.Jacks is about being ourselves.In your role, you will consistently provide our guests with.We will prepare and s...Show more
    Last updated: 30+ days ago • Promoted
    Database Engineer

    Database Engineer

    Pixomondo • Toronto, ON, Canada
    Full-time
    We’re looking for a seasoned Database Engineer to join our.In this role, you will be responsible for ensuring performance, reliability, and scalability of our data layer, as well as contribut...Show more
    Last updated: 30+ days ago • Promoted
    Server

    Server

    Ruth's Chris Markham • Unionville, ON, Canada
    Full-time
    All FOH positions are expected to report to work as indicated on the work schedule, be in correct uniform, practice positive personal hygiene and cleanliness habits during all work shifts.Each posi...Show more
    Last updated: 30+ days ago • Promoted
    Senior Analyst

    Senior Analyst

    Vaco by Highspring • Stouffville, ON, CA
    Temporary
    Our client is sourcing a Senior Analyst for a 6-month contract.Responsible for month-end, quarter-end, and annual close process in accordance with company requirements. Responsible for expense reimb...Show more
    Last updated: 7 days ago • Promoted
    Senior Database Developer

    Senior Database Developer

    Boyd Interactive • Toronto C6A, ON, Canada
    Full-time +1
    Pala offers a full spectrum of games across all distribution channels (web, download, tablet & smartphone).In Canada, they offer sports betting and casino games. In the US, they offer casino, bingo,...Show more
    Last updated: 30+ days ago • Promoted
    Senior Systems Administrator

    Senior Systems Administrator

    Idealogical Systems inc. • Markham, ON, Canada
    Full-time
    WHEN WAS THE LAST TIME YOU ENDED YOUR WORKDAY WITH A SMILE? You spend 80% of your life at work, and you should be doing what you love with people you like doing it with, all while making a differen...Show more
    Last updated: 30+ days ago • Promoted
    Senior SQL Engineer

    Senior SQL Engineer

    SuperAnnotate • Newmarket, Ontario, CA
    Remote
    Full-time
    As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...Show more
    Last updated: 18 hours ago • New!
    Data Architect : Hybrid Cloud & Enterprise Data

    Data Architect : Hybrid Cloud & Enterprise Data

    Util-Assist Inc. • Newmarket L0G, ON, Canada
    Remote
    Full-time
    A consultancy for utilities is seeking a Data Architect with extensive experience in designing and implementing data architectures. This role focuses on developing data solutions that support advanc...Show more
    Last updated: 30+ days ago • Promoted