Sql Server Ms

Viral Desai

Immigration: Green Card

Address: **** ***** ****** *****

Abingdon, MD

Email: actvfz@r.postjobfree.com

Phone No: 443-***-****

EXPERIENCE SUMMARY.

6+ years of IT experience with Database Administration on MS SQL SERVER 2012/2008 R2/2005/2000 in Production, Development and Testing Environments.

Hands-on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2014/2012/2008 R2/2008/2005/2000 on Windows 2008/2003/2000/NT server.

Implemented MS SQL Server 2012 on Development and Test Environment

5+ years solid experience on SQL Server Integration Services (SSIS), ETL packages

3+ year of experience in creating heavy duty SQL Server Reports with (SSRS)

5+ year experience in Advanced T-SQL Programming and Application development

5+ year experience in Active/Active and Active/Passive Clustering

Strong experience with T-SQL, Stored Procedures, Functions and Excel macros

Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company’s Security Policies

Extensive knowledge with Backups, Restoration and Disaster Recovery Planning.

Extensive experience in developing Stored Procedures, Views, Triggers, and Complex Queries on SQL Server 2008 R2/2008/2005.

Experience in Upgrading of SQL Server from version 2000 to 2005 and 2005 to 2008/2008R2.

Highly Proficient in migration of Databases, packages and Job activities from MS SQL Server 2000 to MS SQL Server 2005/2008R2 and also migrating the database from development to production, and migrate the data between the databases.

Experience in Constructing Server Baselines and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMV's, and SQL Query Analyzer and performed Query Optimization.

Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning

Experience in designing & implementing high availability, clustering, log shipping and/or mirroring standby, large database management, and partitioning.

Experienced in Data Migration between Homogeneous & Heterogeneous Systems using various tools

(SQL Server Upgrade Advisor, DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP and SSIS).

Automated Database Consistency Checks, Fragmentation checks and Index Reorganization/Rebuilding Operations.

Technical Skills

RDBMS/DBMS: MS-SQL Server 2005/2008/2012, Oracle10g

Operating Systems: Windows Server 2012/2008, Windows XP/Vista, Windows 7

Programming Languages: T-SQL, PL/SQL, C/C++.

Office/Business tools :Acrobat, MS Word, MS Excel, MS PowerPoint Education

M.S. in Computer Science, New Jersey Institute of technology, Newark, NJ, USA. GPA 3.0/4.0

B.E. in Mechanical Engineering, SVIT, Gujarat University, India. GPA 3.62/4.0 Certification

Microsoft Certified Technology Specialist (MCTS), SQL Server 2005 Viral Desai

Immigration: Green Card

Address: 3704 Misty Valley Court

Abingdon, MD

Email: actvfz@r.postjobfree.com

Phone No: 443-***-****

Experience Details

KARVY Computershare Pvt. Ltd., India July 2012 - April 2015 SQL Server DBA/Developer

Installed Standalone and Clustered SQL Server 2005/2008 R2 instances in Production and Development environments.

Experience in setting up High Availability environments like Active-Active and Active-Passive Clustering.

Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.

Worked extensively on Database space management, performance monitoring and alert management.

Configuring, administration and troubleshooting multiple databases which include databases in QA and Production environments in clustered and stand-alone environments.

Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements

Suggested backup strategies, Scheduled backups and Performed restoration operations.

Worked with migrating data from SQL Server 2005 to SQL Server 2008.

Created Jobs and scheduled jobs according to the requirements.

Designed and created ETL process in SSIS

Implemented various transformations and created SSIS packages

Created SSRS simple and Drill-down reports depending on client requirement

Dropped and recreated the indexes on tables for performance improvements.

Written complex stored procedures and functions and integrated it with the front end application.

Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Extensively used SSIS to move data from text files to SQL Server.

Created packages successfully using SSIS to transfer large volume of Data. Environment: Windows 2008/2003 Server, MS SQL Server 2008/2005/2000, Business Intelligence Development Studio, T-SQL, Lite Speed, SSIS, SSRS, BCP, SQL Profiler. HCL America, NC, USA Sep 2010 – Feb 2012

Project: VEC UI Modernization

Role: Project Engineer

Involved in implementing a modularized database in the development environment.

Involved in creating data model diagram in Microsoft Visio.

Performed database backup and maintenance using SQL Server Management Studio 2008.

Developed Mapping spread sheet for data migration.

Involved in Mapping of destination tables with legacy sources.

Involved in data cleansing from old database.

Ensure all database environments (Development, QA and Production) are in sync(DB Refresh when requested).

Viral Desai

Immigration: Green Card

Address: 3704 Misty Valley Court

Abingdon, MD

Email: actvfz@r.postjobfree.com

Phone No: 443-***-****

Implemented JBOSS application for development environment.

Designed and developed test cases for putting the application on Manual testing.

Performed smoke and regression testing on web based application.

Performed testing on in-house data-migration script generating tool. Environment:

MS SQL Server 2008, SSIS, Microsoft Visio 2010, JBOSS 4.0.5, Windows Vista/7. Assurant Health, PA Jan 2009 – Aug 2010

Role: SQL Developer

Performed MS SQL Server Installation and upgradation.

Extensively used Joins and sub-queries for complex queries involving multiple tables

Optimized the database by creating various clustered, non-clustered Indexes and Indexed Views

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Involved in creating Stored Procedures, views, tables, constrains, triggers, functions

Rebuild the indexes at regular intervals for better performance Environment:

MS SQL-Server 2005, BIDS, Windows Server 2003, SSIS, SSRS.

Contact this candidate