Associate Director, Lead database developer (SQL)

Royal Bank of Canada • Dartmouth, NS

5d • Onsite

About The Position

At RBC Capital markets, we are looking for an experienced Database Developer to join our Client Banking Data & Digital team. The objective of the developer is to design stable, robust, and reliable database objects, and processes, to effectively manage large amounts of information.

Requirements

• 8+ years of experience in database design and development.
• Advanced proficiency in programming such as SQL and T-SQL.
• Experience working with MS SQL Server.
• Excellent analytical, organization skills, verbal, and written communication skills.
• Strong technical and problem-solving skills, as well as the ability to work independently on complex tasks.

Nice To Haves

• Database administration, performance tuning, and security best practices.
• MySQL/ SingleStore (Memsql)
• Certificate in Database Development.

Responsibilities

• Designing and developing complex databases, maintaining the integrity of the database system, and participating in the development of database applications.
• Modelling and developing complex databases, maintaining the integrity of the database system, and participating in the development of database applications.
• Optimizing database performance and troubleshooting any issues.
• Writing and executing SQL and/or NoSQL queries and ensuring data security and integrity.
• Testing databases for accuracy and functionality & documenting all database designs and modifications.
• Providing technical support for database-related questions and issues.
• Creating software for retrieving, parsing and processing structured and unstructured data.
• Defining and building scalable ETL/ELT workflows for reporting and analytics.
• Supporting project team to scale, monitor and operate data platforms for very high availability and performance.
• Developing scripts and programs for converting various types of data into usable formats.

Benefits

• bonuses
• flexible benefits
• competitive compensation
• commissions
• stock where applicable
• Leaders who support your development through coaching and managing opportunities.
• Ability to make a difference and lasting impact.
• A world-class training program in financial services.
• Flexible work/life balance options.

What This Job Offers

• Job Type: Full-time
• Career Level: Manager
• Education Level: No Education Listed