Sql Server Development Experience .Net Service
Resume:
Vipul Patel
********@*****.***
Contact No - ***-
SUMMARY
. Strong experience in SQL Server Database Administration/Development.
. Experience with SQL Server 2000, 2005, 2008 in Production and
Development Environments.
. 24/7 on Call Support for Production Database.
. Extensive experience in Deploying and Consolidating Multiple
Instances.
. Extensive experience in Installation, Configuration and Administration
for SQL Server in a Clustered and Non-Clustered Environment.
. Experience in Configuring and Maintaining Database Mirroring and
Database Snapshots.
. Extensive experience in Configuration, Implementation and Maintenance
for Disaster Recovery solutions Using Log Shipping, Transactional and
Snapshot Replication in SQL Server 2000/2005.
. Experience in BI Development and Deployment of DTS, SSIS packages.
. Extensive experience in Installation, Configuration and Deployment of
SSRS.
. Designing and Deployment of Reports for the End-User requests using
Crystal report & SSRS.
. Experience in scheduling Backups and Restore, Log Shipping and
Maintenance plans using Native & Third-party tools.
. 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
. Experienced in programming tasks-Stored Procedures, Triggers, Cursors
using SQL Server 2005/2000 with T-SQL
. Experience with upgrade from SQL Server 2000 to SQL Server 2005.
. 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 2.0(VB.Net, ASP.Net, ADO.Net), IIS
6.0
. Testing methodologies and tools - Automation and Performance testing.
. Good knowledge of operating system like WinXp, Vista, Windows 2003.
. Strong communication & Management skills and Excellent Team player.
TECHNICAL SKILLS
Databases: SQL SERVER 2000/2005/2008, MS-Access, Oracle
O/S: Windows Server 2003/2000/XP/98, UNIX
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 .Net, Quest LiteSpeed 5.0/4.5,
Spotlight, Toad for SQL Server, Veritas Netback up,
Erwin, MS- Office2007.
EDUCATION QUALIFICATIONS
. Bachelor of Computer Engineering Sardar Patel University, Anand,
Gujarat, India - January 2004
. Master's of Computer Science, NJIT, NEWARK, NJ - January 2008
. Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server
2005
. Microsoft Certified IT Professional (MCITP): Database Administrator
PROFESSIONAL SUMMARY
Warshaw Group Feb 2010 -
PRESENT
New York, NY
SQL Server DBA
Warshaw group develops data collection and workflow software systems, with
a focus on mobile systems and backend database integration. their systems
feature optimized data entry, retrieval, data presentation, and rapid
deployment on PC, web, mobile and wireless platforms.
- Handled daily backups and developed recovery procedures.
- Scheduled maintenance Jobs and Alerting using SQL Server Agent.
- Involved in writing Ad hoc queries, Stored Procedures, Functions and
Cursors using T-SQL.
- Generated reports using SQL Server Reporting Service (SSRS).
- Created Users, Logins and managed security of SQL Server.
- Used SQL Profiler for Performance monitor to resolve Dead Locks and
long running queries by checking appropriate changes to Transaction
Isolation levels.
- Created SSIS package to export and import data from SQL Server.
- 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.
- Moving objects from Development to QA to Production databases.
- Managed Log Shipping for hot standby computers.
- 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 2008/2005/2000, .Net Framework 3.5, C#.Net,
ADO.Net, JavaScript, VSS, Windows 2003 Server
Citigroup,
July 2008 - Feb 2010
Warren, NJ
SQL Server DBA
Citigroup is one of the largest financial services firms known to man,
Citigroup (also known as Citi) has some 200 million customer accounts and
does business in more than 100 countries. Citigroup offers deposits and
loans (mainly through Citibank), investment banking, brokerage, wealth
management, alternative investments, and other financial services
Responsibilities:
. Planned, Configured, Installed and Maintained of SQL Server in
environment of Multi-node Cluster with Multi- instances.
. Setup and troubleshoot for Active/Passive Clustering in SQL Server
2005 and SQL Server 2008.
. Configured and Monitored Database Mirroring for Application
Development environment
. Created SSIS package to export and import data from SQL Server to
Access, text and EXCEL files.
. Migration of DTS packages to SSIS packages
. Scheduled maintenance Jobs and Alerting using SQL Server Agent.
. Involved in Installation, Configuration and Deployment of Reports
using SSRS.
. Wrote T-SQL for the retrieval of the data.
. Involved in writing Stored Procedures, Functions an Cursors using T-
SQL.
. Involved in SQL Server Configuration, Administration, Implementation
and Trouble-shooting for Business work.
. Configured Disaster Recovery solution with Snapshot and
Transaction Replication from Distribution Server.
. Controlled and coordinated the installations (Security Patches,
Service packs) and evaluated the performance before Pre-
deployment.
. 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.
. Used NetMon for Monitoring and Performing Network throughput issues.
. Created Users, Logins and managed security of SQL Server.
. Work involvement in performance monitoring of Memory, Processor, Disk
I/O and fine tuning
. Handled Scheduled backups and restore operations with Litespeed 5.0
and monitored the tasks and Maintenance plan.
. Handled daily backups and developed recovery procedures.
Environment: SQL Server 2008/2005/2000, .Net Framework 2.0, C#.Net,
Asp.Net2.0, ADO.Net, JavaScript, VSS, Windows 2000, Windows 2003 Server,
LiteSpeed 5.0, Veritas Netback up
Credit Suisse
Oct 2007 - Jun 2008
Credit Suisse, Oct
2007 - Jun 2008
NewYork, NY
SQL Server DBA
Credit Suisse is divided into three segments: investment banking, private
banking, and asset management. Its investment banking division provides
debt and equity underwriting, mergers and acquisitions, and other
securities services. Asset management offers a range of investment
opportunities for private, government, and institutional clients.
Responsibilities:
. Created and maintained various databases for Production, Development
and Testing environments using MS SQL Server 2005.
. Transformed data from various data sources using OLE DB connection by
creating various SSIS packages.
. Involved in Creation, Development and Deployment of SSIS packages in
SQL Server 2005.
. Interaction with development team to resolve in perspective of high
utilization of Server in depends on performance issue of High
throughput.
. Performed Database Refresh tasks from production to Development and
Staging Servers
. Performed Scheduled backups and restore operations with Litespeed 4.5.
. Involved in creation of Logins, Users, groups, Roles, Jobs, Alerts,
Mails confirmation upon tasks
. Managed Log Shipping for hot standby computers.
. Performed Database consistency checks with DBCC, Defrag, Index tuning
and monitored error logs.
. Used Database Tuning Advisor for Database performance for proper
indexes
. On-Call support to esteemed customers to resolve with Disaster
Recovery mechanism.
. Maintained two different databases: Read-only reporting database and
Disaster recovery database
. Performed security tasks like Grant, Revoke permissions for security
tasks.
. Performed Physical and Logical Data Modeling for databases of varied
sizes including VLDBs.
. Monitor and tuned the server and databases using DBCC, server
configuration options like sp_configure and database option as
sp_dboption.
. Involved in auditing and performing the transactions to database and
resolve the issues with PerfMon and SQL Profiler and Used NetMon for
Monitoring and Performing Network throughput issues.
. Resolved issues for mission critical of high usage of system CPU,
Disk, Deadlocks issue and Transaction per/sec, Memory
. Developed Stored Procedures, Triggers, and SQL scripts for performing
automation tasks.
. Developed Packages for Data transfer/Migration using SSIS Packages.
. Performed and fine tuned Stored Procedures and SQL Queries and User
Defined Functions.
Environment: SQL Server 2005, .Net Framework 2.0, C#.Net, Ado.Net,
JavaScript, VSS, HTML, Windows 2003 Server, LiteSpeed 4.x
Saks Fifth Avenue
June 2006 - Sep 2007
NewYork, NY
SQL Server DBA
Saks Fifth Avenue, Inc. retails apparel for men and women, shoes and
handbags, jewelry and accessories, and gift products. It offers denim,
dresses, swimwear, shorts, outerwear, intimate apparel and hosiery for
women; and sportswear, dress shirts and ties.
Responsibilities:
. Involved controlling and co-coordinating the installations (security
patches, Service packs) and system performance before pre-deployment
in production.
. Interact with development team to resolve in perspective of high
utilization of Server upon the transactions.
. Involved in solving high critical throughput, mission critical
problems with interaction of development team.
. Setup Snapshot and Transactional Replication between Servers, and
troubleshoot and monitor Publishers, Distributors, and Subscribers.
. Involved in Installation of SQL Server with Multiple instances, latest
Service packs and hot fixes
. Performed Database Refresh tasks from production to Development and
Staging Servers.
. System performance monitors and interacts with development upon
transactions into server.
. Monitored Server performance on scheduling basis and gather data for
analysis.
. Involved in auditing and performing the transactions to database and
resolve the issues with PerfMon and SQL Profiler
. Used Index tuning wizard to create proper indexes
. Performance monitor of Memory, Processor, Disk I/O, fine tuning, Disk
usage, Cache-hit ratio, Transaction per/sec, shrinking of databases
. Created the logins, groups, roles, jobs, alerts, mails confirmation
and Authentication modes for various users upon tasks
. Involved in upgradation of SQL Server 2000 to SQL Server 2005
. Monitored and tuned the server and databases using DBCC, server
configuration options like sp_configure and database option as
sp_dboption
. Involved in Creation of databases, writing queries, tuning of
execution plan for tracing the execution flow for critical throughput
Environment: SQL Server 2005/2000, Windows 2003/2000, Visual Basic 6.0,
VERITAS Net Backup and Crystal Reports
AvePoint
Dec 2005 - May 2006
Jersey City, NJ
SQL Server DBA
Responsibilities:
. Involved in Technical sessions to enhance the new features for
Business Work Flow.
. Involved in controlling and co-coordinating the installations
(security patches, Service packs) and system performance before pre-
deployment.
. Configured Disaster Recovery solution using Log Shipping for
maintaining the databases.
. Setup for Snapshot and Transactional Replication between Servers,
troubleshoot and monitor Publishers, Distributors, and Subscribers.
. 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
. Performed Uploading of bulk data using BCP Utilities
. Database support with Store Procedures, Cursors and Queries
. Handled On-Call Support with concern to issues
Environment: SQL Server 2000, VB 6.0, Crystal Reports, Quest TOAD tool,
Windows Server 2003 / 2000.
Citizenship
US Citizen
Contact this candidate