Database Engineer

Job Responsibility:

Requisition ID: 223451 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

The Team Contributes to the overall success of the Core Banking Engineering Database Services -SQL Server & Cloud EngineeringTeam 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.

Database Services manage, maintain and optimize critical enterprise database systems for Canadian Banking Technology, International Banking Systems, Global Finance Technology, and Digital Factory. We deliver 24/7, year-round support to production databases on both cloud and on premise.

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.
• Design, develop & test enhancements and support MS SQL, Azure SQL DB and Azure MI database systems.
• Provide technical analyses and recommendations in terms of new solutions and supporting existing ones.
• Ability to translate meta data and/or requirements into a DB design and understand the impacts of the design in terms of DB performance so we can ensure the full solution is optimal.
• Develop DDL/DML scripts and enhance DB performance (queries, stored procedures, views, data distribution patterns, etc.).
• 24x7 pager support on a rotating basis.
• Able to work individually or as part of a team.
• Possess good technical presentation and communication skills.
• Desire to keep up with new technological innovations.
• Willingness to be accountable/responsible for assigned tasks/projects.
• Ability to prioritize work in a fast-paced environment.
• 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:

• Undergraduate Degree in Computer Science or technical equivalent
• Must have at least 5 years of experience as a Database Analyst/Database Engineer/Application DBA supporting MS SQL, Azure SQL DB, Azure MI, CloudSQL
• Experience working with remote teams.
• Experience developing ETL solutions with SSIS or Data Factory is an asset.
• Ability to contribute in Agile environments with understanding of its methodologies (Scrum/Kanban) and its tools (Jira, Confluence, Azure DevOps).
• Understanding the use of Source Code Management for tracking database scripts using Git or TFVC and its tools (Bitbucket and Azure DevOps).
• Understanding the impact of data encryption in database solutions using Always Encrypted and/or Tokenization.

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 egagement & belonging with our various programs such as hackathons and much more!

Work conditions: Hybrid

#LI-Hybrid

Location(s): Canada : Ontario : Toronto Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets. At Scotiabank, 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. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.