Work location : Preferably Delhi NCR.
Work Type : Remote, with mostly 1 day in office in a week on need basis.
Experience Required: 6-9 Years
Responsibilities :
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.