SUMMARY

• Strong experience in SQL Server Database Development/ Administration.
• Experience with SQL Server 2000, 2005, 2008 in Windows environment.
• Expert in designing relational database model and implementation as per business requirements.
• Experience in designing Database Models using MS Visio and ER - win.
• Proficient in creating Index, Views, Complex Stored Procedures, functions, and Triggers to facilitate efficient data manipulation and data consistency.
• In-depth knowledge of Transact-SQL DDL and DML.
• Experience with tuning SQL queries and improving the query performance using SQL server profiler.
• Experience in BI Development and Deployment of SSIS packages.
• Experience in scheduling Backups and Restore, and Maintenance plans using Native & Third-party tools.
• Experience with Log Shipping for hot standby computers.
• Good knowledge in developing and implementing Disaster Recovery Model and Replication Models.
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Extensive experience in controlling the User Privileges, Monitoring the Security.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Experience with upgrade from SQL Server 2000 to SQL Server 2005 and SQL Server 2008.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects.
• Good knowledge in OOP’s concepts and Business Objects.
• Working knowledge of .Net Framework 3.5(VB.Net, ASP.Net, ADO.Net), IIS 6.0
• Good knowledge of operating system like WinXp, Vista, Windows Server 2003.
• Strong communication skills and Excellent Team player.

TECHNICAL SKILLS

Databases: SQL SERVER 2000/2005/2008 , MS-Access, Oracle 10g

O/S: Windows Server 2003/2000/XP/98

Programming Languages: SQL, PL/SQL, VB 6.0, VB.Net, C#, VBScript

Web Technologies: Asp.Net, HTML, XML, IIS 6.0, Java Script

Tools: MS Visual Studio, Quest LiteSpeed, Toad for SQL Server, MS Visio, Erwin, MS- Office2007. Embarcadero, Adapt SQL Diff, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

SQL Server Developer

Responsibilities:

• Involved in writing Ad hoc queries, Stored Procedures, Functions and Cursors using T-SQL.
• Defining Check constraints, functions, triggers and views.
• Designed index to improve the performance of query.
• Used SQL Profiler to optimize queries and enhance the Performance of database server.
• Developed SSIS packages to move data from source to destination.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and long running queries.
• Created SSIS package to export and import data from SQL Server.
• Handled daily backups and developed recovery procedures.
• Work as part of a project team to coordinate database development and determine project scope and limitations.
• Responsible for implementation and release of database changes according to agreed timelines and schedule

Environment: SQL Server 2005, .Net Framework 3.5, C#.Net, ADO.Net, JavaScript, VSS, Windows 2003 Server

Confidential, Exton, PA

SQL Server Developer/ DBA

Responsibilities:

• Developed stored procedures, triggers and functions.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Created tables, indexes, and other SQL Server objects.
• Wrote T-SQL for the retrieval of the data.
• Involved in queries optimization using tools such as SQL Profiler, Tuning Advisor, and statistics IO.
• Created SSIS package to export and import data from SQL Server to Access, text and EXCEL files.
• Scheduled maintenance Jobs and Alerting using SQL Server Agent.
• Managed Log Shipping for hot standby computers.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Database Performance of Index tuning with using Database Tuning Advisor to resolve issues.
• Created Users, Logins and managed security of SQL Server.
• Handled Scheduled daily backups and restore operations and monitored the tasks and Maintenance plan.

Environment: SQL Server 2005/ 2008, .Net Framework 3.5 C#, JavaScript, Visual Source Safe, Windows 2003 Server

Confidential, Jersey City, NJ

SQL Server Developer/ DBA

Responsibilities:

• Created Index, Views, Complex Stored Procedures and functions.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules.
• Cleaned and maintained the database by removing and deleting old data.
• Scheduled maintenance Jobs and Alerting using SQL Server Agent.
• Scheduled jobs for backup, and created alerts for error reporting.
• Wrote T-SQL for the retrieval of the data.
• Performed Database Refresh tasks from Production to Development and Staging Servers
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage.
• Involved in Creation of logins, Users, groups, roles, jobs, alerts, mails confirmation upon tasks

Environment: SQL Server 2000/2005, Crystal Reports, Quest TOAD tool, Windows Server 2003.