Sql Server Project

ADWAIT A. KULKARNI

Email Id:******************@*****.***

Mobile: +91-997*******

OBJECTIVE:

To excel in given area of activity, by taking challenging assignments at

work place.

Shaping my skills by maintaining learning attitude and contribute to the

growth of the organization with the skills and knowledge acquired over the

time.

EDUCATIONAL QUALIFICATION:

o Master of Computer Application from Pune University with first class in

year 2011.

o B.Com from Pune University in year 2007.

o HSC through MH Board in year 2004.

o SSC through MH Board in year 2002.

o Completed C# DOT NET and ASP.NET certification from Seed InfoTech.

TECHNICAL SKILLS:

PROGRAMMING LANGUAGE : C, C++, JAVA, C#

Operating System : Windows XP, Windows07.

Database : MS-SQL, MS-Access.

STRENGTHS:

ABILITY TO GRASP NEW TECHNOLOGIES QUICKLY AND USE THEM.

Confidence.

Teamwork.

Commitment.

Flexibility.

PROFESSIONAL EXPERIENCE:

Currently Working In: Allscripts, Pune

Designation: Associate Database Administrator

Work Experience: 1 Year 10 months

PROJECT PROFILE:

CLIENT : B&T, SMG, PIH, QLIMG, TBHC

Project : Health Care Project

Domain : Health Care

Role : SQL DBA

Team size : 5

Environment : Microsoft SQL Server 2005, Microsoft SQL Server 2008 on

Windows Server 2003, Windows Server 2008

Duration : Feb' 12 to Till Now

Role and Responsibilities:

. Administering SQL Server Production Database

. Installation, Configuration of SQL server 2005,2008

. Backup client databases and perform database restore and run

consistency checks from SQL Server and application.

. Monitor the status of Maintenance jobs schedule to run daily and on

weekends (tasks like rebuilding indexes).

. Maintenance of Log shipping and replication.

. Rebuilding the indexes at regular intervals for better performance.

. Involved in trouble shooting and fine-tuning of databases for its

performance and concurrency.

. Making data available to all the resources using the Transactional

Replication.

. Regular checking of the database consistency using DBCC commands to

minimize complexity.

. Installation & Configuration of SQL Server 2005, 2008, 2008 R2 on

Local System and Remote System.

. Resolves if any backup or other job failures.

. Creation of database users and assigning permissions.

. Capacity planning and monitoring database growth using quest capacity

manager tool.

. Designing disaster recovery strategies.

. Find out long running query, procedure and views using SQL Server

profiler and tune the query for better performance.

. Minimize log file size using log backup and after that shrinking the

database

. Create linked server as per requirement

. Create Database Snapshot As per the requirement

. Create Jobs and Maintenance Plan using Lite Speed Tools and SSMS .

. Monitor every critical Database activity (Memory Management, Deadlock

Detection, Logins per Seconds, CPU Utilization) using SPOTLIGHT TOOL.

. Create Weekly Reports for each databases and Maintain Technical

dashboard.

. Patching SQL SERVERS with Latest Service Pack.

PROJECT PROFILE:

o GUITARINFO

Duration Sept 2009 - Nov 2009

Team Size 1

Technology HTML

Operating System Windows XP

Description:

The proposed software is built by keeping in mind that

customer's requirements are satisfied at minimal time. Customer can view

category wise items. In each category individual information of item is

provided. The software developed is very easy to handle and operate. It is

very user friendly. It saves time and man power.

o CE STREET.com @ Major-Brains Pvt. Ltd.

Duration Jan 2011 - Mar 2011

Team Size 2

Technology ASP.NET, C#

Operating System Windows XP

Description:

"CE STREET" is a web application which stands for Continuing

Education. This web application provides platform for the '360 Training'

which is a reputed online examination service provider web application

having wide area network in United States of America.

This marketing web application allows user to communicates with

the system using friendly interface. This platform also provides

certification of 360 training program. Web application also enables user to

blog, articles, examination, news, etc.

hobbies:

SWIMMING

Table Tennis

. Attending seminars.

PERSONAL PROFILE:

NAME : ADWAIT ANIL KULKARNI

Birth Date : 8th January, 1987

Permanent Address : 115/6 E-2, Saket society, Shivtirthnagar, Kothrud,

Pune-411038.

Contact this candidate