Sql dba Jobs in North York, ON

Is this role right for you?

In this role you will:

• Design, develop, test, and support enterprise applications and services.

• Develop scalable solutions using Python and SQL.

• Build and optimize complex database queries, stored procedures, and data pipelines.

• Design and implement APIs, integrations, and distributed processing solutions.

• Contribute to application architecture, technical design, and engineering best practices.

• Perform code reviews and drive continuous improvement in software quality.

• Troubleshoot production issues and implement long-term solutions.

• Collaborate with cross-functional teams to deliver technology initiatives.

• Participate in incident investigation, root-cause analysis, problem management, and implementation of permanent corrective actions.

• Improve application observability through logging, monitoring, alerting, performance metrics, and operational dashboards.

• Design solutions with appropriate resiliency, recovery, availability, and supportability requirements.

• Develop automated unit, integration, regression, and performance tests.

• Build reusable components and promote consistency across engineering teams.

• Design and support reliable batch and real-time data pipelines.

• Implement appropriate data-quality checks, reconciliation, exception handling, lineage, and monitoring.

• Ensure data interfaces are traceable, supportable, and aligned with enterprise data standards.

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 a related field.

• 7+ years of software development experience.

• Strong proficiency in Python.

• Advanced knowledge of SQL, database design, and query optimization.

• Experience developing scalable, enterprise-grade applications.

• Strong analytical, problem-solving, and communication skills.

• Experience with Java.

• Experience developing and consuming REST and SOAP web services.

• Experience with Angular.

• Experience with Apache Kafka and event-driven architectures.

• Experience with Apache NiFi and data integration solutions.

• Familiarity with Agile development methodologies and CI/CD practices.

• Experience with CI/CD pipelines, automated deployments, environment configuration, and release controls.

• Experience working with capital-markets, Prime Brokerage, securities lending, trading, risk, margin, settlement, reference-data, or regulatory-reporting platforms is an asset.

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 - We offer opportunities for community engagement & belonging with our various programs such as hackathons.