The ability of a junior DBA to evolve to a mid-level DBA or even a senior DBA

It's July 5, 2017, 23:11.

I am now working in an internet company in Shenzhen, working as a database engineer.

Recently a little disoriented, overwhelmed.

What is the reason? Although I have been to this company for more than a year of work experience, is engaged in database-related work, but I did not study in-depth, and even the most basic things are not mastered well. So that now, do everything to re-learn. Even if it is to build a table, also to the Internet to understand the table specification, table and field naming specification, how to build indexes, how to modify fields to add fields and so on.

Here's what I personally think is the ability of a junior DBA to evolve to an intermediate DBA or even a senior DBA:

(biased towards MySQL, the content is summarized in the "high-performance MySQL")

1. Familiar with MySQL architecture (including logical architecture, locks, things, storage engines, etc.)

2. Ability to create high-performance indexes (first to know what the index is, how the index works)

3. Query performance optimization (knowing what will cause the query to be slow and how to optimize it)

4. Learn more about MySQL's advanced features (including partitioned tables, views, foreign key constraints, storing code inside MySQL (Stored procedure function trigger events, etc.), full-text indexing, query caching)

5. Optimize server settings (MySQL-related configuration)

6. Operating system and hardware optimization (CPU, storage, etc.)

7. master copy (copy principle, copy operation procedure)

8. High availability (avoid single point of failure and failover and recovery, etc.)

9. MySQL in the cloud (pros and cons, scalability, and high availability)

10. Backup and restore (backup scenario)

11. Master the SQL Writing specification, build the table specification (no rules inadequate surrounding area)

12. In-depth understanding of MySQL and other related technology research (first of all to professional, followed by Broad vision)

13. Be able to read the official MySQL document (US)

14. The love of technology (interest is the best teacher)

15. Self-study ability (many things need to explore)

16. Read more, practice more, sum up (turn other people's experience into their own)

17. Willing to work overtime, willing to stay up late to study (just like I am now, haha)

The ability of a junior DBA to evolve to a mid-level DBA or even a senior DBA