Job Title

SQL Server Database Administrator Specialist Join to apply for the SQL Server Database Administrator Specialist role at RBC . Overview 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 but also lead initiatives across the group. This is an exciting position working with SQL Server as leading initiatives in the group as well as working with the databases in cloud. 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 & 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 a 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 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 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 performance, high availability, reliability, and reducing 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 architecture, structures, theories, principles, and practices. A minimum 10+ years of proven working experience in Microsoft SQL Server technology as a database administrator specialist and current on SQL Server releases (e.g., SQL Server 20122019). Knowledge of database architecture and ability to redesign as per best practices. Expert knowledge to analyze performance issues, identify tuning opportunities, implement improvements and advise developers on SQL Server; expert knowledge of supporting and maintaining SQL Server on Windows. Proficiency in SQL query tuning and slow query optimizations with optimized rewrites. 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 DB architecture for workload-specific configurations. Strong communication skills; ability to present ideas in user-friendly language. Self-motivated with keen attention to detail. T-SQL, PowerShell, CLI and coding expertise. Able to prioritize and execute tasks in a high-pressure environment; experience working in a team-oriented, collaborative environment; proactive problem solving. Expert knowledge of indexes and index management; ability to use Performance Monitor to gather metrics and define baselines. Experience using SQL Profiler and examining execution plans. Willingness to learn new technologies. Nice-to-have Some knowledge of public cloud (e.g., Azure, AWS RDS) and containerization. Experience managing SQL Server on containers (e.g., Docker, Kubernetes, OpenShift). Knowledge of other NoSQL databases, DevOps tools (git, JIRA). Coaching/mentoring skills, strong client-focused communication; attention to client service. Whats in it for you? We thrive on the challenge to be our best, drive progressive thinking, and work together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, our potential, and making a difference. A comprehensive Total Rewards Program including bonuses and flexible benefits, compensation, and stock where applicable. Leaders who support your development through coaching and opportunities. Opportunity to make a difference and lasting impact. Work in a dynamic, collaborative, progressive, high-performing team. World-class training program in financial services. Opportunities to do challenging work and take on greater accountabilities. Opportunities to build close relationships with clients. Access to a variety of job opportunities across business and geographies. Address: RBC WATERPARK PLACE, 88 QUEENS QUAY W, TORONTO, Canada City: Toronto 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-10-31 Note: Applications will be accepted until the deadline date above. At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth. RBC strives to deliver a workplace based on respect, belonging and opportunity for all. Join our Talent Community to stay informed about RBC opportunities. Seniority level: Not Applicable Employment type: Full-time Job function: Information Technology Industries: Banking and Financial Services Posted in Greater Toronto Area, Canada. #J-18808-Ljbffr