SUMMARY:

• 10+ years of Professional Experience as SQL Server Database Developer.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Knowledge in planning and implementing MS SQL server security and database permissions.
• Data transfer between SQL Server and other heterogeneous relational databases
• Monitoring tools and Application support.
• Good experience in querying the database using SQL and programming using Oracle 10g/11g and SQL Server 2005/2008/2012/2015, written stored procedures, joins, packages, database triggers rules, user defined data types, cursors etc. Expertise in RDBMS such as Normalization, Views, Joins Relational Algebra etc.
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views.
• Experience in Migrating from SQL server 2000 to 2005 and 2000/2005 to 2008 by using side - by-side upgrade process, and documented the Upgrade Process.
• SQL Server Business Intelligence Development Studio Expertise to Create SSIS packages, SSRS reports .
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Tune slow running queries using SQL Server Profiler.
• Performed data partitioning for efficient management of database tables and indexes.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Checking the threshold values and baselines and monitoring in perfmon .
• Rebuilding indexes with different fill factors and updating statistics.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Good Team Player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Worked closely with applications development staff, and users on database solutions to business problems.

TECHNICAL SKILLS:

Databases: MS SQL Server 2015\20012\2008\2005, Oracle 8/9/10g/11g

Languages: T-SQL, PL SQL, VB6, .Net 2.0-3.5, C#, Java, HTML, C++, Win Form

Operating System: Windows Server 2003/2008/2008 R2, Window XP/ 7/ 8/10, Linux, Unix.

Others: Microsoft office, Microsoft Project.

Tools: Active X, MTS, Lite speed, Spotlight, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, Erwin 8.0, SSIS, SSRS .

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

SQL Server Developer

Responsibilities:

• Involve in all the phases of the project including, interaction for requirements gathering, analysis, preparing functional and technical design documents.
• Responsible for Database Design, creating tables, views, stored procedures and functions in SQL Server.
• Installed Service packs and Builds on SQL 2008 and SQL 2012.
• Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Access to MS SQL Server by using BCP utility, DTS and SSIS services.
• Worked on SSIS and SSRS and created many user reports.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies.
• Worked on Performance of Production Servers.
• I used to support 24/7 for all SQL Instances
• Performed Performance Tuning of the Stored Procedures.
• Experience in trouble shooting database issues.
• Monitoring SQL server performance using profiler to find the performance and deadlocks.
• Experience in using ERWIN tool for designing the reporting databases.
• Performance Monitoring using SQL Profiler and Windows System Monitor.
• Backup & Restore Plans.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes
• Generated script files when changes applied to stored procedures and functions.
• Managed schema objects like Triggers, cursors, indexes, procedures.
• Creating and Maintaining Database Maintenance Plans.

Confidential

Sr. Software Engineer

Responsibilities:

• Involved in requirement analysis, UI design & Coding, database design & development, testing and documentation.
• Participating in functional review meeting with many officers and project leads.
• Design and developed win forms by using VB.Net.
• Involved in the normalization of the database structures, tables, views, synonym and stored procedures, functions, etc.
• Responsible for creating the utility to take backup of daily data.
• Involved in demonstration and training to many officers about the usage of CPRC.

Environment: VB.Net, ADO.NET, Win Forms, Windows 2000/server, SQL Server 2000, T-SQL, Crystal Reports 9.0

Confidential

SMS (Stock Management System)

Responsibilities:

• Involved in requirement analysis, Win forms and Web forms design & Coding, Validation, database design & development, testing and documentation.
• Design and developed win forms by using VB.Net.
• Design and Developed GUI Web form using HTML, Javascript, ASP.Net, C#.
• Involved in the normalization of the database structures, tables, views, synonym and stored procedures, functions, etc.
• Responsible for creating the utility to take backup of daily data.
• Involved in demonstration and training to many officers about the usage of CPRC.

Environment: VB.NET 1.2, ASP.Net 1.2, C#.Net 1.2, ADO.NET, Win Forms, Web Forms, HTML, DHTML, CSS, Visual Studio 2003, Windows 2000/server, SQL Server 2000, T-SQL, Crystal Reports 9.0

Confidential

Library Automation System

Responsibilities:

• Responsible for requirement analysis, Win forms and Web forms design & Coding, Validation, database design & development, testing and documentation.
• Developed many win forms and web forms.
• The complete application developed by me only and also providing support when needed.
• E-Mail service by using Windows Services.

Environment: VB.NET 1.2, ASP.Net 1.2, C#.Net 1.2, ADO.NET, Win Forms, Web Forms, HTML, DHTML, CSS, Visual Studio 2003, Windows 2000/server, SQL Server 2000, T-SQL, Crystal Reports 8.5

Confidential

Sale - Purchase Management System

Responsibilities:

• Design and work on multi-thread client side application
• Coding using Core Java
• Forms Development using Java Swings
• Web forms development by using Servlets & JSP
• Database Handling using JDBC
• Design and Creating tables, views, sequences, joins using Oracle
• Designing the test cases for the Unit Test and Integration Test

Environment: HTML, DHTML, CSS, JDK 1.2, Core Java, Java Util, AWT, Applet, Java Swings, JFC, JDBC, RMI, Servlets, JSP, Oracle 8.0, Data Source Name, ODBC, Crystal Reports 8.5

Confidential

Billing Automation of Water Supply and Sewerage

Responsibilities:

• Planning, analysis, Database Design, Forms Design, Coding, Testing and Implementation.
• Windows Form Development using Visual Basic 6.0

Environment: Visual Basic 6.0, Oracle 8.0, Crystal Report 8.0, Windows 98/2000/XP.