Database Administrator
lm group
Chiasso, Switzerland
vor 18 Std.
Company Description

lm group is a publicly traded multinational Group, among the worldwide leaders in the online travel industry, and we operate a portfolio of well-known brands such as lastminute.com, Bravofly, Rumbo, Volagratis and Jetcost.

Every month, the Group reaches across all its websites and mobile apps (in 17 languages and 40 countries) 43 million unique users that search for and book their travel and leisure experiences. More than 1,200 people enjoy working with us and contribute to provide our audience with a comprehensive and inspiring offering of travel related products and services.


Job Description

lm group is looking for a Database Administrator for its Datastore team based in Chiasso.

We are looking for brilliant people, not for a list of skills. While reading key responsibilities of the role, please consider that we value attitude more than your expertise. Are you curious and passionate about working in a constantly evolving and challenging international environment? Even if you don’t feel to fit the role 100%, please apply: put your willingness to learn and we will grow together!

Key Responsibilities

  • Analyze and respond to performance and other maintenance issues of both production and staging environment
  • Responsible for installation, configuration, monitoring, upgrading and maintaining MySQL databases in production and non-production environments
  • Database administration backup, performance-tuning, resolve database related problems on a daily basis
  • Work with developers in defining optimal database architecture, optimizing SQL queries
  • Monitor and optimize databases performance and capacity planning
  • Perform rolling upgrades of MySQL servers
  • Root cause analysis of database related issues
  • Manage backup and recovery
  • Contribute in development of SQL scripts and complex queries
  • Manage tracking, alerting, and reporting of database servers

  • Qualifications

     Essential

  • Experience with Database administration, performance tuning and optimisation (at InnoDB engine level), replication in master/master and multi slave environment.
  • Previous experience with Mysql 
  • Familiar with Linux OS (specifically, CentOS) and able to use the OS tools to investigate performance issues
  • Familiar with Cloud (ex. AWS/GCP) , DevOps methodologies and basic knowledge of at least one Configuration Management tool (ex. Puppet/Ansible)
  • Ability to write shell scripts in order to automate maintenance task
  • Experience in day by day administration of large datasets (1 TB and over)
  • Desirable

  • Knowledge of Mysql HA solutions (ex. Galera Cluster) would be a plus
  • Knowledge of NO-SQL (ex. Cassandra/MongoDB) databases would be a plus
  • Working experience in an Agile Environment would be a plus. 
  • Ability to write SQL scripts, reports and ETL
  • MySQL Backup and Recovery experience and concepts other than mysqldump
  • Experience managing monitoring and alerting for MySQL using tools such as Graphite/Grafana, Nagios, custom script, etc.


  • Additional Information

    Abilities/qualities

  • Proactive attitude, strong teamworking, communication and collaboration skills

  • Bewerben
    Zu Favoriten hinzufügen
    Aus Favoriten entfernen
    Bewerben
    Meine Email
    Wenn Sie auf "Fortfahren" klicken, stimmen Sie zu, dass neuvoo Ihre persönliche Daten, die Sie in diesem Formular angegeben haben, sammelt und verarbeitet, um ein Neuvoo-Konto zu erstellen und Sie gemäß unserer Datenschutzerklärung per Email zu benachrichtigen. Sie können Ihre Zustimmung jederzeit widerrufen, indem Sie diesen Schritten folgen.
    Fortfahren
    Bewerbungsbogen