Mobile: **-

782-***-****

Koti Abburi Email :

acaa1g@r.postjobfree.com

Profile Summary:

> Having 3- Years of experience in Information Technology as SQL Server

Data Base Administration

> Experience on installing, configuring, Managing and Monitoring of all SQL

server with Service packs, Cumulative updates and hot fixes.

> Automation of SQL Server activities including scheduled and maintained

routine Jobs, Tasks, Alerts and Maintenance Plans and DBCC consistency

checks

> Experience in Database Backup and Restore.

> Implementing disaster recovery procedures to ensure minimal downtime and

data loss

> Experience on Performing database refresh

> Troubleshooting and resolving suspect databases.

> Migration of databases from SQL server 2000 to SQL server 2005

> Performing upgradation of SQL Server 2005 instances

> Implementing log shipping of SQL Server instances.

> Successfully planned and implemented SQL Server 2005 Database Mirroring

and Replication

> Having experience on clustering.

> Troubleshooting and resolving blocking/locking and dead lock Issues.

> Experience in implementing Snapshot.

Professional Summary:

> Working as a DBA in Enterfuse Soft Technologies Pvt.Ltd, Bangalore from

February 2012 to till date.

> Worked as DBA in SLK Software Services, Bangalore October 2010 to

January 2012.

Education:

> B.Tech (IT) from Anna University Tamil Nadu.

Technology Summary:

Operating System : Windows XP, Windows Server 2003

Database : SQL Server 2000, 2005,2008 & 2008 R2

Tools :Perfmon,Profiler.

Professional Experience:

Project:1

Project Name GEMCO Medical

Role SQL DBA

Environment SQL2005\2008\R2\2012 Server

Description:

GEMCO Medical is one of the pioneers in the diabetes supply industry. It is

the first to partner with a diabetes manufacturer to design a Medicare and

Medicaid diabetes program geared to the Medicare provider market. These

programs maximize the profits on diabetes products that are billed to

Medicare and Medicaid.

. Maintaining of over 1000 standalone\Cluster servers.

. SQL Server 2000,2005 and 2008 installations, configuration and

security settings for stand alone\Clustered servers.

. Implement database administration/ maintenance plans with database

backup and restorations.

. Configuring / maintaining high availability SQL Server solutions that

include Log shipping, Mirroring, Replication, Clustering.

. SQL Server upgrade with service packs and hot fixes in Clustered and

standalone environments.

. Monitor database usage and growth trends to forecast future storage

needs as Capacity planning measure with request of application team .

. Maintaining/Creating logins/users and giving permission to them as per

request.

. Creating and Maintaining scheduled jobs and implementing automation

for other tasks.

. Heavily involved in troubleshooting, resolving data integrity and

performance monitoring issues.

. Having a good knowledge and minimal experience on PT[Performance

Tuning].

. Establishing availability baselines and set thresholds for monitoring

and alerting.

. Handling blocking/locking issues and troubleshooting accordingly.

. Speaking with clients/application & development teams regarding issues

and keeping track of the issue till it gets resolved.

. Working on file moment activities as per request with application

teams.

. Creating snapshots as per requirement of Application team

. As per hardening measure, changing system/user databases default

location

. Having knowledge on Analysis services.

2.Project Name : WWL (Wallenius Wilhelmsen Logistics)

Role: Data Base Administration

Wallenius Wilhelmsen Logistics delivers innovative and sustainable global

shipping and logistics

Solutions for manufacturers of cars, trucks, heavy equipment and

specialized cargo. All the services provided with the strong help of SQL

Server backend support. All the applications and databases are Critical for

all operations. Our main responsibility ensures that all the applications

running on them are online 24*7 and troubleshooting the issues.

Roles & Responsibilities:

. Maintaining of over 500 servers.

. SQL Server 2000, 2005, 2008 and 2008 R2 installations, configuration

and security settings for standalone servers.

. Monitor database usage and growth trends to forecast future storage

needs as Capacity planning measure.

. Maintaining/Creating logins/users and giving permission to them as per

request.

. Creating and Maintaining scheduled jobs and implementing automation

for other tasks.

. Involved in troubleshooting, resolving data integrity and performance

monitoring issues.

. Coordinating with the Offshore DBA Support Team on production support

issues.

. Speaking with clients/application & development teams regarding issues

and keeping track of the issue till it gets resolved.

. Performing file movement in prod servers on weekly basis.

. As per hardening measure, changing system/user databases default

location

. Worked on database backup and restoration issues.

(Koti Abburi)

Contact this candidate