DBA - Senior DBA

12 Hours ago • 6-9 Years • Administrative

About the job

Summary

Senior DBA responsible for ensuring stable operation of databases (MySQL, Redis, Hadoop, ES, etc.) across all business lines. Key responsibilities include database cluster architecture design, collaborating with business departments for high availability and scalability solutions, database performance optimization, developing automation tools, and researching new database technologies. The role requires proficiency in MySQL, including InnoDB, replication, and high availability architectures (MHA, MGR, Orchestrator). A strong understanding of database internals (indexes, transactions, concurrency, locks) is essential, along with Linux, AWS, SQL optimization, and experience with Redis and MQ. Experience with middleware (Mycat, dble, ProxySQL), ES, MongoDB, TiDB, and ClickHouse is preferred. The position is primarily remote with one day in the office per week.
Must have:
  • MySQL expertise (InnoDB, replication, HA)
  • Database architecture design & optimization
  • Automation tool development
  • SQL optimization & performance tuning
  • Linux & AWS experience
  • Redis & MQ experience
Good to have:
  • Mycat, dble, ProxySQL experience
  • ES, MongoDB, TiDB, ClickHouse experience
Not hearing back from companies?
Unlock the secrets to a successful job application and accelerate your journey to your next opportunity.
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.
undefinedundefinedundefined
View Full Job Description

About The Company

Uttar Pradesh, India (Hybrid)

Uttar Pradesh, India (On-Site)

Uttar Pradesh, India (On-Site)

Uttar Pradesh, India (On-Site)

Uttar Pradesh, India (On-Site)

Uttar Pradesh, India (On-Site)

Uttar Pradesh, India (On-Site)

Karnataka, India (Remote)

Uttar Pradesh, India (On-Site)

Uttar Pradesh, India (On-Site)

View All Jobs

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug