All jobs within 50 km around Concord in IT & Telecoms

Contributes to the overall success of the Online Digital Banking in Canada ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives.  Ensures all activities conducted are in compliance with governing regulations, internal policies, and procedures.

Is this role right for you? In this role you will:

• Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems, and knowledge.   
• Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
• Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabank’s Values, its Code of Conduct, and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.
• Champions a high-performance environment and contributes to an inclusive work environment.

Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

• Full Stack developer with 8+ years of progressive experience working in the IT industry in roles like developer and team lead.
• Current on industry best practice and secure coding
• Analyze and oversee the team’s development efforts working towards successful code delivery.
• Provide technical leadership to teammates through coaching and mentorship.
• Maintain high standards of software quality within the team by establishing good practices and habits.
• Collaborate with other software developers, business analysts and software architects to plan, design, develop, test, and maintain different applications.
• Design, develop, and unit test applications in accordance with established standards.
• Work with Delivery Leads and BSA’s to articulate efforts and compile estimates.
• Expert level experience in the following technologies: Javascript / ReactJS / NodeJS
• Deep knowledge of HTML / CSS / SASS (BEM, OOCSS, SMACSS, CSS3 Animations, Semantic HTML)
• Extensive experience in designing and developing enterprise grade software.
• Excellent verbal and written communication skills coupled with strong interpersonal and problem-solving skills.
• Time management skills with the ability to handle multiple assignments.

What's in it for you?

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove, and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.  
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance. 
• Competitive Rewards program including bonus, flexible vacation, personal, sick days, and benefits will start on day one.
• Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Work arrangements: Hybrid

#LI-Hybrid

#BFUTR

We are seeking an experienced Senior Data Engineer with deep expertise in Google Cloud Platform (GCP) to join our growing team. In this role, you will be responsible for designing, building, and maintaining scalable data architectures that support our data-driven initiatives. You will lead a team of engineers, collaborate with cross-functional teams including data architects, solution architects, business systems analysts and data engineers and ensure that our data infrastructure is robust, secure, and optimized for performance.

Is this role right for you? In this role you will:

• Develop and maintain robust data pipelines for data ingestion and distribution of large datasets for processing and consuming.
• Utilize SaaS services and tools to build, configure and automate data workflows and streamline the data engineering process.
• Collaborate with stakeholders and product managers to analyze data requirements, and build ingestion patterns to bring in new data sources to the data platform.
• Build and monitor application services and pipeline performance.
• Conduct data quality checks
• Experience building data pipelines, and composable cloud-based data platforms in Google Cloud Provider (GCP).
• Experience configuring and using data ingestion tools such as Fivetran, and Qlik Replicate
• Have prior experience with data engineering, programming, ETL, ELT, processes for data integration and ingestion.
• Experience in data modelling, manipulating large data sets and handling raw data, and other cleaning techniques.
• Experience working with structured, semi-structured, and unstructured data.
• Experience collaborating and working with DevOps and Scrum Teams
• Demonstrated team player with strong communication skills and a track record of successful delivery of product development.
• Expert at problem solving.
• Strong scripting skills (SQL, Python)
• Strong knowledge of cloud infrastructure

Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:

• 3+ years of experience building Data Warehouse / Data Platforms
• 3+ years of experience creating ELT / ETL data pipelines from scratch, working with structured, semi-structured, and unstructured data
• 2+ years of experience configuring and using data ingestion/ replication tools such as Fivetran, or Qlik
• 2+ years of experience with Cloud: GCP
• 2+ years of experience with Airflow
• 3+ years of experience working on continuous integrations and continuous deployment pipeline (CI/CD) and working with source control systems such as Github, Bitbucket, and Terraform

What's in it for you?

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.  
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance. 
• Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
• Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.
• Community Engagement - No matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Working location condition: Hybrid

#LI-Hybrid  

01/10/2025

Address:

33 Dundas Street West

Drives the overall software development lifecycle including working across functional teams to transform requirements into features, managing development teams and processes, and conducting software testing and maintenance. Specific project areas of focus includes translating user requirements into technical specifications, writing code and managing the preparation of design specifications. Supports system design, provides advice on security requirements and debugs business systems and service applications. Applies deep knowledge of algorithms, data structures and programming languages to develop high quality technology applications and services - including tools, standards, and relevant software platforms based on business requirements.

• Translates user needs into technical specifications by understanding, conceptualizing, and facilitating technical requirements from user.
• Analyzes, develops, tests, and implements new software programs, and documentation of entire software development life cycle execution.
• Performs preventative and corrective maintenance, troubleshooting and fault rectification of system and core software components.
• Ensures that code/configurations adhere to the security, logging, error handling, and performance standards and non-functional requirements.
• Evaluates new technologies for fit with the program/system/eco-system and the associated upstream and downstream impacts on process, data, and risk.
• Follows release management processes and standards, and applies version controls.
• Assists in interpreting and documentation of client requirements.
• Focus is primarily on business/group within BMO; may have broader, enterprise-wide focus.
• Exercises judgment to identify, diagnose, and solve problems within given rules.
• Works independently on a range of complex tasks, which may include unique situations.
• Broader work or accountabilities may be assigned as needed.

Qualifications:

Foundational level of proficiency:

• Creative thinking.
• Building and managing relationships.
• Emotional agility.
• Quality Assurance and Testing.
• Cloud computing.
• Technology Business Requirements Definition, Analysis and Mapping.
• Adaptability.
• Learning Agility.

Intermediate level of proficiency:

• Experienced in MS Power Platform (Power App & Power Automate) is a must
• Knowledge of .NET Language is preferred or some experience with Java
• Programming
• Applications Integration.
• Test Driven Development.
• System Development Lifecycle.
• Troubleshooting.
• System and Technology Integration.
• Verbal & written communication skills.
• Collaboration & team skills.
• Analytical and problem solving skills.
• Data driven decision making.
• Typically between 3-5 years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience.
• Technical proficiency gained through education and/or business experience.

$60,000.00 - $111,700.00

What is the opportunity?

In this role as a Senior Data Engineer, you will be responsible for development deliverables for the Finance Core Data Platform. The Platform, leveraging Hadoop Big-Data technologies, serves as the central repository of finance related datasets, with capabilities including the ingestion of positional/trade, sub-ledger, general-ledger trial balances, and reference data; as well as data enrichment, adjustment, reconciliation, analytics and reporting functions.

What will you do?

• Work with the Product Owner, Product Manager, and Development Lead to understand and determine best mix of development and technical solutions to meet business requirements and project objectives.

• Work on detailed design and development phases of project initiatives; identifying, tracking and resolving technical issues.

• Ensure design/development solutions are aligned to the data/architecture strategy.

• Ensure adequate technical/reference documentation and training is in place.

• Provide assistance to the application support team in troubleshooting and resolving production issues.

• Coordinate with the Quality Engineering team on all aspects of testing and verification, ensuring quality assurance testing is performed for all changes.

• Impart knowledge, benefit of experience, and mentoring to other members of the team.

Must-have:

• 3+ years’ experience with Scala, Spark,Python

• Solid experience (as evidenced by resume) with Apache Hadoop/Hive ETL/data-pipelines or other big-data platform technology/tools Cloudera

• Solid experience (as evidenced by resume) with SQL, Oracle/PL-SQL or any ANSI-compliant RDBMS platform preferred.

• Experience on Windows/Unix/Linux OS.

• Undergraduate degree/diploma in computer science/engineering or related technology discipline.

• Solid communication and time management skills.

Nice-to-have:

• Demonstrable experience with DevOps tools/technologies, including continuous integration/delivery tools and technologies such as GitHub, Jenkins, Synk, JIRA, Confluence, Airflow

• Demonstrable experience with containerization tools and technologies such as Docker, Kubernetes, Redhat OpenShift Container Platform (OCP).

• Experience with Capital Markets or other financial technology services’ middle/back office environments.

• Experience with/exposure to cloud technology platforms such as PCF (on-prem), AWS. Azure (off-prem).

• Experience with/exposure to Business Intelligence (BI)/Analytics/Reporting tools, such as Tableau, Datameer, Power BI, Presto, Snowflake, Apache Superset, etc.

• Experience with/exposure with Test driven development (TDD) and automated unit testing.

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

• Flexible work/life balance options Opportunities to do challenging work

• Opportunities to take on progressively greater accountabilities  

• This is a hybrid opportunity

#LI-Hybrid

#LI-Post

#LI-PK

Job Skills

Apache Spark, Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Python (Programming Language), Quality Management, Requirements Analysis, Scala (Programming Language), Structured Query Language (SQL)

Additional Job Details

RBC CENTRE, 155 WELLINGTON ST W:TORONTO

TORONTO

Canada

37.5

Full time

TECHNOLOGY AND OPERATIONS

Regular

Salaried

2024-12-16

2025-01-03

Contributes to the overall success of the Retail Customer Platform Technology applications ensuring specific individual goals, plans, initiatives are executed and delivered in support of the team’s business strategies and objectives. Ensures all activities conducted are in compliance with governing regulations, internal policies and procedures.

Is this role right for you? In this role you will:

• Champion a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.

• You will provide system analysis, object-oriented design / programming, technical documentation, and support for existing and new applications and systems.

• You will provide recommendations on best practices and enhancements that are in line with the bank’s technology road map.

• You will work with project team to refine technical requirements and provide technical design and guidance based on industry best practices.

• You will perform coding, unit testing, debugging, documenting, and implementing of applications and scripts.

• You will participate in estimation and planning of development efforts required for various projects and enhancements.

• You will maintain, support, and enhance existing applications.

• You will participate in regular code reviews for release activities.

• You will lead the implementation efforts for implementations of code to non-production and production environments.

• You will participate in production issue analysis and perform root cause analysis for production issues and implementation issues.

• You will assist the product owners and business analysts in discovering the current system behavior and provide recommendations on improving the current system.

• Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.

• Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk. 

• Champion a high-performance environment and contributes to an inclusive work environment.

Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

• Bachelor’s degree in Computer Science, Engineering, or related discipline is preferred.

• You have at least 3-5 years of technical working experience in systems analysis, design, development, unit testing, and debugging.

• Must have technical working experience with Core Java (Version 8 or higher)/Java

• Proficient in SQL & relational databases.

• Knowledge or experience in the use of GIT, Gradle, Jira, Confluence or a similar tool(s) for building Continuous Integration/Continuous Delivery (CI/CD) pipelines.

• Technical working experience in an agile environment.

• Working experience with Spring Boot, Spring Security and Spring Data Repositories, Spring Batch. At least one. Spring framework works.

• Technical working knowledge of Web Services, SOAP/REST, STS Spring Tools, or Eclipse Integrated Development Environment (IDE).

• Knowledge of SSL and setup of secure handshake between applications. It could be implicit. Technical knowledge of Microsoft Azure Cloud/Google Cloud and Splunk

Nice to Have:

• Oracle Certified Java Developer certification.

• Technical Knowledge of event driven architecture (Kafka, Kafka connectors, Kafka brokers).

• 2-3 years of working experience in the banking/financial services industry.

• Working knowledge of SoapUI.

What's in it for you?

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.

• Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.  

• Upskilling through online courses, cross-functional development opportunities, and tuition assistance. 

• Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.

• Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Work arrangements: Hybrid

#LI-Hybrid

As a Customer Experience Associate, you are the face, character and heart of our branches. Scotiabank is a place where we put our customers first, and our priority is to help them achieve their financial goals.

Our Customer Experience Associates are people-centric and  connect with customers in a relatable way. As an essential member of the Canadian Banking Branch network, the focus is to provide exceptional service throughout the customer’s journey by:

• Taking a proactive approach to discovering our customer’s needs and listening to understand what they are asking for
• Processing day to day transactions
• Nurturing rich, long-standing relationships
• Contributing to the Branch’s targets by identifying and fulfilling simple sales opportunities
• Being a technology expert and sharing your knowledge by introducing clients to our mobile banking applications and assisting them to better manage their banking needs

Is this role right for you?  In this role you will:

• Build strong customer relationships and deliver excellent customer service
• Uncover and solve customers’ needs
• Explain complicated concepts simply
• Demonstrate success in a target-based performance environment, as well as contribute positively to a team-oriented work environment
• Demonstrate an eagerness to learn and determination to succeed

Do you have the skills that will enable you to succeed in this role? – We’d love to work with you if you:

• Have proven customer service skills through work or community involvement
• Are willing to assist in a professional, friendly and efficient manner
• Are available to work a flexible schedule
• Are comfortable in simple sales situations
• Have strong technical skills and the ability to promote digital and self-service banking options to our customers

What’s in it for you?

• The opportunity to join a forward-thinking organization surrounded by a collaborative team of innovative thinkers
• A rewarding career path with diverse opportunities for professional development
• Internal training to support your career growth and enhance your skills
• An organization committed to making a difference in our communities – for you and our customers
• You can expect to be recognized and rewarded for high-performance. You’ll be supported by leadership through meaningful development conversations that enable faster advancement and internal training to support your growth and development.
• A competitive compensation and benefits package

GBME is searching for Java Software Engineers who are continuous learners and are eager to boost capabilities of capital markets products and analytics platforms. The role focuses mainly on backend development using Java / Spring Boot / RESTful API with potential opportunities for front end development. (Approx. 70/30 split)

The successful candidate will have a strong technical and engineering mindset.  You will work closely with business teams and cross functional engineering leaders to develop and implement market leading solutions for the various projects within GBME. 

Do you thrive when faced with challenges? Like using fresh technologies to solve problems? Looking to work in various projects across the organization, collaborating with great teams and inspiring leaders? Then this is the right team for you!  In this exciting role, you’ll apply your analytical skills to design and develop applications that deliver excellence, effectiveness, and value to our business partners and customers.

Is this role right for you? In this role you will:

• Work closely with end users, and business teams to understand business needs, conduct gap analysis and requirements assessments as needed
• Partner with Architecture on the design and integration
• Deliver and enhance new and current solutions and applications
• Be involved in the full life cycle of a project, responsible for producing actionable and complete specifications, writing production quality code, and implementation
• Design, deliver and implement a database schema
• Design test sets and automate where possible, including functional and non functional testing, regression testing as well as performance testing
• Write deployment scripts and leverage tools such as the Accelerator pipeline to promote code
• Support the solution in production (as needed)
• Improve the end user experience by finding scalable solutions and addressing complex ad hoc queries.
• Effectively communicate with technical and non-technical audiences
• Able to work with and refactor legacy code (as needed).
• Coach and train end users (as needed). 
• Participate and run SCRUM Meetings (as needed).

Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:

• 4+ years of recent experience in backend development (Specifically Java / SpringBoot )
• 4+ years of recent experience working with Python
• 4+ years of recent experience in Microservices and API development in an enterprise environment
• Working experience of database and SQL (e.g., Postgres, MSSQL, Oracle)
• Working experience with Shell scripting in Unix/Linux environments
• Working experience in an Agile environment, with experience and understanding of Test-Driven Development methodology
• Bachelor’s degree in computer science, Engineering or relevant experience.
• Capital Markets experience (Understanding of Front, Middle and Back office operations)
• Experience with Messaging Frameworks; IBM MQ/ Kafka/ Redis
• Experience working with real-time, high availability and low latency systems 
• Experience in Java multi-threaded applications
• Working experience with containerized systems in public cloud (Azure or GKE/GCP)
• Familiarity (understanding) with front-end technologies (e.g., Angular, React, JavaScript, HTML, CSS) 
• Excellent communication and presentation skills.
• Work as a contributing member of a team.
• Values quality, while still managing expectations and deliverables.
• Open to ideas and gives and receives feedback well. 
• Wants to understand financial market.
   

What's in it for you?

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans. 
• Accessibility and Workplace Accommodations - We value the unique skills and experiences everyone brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove, and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements. 
• Remote-friendly work environment will provide you with the flexibility to perform at your best. 
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance.   
• Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
• Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

What you’ll do:

The Senior Information Security Specialist, Governance and Compliance will lead the charge in maintaining cyber security policies and standards, responding to regulator and auditor inquiries, and providing an advisory function to the business surrounding cyber security governance.

• Provide senior level advisory services to cybersecurity, technology teams, and business team members, as required

• Create and maintain cyber security policies and standards

• Manage the cyber security policy exemption management processes by assessing policy exception requests, maintaining the exception workflows, and updating and keeping current the exception database

• Respond to external inquires regarding cyber security (e.g. ESG, regulators, etc.)

• Analyze and assess cyber security related business scenarios and prepares/presents position papers providing risk-based recommendations to assist the leadership team in making informed decisions

• Oversee and provide guidance on the cyber security configuration compliance management program for both on prem and cloud environments

• Oversee and provide guidance on the cyber security vulnerability, configuration & patch remediation management programs

• Oversee and provide guidance on the Cloud security compliance management program

• Design and perform annual reviews of configuration benchmarks for teams to follow for new and existing systems

• Keep current with ongoing trends and changes within the cyber security community

What you bring:

• University degree preferably in an IT related discipline

• CISSP, and/or CISM, and/or CISA, and/or CRISC designations would be an asset

• 8-10+ years experience in information security, and/or IT Audit/Compliance, and/or external audit

• Extensive experience with governance and risk policy review, creation, and implementation, particularly concerning Azure cloud

• Strong understanding of IT, cloud and cyber security concepts and best practices

• Strong technical writing skills for the creation of new security polices and controls

• Understands cyber security risks and control frameworks including NIST CSF, CIS, COBIT 5, PCI DSS, accepted CIS benchmark, MS Azure security benchmark and ISO 270001

• Extensive experience with Microsoft Azure Portal/Security Center to monitor and manage vulnerabilities, security policy compliance and all outstanding Microsoft recommendation

• Understanding of Agile concepts and practices

• Ability to communicate and influence effectively at all levels from technical staff to company leadership team

• Proven ability to weigh business needs with information security priorities and make sound risk-based judgement calls

• Experienced with analyzing and assessing cyber security related business scenarios, performing risk assessments, and preparing position papers outlining sound, risk-based recommendations

• Experienced with analyzing and assessing cyber security policy exception requests and providing risk-based recommendations

• Experience overseeing cyber security configuration compliance programs

• Experience overseeing cyber security vulnerability & patch management programs

• Experience overseeing Cloud security compliance management programs

• Experience with developing security baselines based on industry accepted CIS benchmark, MS Azure security benchmark, PCI DSS benchmark, etc. and conduct regular reviews to update existing custom baselines

• Experience with security assessment tools such as Tripwire, Nexpose, MS Defender, McAfee EPO, Kenna, etc.

• Technical knowledge including Linux, Windows, AIX, databases, network and security appliances and firewalls/IDS/IPS, web and cloud-based applications, secure coding practices, and cloud security

• Highly proficient with MS Office suite of products

Hybrid

We value flexibility. We have adopted a hybrid work model whereby employees use a combination of working in office and virtually in service of outcomes. Each leader is empowered to decide what work is best achieved in person based on the unique needs of their team.

What is the opportunity?

RBC is looking for an experienced SQL server DBA specialist with minimum of 10+ years of working experience. We are looking for someone provide application DBA support and services but also lead initiatives across the group.

This is an exciting position working with SQL server as leading initiatives in the group as well working with the databases in cloud.

We are looking for someone within local Toronto area as this is Hybrid working from office position.

Data and Analytics (DNA) team is looking for a SQL Server DBA Specialist.  The DBA will oversee predominately on-prem 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 SQL server.  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

• A minimum 10+ years of IT operation with strong understanding of SQL server database Architect, structures, theories, principles, and practices. A minimum 10+ years of proven working experience in Microsoft SQL Server technology at database administrator specialist capacity and current on SQL Server releases (i.e. SQL Server 2012, 2014, 2016, 2017, 2019)

• Knowledge on Database Architecture and able to understand the need to redesign as per best practices.

• Expert knowledge to analyze performance issue, identify tuning opportunities, implement improvements and advise developers on SQL Server as well as expert knowledge of support and maintaining SQL server on Windows platform 

• 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. Experience with High Availability (i.e. FCI, Always On), data management and data processing flowcharting techniques.

• Deep knowledge and understanding of DB architecture for workload specific configurations.

• Good understanding of the organization’s goals, objectives, interpersonal, written, and oral communication skills.

• Ability to present ideas in user-friendly language. Strong root cause analysis, Self-motivated and directed, with keen attention to detail. TSQL, Power-shell, CLI and coding expertise.

• Able to prioritize and execute tasks in a high-pressure environment.

• Experience working in a team-oriented, collaborative environment.

• Ability to work towards proactive solutions.

• An expert Knowledge of Indexes and Index Management Ability to use Performance Monitor to gather Metrics to define baselines.

• Experience using SQL Profiler and examining Execution Plans. Willingness to learn in new technologies.

Nice-to-have

• Some knowledge of public cloud (i.e. Azure, AWS RDS) and containerization.

• 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

• 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

• Opportunities to do challenging work.

• 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-Post

#LI-KAS

#LI-Hybrid

#TECHPJ

Job Skills

Customer Service, Customer Service Management, Detail-Oriented, Industry Knowledge, Information Technology Trends, IT Standards, IT Systems Integration, Resource Coordination, Service Platforms, Time Management

Additional Job Details

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO

TORONTO

Canada

37.5

Full time

TECHNOLOGY AND OPERATIONS

Regular

Salaried

2024-11-29

2024-12-31

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

If you are passionate about leading the delivery of high quality information technology solutions, you will contribute, oversee and advise the Software Testing and Quality Assurance practice for a diverse array of Technology Services, projects and operational initiatives when you join the City of Toronto as a Quality Assurance Integrator.

As a Quality Assurance Integrator (Quality Assurance Lead), you will bring subject matter expertise to technically lead the modernization of the Quality Assurance (QA) practice at the City of Toronto. In this role, you will be responsible for defining test strategies, providing technical advice in the planning, designing and testing of technology solutions with an emphasis on test automation in Agile, DevOps and traditional (waterfall) environments. You will rely on strong functional/technical expertise and skills to effectively evolve manual software testing practices to the implementation of automated test scripting. You will also help ensure user expectations are met during the testing process, by maintaining a strong customer focus. When advising projects, you will utilize your interpersonal communication skills and work effectively with team members across the organization.

Major Responsibilities:

Your responsibilities as a Quality Assurance Integrator (Quality Assurance Lead) will be varied. Specifically, you will:

• Perform a key role in supporting and elevating the software Quality Assurance (QA) practice through the development of an effective Test Automation Framework based on QA principles, best practices and industry standards in environments where Agile (Scrum, Kanban), CI/CD, DevOps and traditional Waterfall methodologies are utilized.
• Leverage technical knowledge and experience to help design, guide and review all layers of Test Automation in every stage of the development cycle, such as Unit, Functional, Component, Integration etc., and supporting the implementation of a TDD/BDD development model amongst others.
• Collaborates and works closely with Program Management Offices and operational (sustainment) initiatives to devise quality strategies for the effective delivery of solutions in compliance with QA policies, standards and procedures. Provides reports on tests results, provides feedback and raises any issues or concerns that could have implications in the delivery of solutions.
• Advises on the development, maintenance and execution of Test Automation practices for, functional, regression, integration and end-to-end testing.
• Recommends software test automation approaches based on project needs and sustainment plans.
• Leads the establishment of a performance measurements model for overseeing end-to-end quality control and compliance in the delivery of technology solutions. Perform regular audits to ensure proper adherence to QA process and standards.
• Provide critical insight and develop reports on quality measurements (KPIs) and QA compliance to drive discussions towards quality improvement.
• Oversee or execute as required performance (load/stress) testing activities using existing or new tools. Interpret test results, produce reports and report back any significant risk concerns.
• Supervise, motivate and train staff, ensuring effective teamwork, high standards of work quality, continuous learning and innovation.
• Manages, leads and/or oversees as required the Software Quality Assurance component of large IT initiatives.
• Collaborates with project teams on the definition of test strategies and test plans to ensure the final product meets the clients' requirements.
• Manages, advises and/or oversees on the User Acceptance Testing procedures and Quality Assurance measures for projects and attends project meetings as required.
• Ensures that a proper gating criterion is applied through the execution of the project. Checks for compliance as it receives the Development team's unit and sub-system integration testing results.
• Supervise the day-to-day operation of all assigned staff including the scheduling, assigning and reviewing of work; authorize and coordinate vacation and overtime requests; and monitor and evaluate staff performance, approve salary increments, hear grievances and recommend disciplinary action when necessary.
• Provide input when required into the assigned budget. When requested ensure that expenditures are controlled and maintained within approved budget limitations.
• Lead different forums such as communities of practice, working groups, etc. where sharing knowledge/technical expertise with fellow QA team members is required.
• Recommend and implement quality assurance requirements consistent with the Municipal Freedom of Information Privacy and Protection Act (MFIPPA) as well as corporate and legislated standards related to confidential data.
• Provide leadership during the procurement process related to evaluating, and recommending technical solutions with regards to quality assurance.
• Propose and implement plans in support of continuous process improvements including opportunities to enhance the Software Testing Methodology, QA Standards, process and procedures.

Key Qualifications:

Your application for the role of Quality Assurance Integrator (Quality Assurance Lead) should describe your qualifications as they relate to:

1. Post-Secondary education in Computer Science or in "STEM" (Science, Technology, Engineering and Math) disciplines, Electronic Engineering or equivalent and considerable experience working within an organization with a Quality Assurance Center of Excellence or on large-scale information technology projects.
2. Extensive progressive experience in a lead Quality Assurance role for large, complex IT solution delivery projects within a mixed environment setting (web based, cloud based, mobile, etc.) with hands-on experience in all facets of QA testing (unit, functional, integration, system, regression, performance and acceptance) in an Agile, DevOps, CI/CD and traditional waterfall (SDLC).
3. Extensive experience in using Test Automation and in building Test Automation frameworks applicable to Agile, CI/CD and SDLC software delivery models with focus on all layers of Test Automation (i.e. Unit/ UI/ Component/ Integration/ System/ End-to-End) leveraging commonly used tools (i.e. Micro Focus-UFT, Selenium, etc.) in various platforms.
4. Considerable experience working in a SCRUM and Kanban agile software development environment overseeing QA activities reviewing and analyzing business requirements, functional specifications and/or User Stories.
5. Experience using Defect tracking and Test Management tools JIRA, X-Ray, Visual Studio, Confluence,  OpenText ALM etc.), performance (load/stress) testing tools (Jmeter, Load Runner Enterprise, etc.) and other relevant technologies such as, Cucumber Testing Tool (BDD), Gherking language, Serenity (BDD), GitLab, etc. that enable a "Shift-left" testing mindset.
6. Experience in developing test scenarios, test cases, test scripts and test data, executing the tests and analyzing the test results, recording bug/defects and issuing and assigning preliminary severity level in a Defect Tracking System.
7. Solid understanding of System Development Life Cycle, Defect Life Cycle and Testing Life Cycle with a strong knowledge and/or experience with manual testing practices.
8. Excellent verbal and written communication skills, able to effectively communicate in cross functional groups. Comfortable working in a fast-paced dynamic environment.
9. Expert problem solving and effective analytical skills with strong attention to detail.
10. Excellent organization and time management skills, as well as strong influencing and negotiating skills to achieve results.
11. Certification in Software Quality Engineering or equivalent is an asset.