Wrote MS SQL Tips, providing insightful articles stemming from my extensive expertise in crafting and enhancing T-SQL procedures while excelling in query performance tuning. This platform serves as a haven where I passionately employ my skills to successfully address and resolve intricate challenges.

Adoddle is a globally utilized platform employed by prominent property owners and architecture, engineering, and construction firms for the purpose of efficiently overseeing their intricate and extensive capital investment programs. Designed and developed integral database components and migrated a database server for client databases, managing 100+ large-scale databases for diverse clientele. Such endeavors presented thrilling challenges, particularly those pertaining to merge and transaction replication. Implemented query optimization and conducted performance tuning on notably extensive databases.

ZI is a sophisticated application designed for locating and leasing electric bikes. Devised a comprehensive product structure using PostgreSQL and Redis cache to optimize the flow. The product architecture follows a microservices-based solution, ensuring seamless integration of the database. Segmented the product into distinct modules and databases, enhancing overall availability.

Freedom is a cutting-edge video-streaming solution that seamlessly integrates cryptocurrency functionality alongside a sophisticated chat messaging system. Architected the entire product using a robust monolithic framework and industry-leading technologies such as PostgreSQL, MongoDB, and Redis cache. Crafted the messaging feature using MongoDB and RabbitMQ.

Beep is a comprehensive cab solution catering to both end users and travel operators. An imminent update will integrate support for kiosk machines at airports to facilitate seamless cab bookings. This sophisticated product has been intricately crafted using a microservice-based architecture. Worked on the flow and database design incorporating MariaDB and Redis cache for optimal performance.

BF is a premier Australian accounting firm offering extensive outsourcing solutions to numerous Australian clients for several decades. Restructured the entire database using MariaDB, rectifying several performance issues that had arisen due to the increased user base. The key highlight of the new design is its superior performance achieved through normalization and efficient JSON queries. Conducted a comprehensive database training session for a team of five members, focusing on query writing and query optimization techniques.

CERTIF is a prominent digital certification platform using a microservices-based architecture that seamlessly integrates MariaDB, a Redis cache, and MongoDB. Worked on end-to-end product design and management including database procedure development, ORM query trace and analysis, performance optimization, and continuous maintenance.