Sql Server Project

Jaimin Patel

** ******** ***.

Cell: 732-***-****

Fords, NJ 08863

*********@*****.***

Summary:

. 8 years of experience as a SQL Server Database Administrator

maintaining SQL Server 2000/2005/2008/2012

. Expert in designing, maintaining,and tuning SQL Server 2000/2005/2008

. Proficient in developing stored procedures, SSIS, DTS, and Server

agent scheduling in SQL-Server

. Extensive knowledge in Indexing, T- SQL queries, Partitioned Tables

and improving the performance of the database

. Implemented different types of replication models like snapshot and

transactional

. Extensive knowledge of database backup, replication, recovery,

restoration, and Linked servers

. Set up Cluster environment for failsafe dual node

. Tremendous SQL Server Administration skills including user

authorizations, database creation, tables, indexes, and clusters

creation

. Good knowledge and experience in Database Modeling & Normalization

Concepts

. Excellent experience as SQL programmer in development of large-

scale, performance critical client/server and web applications

. Managed 24X7 environment of FDA regulated and 21 CFR data for the top

10 pharmaceutical companies

. Database design, security, policies

Education:

New Jersey Institute of Technology, Newark, NJ

Bachelor of Science in Information System

Essex County College, Newark, NJ

Associate of Science in Computer Science

Software/Hardware:

MS SQL Server 2000/ 20005/ 2008, SQL, SQL Navigator 6.0, My SQL Access,

Visual Source Safe 6.0, Crystal Reports 10.0, ERWIN r7.2, Beyond Compare 2,

HTML, MS-Visio, MS-Projects, Windows Server 2000/2003/2008

Experience:

Jersey Mike's Corporation Feb 2013

- Present

Senior Database Administrator

. Administrating SQL 2008/2012/Express over 650 servers

. Set up active-active cluster nodes

. Managing transactional replication and merge replication for 600

subscribers

. Responsible for trouble shooting server issues and slow running

queries

. Work with developers to improve the system and making

recommendation for writing better TSQL

. Building Disaster Recovery site and also managing backups and

restores for all environments and do capacity planning

. Deploy ETL processes for all environments

. Manage security, roles and groups

AMBAC Financial Group, INC. Feb 2011 - Feb

2013

Assistant Vice President / SQL DBA

. System administration with primary emphasis on MS SQL (2k and

higher) servers, multi environments and related technologies, for

production, test and disaster recovery environments.

. Managing database security (users, object/system level privileges,

and roles), monitoring/managing space usage, basic capacity

planning, schema synchronization, tuning, and problem

solving/troubleshooting

. Working with application support team to successfully deploy, run

and support all database servers such as configuration/setup,

problem solving/troubleshooting bugs, and optimizing batch jobs

. Assisting development groups in working, using, supporting and

deploying ETL changes in multi environments

. Resolving Performance issues, Tune codes and stored procedures

. Using Partitioned Tables to manage large scale database for ETL

processes

. Updating statistics, rebuilding/reorganizing indexes

. Creating and importing SSIS packages

. Implementing backup plans across the network

. Deploying changes on Core side / executing PL/SQL packages and

managing change control processes

Environment:

SQL Server 2000/2005/2008, Window Server 2008,

International Swaps & Derivatives Association

SQL Server DBA

Feb 2007 - Jan 2011

. Complete administration of MS-SQL Server 2000 and SQL Server 2005

. Responsible for re-designing overall architecture of end-to-end

database based applications

. Involved in requirement gathering, requirements for the data

analysis

. Perform data modeling and normalization

. Troubleshoot on going performance issues presented by users

. Redesign indexes or introduce optimized indexes for better

application performance

. Use Performance Monitor and SQL Profiler to optimize queries and

enhance the performance of database servers

. Install and configure new SQL servers

. Set up transaction replication

. Create DTS and SSIS packages

. Tune Triggers and Stored Procedures

. Planning Backup, recovery to ensure up-to the minute recoverability

. Generate and modify reports and ad-hoc queries

. Maintain database such as backup/recovery plan, check integrity,

indexes

. Support online users 24X7

. Provide training to subordinates

Environment:

SQL Server 2000 / 20005, Window Server 2008, Crystal report 10

Medidata Solutions Inc.

July 2005 - Feb 2007

SQL Server DBA

. Complete administration of MS-SQL Server 2000 and SQL Server 2005

. Supported 24X7 production environment of FDA regulated and 21 CFR

data for the top 10 pharmaceutical companies

. Installed SQL Server 2000 and 2005

. Build cluster environment for SQL Server 2000/2005

. Managed health of over 50 servers

. Upgraded databases from 2000 to 2005

. Moved and restored databases across the network

. Implemented new stored procedure to improve performance

. Planned Backup, recovery to ensure up to the minute recoverability

. De-bugged existing SQL objects

. Created transactional replication on both SQL Server 2000 and 2005

. Run critical scripts and patches into production

. Created DTS packages to move data or objects across the network

. Login and User Management: Adding logins, roles, groups to the

Window NT and SQL Server, and maintaining proper security

procedures

. Used SQL Profiler to optimize queries and enhance performance

Environment:

SQL Server 2000, SQL Serer 2005, Windows Server 2003

Edelman, New York, NY

Mar 2005 - June 2005

SQL Server DBA

www.ourcolony.net

The project was a campaign for Microsoft to launch its new product XBOX 360

in near future. The project involved creating a web site where people can

work together in teams in order to solve the challenges on daily bases. At

the end of the project, Microsoft promoted its new XBOX 360 through this

site.

. Complete administration of MS-SQL Server 2000

. Installed and configured SQL Server 2000

. Transferred databases to different servers

. Created DTS packages to import data

. Set up challenges and maintained web site on daily bases

. Written numbers of stored procedures and triggers using T-SQL

. De-bugged existing stored procedures and triggers

. Created views and indexes on tables to improve performance

. Developed database back up plans

. Worked closely with front-end programmers to resolve the issues

. Added logins, roles, and groups to the Window NT and MS SQL Server,

and maintaining proper security procedures such as assigning

permissions

. Scheduled Jobs and alerts using SQL Server Agent

. Supported a large number of online users

Environment:

SQL Server 2000, Windows 2000

Contact this candidate