Jignesh Raiyani

I am the author of MS SQL Tips. Here, I write articles with experience in designing and developing T-SQL procedures and query performance tuning. It is a place where I love to resolve and troubleshoot complex issues.

Atoddle is a platform used worldwide by leading property owners, architecture, engineering, and construction firms to manage their largest and most demanding capital investment programs.

PROJECT DETAILS:
I designed and developed database components. I also migrated a database server for client databases and managed 100+ large databases for different clients. There were exciting challenges that I tackled concerning merge and transaction replication. I also implemented query optimization and performance tuning on very large databases.

ZI is an app to find and rent electric bikes.

PROJECT DETAILS:
I designed a complete product with a flow in PostgreSQL and Redis cache. The product architecture is designed in a microservice-based solution along with an integration of a database. I also divided the product into different modules and databases to increase availability.

Freedom is a video-streaming product with integrated cryptocurrency and a chat messenger.

PROJECT DETAILS:
I designed the complete product in a monolithic architecture with PostgreSQL database, MongoDB, and Redis cache. I also designed the Messenger body with MongoDB and RabbitMQ.

Beep is a cab solution product for the end-user and travel operators. An upcoming release supports kiosk machines to book the cab while in the airport as well.

PROJECT DETAILS:
This product is very vast and was designed in a microservice-based architecture. I handled the flow design and database design. I also used MariaDB and Redis cache on the database side.

BF is the leading Australian accounting firm providing outsourcing solutions over the decades to thousands of Australian clients.

PROJECT DETAILS:
I restructured the complete database with MariaDB. The previous design had caused a number of performance issues that came with the growth in the number of users. The best part of the new design is the normalization and JSON query to achieve good performance. A special note is that I also held a database class with a five-member team on database query writing and query optimization.

Certif is a public digital certification platform.

PROJECT DETAILS:
I designed the complete product with a microservice-based architecture that involved integrating MariaDB, a Redis cache, and MongoDB. I also managed all of the tasks, such as the development of the database procedure, ORM query trace and analysis, optimization, and maintenance.