I currently work at Alibaba Cloud as Database Solution Architect.
Prior to Alibaba, I was a Lead DBA for RDS DB + Aurora MySQL at AWS (Amazon Web Services). My work and interests cover ... Show morethe performance and reliability of OLTP systems in MySQL, understanding the source code of MySQL and optimising it . I often work on source code of MySQL in order to understand Redo log, log buffer , mtr (mini tx) , mtr buffers and other related aspects of storage layer of Innodb. In addition to this I am also working on Postgres design . For distributed databases I work on MPP database of MySQL and PG which we can call it Analytics DB for MySQL and PG or Redshift for MySQL.
I have strong skills in designing of OLTP architectures (be it cloud or on-prem).
Additionally , I am well-versed in performance tuning, diagnosing abnormal or suboptimal behaviour, high availability operations, designing RTO and RPO , fail overs, preventing single point failures, DB security , pin-pointing bottlenecks of performance and implementing optimisations. I can program proficiently in C and started working on details of shell scripting. I keep on refreshing my knowledge on data structures , implementing data structures in scripting.
As an open source DBA, I have a good understanding of design trade offs in databases. I also have extensive experience in migrating various databases using traditional methodologies via code or by using existing migrations tools.
I also have the necessary communication skills to share my research findings and engage with the community. I love teaching and sharing my skills with others.
You can see my work below which can substantiate my sharing skills :
https://wordpress.com/home/jinglespreparatorycom.wordpress.com
https://en.gravatar.com/akapoordbgeek