Senior SQL server DBA

Job title: Senior SQL server DBA

Job description: Come Work with Us!

At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose.

Whether you’re helping clients find new opportunities, developing new technology, or providing expert advice to internal partners, you will be doing work that matters in the world, in an environment built on teamwork, service, responsibility, diversity, and integrity.

Job Title Senior SQL server DBA

Job Description

What is the opportunity?
Data and Analytics (DNA) team is looking for a Senior SQL Server Database Administrator. The DBA will oversee the creation and maintenance of database & transaction processing environments for application testing, pre-Production verification, and production operation. You will provide technical support for transaction processing, data access, performance tuning, and database recovery. The Database Administrator will provide DBA services 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 on RBC systems and clients.
• Provide strong technical knowledge and business subject matter expertise across a wide range of database technologies, with a primary focus on SQL servers.
• 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 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

• 10+ years of proven working experience in Microsoft SQL Server technology and current on SQL Server releases (i.e. SQL Server 2012, 2014, 2016, 2017, 2019)
• In-depth technical knowledge of database and transaction management technologies and operating systems
• Experienced with data manipulation languages, data definition languages, physical database design, and application performance analysis & tuning
• Experience in providing L3/L4 support in troubleshooting SQL Server performance-related issues.
• Expert knowledge to analyze performance issues, identify tuning opportunities, implement improvements and advise developers on SQL Server
• Intermediate knowledge of support and maintaining SQL server on Linux platform
• Experience automating routine DBA tasks using scripts or CI/CD pipelines

Nice-to-have

• Some knowledge of public cloud (i.e.
• Some knowledge of containerization
• Managing SQL Server on containers (i.e. Docker, Kubernetes, 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
• Flexible work/life balance options
• 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

RBC requires as a condition of employment that all successful candidates in the United States and Canada be fully vaccinated against COVID-19 prior to their start date, and may require proof of the same. Reasonable accommodation is available where required by law.

RBC exige, à titre de condition d’emploi, que tous les candidats retenus aux États-Unis ou au Canada soient entièrement vaccinés contre la COVID-19 avant leur date d’entrée en fonction. Il est possible qu’ils aient à présenter une preuve vaccinale. Des mesures raisonnables d’adaptation sont offertes lorsque la loi l’exige

Job Summary

Address: TORONTO, Ontario, Canada

City: CAN-ON-TORONTO

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: Technology and Operations

Job Type: Regular

Pay Type: Salaried

Posted Date: 2022-03-21-07:00

Application Deadline: 2022-04-30-07:00

Inclusion and Equal Opportunity Employment

At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.

We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.

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 rbc.com/careers.

Company: Royal Bank of Canada

Expected salary:

Location: Toronto, ON

Job date: Wed, 23 Mar 2022 05:47:10 GMT

Job Source: Careerjet.ca

Click Here to Apply