Développeur senior SQL Server (Sr SQL Database Developer)

Intrado; Montreal; On-site; CAD 90,000 - 120,000; Full time

Job summary

Une entreprise technologique recherche un Développeur de Bases de Données Senior SQL Server pour concevoir et maintenir des systèmes logiciels robustes. Le candidat idéal possède plus de 5 ans d'expérience en gestion de bases de données et une maîtrise du T-SQL. Ce poste nécessite des compétences en collaboration et optimisations de performance. Un package d'avantages complet est offert.

Benefits

Couverture médicale

MBF de retraite avec correspondance de l'employeur

Remises pour employés

Qualifications

• 5+ années d'expérience avec les bases de données SQL Server et Oracle.
• Capacité à travailler avec des équipes techniques et non techniques.
• Connaissance des principes de design logiciel et des algorithmes.

Responsibilities

• Concevoir et maintenir des bases de données relationnelles.
• Collaborer avec les équipes pour traduire les exigences métier en solutions techniques.
• Établir des normes de qualité et des meilleures pratiques pour les données.

Skills

Administration de bases de données

T-SQL

Optimisation des performances

Collaboration en équipe

Education

Baccalauréat/Master en Informatique

Tools

SQL Server

Oracle

Python

Git

Job description

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

About Us

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.

Job Summary

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.

Responsibilities

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

Qualifications

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

Preferred Skills

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

Soft Skills

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

Benefits

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