SQL Developer and Database Engineer

GAURAV PATIL

Pune, Maharashtra Email: **************@*****.*** Phone: +91-960*******/832-***-****

LinkedIn: https://www.linkedin.com/in/gaurav-patil-8235b3222 Professional Summary

Reliable Software Engineer and SQL Developer with 3+ years of experience in designing, developing, and optimizing SQL queries, stored procedures, database solutions and maintenance, aiming to contribute to a dynamic team with strong problem-solving skills and a commitment to organizational growth. Technical Skills

Programming Languages: SQL, PL/SQL, T-SQL

Database Management Systems: Microsoft SQL Server, MySQL Database Development & Expertise: T-SQL Programming, Stored Procedures, Functions, Views, Triggers, Query Optimization & Performance Tuning, Indexing & Execution Plan Analysis, Database Design & Normalization, Data Manipulation.

Developer Tools: SSMS (SQL Server Management Studio), SQL Server Profiler, SSRS (SQL Server Reporting Services), Postman, Visual Studio, VS Code, Git & GitHub

Professional Experience

Prowess Selling Skills Private Limited - Pune [April 2023 – Present] Associate Software Developer – Database

Projects: - [DMS Structure Module]

Involved in Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems. Perform DML, DDL Operations as per the Business requirement. Creating views and preparing the Business Reports. Resolved production issues by modifying backend code as and when required. Used different joins, sub queries and nested queries in SQL query Documented the data such as entity relationships and attributes, file descriptions and definitions. created Database Objects like tables, Views, Stored Procedures, functions and Cursors. Testing of code functionality using testing environment.

Designed and implemented data flow and database architecture for Distributor and Company modules.

Developed modules for Retailer Loyalty Programs, Stock Inward/Outward Management, Invoicing, and Tele-calling systems.

Wrote complex SQL queries, subqueries, and Common Table Expressions (CTEs).

Developed and maintained Stored Procedures, Functions, Views, and Tables.

Created and optimized complex queries to improve database performance and availability.

Implemented query optimization techniques and indexing strategies.

Generated BI reports by creating optimized Stored Procedures with proper exception handling.

Used XML and JSON for data reading, parsing, and insertion operations.

Worked with Cursors for row-by-row data processing where required.

Created backend database logic for web and mobile applications.

Troubleshot and resolved database issues, including handling SQL Server Always On availability groups.

Identified and fixed bugs to ensure smooth system performance. Associate Software Developer – Database (L3 Support)

Provided L3 production support and solved critical incidents affecting applications and databases.

Handled ServiceNow tickets including code fixes, performance issues and enhancements.

Monitored SQL Server and application performance to ensure system stability.

Analyzed logs and resolved failed or incomplete scheduled jobs.

Documented production issues and resolutions using HelpDesk ticketing tool. Education

B. Tech in Computer Science 2019-2022

KCE Society’s College of Engineering and Management, Jalgaon CGPA: 8.76

Diploma in Computer Science 2015-2018

SMT. S.S.PATIL Poly Institute of Technology, Chopda Percentage: - 64.38%

Certification

Completed Six months Training of Manual Testing from Cyber Success, Pune.

Completed Three months Training of Core Java from R3 Systems India Pvt. Ltd. Nashik.

Contact this candidate