Senior Sql Database Administrator

2 months ago


Montreal Quebec, Québec, Canada Experience AI Solutions Full time

Senior DBA


Start Date: as soon as possible

Type of employment: permanent

Location: Montreal, QC (hybrid position; 3 days onsite per week)

Number of Positions: 1

Language skills: Excellent English language skills

Perks: work for a multinational, award winning, socially responsible company with an operational presence in many countries, having been in business for over 75 years. It is a culturally diverse environments, employing thousands of people around the world, with beautiful downtown offices.


As a Senior Database Administrator, you have the responsibility of administrating, monitoring, and troubleshooting a 24x7 production environment’s database servers and associated infrastructure. This role is with other team members to ensure 100% uptime, plan future capacity requirements, maintain security, and apply updates.

You will also solve exciting technical challenges by analyzing, troubleshooting, and designing vital services, platforms, and infrastructure while always thinking about reliability, scalability, resilience, security, and performance.


Principal Duties and Responsibilities:

  • Extensive and demonstrable experience as a DBA in large-scale MSSQL environments
  • Hands-on experience in managing high volume instances of highly available PostgreSQL configurations
  • Build and establish policies and procedures related to data security and integrity; monitor and limit database access as needed
  • Document the company's database environment
  • Knowledge of database storage engines and master-slave replication principles and practices
  • Good communication and co-ordination skills and ability to work effectively under pressure


Education: University degree, preferably in Computer Science, Computer Engineering, Mathematics or similar.

Required Skills:

· Strong and demonstrable experience as DBA in large-scale PostgreSQL or MSSQL environments

· Experience with site reliability

· Experience with VMware, as well as cloud (Azure, AWS)

· Documented hands-on expertise managing high-volume instances of PostgreSQL setups featuring high availability Linux shell scripting and general Linux system administration experience Strong problem-solving skills, with the ability to get to the route of an issue quickly

· Develop and establish policies and procedures related to data security and integrity; monitor and limit database access as needed.

· Ensure all database servers are managed to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).

· Document the company’s database environment.

· Experience in writing automation scripts, building application dashboards for proactive monitoring using Ruby, PowerShell, Python scripting or similar technologies, ability to debug and optimize code and automate routine tasks

· Experience with database storage engines and master-slave replication principles and practices.

· Experience as Linux systems administrator (e.g., CentOS, RedHat) and command line system administration such as Bash, VIM, SSH.

· Experience with CI/CD in cloud environments and container technology, Docker and Kubernetes, Docker Swarm

· Good communication and coordination skills and able to work efficiently under pressure.

· Open to learning new skills and technologies


Preferred skills:

· Nice to have MongoDB and Oracle management

· Experience with CI/CD in cloud environments and container technology.

· Strong Good communication and coordination skills and able to work efficiently under pressure.


Administrateur de base de données principal


Date de début : dès que possible

Type d'emploi : permanent

Lieu : Montréal, QC (poste hybride ; 3 jours sur site par semaine)

Nombre de postes : 1

Compétences linguistiques : Excellentes compétences en anglais

Avantages : travaillez pour une entreprise multinationale, primée et socialement responsable, présente opérationnellement dans de nombreux pays depuis plus de 75 ans. C'est un environnement culturellement diversifié, employant des milliers de personnes dans le monde, avec de magnifiques bureaux en centre-ville.


En tant qu'Administrateur de base de données principal, vous avez la responsabilité d'administrer, surveiller et résoudre les problèmes des serveurs de base de données d'un environnement de production 24x7 et de l'infrastructure associée. Vous travaillerez avec d'autres membres de l'équipe pour assurer un temps de disponibilité de 100 %, planifier les besoins futurs en capacité, maintenir la sécurité et appliquer les mises à jour. Vous résoudrez également des défis techniques passionnants en analysant, dépannant et concevant des services, des plates-formes et une infrastructure vitaux, tout en pensant toujours à la fiabilité, à la scalabilité, à la résilience, à la sécurité et aux performances.

Principales tâches et responsabilités :

  • Expérience étendue et démontrable en tant qu'administrateur de base de données dans des environnements MSSQL à grande échelle
  • Expérience pratique de la gestion d'instances à volume élevé de configurations PostgreSQL hautement disponibles
  • Élaborer et établir des politiques et des procédures liées à la sécurité et à l'intégrité des données ; surveiller et limiter l'accès à la base de données au besoin
  • Documenter l'environnement de base de données de l'entreprise
  • Connaissance des moteurs de stockage de bases de données et des principes et pratiques de réplication maître-esclave
  • Bonnes compétences en communication et en coordination, et capacité à travailler efficacement sous pression

Éducation : Diplôme universitaire, de préférence en informatique, en génie informatique, en mathématiques ou domaine similaire.

Compétences requises :

  • Forte et démontrable expérience en tant qu'administrateur de base de données dans des environnements PostgreSQL ou MSSQL à grande échelle
  • Expérience en fiabilité du site
  • Expérience avec VMware, ainsi qu'avec le cloud (Azure, AWS)
  • Expertise pratique documentée dans la gestion d'instances à volume élevé de configurations PostgreSQL avec haute disponibilité
  • Compétences avancées en résolution de problèmes, avec la capacité d'identifier rapidement l'origine d'un problème
  • Élaborer et établir des politiques et des procédures liées à la sécurité et à l'intégrité des données ; surveiller et limiter l'accès à la base de données au besoin
  • Veiller à ce que tous les serveurs de base de données soient gérés selon les objectifs de point de récupération (RPO) et les objectifs de temps de récupération (RTO)
  • Documenter l'environnement de base de données de l'entreprise
  • Expérience dans l'écriture de scripts d'automatisation, la création de tableaux de bord d'application pour une surveillance proactive en utilisant Ruby, PowerShell, Python ou des technologies similaires, capacité à déboguer et optimiser le code et automatiser les tâches courantes
  • Expérience avec les moteurs de stockage de bases de données et les principes et pratiques de réplication maître-esclave
  • Expérience en tant qu'administrateur de systèmes Linux (par exemple, CentOS, RedHat) et en administration système en ligne de commande tels que Bash, VIM, SSH.
  • Expérience avec CI/CD dans des environnements cloud et la technologie de conteneur, Docker et Kubernetes, Docker Swarm
  • Bonnes compétences en communication et en coordination, et capacité à travailler efficacement sous pression.

Ouvert à l'apprentissage de nouvelles compétences et technologies

Compétences préférées :

  • Souhaitable d'avoir des compétences en gestion de MongoDB et Oracle
  • Expérience avec CI/CD dans des environnements cloud et la technologie de conteneur.
  • Fortes compétences en communication et en coordination, et capacité à travailler efficacement sous pression.



  • Montreal, Quebec, Québec, Canada Tata Consultancy Services Full time

    Inclusion without ExceptionTCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our...

  • Database Administrator

    4 months ago


    Montreal, Quebec, Québec, Canada Squarepoint Capital Full time

    Department: Application EngineeringPosition Overview: Platform Applications Specialists Database role will be part of a global systems team responsible to deliver highly available, high-performance, and scalable infrastructure to support trading and research using the DevOps methodology.As part of this role will be focused on working collaboratively with...


  • Montreal, Quebec, Québec, Canada BlueRose Technologies Full time

    Description : This is an experienced Oracle Database Administrator position where the individual will be responsible for overseeing and managing the Oracle databases. In addition, this DBA will be responsible for providing 2nd and 3rd level support for all DB related issue or outages. Ensures the smooth operation of the infrastructure in order to provide...


  • Montreal, Quebec, Québec, Canada VLink Inc Full time

    Senior Java Software Engineer with KafkaLocation – Montreal, QCfulltimeWe are looking for a highly skilled senior Java developer to join our company. In this role, you will design, create, and implement various Java-based solutions for the business that will range from mobile applications to database programming.Responsibilities:Write code for...


  • Montreal, Quebec, Québec, Canada Atlantis IT Group Full time

    Role : MSSQL DBA(Performance Tuning & Replication) Location : Montreal, QC 1 yr Contract Onsite Microsoft SQL Server Database Administrator (MSSQL DBA) + Strong knowledge in Performance & Tuning + Replication Role name: Engineer Role Description: Site Reliability Engineers (SRE) need database platform experience ( MSSQL), service maintenance, monitoring,...


  • Montreal, Quebec, Québec, Canada Tata Consultancy Services Full time

    About TCS:Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...


  • Montreal, Quebec, Québec, Canada Tata Consultancy Services Full time

    Inclusion without Exception:TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our...


  • Montreal, Quebec, Québec, Canada Vaco Full time

    We are seeking a Senior Administrator-Developer with expertise in ActiveVOS (an Informatica tool) to join a dynamic team. The role involves creating, modifying, and maintaining business processes using ActiveVOS Designer while optimizing its performance. The ideal candidate will have a deep understanding of Oracle DB and Java and the ability to troubleshoot...


  • Montreal, Quebec, Québec, Canada KTek Resourcing Full time

    At least 5 years of experience in Intellimatch development and reconciliation.At least 2 years of experience in Intellimatch architecture and design.Strong knowledge of Intellimatch Designer, Intellimatch Application Server, and Intellimatch Database.: Should have expert level work experience in IntelliMatch , Swift Messages, SQL queries, IntelliSUITE Web...


  • Montreal, Quebec, Québec, Canada Axelon Services Corporation Full time

    Senior Python DeveloperLocation: Montreal (day 1 onboarding onsite - hybrid work model/in office presence required 3x per week)12 Months Contract PositionRequired years 10+Job Description:The Portfolio Central team is looking for a highly motivated individual to expand a Portfolio Optimization tool to the Munis Desk. The tool will allow users to provide a...


  • Montreal, Quebec, Québec, Canada Synechron Full time

    Nous sommesChez Synechron, nous croyons en la puissance du numérique pour transformer les entreprises en mieux. Notre cabinet de conseil mondial combine la créativité et la technologie innovante pour offrir des solutions numériques de premier plan. Les technologies progressistes et les stratégies d'optimisation de Synechron couvrent...

  • Senior Java Developer

    3 weeks ago


    Montreal, Quebec, Québec, Canada Quantum World Technologies Inc. Full time

    7+ years of hands-on development experience in Java technology stack Spring Boot, Spring REST, ORM, JSON, Multithreading Established technical knowledge in software development life cycle and agile methodologies Experience developing Single Page Web applications Strong experience with SQL Database development (queries and table design) Should be able to...


  • Montreal, Quebec, Québec, Canada VLink Inc Full time

    LOOKING FOR CONSULTANTS ONLY LOCAL TO QUEBECType: Full Time/ ContractWork model: Hybrid Required Skills: Java 11+, Spring-boot, and RESTful micro-services, Angular 17+, MongoDB, SQL, TypescriptRole Description:We have an immediate need in an experienced full-stack developer, who is strong in Java and knowledgeable in Angular. Ideal candidates will have an...


  • Montreal, Quebec, Québec, Canada Anywr Canada Full time

    Job Opportunity: Senior Front-End Software EngineerAbout Our Client:Our client, a rapidly growing Insurtech company, has revolutionized the insurance industry with a SaaS platform driven by predictive analytics and AI. Now, they are looking for a Senior Front-End Software Engineer to develop cloud-native solutions and play a crucial role in their...


  • Montreal, Quebec, Québec, Canada Anywr Canada Full time

    Job Opportunity: Senior Front-End Software EngineerAbout Our Client:Our client, a rapidly growing Insurtech company, has revolutionized the insurance industry with a SaaS platform driven by predictive analytics and AI. Now, they are looking for a Senior Front-End Software Engineer to develop cloud-native solutions and play a crucial role in their...


  • Montreal, Quebec, Québec, Canada LanceSoft, Inc. Full time

    Job Description:We have an immediate need in an experienced full-stack developer, who is strong in Java and knowledgeable in Angular.Ideal candidates will have an extensive, multi-year hands-on experience, an eye for quality and emphasis on details, to help our highly motivated agile squads to develop and maintain the next generation, distributed platform...

  • Mainframe Consultant

    3 months ago


    Montreal, Quebec, Québec, Canada LanceSoft, Inc. Full time

    This role is for a senior RACF engineer who will assist with design and execution of projects aligned with the RACF security function. The ideal candidate should have advanced knowledge of RACF, ZSecure, and Mainframe infrastructure as they will be working closely with the other infrastructure teams (CICS, Systems Programming, Db2, etc.) and business...

  • Python Developer

    3 weeks ago


    Montreal, Quebec, Québec, Canada LanceSoft, Inc. Full time

    POC: RSR MSPJob Title: Senior Python DeveloperLocation: Montreal (day 1 onboarding onsite - hybrid work model/in office presence required 3x per week)Required years 10+Job DescriptionThe Portfolio Central team is looking for a highly motivated individual to expand a Portfolio Optimization tool to the Munis Desk. The tool will allow users to provide a list of...


  • Montreal, Quebec, Québec, Canada Vaco Full time

    Position Overview:We are seeking an experienced Developer with expertise in the Property and Casualty (P&C) insurance domain to join our dynamic team. The ideal candidate will have a strong background in Java or Pega development, demonstrating the ability to design, build, and implement robust applications that drive business efficiency and innovation. This...


  • Montreal, Quebec, Québec, Canada TalentBurst, an Inc 5000 company Full time

    Job Title:- Machine Learning Expert Location:- Montreal Hybrid Duration: 9 month(s) Contract 7+ Years of Machine Learning experience needed. Responsibilities: The Machine Learning (Client) Expert will: Understand the business needs and requirements and translate them into Client solutions. Communicate technical concepts and results to non-technical...