Gaurang Patel

Experience

• 

  DBMARES PRIVATE LIMITED

  Mar 2022 - now

  SQL Developer

  ➥ Proficient in designing and implementing complex SQL stored procedures, functions, views,triggers, JSON and dynamic T-SQL queries for Microsoft SQL Server.➥ Developed and implemented a robust stored procedure for seamless data migration from one database to another, ensuring data integrity and optimal performance. This involved designing and executing efficient SQL queries, handling data transformations, and conducting thorough testing to guarantee a smooth transition process.➥ Automated ETL processes using job scheduling tools (e.g., SQL Server Agent) to refresh data in tables on a regular basis, improving data availability and consistency.➥ Led the migration of a legacy application to a new platform, including the design and implementation of a new database schema and the adaptation of ETL processes.➥ Experienced in creating and optimizing Common Table Expressions (CTE) to simplify complex SQL queries.➥ Experienced in optimizing large table queries and complex joins.➥ Strong at maintaining clear data documentation and mapping records.➥ Created and maintained ETL processes using SSIS to extract, transform, and load data from various sources into the target databases, ensuring data accuracy and consistency. Show less