Chirag Patel

SQL Server Developer

757-***-**** acwxdj@r.postjobfree.com

Summary:

Over 2+ years of professional experience as a SQLServer Developer which includes Installation of Database, Managing Database, Backup & Recovery (both logical and physical), Performance Tuning, Patching, and Migration/ Up gradation.

Implemented Always on availability groups and replicas for reporting, backup and performance

Expert in managing SQL Server in Physical and Virtual Environment.

Expert in implementing, installing and configuring SQL Server Cluster in Active/Active and Active/Passive environment.

Expert in monitoring SQL Server with Diagnostic Manager

Expert in Using extensive SQL Server DMV's for performance tuning and Monitoring

Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities, Linked Servers

Expert in implementing Full, Differential, Log and Compressed backups

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems

Expert in Microsoft Business Intelligent Studio (SSIS/SSRS/SSAS)

Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies

Experienced in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server

Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages

Expert in developing and modifying multi-dimensional cubes using MS SQL Server Analysis Services (SSAS)

Expert in T-SQL writing and developing Database Objects, Triggers, stored procedures, Functions and Views

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

Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import /Export.

Experienced in providing quality operational Support for Production Environments

Provided 24/7 database maintenance and production support

Area of Expertise:

Data modeling and Database design Data Security

Schema Creation and Management Data Integrity

SQL expertise Project Management

Query Writing and Optimization Patch Management

Performance Improvements IT Implementation

Strong Analytical Skills Strategic Thinking

Capacity Planning Web Specific Technology Expertise

SQL Code reviews & Walk-Throughs Ensuring availability

Team Player Procedural Skills

ERP and business knowledge Dedicated

Technical skills:

RDBMS :- MS SQL Server […] […] Oracle (9i,10g), MYSQL

Virtualization :- VMware, oracle virtual machine

Languages :- T-SQL, C, C++,C#, VB, HTML, XML,Java Scripts, ASP.net 3.5 and 4.5

Reporting Tools :- SSRS, Crystal Reports 8.5 and VB.

Operating Systems :- UNIX, Ms-Dos, Ms-Windows Windows Server […],MacOS.

Database Tools :- SQL Profiler, SQL Query Analyzer

Other Tools :- Red Gate SQL Compare, Toad, MS Office Suite, Adobe Suite, Visual Studio

Project Work:

Fees Management System

This project is a gateway to pay the fees for student. I have worked with following technologies: ASP.NET with C#, SQL Server, DreamVeawer, Microsoft Visual Studio.

Franchise Management System

This project is basically a franchise management system which works between franchise and franchiser. I have worked with following technologies: ASP.NET with C#, SQL Server, DreamVeawer, Microsoft Visual Studio.

Cloud Wall(Java Project) as Database Admin

A web application to keep a track of Sybil attacks with Trust Management. In the era of rapid growing technologies, where we even have reached cloud, as they say, the most important aspect is to maintain security. With this web application we can detect of attackers on cloud service providers.

Web monitoring system

Web Monitoring System is a product for monitoring the web sites. It provides the user with valuable

data regarding the series of requests made at the website. The product also analyzes the data and

identifies the bottlenecks involved in the request/response process of the monitored web sites. Web

Monitor consists of a set of distributed components, which collaborates with each other, to monitor a

web site.

I was involved in the Configuring database, generate tables and ensure the availability of database after deployment. All the requests made by users was stored and analyzed using PL/SQL queries. Also worked on the backup and recovery of the database.

Work Experience:

Database Admin at RBM Infosys Jan 2013- May 2015 My responsibilities were

My Responsibilities were:

Involved in creating Stored Procedures, views, tables, constrains.

Created stored procedures and triggers for Data consistency.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.

Rebuilding the indexes at regular intervals for better performance.

Using log shipping for synchronization of database

Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Moved files between the File Groups and partitioned the tables to improve the performance.

Monitoring SQL server performance using profiler to find performance

Wrote complex stored procedures to process employee’s requirement and generating.

Worked on complex T-SQL statements, and implemented various codes and functions.

Write T-SQL Scripts for database backup jobs and daily/weekly jobs.

Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.

Experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines

Education:

Summer 2016 NorthWestern Polytechnic University MS(CS)

2015 Ganpat University M.Sc(IT)

2013 Ganpat University B.Sc(IT)

Certifications:

Oracle Database 10G:Introduction to SQL

Oracle Database 10G:Administration Workshop-1 Release-2

Contact this candidate