Sql Server Project
Resume:
Mobile: **-
Koti Abburi Email :
************@*****.***
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