Hi, I sincerely hope you are doing well and safe from ✔️covid-19✔️.
I like Data Modeling, DML(Data modeling language) and DDL (Data definition language)
Hi, I have checked your description carefully and very interesting.
I have been trying to become RDBA, I am very family with database management.
While checking your job description, I knew you were looking for experienced and reliable developer.
For the last 6 years, Developing more than 4 websites, I have met and solve many problems and enough experiences in this area.
The techniques I got about database optimization are following:
- Optimizing Queries with EXPLAIN. We can look execution plan of optimizer.
- MySQL Query Log. slow executed query is stored here.
- Optimizing Database Schema. Limiting the number of columns, Normalization
- Use Indexes
- MySQL Query Caching. provides database caching functionality.
- Converting OUTER JOINs to INNER JOINs
...
I can finish your issue with my skills.
please check my result