Royal Bank of Canada
Job title:
Senior Sybase and Cloud DBA
Company
Royal Bank of Canada
Job description
Job Summary
Job Description
What is the opportunity?
Data and Analytics (DNA) team is looking for a Sr. Sybase Database Administrator Specialist (ASE and Replication Server) with experience in Azure Cloud technology and SQL Server. The DBA will oversee predominately on-premise 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 Sybase ASE and Replication server. Also 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
10+ years of IT operation with strong understanding of Sybase server database architecture, structures, theories, principles, and practices. Working experience on Public Cloud for SQL Server in either Azure or AWS. 10+ years of proven working experience in Sybase and Microsoft SQL Server technology at database administrator specialist capacity and current on releases (i.e. Sybase 16 and SQL Server 2014, 2016, 2017, 2019)
Knowledge on Database Architecture and ability to understand the need to redesign as per best practices.
Expertise in analyzing performance issue, identifying tuning opportunities, implementing improvements and advising developers on Sybase/SQL server as well as expert knowledge of support and maintaining database servers on multiple platforms
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.
Deep knowledge and understanding of DB architecture for workload specific configurations. Good understanding of the organization’s goals and objectives. Excellent interpersonal, written, and oral communication skills.
Nice-to-have
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
Flexible work/life balance options
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-Hybrid
#LI-POST
#LI-TECHPJ
Job Skills Critical Thinking, Data Administration, Database Structures, Data Governance, Data Mining, Data Modeling, Detail-Oriented, Information Security Management, Quality Management, Quantitative Research
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-01-19
Application Deadline: 2024-02-02
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 .
Expected salary
Location
Toronto, ON
Job date
Sun, 21 Jan 2024 07:40:24 GMT
To help us track our recruitment effort, please indicate in your email/cover letter where (un-jobs.net) you saw this job posting.