Sql jobs in Canada

Get AI-powered advice on this job and more exclusive features.

Intrado se consacre à sauver des vies et à protéger des communautés, en les aidant à se préparer pour des événements critiques, à intervenir lorsqu’ils surviennent, et à s’en rétablir. Intrado is dedicated to saving lives and protecting communities, helping them prepare for, respond to, and recover from critical events. Today, our cutting-edge SaaS company is at the forefront of transforming the 911 emergency response continuum with next generation data-driven software. Intrado’s solutions allow enterprises, call takers, dispatchers, and first responders to make more informed decisions, respond quickly and safely, and ultimately serve their communities better.

We are seeking an experienced Senior SQL Server Database Developer with strong databases experience to design, implement, and maintain robust software systems. This role requires hands-on experience with database development and management to ensure reliability, scalability, and performance of databases.

• Database Management & Design: design, implement, and maintain relational databases (SQL Server; knowledge of MySQL, PostgreSQL and NoSQL databases is a plus). Install and configure database software. Experience with Always On Availability Groups and replication. Ensure integrity, security, and performance optimization. Assist developers in writing and optimizing complex SQL queries and database code (stored procedures, functions). Design and maintain database schemas and architecture.
• System Architecture: design scalable and maintainable database architectures. Collaborate with stakeholders to translate business requirements into technical solutions. Recommend improvements for system performance and development processes.
• Data Architecture & Storage: build databases for developers on prem and in cloud. Cloud-based data warehouses, data lakes, and other storage systems experience is a plus. Ensure high availability, performance, and scalability of data platforms.
• Collaboration: partner with business teams and application support / architecture teams to identify data requirements and provide technical solutions. Serve as a technical mentor to application developers and support the team’s growth.
• Data Quality & Governance: establish and enforce data quality standards and best practices. Implement monitoring and alerting to ensure data integrity and consistency. Collaborate on governance policies including access controls, security, and compliance with industry standards.
• Technical Expertise: optimize existing systems for performance and cost efficiency. Evaluate and recommend new technologies to improve the data engineering ecosystem. Provide database leadership and guidance to developers. Review database code when requested and promote best practices for code quality and security. Participate in Agile / Scrum ceremonies and contribute to sprint planning, stand-ups, and retrospectives. Troubleshooting & Support: investigate and resolve database defects and performance issues; provide technical support for database-related incidents.

• Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field. Equivalent work experience may be substituted.
• 5+ years of experience installing, configuring, and administering Oracle and SQL Server databases.
• Proficiency in T-SQL (PL / SQL and pgSQL are advantages).
• Experience with Python and / or Windows PowerShell is a plus.
• Experience with database design, performance optimization, and query tuning. Strong understanding of data structures, algorithms, and software design principles.
• Familiarity with version control systems (e.g., Git, Subversion).

• Knowledge of microservices architecture and cloud platforms (AWS, Azure, GCP) is a plus.
• Big data technologies (e.g., Hadoop, Spark) are a bonus.
• Knowledge of DevOps practices and CI / CD pipelines for data engineering.
• Understanding of data security, GDPR, and other compliance frameworks.

• Ability to mentor and lead technical teams.
• High attention to detail and ability to meet deadlines.
• Strong analytical and problem-solving abilities.
• Excellent communication and collaboration skills with technical and non-technical stakeholders.
• Ability to work independently while contributing to team objectives and collaborate cross-functionally with multiple teams.
• Fluency in English (written and spoken) as interactions with USA teams are frequent.

We offer a comprehensive benefits package including medical, dental, vision, life and disability coverage, paid time off, RRSP with employer matching, and flexible spending accounts. Additional benefits include tuition reimbursement, paid parental leave, access to training resources, employee discounts, and more.

J-18808-Ljbffr