SQL Server Database Administrator Specialist

RBC; Toronto; Hybrid; CAD 100,000 - 130,000; Full time

Job summary

A leading financial services company in Toronto seeks an experienced SQL Server Database Administrator Specialist. This hybrid role involves overseeing database environments, providing technical leadership, and ensuring optimal performance for critical applications. The ideal candidate will have over 10 years of experience in SQL Server technology and a strong understanding of database architecture. The position offers opportunities for professional growth and a comprehensive rewards program.

Benefits

Comprehensive Total Rewards Program

Flexible benefits

Competitive compensation

Stock options

World-class training program

Qualifications

• 10+ years of experience in SQL Server technology as a DBA specialist.
• Proficient in SQL Query Tuning and Slow Query Optimizations.

Responsibilities

• Lead database and transaction management technology support.
• Ensure optimal database design to meet SLA requirements.
• Provide technical support for development and production environments.

Skills

Customer Service

Detail-Oriented

Information Technology Trends

Time Management

Tools

TSQL

Power-shell

Job description

SQL Server Database Administrator Specialist

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 well working with the databases in cloud.

We are looking for someone within local Toronto area as this is Hybrid working from office position.

Data and Analytics (DNA) team is looking for a SQL Server DBA Specialist. The DBA will oversee predominately on-prem and some Azure SQL the creation and maintenance of database & 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 to many business-critical applications. The ideal candidate will demonstrate proven success in fast paced dynamic environment and demonstrated critical thinking, agility, and innovation in 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 it’s 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 SLA s, 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 environment including required level of 7X24 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 the performance, high availability, reliability, and reduce TOIL using SRE practices.

Build self-service and self-managing capabilities of our database as a service infrastructure.

What do you need to succeed?

Must-have

A minimum 10+ years of IT operation with strong understanding of SQL server database Architect, structures, theories, principles, and practices. A minimum 10+ years of 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 on Database Architecture and able to understand the need to redesign as per best practices.

Expert knowledge to analyze performance issue, identify tuning opportunities, implement improvements and advise developers on SQL Server as well as expert knowledge of support and maintaining SQL server on Windows platform

Should be proficient in SQL Query Tuning and Slow Query Optimizations with rewrite in an optimized 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 and understanding of DB architecture for workload specific configurations.

Good understanding of the organization’s 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, Power-shell, CLI and coding expertise.

Able to prioritize and execute tasks in a high-pressure environment.

Experience working in a team-oriented, collaborative environment.

Ability to work towards proactive solutions.

An 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 in new technologies.

Nice-to-have

Some knowledge of public cloud (i.e. Azure, AWS RDS) and containerization.

Nice to have other NoSQL Databases 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?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

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 building close relationships with clients.

Access to a variety of job opportunities across business and geographies.

**Please note- This is a Hybrid role (3 days in a week from RBC waterpark place) & 2 days remote at this moment. This job requires you be flexible on work hours like weekend support, On-call/Pager support, 24/7.

#LI-Post

#LI-Hybrid

#TECHPJ

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

Job Summary

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 well working with the databases in cloud.

We are looking for someone within local Toronto area as this is Hybrid working from office position.

Data and Analytics (DNA) team is looking for a SQL Server DBA Specialist. The DBA will oversee predominately on-prem and some Azure SQL the creation and maintenance of database & 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 to many business-critical applications. The ideal candidate will demonstrate proven success in fast paced dynamic environment and demonstrated critical thinking, agility, and innovation in 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 it’s 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 SLA s, 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 environment including required level of 7X24 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 the performance, high availability, reliability, and reduce TOIL using SRE practices.

• Build self-service and self-managing capabilities of our database as a service infrastructure.

What do you need to succeed?

Must-have

• A minimum 10+ years of IT operation with strong understanding of SQL server database Architect, structures, theories, principles, and practices. A minimum 10+ years of 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 on Database Architecture and able to understand the need to redesign as per best practices.

• Expert knowledge to analyze performance issue, identify tuning opportunities, implement improvements and advise developers on SQL Server as well as expert knowledge of support and maintaining SQL server on Windows platform

• Should be proficient in SQL Query Tuning and Slow Query Optimizations with rewrite in an optimized 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 and understanding of DB architecture for workload specific configurations.

• Good understanding of the organization’s 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, Power-shell, CLI and coding expertise.

• Able to prioritize and execute tasks in a high-pressure environment.

• Experience working in a team-oriented, collaborative environment.

• Ability to work towards proactive solutions.

• An 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 in new technologies.

Nice-to-have

• Some knowledge of public cloud (i.e. Azure, AWS RDS) and containerization.

• Managing SQL server on container (i.e. Docker, Kubernetes, OpenShift etc…)

• Nice to have other NoSQL Databases 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?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• 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 building close relationships with clients.

• Access to a variety of job opportunities across business and geographies.

**Please note- This is a Hybrid role (3 days in a week from RBC waterpark place) & 2 days remote at this moment. This job requires you be flexible on work hours like weekend support, On-call/Pager support, 24/7.

#LI-Post

#LI-KAS

#LI-Hybrid

#TECHPJ

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:

2024-11-29

Application Deadline:

2025-05-30

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 customized 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 .

About the company

Royal Bank of Canada (RBC), is a diversified financial services company. The Company provides personal and commercial banking, wealth management services, insurance, investor services and capital markets products and services on a global basis. The Com...