Job Description

1. Ensure the stable operation of all kinds of databases in all related business lines of the company, including but not limited to MySQL, Redis, Hadoop, ES, etc;2. Responsible for the architecture design of database clusters, work with business departments to achieve database availability assurance, vertical and horizontal scaling solutions and implementation;3. Able to do optimization and adjustment with the business, to achieve low-cost, high-performance database services;4. Develop and design database operation and maintenance automation products and related components;5. Maintain technical sensitivity, continue to do research on new database technologies and products, and form feasible solutions to promote business implementation and support business development.Requirements:1. Bachelor degree or above in Computer Science or related majors, proficiency in MySQL database architecture and working principles;2. Proficiency in innodb storage engine, replication technology, and familiarity with functional features of various versions;3. Practical maintenance experience in MySQL high availability architecture, familiar with the advantages and disadvantages of various architectures, not limited to MHA, MGR, Orchestrator, etc;4. A deep understanding of indexes, transactions, concurrency, and locks;5. Familiar with linux operating system, familiar with AWS environment, and proficient in deployment, monitoring, permission assignment, data migration, archiving and other necessary skills for daily operation and maintenance;6. Rich experience in sql statement optimization, proficiency in Redis, MQ operation and maintenance management;7. Practical experience in maintaining medium to large databases with separate libraries and tables, proficiency in backup recovery and use of operation and maintenance tools;8. Proficiency in at least two scripting languages, shell, python, go, etc.;9. Practical operation and maintenance experience in mycat, dble, proxysql and other middleware, ES, MongoDB, TiDB, Clickhouse is preferred;10. Willing to learn, good at communication and sharing, good teamwork spirit, strong anti-stress ability.

Paytm