Job Information
Scotiabank Database Developer - Tangerine in Toronto, Ontario
Database Developer - Tangerine
Requisition ID : 202620
Tangerine is Canada’s leading direct bank. We offer flexible and accessible banking options, innovative products, and award-winning Client service. The reason why Tangerine employees come to work each day is to help Canadians live better lives. We focus on making a difference in our communities, and that includes our own internal community. It’s important to us that our employees feel empowered and enthusiastic about belonging to our Orange culture.
As Canada’s leading digital bank, Tangerine technology is at the heart of everything we do. We have redefined what digital banking is, and we continue to evolve to tackle any opportunity and face every challenge through progressive technology and the power of collaboration.
Do you like new challenges? Are you ready to reach new heights in your career and become part of an established disruptor? If so, come join us and help redefine the Canadian banking landscape!
What you will be doing:
As a Database Developer, you will be responsible for the enhancement, development and maintenance of the corporate ebusiness and banking systems.
Is this role right for you? In this role, you will:
Write, test, debug, maintain, document and deploy SQL statements, scripts, PL/SQL blocks, triggers, views, BULK Collections, stored procedures.
Design and build database component for growing banking application.
Write technical specifications.
Prepare and execute test scripts, document and analyze results.
Prepare SQL Loader script.
Investigate and fix bugs, defects, data issues, etc.
Perform routine maintenance and/or support operations.
Work closely with the development team to provide database components.
Be able to quickly answer questions regarding functionality and/or features of existing applications and/or scripts.
Have a strong understanding of latest Oracle/SQL Server Database, PL/SQL.
You will have good knowledge of MS SQL Server and SQL/store procedures development.
Participate in and support analysis, design, testing, implementation and maintenance of enhancements to Tangerine banking systems.
Maintain a technical proficiency with respect to programming languages and processes to ensure that Tangerine is well positioned for technological advances in the marketplace.
Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:
You have 3-5 years of experience in Oracle PL/SQL development (server side).
You have 3-5 years of experience with Oracle/SQL Server database.
You have 2-3 years of experience in Data Modeling (OLTP/OLAP).
You are well versed in development lifecycle and object-oriented development methodologies.
You are competent in enterprise application delivery and design techniques.
You have excellent communication and documentation skills.
You have good troubleshooting and problem solving skills.
You have application performance tuning experience.
You are familiar with Unix Shell Script.
You are familiar with TOAD.
You are familiar with GIT or any other version control tool.
You are able to formally document designs and implementations.
You must be able to handle multiple projects/Agile squads at one time.
You are familiar and comfortable with formal software development and testing processes.
Oracle DBA experience considered an asset.
You are familiar with Agile methodology.
What's in it for you?
You will be part of a diverse and inclusive team of Client-focused go-getters looking to learn from each other in an environment that celebrates and recognizes success!
You will have access to thousands of online and in person courses so you can shape your career growth with the support from diverse industry leaders.
You will get our help to save for your future and to invest in your total wellbeing through our Tangerine benefits*.
You belong here, we are equal and un-complicated. Bring your true self to work, dress codes don’t apply here.
You will enjoy workspace flexibility and all the excitement that comes from working at the official Bank of the Toronto Raptors.
*Tangerine employees participate in Scotiabank’s pension & benefits programs (available to permanent employees)
Location(s): Canada : Ontario : Toronto
At Tangerine we value the unique skills and experiences each individual brings to the team, and are committed to creating and maintaining an inclusive and accessible environment. If you require accommodation during the recruitment and selection process, please let our Recruitment team know.