Jignesh Raiyani, Developer in Ahmedabad, Gujarat, India
Jignesh is available for hire
Hire Jignesh

Jignesh Raiyani

Verified Expert  in Engineering

Database Administrator and Developer

Location
Ahmedabad, Gujarat, India
Toptal Member Since
December 19, 2018

Jignesh has mastered database architecture, database administration, query solution generation, and query optimization with SQL Server, MySQL, and PostgreSQL. He is also proficient with the design, development, and delivery/implementation of a range of database solutions. This list includes high availability, disaster recovery, replication, always on availability group, architecture design, prototyping the proof of concept, and the design and development of test plans.

Availability

Full-time

Preferred Environment

Database Administration (DBA), SQL Server DBA, Microsoft SQL Server, MySQL, PostgreSQL, MongoDB, SQL Performance, Database Development, Database Design, Database Architecture

The most amazing...

...was troubleshot extreme bugs in a project involving query optimization, a SQL Server merge-transaction replication, HA, DR and performance tuning.

Work Experience

Database Specialist

2016 - PRESENT
Rapid Data Labs
  • Completed database solution, which included working with SQL and NoSQL database components design and development. Designed and developed database and T-SQL procedures. Made a contribution to administration, maintenance, and optimization.
  • Maintained and managed all of the versions of data models for production, testing, and developing databases.
  • Installed, administered, and maintained database instances.
Technologies: PostgreSQL, MySQL, MariaDB, Microsoft SQL Server, SQL

Database Developer | Database Administrator (DBA) | DBA Lead

2013 - 2018
Asite Solution PVT LTD
  • Contributed to the Adoddle platform used worldwide by leading property owners, architecture, engineering, and construction firms to manage their largest and most demanding capital investment programs.
  • Contributed to the design and development of database components. Migrated client database and implemented the system. Administered, maintained, optimized, and tuned very large databases.
  • Migrated the client database and implemented the system. Set up high availability (HA), disaster recovery (DR), and replication. Performed tech refresh and managed more than 20 SQL Servers and 100+ databases on production.
  • Performed tech refresh and migrated all the stuff from one server to another with all the dependencies. Was the star employee award winner.
  • Managed 100+ product databases and QA platforms independently.
  • Administered, maintained, optimized, and tuned large databases.
Technologies: MySQL, Database Development, Database Replication, High Availability Disaster Recovery (HADR), SQL Performance, Optimization

Software Professional

2013 - 2015
VCS
  • Served as a software professional for VCS, a company that provides cutting-edge solutions in supply chain and sales and marketing. VCS ranked as one of the top 20 recommended consultancies globally with vast experience working with Fortune 500 companies.
  • Migrated many clients' databases and worked on reporting parts with SQL development and code deployment.
  • Developed databases and reporting modules. Supported the back-end team.
  • Administered, maintained, optimized, and tuned databases.
Technologies: SQL Server 2008

MS SQL Tips

https://www.mssqltips.com/sqlserverauthor/244/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.

Adoddle | Construction Computing

http://www.asite.com/
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 Bike

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

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 Cab

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 Accounting

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

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.

Languages

SQL, T-SQL (Transact-SQL)

Paradigms

Database Design, Database Development

Storage

Microsoft SQL Server, Database Administration (DBA), Relational Databases, Database Architecture, Database Replication, Databases, SQL Performance, SQL Server DBA, MariaDB, MySQL, PostgreSQL, NoSQL, MongoDB

Other

Relational Database Design, High Availability Disaster Recovery (HADR), Optimization

2009 - 2013

Bachelor of Engineering Degree in Information Technology

B.H. Gardi College of Engineering and Technology - Rajkot, India

JUNE 2018 - PRESENT

AWS Solution Architect - Associate

DevOps Tech Lab

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring