Développeur senior de bases de données Oracle et SQL Server Senior Oracle &

at  Intrado Life Safety Inc

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.
Aujourd’hui, notre entreprise de logiciels en tant que service (SaaS) de pointe est à l’avant-garde de la transformation du continuum des interventions d’urgence du service 911, grâce à des logiciels fondés sur des données de prochaine génération. Les solutions d’Intrado permettent aux entreprises, aux préposés aux appels, aux répartiteurs et aux premiers intervenants de prendre des décisions plus éclairées, d’intervenir rapidement et de façon sécuritaire et, ultimement, de mieux desservir leurs communautés.
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.
Responsibilities/Qualifications:
Nous recherchons un Développeur senior de bases de données Oracle et SQL Server expérimenté, ayant une solide expertise en bases de données, pour concevoir, mettre en œuvre et maintenir des systèmes logiciels robustes. Ce poste exige une expérience pratique en développement et gestion de bases de données, garantissant leur fiabilité, évolutivité et performance.
Ce rôle est hybride, avec une présence au bureau trois (3) jours par semaine. Le bureau est situé au : 7150 rue Alexander Fleming, St-Laurent, QC.

JOB SUMMARY:

We are seeking an experienced Senior Oracle & 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. This role will ensure the reliability, scalability, and performance of databases.

REQUIRED SKILLS AND EXPERIENCE:

• Bachelor’s/Master’s degree in Computer Science, Information Technology, or a related field. Equivalent work experience may be substituted for education.
• 5+ years of experience in installation, configuration, and administration of Oracle and SQL Server databases.
• Oracle RAC with ASM experience strongly preferred
• Proficiency in database scripting languages (PL/SQL, T-SQL,pgSQL).
• Proficiency in Unix scripting (bash, k-shell, c-shell). Experience with Python and/or Windows PowerShell is a plus.
• Experience with database design, performance optimization, and query tuning.
• Solid 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.
• Experience with big data technologies like Hadoop, Spark is a bonus.
• Knowledge of DevOps practices and CI/CD pipelines for data engineering helpful.
• 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 to work effectively with technical and non-technical stakeholders.
• Ability to work independently while contributing to team objectives.
• Ability to work cross functionally with multiple teams
  Total Rewards:
  Vous voulez aimer là où vous travaillez? Chez Intrado, nous offrons un régime complet d’avantages sociaux qui comprend ce que vous attendez (assurance médicale, assurance dentaire et assurance des soins de la vue, assurance-vie et assurance invalidité, congés payés, régime enregistré d’épargne-retraite (REER) avec cotisations égales de l’employeur et compte de gestion de dépenses flexible), et plusieurs avantages qui excèderont vos attentes, tels que le remboursement de frais de scolarité, des congés parentaux payés, l’accès à une bibliothèque complète de ressources de formation personnelle et professionnelle, des rabais d’employés, des assurances couvrant et plus encore! Postulez dès aujourd’hui pour vous joindre à nous dans un travail qui en vaut la peine!
  Want to love where you work? At Intrado, we offer a comprehensive benefits package that includes what you’d expect (medical, dental, vision, life and disability coverage, paid time off, a Registered Retirement Savings Plan (RRSP) with employer matching contributions plan and flexible spending accounts), and several that go above and beyond – tuition reimbursement, paid parental leave, access to a comprehensive library of personal and professional training resources, employee discounts, insurance coverage and more! Apply today to join us in work worth doing

KEY RESPONSIBILITIES:

• Database Management & Design:
• Design, implement, and maintain relational databases Oracle RAC with ASM and SQL Server (MySQL, PostgreSQL, NoSQL databases is a plus.). This will include installation and configuration of database software.
• Experience with Always On Availability Groups is a plus.
• Experience with Replication, including GoldenGate and/or Shareplex is a plus.
• Ensure database integrity, security, and performance optimization.
• Assist developers in writing and optimizing complex SQL queries and database code (stored procedures, functions, and triggers).
• 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 and design databases for developers to utilize both on prem and cloud.
• Cloud-based data warehouses, data lakes, and other storage systems experience a plus.
• Ensure high availability, performance, and scalability of data platforms.
• Collaboration:
• Partner with business teams and application support/architect teams to identify data requirements and provide technical solutions.
• Serve as a technical mentor to application developers and support the team’s professional growth.
• Data Quality & Governance:
• Establish and enforce data quality standards and best practices.
• Implement monitoring and alerting systems to ensure data integrity and consistency.
• Collaborate on data 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.

Leadership & Mentorship:

• 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, including sprint planning, stand-ups, and retrospectives.
• Troubleshooting & Support:
• Investigate and resolve database software defects and performance issues.
• Provide technical support for database-related incidents.