Database Administrator in IT-Solutions

The product is the internal CRM system of a leading IT company. What do we expect from the candidate: -experience with databases from 3 years; -experience with MySQL Percona (version 5.6 and higher) - required; -knowledge of PL, SQL; -understanding of concepts - data replication, sharding, partitioning; -knowledge and understanding of how InnoDB works; -knowledge and experience with view; -understanding how index, autocommit, savepoint, rollback works; -experience with Sphinx; -ability to analyze data schemes and act on the principle: "Do not tune your query, know your data!"; -knowledge and experience with Ubuntu; -knowledge of diagnostic tools: iostat, perf, top for fast database recovery; -ability to write post mortem and learn from incidents. Main tasks: -installation of MySQL database software; -creation of new databases; -implementation of database backup scenarios; -testing (regularly and on request) performance and quality of database backup; -monitoring of key database parameters to ensure service continuity; -migration of databases to equipment or another version; -creation of test environments and environments for developers; -restoration of databases in case of accidents on equipment and operating systems; - elimination of consequences of accidents in databases; -schedule planning and installation of database security patches; -analysis of critical messages from databases; -providing advice and assistance in solving the problem of database users (optimization of database queries, database speed, optimal structure of database objects, actions requiring the level of access "administrator", etc.). What we offer: -high level of compensation in USD; -convenient work schedule; -bright corporate events; -adequate, friendly management and no bureaucracy.