Sql Server Maintenance

Gopinath Reddy

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

Mobile : +917*********

Objective:

Seeking a position to utilize my skills & ability that offers professional

growth while resourceful, innovative & flexible.

Overview:

. I have around 3.5 years of total experience as Microsoft SQL Server

database administrator. Has a good experience in administration of MS

SQL Server 2005 and 2008 on Windows 2003 environments.

. As a SQL Server DBA, I involved in all core DBA responsibilities like

Installation, Configuration, Database Creation, Database

configuration, Backup & Recovery procedures, Replication, Transaction

Log shipping, Database Mirroring, Monitoring, Troubleshooting and

Performance Tuning in Production/Test/Dev environment.

Key Responsibilities as a SQL server DBA

. Database Administrating with proficiency in SQL Server 2005, 2008 and

2008R2 Production Environment.

. Providing day-to-day Support and Maintenance for SQL Server databases

. Involved in Installation and configuration of MS SQL Server in Windows

Environment.

. Responsible for Migrating databases from SQL server 2005 to SQL server

2008 and 2008R2.

. Administrating high availability solutions like Log shipping and

Database Mirroring

. Implementing and managing Transactional Replication across multiple

sites.

. Performing and maintaining all types of Databases Backups and Recovery

operations.

. Performing maintenance tasks like rebuilding/reorganizing indexes and

update statistics and checking database integrity on regular

intervals.

. Identifying and Monitoring memory usage, CPU utilization, cache hit,

physical reads counters required for performance tuning using

performance monitor.

. Good knowledge on SQL Server Clustering.

. Proficiency in query optimization and improve performance using SQL

profiler, execution plan, tuning advisor and DBCC Commands.

. Resolving space management issues like database and log file space

issues.

. Identifying and resolving Blocking and Deadlocking issues by using

activity monitor system Stored Procedures and Profiler

. Identifying and resolving fragmentation and index-statics issues.

Professional Experience:

. Currently working with Mindtree Ltd From Aug'2012 to till date

. Worked with Accenture from Feb,2011 to Aug,2012

Educational Qualification:

. B.E Computer Science from Anna University in 2011

Technical Skills:

Operating Systems : Windows Family(XP/2000/2003)

SQL Server Tools : SQL Server Management studio, SQL Profiler, Database

Tuning

Advisor.

Project #1

Client TSS (Treasury Security and Services)

Role SQL Database Administrator

Organization Mindtree Ltd., Bangalore

Duration Aug'2012 to till date

Team size 7

Environment SQL Server 2000/2005/2008, Windows XP/2003

Treasury & Securities Services (TSS) provides a broad range of integrated

cash management, securities and trade finance solutions that meet the

transaction processing, clearing, liquidity management and reporting

requirements of financial institutions, corporations, and governments in

Australia and New Zealand. On any given day, J.P. Morgan's Treasury &

Securities Services business processes trillions of dollars in cash and

securities transactions through its local and global network, supporting

the investment and trading activities of local clients operating

domestically and offshore as well as overseas based organizations operating

in Australia and New Zealand.

Responsibilities

. Installing, configuring, administrating and securing SQL server

2005/2008.

. Administrating databases in SQL Server 2005/2008.

. Migrated databases from SQL Server 2005 to SQL Server 2008.

. Performing all types of Backups such as Full, Differential and

Transaction log backups.

. Configuring and Monitoring log shipping from production server to the

reporting server.

. Maintained Alert notifications, jobs, and schedules.

. Heavily used Transactional Replication, Configured Transactional

Replication between Primary server and Read-only Servers and

experience in troubleshooting replication problems.

. Scheduling and monitoring all maintenance activities including

database consistency check, update statistics, and index maintenance.

. Managing logins, users and roles.

. Handling database fragmentation related issues

. Identifying and resolving blocking and deadlock issues by using

Activity Monitor and Profiler.

. Solving space issues like TempDB and log file issues

. Monitoring performance by using SQL Server profiler and performance

Monitor.

. Used SQL profiler for trouble shooting, monitoring, tuning of sql

server and SQL code.

Project #2

Client Centex Corporation, US

Role SQL Database Administrator

Organization Accenture

Duration Feb'2011 to Aug,2012

Team size 08

Environment SQL Server 2005/2008, Windows XP/2003

Dallas-based Centex is one of the nation's leading home building companies.

Its leading brands include Centex Homes, Fox & Jacobs Homes and

City Homes. In addition to its home building operations, Centex also offers

mortgage, title and insurance services. Centex has ranked among the top

three builders on FORTUNE magazine's list of "America's Most Admired

Companies" for nine straight years and is a leader in quality and customer

satisfaction.

Responsibilities

. Monitoring and troubleshooting databases

. Performing and monitoring Full, Differential and transactional log

backups.

. Scheduling jobs in SQL server.

. Verifying backup jobs.

. Extensively used Enterprise Manager, Query analyzer

. Implementing Maintenance plans

. Creating Maintenance plans for database consistency checks and update

statistics.

. Monitoring locking issues.

. Monitoring server performance using Performance Monitor and SQL Server

Profiler.

. Monitoring Log shipping and trouble shooting of errors.

. Managed Logins, Users, Roles, and User permissions.

. Good experience in 24/7 in SQL Production Support.

Contact this candidate