Jignesh is a Senior Database Administrator and Developer with 10+ years of experience in database architecture, database administration, microservices-based database design and architecture, and query optimization using SQL Server, MySQL, and PostgreSQL. He designs, develops, and implements an array of database solutions like high availability, disaster recovery, replication, T-SQL procedures, query performance tuning, and the complete lifecycle of data warehouses. Jignesh is also skilled in installing, administering, and maintaining SQL Server instances, managing all versions of data models for production, testing, and developing databases.
Maintaining and managing all versions of data models for production, testing, and developing databases.
Installing, administering, and maintaining database instances.
Designing and developing database and T-SQL procedures and SQL/NoSQL database components. Design Data warehouse ETL solutions on AWS Cloud Infra with the help of AWS Glue, S3, and AWS Redshift.
Adoddle is a platform globally used by prominent property owners and architecture, engineering, and construction enterprises to manage their extensive capital investment programs.
The project involved designing and developing core database components, migrating a database server, managing over 100 large-scale databases for various clients, and solving complex challenges related to merge and transaction replication.
Performance tuning was performed and query optimization was implemented on extensive databases.
BF Accounting, a premier Australian accounting firm restructured its entire database using MariaDB to solve performance issues due to increased user base.
The new database design, featuring superior performance, was achieved through normalization and efficient JSON queries.
A comprehensive database training session was conducted for a team of five, focusing on query writing and optimization techniques.
