Job Description
Requisition ID: 223337
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
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 Dynamic Fund systems.
Maintain a technical proficiency with respect to programming languages and processes to ensure that Dynamic Funds 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 can formally document designs and implementations.
You are familiar with asset management/financial sector data domain knowledge.
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?
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
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.
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
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 Dynamic Fund systems.
Maintain a technical proficiency with respect to programming languages and processes to ensure that Dynamic Funds 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 can formally document designs and implementations.
You are familiar with asset management/financial sector data domain knowledge.
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?
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
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.
💡 Quick Summary
Seeking a career-building opportunity? The Database Developer position is now open for candidates interested in the Bank Jobs sector. This role in Toronto offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Bank Jobs is a plus.