Lead Database Developer, GFT

Job Description

Job Description What is the opportunity? Are you a hands-on database developer who loves designing scalable data systems, optimizing complex queries, and building robust data solutions? RBC is looking for a Lead Database Developer to help build and modernize our data infrastructure, creating high-performance databases and data warehouses that power critical analytics, reporting, and business intelligence systems. You'll spend the majority of your time designing schemas, developing ETL pipelines, optimizing database performance, and building reporting data models that enable teams across the organization to make data-driven decisions. If you're excited about solving complex data challenges, mentoring junior database engineers, and shaping the data architecture that powers RBC's operations, let's talk. What will you do? Design and implement efficient database schemas, data models, and dimensional structures optimized for both transactional and analytical workloads across SQL Server, PostgreSQL, and Snowflake. Develop, optimize, and maintain complex ETL pipelines and data integration solutions that reliably move data from source systems to target databases, data warehouses, and data marts. Build and optimize reporting data models including dimensional models, star schemas, and slowly changing dimensions that enable self-service analytics and business intelligence. Write and optimize T-SQL, PL/pgSQL, and other database code including stored procedures, functions, triggers, and views to ensure performance and maintainability. Conduct performance tuning and optimization of queries, indexes, and execution plans to meet SLAs and support growing data volumes and user concurrency. Design and implement data governance practices including data quality validation, monitoring, and lineage to ensure data accuracy and trustworthiness. Collaborate with analytics teams, business intelligence teams, and application developers to translate requirements into robust database solutions. Develop and maintain ETL validation frameworks and data quality checks to catch issues early and maintain system reliability. Lead database migration projects from legacy systems to modern platforms like Snowflake, ensuring data integrity and minimal downtime. Stay current with emerging database technologies and best practices, evaluating new tools and approaches that could improve data delivery and performance. Implement monitoring, alerting, and backup strategies to ensure database availability, disaster recovery, and business continuity. What do you need to succeed? Must have: 8 years of hands-on experience developing and optimizing relational databases in production environments. Expert-level proficiency in SQL Server including T-SQL development, query optimization, indexing strategies, and performance tuning. 5 years of experience with PostgreSQL including schema design, query optimization, and production administration. 3 years of hands-on experience with Snowflake or similar clou

Required Skills