Sql Server Project Manager

[pic]

Mayank Patel

**** ******** ***** **

Apt # N-1, North Bergen - 07047

New Jersey.

*************@*****.***,

Cell : 201-***-****

Visa status: Green Card Holder

Summary:

. Over 3+ years experience in the IT industry as a SQL DBA.

. Expert in MS SQL Server suite of products like SQL Server, SQL

Server Reporting Services, SQL Server Analysis Services and SQL

Server Integration Services.

. Experience in working on all activities related to

installing, configuring, managing, monitoring and

troubleshooting SQL Server 2000, SQL Server 2005, SQL Server

2008.

. Solid experience in Database Upgrade from SQL 2000 to SQL 2005 to SQL

2008.

. Experience in MS SQL Server performance tuning, client/server

connectivity, query optimization, running Database Consistency Checks

using DBCC commands.

. Highly proficient in the use of SQL Server 2005 and T-SQL in

constructing triggers, tables, user functions, views, indexes, user

profiles, relational database models and data integrity, SQL joins and

query writing.

. Detail-oriented, results-driven, excellent verbal and written

communication skills with interpersonal and conflict resolution skills

and possesses strong analytical skills.

Education:

. Master of Information Technology (M.I.T) from Swinburne University,

Melbourne - Victoria, Australia.

. Bachelor of Science (I.C.) from Sardar Patel University, V.V.Nagar

(Gujarat), India.

Certification:

. Microsoft Certified Technology Specialist (MCTS) in Microsoft SQL

Server 2005

Software/Hardware:

SQL Server 7/2000/2005/2008, MS Access, Visual Basic 6.0, Windows

9x/NT/2000/XP/Server 2003, T-SQL, PL/SQL, HTML, XHTML, Java Script, VB

Script, XML, XSLT, Oracle 8i,9i & 10g, MS Visio 2003.

Experience

VEDALEON TECNOLOGIES NOV 08 - APR 10

Melbourne, Australia.

Reference: Viren Mistry

Project Manager (0061) (433931308)

SQL Server DBA

Responsibilities:

. Installed and configured edition of SQL Server 2008 like Enterprise

edition.

. Successfully migrated from SQL Server 2005 to SQL Server 2008 on

Development and Testing Environment.

. Involved in designing of Conceptual Logical Model and Physical Model.

. Performed Data Modeling tasks and designed Entity Relationship

Diagrams.

. Used ERwin for Data modeling, designing and building relational

databases.

. Supported the Business Intelligence (B.I) division, concentrating on

SSIS (Integration Services), SSRS (Reporting Services), SSAS (Analysis

Services), Data Warehousing, Data Mart operations, OLAP and OLTP

databases.

. Handled up to 2 TB Size databases with clustered and log shipping

environment

. Created Complex SSIS packages for the extracting, transforming and

loading the data from SQL Server 2005, flat files, ORACLE, Excel

files.

. Expertise in Data Cleansing, mapping columns, Lookup with Various SSIS

OBJECTS,

. Converted all existing DTS package of MS SQL 2005 to SSIS packages by

using package migration wizard and Deployed new Package in different

Server.

. Migrated new database structures, such as tables, indexes and stored

procedures from development to the production environment.

. Tuned stored procedures, triggers, views and adding/changing tables

for data load and transformation, and data extraction.

. Monitored database system details within the database, including

stored procedures and execution time and implement efficiency

improvements.

. Development of automated daily, weekly and monthly system maintenance

tasks such as database backup, replication verification, Mirroring,

database integrity verification, indexing and statistics updates.

. Redesign of database architecture with help of Microsoft Database

development group and internal staff to increase application

concurrency and performance.

. Implemented transactional replication to enhance the failover

capabilities increased over all database manageability and improved

performance.

. Implementing different Development and Test Server instances for the

Application Development Team and to co-ordinate Development and

Testing Environments and keep them updated.

. Daily support, troubleshooting, monitoring, optimization and tuning of

server and SQL server environments across entire system.

. Creating logins and roles with the appropriate permissions.

. Optimized the Disk space for performance using RAID and SAN.

. Monitoring & Analysis of SQL Log, Performance counters and Performance

Tuning for all development and staging environment.

. Responsible for resolving blocking and locking issues.

. Worked with TOAD for Oracle to create PL/SQL Script.

. Successfully implemented database mirroring between Primary server

and Mirror Server.

. Implemented log shipping in standby mode to support DR servers.

. Maintained and configured the websites in IIS 6.0

. Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: Microsoft Windows Server 2008 Enterprise Edition, Microsoft

Windows 2003 Server, Microsoft SQL Server 2005, 2008, Microsoft SQL Server

Analysis Services, Microsoft SQL Server Integration Services, Microsoft

SQL Server Reporting Services, ORACLE 10g, Microsoft OFFICE 2003.

[pic]

Contact this candidate