Sql Server Maintenance

Mobile : +919*********

Nagarjuna M Email Id:

*********.*********@*****.***

Professional Summary:

To take up a challenging career in the emerging SQL Server Database

Administration field where I can use my skills, knowledge, talent, hard

work, and determination would make my organization and me as successful.

Technical Summary:

> Having 2.2 years of experience in Information Technology as SQL Server

DBA.

> Extensive experience in installing, configuring, managing, monitoring

and troubleshooting of SQL SERVER versions 2005, 2008.

> Having good experience in Database Backup and Recovery procedures.

> Having good command on Jobs and Maintenance Plans.

> Having good hands on experience on MIRRORING and Log shipping of SQL

Server.

> Successfully planned and implemented SQL Server 2005 &2008 Database

Mirroring resolved related issues.

> Using DBCC and DMV commands in trouble shooting.

> Having good hands on experience in performance tuning of SQL SERVER

issues.

> Managing Database Security by Creating Users, logins and by assigning

roles and permissions.

> Hands on experience in Database Backup and Recovery strategies.

> Experience in implementing different types of Replication models like

snapshot, transactional and design High Availability System.

> Creating and implementing Disaster Recovery plan.

> Migration of Databases between the servers.

> 24 X 7 Production Database on Call Support.

Technical Skills:

> Environment : SQL Server 2000,2005,2008,2012.

> Languages : T-SQL, SQL.

> Database Utilities : SSMS, Enterprise Manager, Perfmon, SQL

Profiler, DTA.

Educational Details:

> MCA from JNTU, Hyderabad - 2012.

Professional Experience:

> Working with Wipro Technologies, Hyderabad from June 2012 to till

Date.

Projects Involved

Project Details 1:

Client : TD BankNorth, Portland

Duration : June 2012 to till date

Environment : SQL Server 2000/2005/2008, 2012 Windows 2008, Windows 2003.

Role : SQL Database Administrator

Description:

TD Bank north Inc. is a leading banking and financial services company

which provides a comprehensive range of financial services: personal

banking, commercial banking, insurance, investment planning and wealth

management. My responsibilities in this bank were to support multiple SQL

Server databases.

Responsibilities:

> Implementation of SQL logins, roles and authentication modes as part

of security policies for various categories of users.

> Scheduled Full and Transactional log backups for the user defined and

system databases using the Database Maintenance Plan Wizard, by

running backup and restore commands.

> Utilization of copy database wizard (for moving or copying the

database along with other objects to other server).

> Used SQL Server Profiler to monitor and record database activities of

particular users and applications.

> Using DBCC and DMV commands in troubleshooting.

> Maintaining the jobs Scheduled during the night for the Backup of

Databases.

> Maintained high availability of database using Log shipping and

"Mirroring".

> Worked with linked servers and distributed transactions.

> Actively monitoring the server by Activity Monitor, Perfmon and

Profiler.

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

performance and concurrency.

> Performing checks on Error log based on issues.

> Setup, Monitor the status of Maintenance jobs - schedule to run daily

and on weekends.

> Rebuilding the indexes at regular intervals for better performance.

> Attaching and Detaching database and shrinking the database while

required.

I hereby declare that the above-furnished details are true to the best of

my knowledge.

Place: Bangalore

Date:

Nagarjuna M

Contact this candidate