SAMIR J. PAWAR

Mobile No.989-***-**** / 902-***-****

Email: adq4yx@r.postjobfree.com

Sr. SQL Developer LinkedIn: linkedin.com/in/samir-pawar-962749123 Mumbai, MH, India

SUMMARY

• 8 Year and 3 month of work experience as a SQL Developer in IT industry

• Experienced in SQL Server 2008/10/12/14 and Above

• Hands on experience in writing simple/complex queries, T-SQL, Views, Stored Procedures, Functions, Triggers, User Defined functions etc.

• Experience in optimization tools such as Index tuning wizard, SQL Profiler, MS SQL Server performance and Deadlocks/Long running queries

• Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.

• Tuned and optimized queries by altering database design, analysing different query options, and Indexing strategies

• Basic Knowledge of SSRS, SSIS, ADF.

• Perform DTS Activity to import and export data from SQL Server to Excel or vice versa. WORK EXPERIENCE

Sr. SQL Developer – Tech Mahindra 05/2021 –Present

• Reviewing Procedures.

• Created procedure depend on requirement.

• Designing and coding database tables to store the application’s data.

• For Performance of query created index.

Sr. SQL Developer – LocoBuzz Solutions Pvt Ltd, Mumbai 10/2018-05/2021

• Reviewing Performance and Optimizing code.

• Conducted query Performance Review of SQL Database for business-critical applications with Manager. Perform root cause analysis on failures.

• Designing and coding database tables to store the application’s data.

• For Performance of query created index.

Sr. SQL Developer – Cnergyis Infotech Pvt Ltd, Mumbai 02/2015 – 09/2018

• Designed and Implemented Tables, Functions, Stored Procedures, Views and Triggers

• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.

• Migration of SQL Database

• Installation & Patching SQL Server Database related issues. Monitoring the database status. Software Engineer – Infoton Solution Pvt Ltd, Mumbai 12/2013 – 02/2015

• Designed and Implemented Tables, Functions, Stored Procedures, Views

• Database support to client

• Created and modified stored procedures to ensure that complete and accurate data was available to .Net applications to use for reporting.

• Check Report Performance

AWARDS:-

• TWICE STAR PERFORMER AWARD at Cnergyis Infotech India (P) LTD.

• FIVE TIMES STAR PERFORMER AWARD at LocoBuzz (P) LTD.

.

EDUCATION

Sathaye College – B.COM

NIIT (GNIIT)

2010 – 2011

2010 – 2012

SKILLS

Databases: MS SQL Server (2008, 2010, 2012, 2014) And Above Languages: C#.NET, SQL

Microsoft Technologies: SQL Server, SQL Server Reporting Services, SQL Server Integration Services, MS Excel, MS Word

Tools: SQL Server Management Studio,, Visual Studio 2017(SSDT) OS: Windows 2003, XP, Windows 7 And Above

Contact this candidate