Job Summary
Job Description
What is the opportunity?
Are you a talented, creative, and results-driven professional who thrives on delivering high-performing applications? Come join us!
Global Functions Technology (GFT) is part of RBC’s Technology and Operations division. GFT’s impact is far-reaching as we collaborate with partners from across the company to deliver innovative and transformative IT solutions.
Our clients represent Risk, Finance, HR, CAO, Audit, Legal, Compliance, Financial Crime, Capital Markets, Personal and Commercial Banking and Wealth Management.
We also lead the development of digital tools and platforms to enhance collaboration.
Working in the Global Functions Technology (GFT) Risk IT team as a Senior Database Administrator to create and maintain Vertica database & processing environments for application testing, pre-production verification, and production operations.
You will be a key player in providing technical support for database processing, data access, performance tuning, and database recovery.
You will perform analysis required to resolve complex technical issues / problems.
What will you do?
Special Conditions - Rotational after-hours & weekend support is required; Support personnel are required to carry cell phone when on call.
Provide Vertica DBA technical support including database processing, performance tuning and database recovery for development and production environments including required level of 7X24 on call support.
Create and maintain Vertica database & processing environments for application testing, pre-production verification, and production operation.
Makes recommendations on process improvements and enhances system and support documentation.
Lead application development and support teams in optimal use of Vertica database 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.
Ensure that all database and environmental changes are appropriately tested and implemented in such a manner that there is no impact to RBC systems and clients
Work on IT risk deliverables : participate in DR exercise, DR planning and design; interacting with various auditors and ensure applications in our portfolio function according to published RBC IT Risk Standards.
What do you need to succeed?
Must have :
Specialized technical knowledge of Vertica database technologies is required, including database security, performance tuning and database recovery.
High level of proven competence with data manipulation languages, data definition languages, physical database design, and application performance analysis & tuning.
UNIX experience is required. Shell scripting : the ability to read, understand, modify, and write non-trivial UNIX shell scripts is preferred.
Strong interpersonal and communication skills; ability to learn and absorb new concepts quickly, apply new knowledge as appropriate and transfer knowledge to others.
Good coaching / mentoring skills.
Sound understanding of database, operating system and file system security practices on the UNIX and Windows platforms is required.
Nice-to-have :
Knowledge of how to create and modify job schedules using job scheduling software would be an asset, as most of the applications we support are run using advanced job scheduling software.
Ideal candidate would possess some business knowledge in Capital Markets arena as it is often essential to be able to express technical issues in business terms, and vice-versa.
Being familiar with incident management and ITIL process workflows will make you a better candidate for this position.
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
LI-Post
LI-Hybrid
TechPJ
Job Skills
Configuration Management (CM), Critical Thinking, Customer Service, Database Backup, Decision Making, Detail-Oriented, Disaster Recovery Testing, Information Security, IT Service Management (ITSM), IT Standards
Additional Job Details
Address :
120 WESTERN PKY : BEDFORD
City : BEDFORD
BEDFORD
Country : Canada
Canada
Work hours / week : 37.5
37.5
Employment Type : Full time
Full time
Platform :
TECHNOLOGY AND OPERATIONS
Job Type : Regular
Regular
Pay Type : Salaried
Salaried
Posted Date : 2024-09-03
2024-09-03
Application Deadline :
2024-11-30
Note : Applications will be accepted until 11 : 59 PM on the day prior to the application deadline date above
I nclusion 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 jobs.rbc.com .
Senior Database Administrator - Vertica - GFT
Working in the Global Functions Technology (GFT) Risk IT team as a Senior Database Administrator to create and maintain Vertica database & processing environments for application testing, pre-production verification, and production operations. Specialized technical knowledge of Vertica database tech...
Senior Database Administrator
Worldline is hiring a senior database administrator to join our North America IT operations team. As a Worldline DBA, you will be a critical member of the team managing our production and non-production databases. You will build, configure, and optimize SQL Server database engines in a variety of en...
Staff Data Analyst, Core Experience
TextNow is looking for an experienced Staff Data Analyst to fuel the next stage of our growth. Skilled in extracting and transforming data from Snowflake warehouse using SQL. Respectfully candid with the ability to collaborate with multiple stakeholders as well as peers on the data team. ...
Office Administrator
Reporting to the Operations Manager, the Office Administrator will have a diverse role, overseeing all general office administration functions for this fast-paced, dynamic organization including a wide variety of financial, procurement and operational activities. The ideal candidate will have 3-5 ye...
Data Analyst, Customer Operations
Minimum 2 years of experience in an analytical or reporting role in Customer Support or Customer Operations within a digital consumer industry• Proficient in using data analytics tools including SQL, Databricks, and creating dashboards• At least 1 year of experience presenting data to diverse stakeh...
office administrator
Oversee and co-ordinate office administrative procedures. ...
Office Administrator
Proficient in Microsoft Office Programs (PowerPoint, Word, Excel and Outlook). ...
Online Data Analyst Canada (French Language)
A Day in the Life of an Online Data Analyst:. Completing research and evaluation tasks in a web-based environment such as verifying and comparing data, and determining the relevance and accuracy of information. ...
Software Engineer, Data
Collaborate with product managers, data analysts, and other data engineers to develop data pipelines and ETL tasks in order to facilitate the extraction of insights. You have developed maintainable data pipelines with these languages. You strive for high code quality, create automated testing, apply...
Software Developer (AWS, ASP.NET, SQL) - 4 available
We’re searching for a Toronto-based Software Developer to join our Global R&D team, so that we can enhance our Human Capital Management stack. The Software Developer will support the development and delivery of high-quality software solutions to drive RLDatix's mission of improving healthcare sa...