Rakesh Patil
Summary
SQL Developer with 4 years of progressive experience (Skills>Experience) In databases with Extensive understanding of Identifying Process Improvement
Overview
4
4
years of professional experience
Work History
SQL Developer
Vagaro Technologies
Ahmedabad
04.2021 - Current
- Be creative with requirement and Ability to work independently within a team and follow through with priority tasks And Work Closely with Development Team to implement Effective and maintainable database coding practices
- Experience in Creation of development,Staging and production database instances and responsible for the database architecture and design, Implement and maintain database code in the form of Stored Procedure,Queries,Scripts,Functions,Triggers,Views etc.
- Responsible for developer SQL Code Review to ensure queries are optimized and reading query plans to perform efficiently prior to production release Lead Efforts to Develop and improve procedures for reducing CPU time,Logical Reads,Execution time Try to Reducing any need for downtime And Understanding of Index design,Query Tuning and SQL Performance tuning techniques
- Good Knowledge of data warehouses, Data flow ETL Pipelines Experience in Create reports in SSRS and ETL Packages in SSIS Experience in Designing,Building and Deploying Effective SSIS Packages.
SQL Developer/DBA
Healthvalors Technologies
Ahmedabad
04.2018 - 04.2021
- Experience in Creating Roles and managing user permission, Jobs, Alerts, Activity monitor/Profiler for resolving deadlocks, Blocking Issues
- Resolved Database Connectivity Issues, Database Corruption issues (Suspect Mode) Provide Ad-hoc support and Good Knowledge in troubleshooting performance issues like High CPU, Memory, IO Issues, Slow Query Performance
- Monitor SQL Server Error Logs, Event Logs, Disk Space Growth, Temp DB Review and Monitor, Analyze and optimization Indexes Strategy (Drop Unused and Create Proper Index Based on Workload of Database), Rebuild and Reorganize Indexes Based on Fragmentation for performance Related Issues
- Experience in Various Ad hock, Routine and Planned Tasks Like Data Extraction, Data Migration, Structure Migration, Schema Change/Update, Scrum meeting/Discussion, Support Issue Tracker, Ad hock Support.
Education
Bachelor of Engineering - Information Technology
GEC Modasa
Modasa, Gujarat05.2017
Skills
- SQL Development
- Performance Tuning
- SQL Maintenance Activities
- SSIS
- SSRS
- Project Management
Timeline
SQL Developer
Vagaro Technologies
04.2021 - Current
SQL Developer/DBA
Healthvalors Technologies
04.2018 - 04.2021
Bachelor of Engineering - Information Technology
GEC Modasa