DBA - Senior DBA
Job Summary
Job Description
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
9 skills required
Job Details
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.
Similar Jobs
Gigglebug Entertainment
Las Palmas De Gran Canaria, Canary Islands, Spain (On-Site)
• 3 Months ago
The Walt Disney Company
Lake Buena Vista, Florida, United States (On-Site)
• 2 Weeks ago
The Walt Disney Company
Papenburg, Lower Saxony, Germany (On-Site)
• 3 Months ago
Get notifed when new similar jobs are uploaded
Similar Skill Jobs
bosh group india
Bengaluru, Karnataka, India (On-Site)
• 1 Month ago
ByteDance
San Jose, California, United States (On-Site)
• 3 Months ago
PlayStation Global
London, England, United Kingdom (On-Site)
• 2 Months ago
PwC
Bengaluru, Karnataka, India (On-Site)
• 4 Months ago
ByteDance
Seattle, Washington, United States (On-Site)
• 3 Months ago
Get notifed when new similar jobs are uploaded
Jobs in Noida, Uttar Pradesh, India
Get notifed when new similar jobs are uploaded
Administrative Jobs
OKX
Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
• 4 Months ago
Assystems
Gurugram, Haryana, India (On-Site)
• 3 Months ago
Get notifed when new similar jobs are uploaded
