AMAR

Mail id: acfax3@r.postjobfree.com

Mobile: +91-812*******

PROFESSIONAL SUMMARY

Having 3.3 years of IT experience in installation, configuration, and administration of MS SQL

Server 2000/2005/2008/2008R2 in Windows environment.

Proficient in Database Backup, Recovery and Disaster Recovery procedures.

Familiarity with SQL server 2005/2008

Experience in using Profiler to resolve Dead Locks or long running queries.

Perform database maintenance tasks-index rebuild, index reorganize.

Experience in log shipping and Transactional Replication.

Configured Database mirroring.

Experience in client/server connectivity, Query Optimization, Performance Tuning and

Database Consistency Checks using DBCC commands

Experience on Database Mirroring.

Strong written and verbal communication to work effectively with cross-functional teams.

Self-motivated, responsible, confident and have the ability to multi-task and

prioritize under changing and challenging workloads.

PROFESSIONAL EXPERIENCE

Working as SQL Database Administrator at SOFT SOL INDIA, Hyderabad from

Nov-2012 to Till Date.

Worked as SQL Database Administrator at NISUM TECHNOLOGIES, Hyderabad from May-

2011 to OCT-2012.

TECHNICAL SKILLS

Operating Systems : Windows XP/7/8 /NT

: Windows 2003

Servers

Languages : T-SQL

RDBMS : MS SQL Server 2005,2008, 2008R2

SQL Server Tools : SSMS, SQL Server Profiler, Performance Monitor

EDUCATIONAL QUALIFICATION

M.C.A in 2010 under Sri Venkateswara University with 63%.

PROJECT PROFILE

Project2:

Project Name : Web Trends

Duration : Nov- 2012 to till date

Role : Database Administrator L2

Team Size :5

Description:

Web-trends dramatically improve digital marketing results for many of the world’s most admired and

innovative companies. The diverse products and services portfolio includes customer intelligence and

behavioral segmentation, targeting and scoring, optimization and testing, professional consulting

services, real-time web analytics, unified digital analytics across mobile, social and web, and general

digital marketing wizardry. Web-trends through our Infrastructure support provide services to more than

3500 of its clients. We ensure the Web/Application/Database servers of Web-trends products are

functional round the clock with minimal downtime.

Responsibilities:

Installation of SQL Server 2000/2005/ 2008/2008R2

Appling service packs for SQL Servers.

Creating logins, database users and assigning roles.

Manage the SQL Server user accounts

Plan and implement backup, recovery strategy.

Troubleshooting backup failures.

Backups and Restoration of production databases.

Perform database maintenance tasks-index rebuild, index reorganize

Daily activities include monitoring the database, checking error logs, checking the log file size

and free space in the data drives, connectivity of the databases.

Remove any unneeded space from the transaction log and data files by shrinking the log files.

Upgrading from SQLServer2005 to SQLServer2008R2

Perform Tuning long running queries and slow running servers through SQL Profile.

2

Checking the integrity and consistency of a Database.

Configure Log Shipping & Replication (snapshot & transactional.).

Configure Database mirroring.

Perform periodic checking of databases with DBCC command for maintaining data consistency

and integrity and rebuilt indexes.

Responsible for query optimizing and performance tuning using SQL profiler.

Project #1:

Client : Cardinal Health

Team size : 4 members.

Duration : may2011– OCT 2012.

Environment : Windows 2005 Server, MS SQL Server2008R2 Server

Tools used : SQL Server 2005/2008/2008r2, Windows Server 2003/2008, Profiler

Role : Data Base Administrator

Description : Specializes in distribution of pharmaceuticals, medical and biotech products.

Responsibilities:

Installation of SQL Server 2005/ 2008.

Appling service packs for SQL Servers.

Creating logins, database users and assigning roles.

Manage the SQL Server user accounts

Plan and implement backup, recovery strategy.

Troubleshooting backup failures.

Backups and Restoration of production databases.

Perform database maintenance tasks-index rebuild, index reorganize

Daily activities include monitoring the database, checking error logs, checking the log file size

and free space in the data drives, connectivity of the databases.

Remove any unneeded space from the transaction log and data files by shrinking the log files.

Upgrading from SQLServer2005 to SQLServer2008R2

Perform Tuning long running queries and slow running servers through SQL Profile.

Checking the integrity and consistency of a Database.

Configure Log Shipping & Replication (snapshot & transactional.).

Perform periodic checking of databases with DBCC command for maintaining data consistency

and integrity and rebuilt indexes.

Responsible for query optimizing and performance tuning using SQL profiler.

(Date) (Amar)

4

Contact this candidate