Senior Database Developer, Oracle

Scotiabank; Toronto; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Performance bonus

Pension matching

Profit sharing

Generous vacation

Job summary

Scotiabank is seeking a Senior Database Developer (Oracle) in Toronto. You will support and deliver system solutions for financial crimes and enterprise case management, collaborating with AML operations, compliance, and architecture teams.

The role requires 5+ years designing database objects, strong SQL, and UNIX shell scripting. Familiarity with Oracle products (FDSM, FCCM, OFSAA) is a plus and you will work with JIRA, Git, Bitbucket, and Confluence.

Qualifications

• 5+ years designing and implementing database objects (tables, views, stored procedures, indexes)
• Strong SQL for ad-hoc data analysis
• Advanced shell scripting (bash, ksh) and cron scheduling
• UNIX-family OS knowledge
• Excellent communication, teamwork and problem solving
• Experience with Jira, Git, Bitbucket, Confluence
• Working knowledge of Oracle products (FDSM, FCCM, OFSAA) is a plus

Responsibilities

• Gather requirements, design and build new features
• Collaborate with the product owner and project teams
• Ensure optimal performance, quality and responsiveness of applications
• Identify bottlenecks and bugs and implement solutions
• Understand lifecycle and enterprise developer tools

Skills

SQL queries

Shell scripting

UNIX

Collaboration

Troubleshooting

JIRA

Git

Tools

JIRA

Git

Bitbucket

Confluence

Oracle tools

Job description

Select how often (in days) to receive an alert:

Title: Senior Database Developer, Oracle

Requisition ID: 273689

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

The Team

Our team is responsible for the systems that enable financial crimes identification (Customer Risk Ratings) and vendor-based case management (Enterprise Case Management) for all of Scotiabank worldwide.

These systems support over 1500 users globally and are critical in the fight against financial crimes.

The Role

The Senior Database Developer is a key position in the Financial Crimes Technology team, responsible for supporting and delivering system solutions. The successful candidate will work closely with various stakeholders including business partners in Anti-Money Laundering Operations, Compliance, business analyst, architecture, and infrastructure and support to understand business requirements and drive the analysis and design of quality technical solutions that best support the business need.

Some of the key accountabilities include:

• Gather requirements, design and build new features
• Collaborate with the product owner, project manager and other relevant teams
• Ensure best possible performance, quality and responsiveness of the applications
• Identify bottlenecks and bugs, and devise solutions to these problems
• Excellent understanding of developer life cycle and enterprise developer tools

What You Will Bring to Succeed

• 5+ years experience designing and implementing database objects, including tables, views, stored procedures, indexes, functions and constraints
• Strong knowledge and experience writing complex SQL queries for ad-hoc data analysis
• Advanced knowledge of shell scripting – bash, ksh and task scheduling systems – cron, autosys
• General knowledge of UNIX-family operating systems
• Strong communication, teamwork and problem-solving skills
• Working knowledge of JIRA, Git, Bitbucket, Confluence
• Working knowledge of Oracle products (FDSM, FCCM, OFSAA) would be a great asset

The Workplace

• We are technology partners who help the business transform how our employees around the world work
• We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!
• You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world
• We foster an environment of innovation and continuous learning
• We care about our people, allowing them to design how they work to deliver amazing results
• We offer a competitive total rewards package, including a performance bonus, company matching programs (on pension & profit sharing), and generous vacation

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. 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.