DBA - Database Administrator - MySQL

  • Slimpay
  • Paris, France
  • Oct 14, 2017
Full time Developer

Job Description

DESCRIPTION

SlimPay provides payments for subscriptions via direct debit. In addition to processing payments in both EURO and GBP for fixed and variable payment plans, SlimPay provides value-added technologies and services to enable merchants to effortlessly onboard customers, increase customer lifetime value and maximise revenue. With a team of over 60 payment specialists spread over 6 international offices and more than 2000 customers in 34 countries, SlimPay is the European leader for payment by direct debit.

 

Purpose of Job

The Database Administrator (DBA) is responsible for the maintenance, administration, performance and availability of the company’s database infrastructure. You will be responsible for implementing and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. You will create scripts for task automation and implement and manage system monitoring of the core systems. You will be responsible for managing backups, clustering, mirroring, and failover elements of the database systems and be responsible for restoring and recovering corrupted databases.

The DBA will work closely with the software engineering team to assess the impact of database changes to ensure performance, security and stability of the database platform. You will provide operational support and assist in troubleshooting any issues that may arise with the database systems.

 

Responsibilities

  • Provision MySQL instances, both in clustered and non-clustered configurations;
  • Handle common database procedures, such as upgrades, backups, recovery and migration;
  • Profile server resource usage and optimizing queries, indexes and MySQL server configuration as necessary;
  • Respond to and resolve database access and performance issues in a timely and efficient manner in line with business requirements and providing timely communication to users on the status of requests and incidents;
  • Monitor the availability, performance and throughput of supported databases always ensuring appropriate maintenance plans are in place;
  • Monitor, optimize and allocate physical data storage for database systems;
  • Plan and coordinate data migrations between systems as required;
  • Implement and maintain change control and testing processes for modifications to databases;
  • Create, or support creation of, required reports in response to business user needs;
  • Establish and manage appropriate end-user database access control levels;
  • Produce and maintain database support technical documentation;
  • Prioritise and schedule assigned support activities and tasks.
  • Be security conscious, ensure familiarity and co-operation with all security protocols;

REQUIREMENTS

Technical Skills

  • 3+ years as a senior database administrator of MySQL systems;
  • Experience with clustering, replication and high availability, ideally in a 24x7 environment;
  • Deep understanding of MySQL scripting, stored procedures and triggers in an enterprise-level environment;
  • Understanding of database design and architecture and MySQL’s underlying storage engines including InnoDB and MyISAM;
  • Keen understanding of core features and how to properly configure them including replication, clustering, partitioning, auditing and encryption;
  • Understanding of database security and attack prevention methods;
  • Understanding of Big Data database solutions such as Hadoop, MongoDB or Amazon EMR
  • Must be familiar with Cloud-based hosting solutions such as Amazon AWS
  • Experience with source code control systems such as Git and workflow tools such as Jira;
  • Understanding of both Agile (Kanban and Scrum) and Waterfall delivery methods;
  • Passionate about data and databases, always keeping up with relevant technology developments;
  • Skilled in problem diagnosis and resolution;
  • Ability to communicate technical information in a clear and understandable manner to non-technical stakeholders;
  • Customer focused and goal orientated with keen attention to detail;
  • Strong planning and organisation skills;
  • Experience of operating with a high level of autonomy and the ability to manage input from others to ensure delivery to agreed timescales;
  • Ability to work as part of an effective and highly skilled team;

Nice to Have Skills

 

  • Experience in DevOps including Infrastructure as a Service, Jenkins, or Docker;

Personal Skills

  • Passionate about data and databases, always keeping up with relevant technology developments;
  • Skilled in problem diagnosis and resolution;
  • Ability to communicate technical information in a clear and understandable manner to non-technical stakeholders;
  • Customer focused and goal orientated with keen attention to detail;
  • Strong planning and organisation skills;
  • Experience of operating with a high level of autonomy and the ability to manage input from others to ensure delivery to agreed timescales;
  • Ability to work as part of an effective and highly skilled team

BENEFITS

  • A highly motivated, experienced and international team
  • Flexible structures with flat hierarchy