Senior Database Administrator (MySQL)

з/п не указана

Требуемый опыт работы: 3–6 лет

Полная занятость, гибкий график

We are looking for the Senior Database Administrator (MySQL).

You will be responsible for improving, optimizing, maintaining and monitoring the current DBs (multiple MySQL instances (>15TB in total), Cassandra cluster, ClickHouse clusters, etc.) in order to satisfy business needs in our unique product development, utilizing strong technical skills.

You will have the opportunity to coordinate, review, analyze and approve the physical database requirements of databases and all associated objects; such as, but not limited to tables, views, and indexes.

Likewise, you will play a key role working together with the product development team to ensure database security, optimum performance of databases, backup & recovery and disaster recovery strategies.

We are ready to consider specialists from other countries, in the same time zone as us. Our vacancy implies the possibility of remote cooperation.

Main Responsibilities:

  • Develop, implement, and maintain processes of MySQL databases servicing in test, quality assurance, and production environments utilizing current standards and procedures as well as introducing new standards

  • Provide performance-related support and systems related support for MySQL databases in production, test, development, and QA environments utilizing current tool sets

  • Provide support on all the stages of database implementation and/or database-related deployments

  • Installation of new MySQL instances, applying necessary patches and version upgrades

  • Run diagnostic tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance. Work with development teams to tune SQL queries

  • Communicate regularly with technical, applications, and operational staff to ensure the database integrity and security

  • Troubleshoot MySQL performance and non-performance related issues either independently or in conjunction with other DBAs

  • Maintain existing MySQL environments, including large replication environments and mid-sized High Availability environments

  • Manage backup/recovery for MySQL instances and provide Disaster Recovery (DR) support

  • Management of database and resource capacity planning

  • Implement and enforce database security based upon best practice, industry regulations, and company policies

  • Participate in project meetings, as necessary, to understand application and database requirements

  • Utilize logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems

  • Write database documentation, including data standards, procedures, and definitions for the data dictionary

Requirements:

  • 3+ years experience in administering MySQL database

  • Experience with MySQL multi-instance configuration (replication and/or clustering), setup and maintenance

  • Experience with High Loaded MySQL and with MySQL in Linux environments

  • Expert in SQL language

  • Experience in one or more scripting languages: Python/ Shell/ Ruby

  • Experience with cloud database services

  • Passionate about data and making sense out of data

  • Ability to quickly learn new concepts and technologies and adapt to changing needs

  • Organized, detail-oriented, and capable of working independently with minimal supervision

  • Middle level of English for writing and reading technical documents

It will be a plus:

  • Experience in Agile development environments
  • Experience in reporting and data mining technologies
  • Experience with ClickHouse
  • Experience with Data Lake / Data Warehouse solutions

Benefits Package:

  • Working on the company's own product highly demanded worldwide, one of the industry leaders in the e-commerce analytics segment

  • Our vacancy implies the possibility of remote cooperation

  • Fair and attractive compensation, competency review

  • Corporate Medical Insurance (fully covered by the company)

  • Vacation (20 working days during the year)

  • Paid sick leave (80% of your daily base salary)

  • 4 days for recovery without a sick leave document during the year (80% of your daily base salary)

  • Professional development opportunities covered by the company (seminars, training, conferences, etc.)

  • Individual sports activities compensation (50%)

  • Car parking compensation (50%)

  • English classes compensation (up to 50 USD per month)

  • Modern and comfortable office in the city center (Business Centre "Royal Plaza")

  • Regular corporate events and team-building activities

Welcome to Profitero! Truly challenging, but incredibly exciting to be a part of Profitero team! :)

Ключевые навыки

Английский — B1 — Средний
MySQL
High Loaded
Linux
SQL language
Python/ Shell/ Ruby
ClickHouse

Адрес

Немига, Минск, проспект Победителей, 7а
Показать на большой карте

Вакансия опубликована 14 января 2021 в Минске

Похожие вакансии