● Led design, implementation, and maintenance of secure, high-availability database architectures for mission-critical applications, supporting SQL Server, PostgreSQL, MySQL, MongoDB, and Cloud Databases environments. ● Applied performance tuning on T-SQL, stored procedures, and complex queries, optimizing indexing and query efficiency for peak system performance. ● Conducted daily database monitoring, log analysis, and space management, proactively identifying and addressing issues to ensure system stability. ● Architected high-availability (HA) solutions using replication, clustering, and sharding, enabling robust, fault-tolerant systems. ● Collaborated on DB-Schema design with RD teams, aligning schema modifications to meet evolving requirements. ● Managed backup, disaster recovery, and failover strategies, securing data resilience and business continuity. ● Deployed cloud-native monitoring tools (e.g., Percona, Zabbix) to identify performance bottlenecks and optimize throughput. ● Oversaw user permissions, security management, and regular updates, ensuring compliance with security standards. ● Executed migration of high-latency SQL Server databases to MySQL and transitioned Oracle to PostgreSQL, saving hundreds of thousands in licensing costs. Technologies: Vector Databases, Elastic Vector Search, Azure Cosmos DB, Google BigQuery, SQL Server, T-SQL, MySQL 8+, NoSQL, MongoDB, PostgreSQL 16, AWS (RDS, Aurora, DocumentDB), AliCloud RDS, DataWorks, AWS DMS, Redshift, Redis, Kong Gateway, pg_basebackup, MariaDB, Puppet, Grafana, PHP, Percona Toolkit, GH-OST, Percona XtraBackup, Innotop, PMM, pt-online-schema-change, Orchestrator, Python, Shell Scripting, Ansible, Terraform, Database CI/CD with Flyway, Liquibase, Git.

Proficient in managing open-source databases such as MySQL, MariaDB, MongoDB, and PostgreSQL, with expertise in designing and architecting robust database solutions across these platforms. Experienced in automating database management tasks using Ansible and Shell scripting, as well as planning and monitoring database server capacity to ensure optimal performance. Skilled in designing and implementing high-availability (HA) solutions for MySQL, PostgreSQL, and MongoDB, and proficient in custom horizontal sharding to manage large-scale MySQL instance fleets handling petabytes of encrypted data. Knowledgeable in disaster recovery (DR) planning, native data center migrations, and providing 24/7 on-call support for level-2 database issues. Familiar with tools such as MySQL 5.7/8+, ProxySQL, PostgreSQL, MariaDB, MongoDB, Percona Toolkit, GH-OST, Percona XtraBackup, Innotop, PMM, Orchestrator, Python, and Ansible in large-scale Linux-based native data center environments.

With extensive experience in E-commerce, I transitioned to online gaming and payment wallet services to tackle complex infrastructure challenges, designing highly scalable and optimized cloud-based transactional databases capable of handling substantial concurrent loads. My accomplishments include managing and architecting open-source databases like MySQL, MariaDB, MongoDB, and PostgreSQL, as well as implementing high availability (HA) and load balancing solutions using Orchestrator and ProxySQL. I have mentored teams in database performance, root cause analysis (RCA), and automated tasks using Ansible and database monitoring tools. I successfully installed ProxySQL on AWS to split read and write traffic, ensuring high availability, and migrated legacy Microsoft-based systems to microservices on Linux and open-source databases. I also established disaster recovery, capacity planning, and monitoring processes with open-source tools for system stability and explored Docker, Kubernetes, and Alibaba Cloud services to optimize cloud infrastructure for scalable microservices. Additionally, I developed a distributed database and multi-cloud architecture to connect China with global markets, creating multi-region services to handle high transaction volumes in East Asia. Key tools and technologies include MySQL, ProxySQL, RDS, Docker, MongoDB, Redis, Grafana, and Alibaba Cloud.

At Alibaba Group (阿里巴巴), a multinational technology company specializing in e-commerce, cloud computing, and digital media, I administered and managed over 1,000 MySQL/Percona Server databases, ensuring optimal performance through robust backup strategies, monitoring, and high availability. I automated backup processes and executed data restorations using Xtrabackup, Mysqldump, Mydumper, and Myloader to safeguard data integrity. I diagnosed slow queries, resolved performance bottlenecks, and planned scalable database solutions across three data centers. Successfully, I migrated over 1,000 databases from on-premises to the cloud with minimal downtime, implemented load balancing with MaxScale and ProxySQL, and led a MySQL sharding project with Vitess and DRC. My contributions included architecting Multi-Master replication with MySQL 5.6, establishing GTID-based replication, and delivering BI/DWH solutions. I provided 24/7 on-call support, collaborated with development teams on query optimization and security, and mentored non-MySQL DBAs in best practices. Key tools included AliSQL, XtraDB Cluster, Docker, Elasticsearch, Redis, AWS, and Alibaba Cloud.

Provided technical leadership to cross-functional teams in the development of enterprise websites, telecom VAS projects, and social media campaigns. Architected and implemented VAS solutions integrating mobile money and telecom services for Safaricom, Tigo TZ, and Vodafone Ghana. Engaged in all phases of the software development lifecycle, including analysis, design, technical specifications, database architecture, programming, testing, system maintenance, and support. Spearheaded research on new technologies, evaluated products and vendors, and led teams of system designers, software developers, and testers to successful project completion. Managed payment transaction processing across credit/debit cards, mobile money, and third-party services. Performed DBA tasks such as backups, table restorations, and database refreshes, while designing module DB structures for Magento and PrestaShop to ensure seamless upgrades. Developed triggers and stored procedures for reporting and optimized batch updates to minimize replication delays.