MONTREAL Hybrid

WHO WE ARE

As the founding entity of RAINBOW PARTNERS, Quanteam is a consulting firm specializing in Banking, Finance, and Financial Services. Guided by our core values of closeness, teamwork, diversity, and excellence, our team of 1,000 expert consultants, representing 35 different nationalities, collaborates across 10 international offices: Paris, Lyon, New York, Montreal, London, Brussels, Geneva, Lisbon, Porto, and Casablanca.

We are currently looking for a Senior DBA MS SQL to join one of our major financial clients in Montreal.

CONTEXT AND ROLE OBJECTIVES

The IT infrastructure division is responsible for supporting a wide range of IT services. The mission is to provide business divisions with secure and reliable infrastructure, including hosting business applications, offering cloud solutions, and managing connectivity and digital workplace services, while also contributing to the organization's digital transformation.

The Database Administration (DBA) department provides hosting services and expertise for major database technologies, including MS SQL Server, Oracle, Sybase, PostgreSQL, and Big Data solutions. The DBA team operates in multiple regions, maintaining high service levels in critical environments across the Americas, Europe, and Asia, and supporting business partners with their database-related needs. In this context, we are looking for a MS SQL Server Database Administrator to join the team.

The role involves supporting the existing infrastructure, assisting clients with database-related projects, and contributing to the development of automation tools and APIs.

DAY-TO-DAY RESPONSABILITIES

• Install, configure, manage, and maintain MS SQL Server databases

• Ensure database health, high availability, performance tuning, optimization, operational control, and inventory management

• Work closely with developers and application support teams to provide technical assistance

• Participate in on-call rotations, handling alerts and escalations during business and off-hours, including weekends and holidays

• Set up and maintain database backup and recovery procedures (AlwaysOn, Backup/Restore, Log Shipping)

• Provide and maintain technical documentation

• Support and implement database changes while ensuring change control and quality assurance adherence

• Perform capacity and growth planning

• Contribute to team strategy, tool development, and process improvement initiatives

PROFILE

Experience Required:

• 5+ years of hands-on experience administering MS SQL Server databases

• Strong knowledge of HA/DR, performance tuning, and production operations

• Experience with automation and scripting (PowerShell required)

• Experience supporting critical, large-scale database environments

Technical Expertise:

• Strong experience administering MS SQL Server (2016–2022) in enterprise environments

• Experience with High Availability and Disaster Recovery solutions: AlwaysOn Clustering, Log Shipping, Replication, Mirroring

• Knowledge of Oracle, Sybase, or PostgreSQL environments is an asset

• Proficiency in Windows Server and Linux environments

• Strong scripting/programming skills: PowerShell, Python, Shell

• Experience with performance tuning, query optimization (execution plans, indexing strategies), and troubleshooting

• Familiarity with underlying storage and networking components related to database infrastructure (SAN, EMC, RAID, etc.) Development & Automation:

• Experience building automation and orchestration scripts for operational tasks

• Familiarity with CI/CD, version control (Git), and DevOps-oriented database processes

• Experience creating or using API-driven automation and monitoring tools

Additional Skills (Nice to Have):

• Experience with cloud-based database platforms (Azure SQL, AWS RDS, GCP Cloud SQL)

• Knowledge of PostgreSQL, Sybase, Cassandra, or MySQL

• Experience with job scheduling platforms (UC4/Autosys, SQL Agent, Control-M)

Soft Skills & Competencies:

• Proven experience working in large-scale, high-availability production environments (preferably in financial services)

• Ability to manage multiple tasks simultaneously in a fast-paced environment

• Strong analytical and problem-solving skills with a proactive approach

• Excellent communication skills, able to explain technical topics clearly to various audiences

• Team-oriented mindset with the ability to work independently when needed

Other:

• Candidates must be located in or willing to relocate to Montréal

• Fluency in English required; French is a strong plus

• Hybrid role: 4 days on-site per week

• Participation in on-call rotations, including evenings/weekends