Jobs

Scholarships

Courses

Companies

Placements

Community

Home >

Jobs >

DBA - Senior DBA

Uttar Pradesh, India (Hybrid)

DBA - Senior DBA

3 Weeks ago • 6-9 Years • Administrative

About the job

9 skills required for this role

Test your skills to join the top 1% applicants for this job

shell

mongodb

redis

aws

python

sql

linux

hadoop

mysql

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

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

Upload your resume, increase your shortlisting chances by 80%