Will & Estate Consultant

What is the opportunity?
As a member of the Database Administration team, RBC Global Asset Management (RBC GAM), this role will have overall responsibility for the GAM database platform including system stability, performance, security, availability, and scalability. The successful candidate will provide DBA support to a portfolio of applications across the GAM line of business.

Please Note: This position can be located in Vancouver.

What will you do?

• Perform day-to-day database administration tasks and provide support to our internal clients

• Complete builds, upgrades and enhancements to maintain the database servers

• Actively discuss, review, and recommend technical options and activities with the team

• Respond to ad-hoc requests from our internal clients with a high level of customer service

• Act as Subject Matter Expert for projects

• Troubleshoot performance-related issues and optimize in-house developed application code

• Create and maintain system documentation, as per RBC standards and project requirements

• Provide after-hours support when needed (planned or on-call)

What do you need to succeed?

Must Have

• A degree in Information Technology or Computer Science, or an equivalent combination of education, experience and training.

• 5+ years of database administration and operational work experience using Microsoft SQL Server (2014/2016/2017/2019)

• Effective communication with team members, internal and external clients

• Basic to intermediate understanding of T-SQL and the SQL Standard

• Strong systematic troubleshooting and problem solving skills

Nice to Have

• Microsoft SQL Server 2016 or higher and/or Azure SQL certifications

• Knowledge of public cloud (Azure, AWS RDS)

• Experience with PowerShell

• Experience/knowledge of PostgreSQL, MongoDB, and other database platforms

Whats 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

• Flexible work/life balance options

• Opportunities to do challenging work

• Opportunities to take on progressively greater accountabilities.

The expected base salary range for this particular position is $80,000- $140,000 -- depending on your experience, skills, and registration status, market conditions and business needs.

You have the potential to earn more through RBCs robust discretionary bonus program which gives you an opportunity to increase your total compensation, provided the business meets its performance targets and you meet your individual goals.