Talent.com
SQL Server Database Administrator Specialist
SQL Server Database Administrator SpecialistRBC • Toronto, ON, CA
Les candidatures ne sont plus acceptées
SQL Server Database Administrator Specialist

SQL Server Database Administrator Specialist

RBC • Toronto, ON, CA
Il y a 21 jours
Type de contrat
  • Temps plein
Description de poste

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

    Créer une alerte emploi pour cette recherche

    Database Administrator • Toronto, ON, CA

    Offres similaires
    Senior Systems Administrator

    Senior Systems Administrator

    Guru Studio • Toronto, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Junior Business Analyst

    Junior Business Analyst

    Swoon • Greater Toronto Area, Canada, Canada
    Temporaire
    Toronto (Hybrid – 2 days onsite per week).Banking / Financial Services / Capital Markets.We are hiring multiple Junior Business Systems Analysts to support a large-scale Corporate Treasury technolo...Voir plus
    Dernière mise à jour : il y a 10 heures • Offre sponsorisée • Nouvelle offre
    System Administrator

    System Administrator

    Hiring Help • Toronto, ON, Canada
    Temps plein +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...Voir plus
    Dernière mise à jour : il y a 15 jours • Offre sponsorisée
    MSSQL Database Administrator

    MSSQL Database Administrator

    NPO USA • Toronto, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 25 jours • Offre sponsorisée
    Corporate Actions Administrator

    Corporate Actions Administrator

    Options Consulting Solutions • Greater Toronto Area, Canada, Canada
    Temps plein
    CORPORATE ACTIONS ADMINISTRATOR.Our client is an investment firm with a history of skillfully navigating the market and providing clients with exceptional service. If you are a proactive and goal-dr...Voir plus
    Dernière mise à jour : il y a 10 heures • Offre sponsorisée • Nouvelle offre
    Platform Architect - ServiceNow

    Platform Architect - ServiceNow

    Warriors Solutions Group • Greater Toronto Area, Canada, Canada
    Permanent
    Principal Platform Architect - ServiceNow.Location : Remote, Canada (East of Calgary).Architects play a critical role in guiding customers through their digital transformation journey through leadin...Voir plus
    Dernière mise à jour : il y a 10 heures • Offre sponsorisée • Nouvelle offre
    System Administrator

    System Administrator

    Picton Mahoney Asset Management • Toronto, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 24 jours • Offre sponsorisée
    Server

    Server

    Jack Astor's • Newmarket, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Snowflake Solution Architect

    Snowflake Solution Architect

    Celebal Technologies • newmarket, on, ca
    Temps plein
    Senior Snowflake Solution Architect.Snowflake Solution Architect who has experience with migration from AWS to Azure.Snowflake Cross‑Cloud Replication | Configure and validate Snowflake replication...Voir plus
    Dernière mise à jour : il y a 9 heures • Offre sponsorisée • Nouvelle offre
    Database Engineer

    Database Engineer

    Pixomondo • Toronto, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Server

    Server

    Ruth's Chris Markham • Unionville, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Senior Azure Cloud Architect (MSP)

    Senior Azure Cloud Architect (MSP)

    Venture Computers of Canada Inc. • Markham, ON, Canada
    Temps plein
    We are seeking a Senior Azure Architect to join our Toronto-based Managed Service Provider team.In this role, you will lead the design, implementation, and management of Azure cloud environments fo...Voir plus
    Dernière mise à jour : il y a 15 jours • Offre sponsorisée
    Payroll Administrator

    Payroll Administrator

    Black & McDonald Limited • Markham, ON, Canada
    Temps plein
    BUILD YOUR CAREER AT BLACK & MCDONALD.Black & McDonald is an integrated, multitrade service provider that safely delivers high quality construction, facilities management, and technical sol...Voir plus
    Dernière mise à jour : il y a 3 jours • Offre sponsorisée
    Data Analyst

    Data Analyst

    Vaco by Highspring • Richmond Hill, ON, CA
    Temporaire
    Our client is seeking a Data Analyst for a 3-month contract.The Data Analyst will support data extraction, transformation, and analysis across multiple databases. The role will focus on consolidatin...Voir plus
    Dernière mise à jour : il y a 2 jours • Offre sponsorisée
    Senior Systems Administrator

    Senior Systems Administrator

    Idealogical Systems inc. • Markham, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Guidewire Integration BSA

    Guidewire Integration BSA

    Cloud Space LLC • Richmond Hill, ON, Canada
    Temps plein
    Hybrid (Mandatorily need to visit office 3 days a week).This position focuses on delivering integration solutions that support business operations, regulatory compliance, and customer experience.As...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Sr. Data engineer KATDC5697872 - markham

    Sr. Data engineer KATDC5697872 - markham

    Compunnel Inc. • markham, on, ca
    Temps plein
    Deep expertise in relational databases (Snowflake, PostgreSQL, Amazon Aurora), big data platforms (Hadoop), and NoSQL databases (MongoDB). Advanced proficiency in data visualization tools such as Sn...Voir plus
    Dernière mise à jour : il y a 8 jours • Offre sponsorisée
    Office Administrator

    Office Administrator

    APT & Solid GC • Richmond Hill, ON, Canada
    Temps plein
    Job Title : Office Administrator.Company : All Professional Trades.Location : 66 Leek Crescent, Richmond Hill, ON.Job Type : Full-Time On-site, 8 : 00AM to 4 : 00 PM. Salary : $45,000 $50,000 per year (based...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée