Chandra

E mail : ab04lw@r.postjobfree.com

Mobile : +91-902*******

Objective:

Being highly motivated admin with good attitude, strong analytical and

admin skills, wanted to become a part of a leading software company and

fulfill my desire of acquiring knowledge and pleasure working with the most

competent DBA professionals.

Summary:

5.2 years of working experience in SQL Server database administration.

•

Expertise in Installing and Configuring the MS SQL Server 2000, 2005,

•

2008, 2008r2, 2012.

Involved in Daily Health Check of the Production Servers.

•

Worked on Import/Export and Attach/Detach of the database.

•

Good Expertise in Performing Backup and Restore strategies with

•

verification.

Experience in Implementing and Monitoring the Log Shipping.

•

Hands on experience in Configuring and Monitoring Replication.

•

Achieving High Availability through Database Mirroring.

•

Maintained the Security in SQL Server like Database Authentication

•

Modes, adding Users and Granting Permissions accordingly.

Maintaining and Automating SQL Server.

•

Ensuring the Data Consistency in the Database through DBCC

•

commands.

Rebuilding and Reorganizing the Indexes at regular intervals for better

•

Performance.

Scheduling Jobs & Maintenance plans in SQL Server.

•

Proactive Monitoring of Performance and take Preventive Measures.

•

Check the Fragmentation Status regularly.

•

Monitoring with SQL Profiler using the Database Tuning Advisor.

•

Troubleshooting SQL Server for Blocks, Deadlocks and Jobs.

•

Upgrading and Migration of the Databases.

•

Worked with Storage and Network Administrators to Plan and Estimate

•

Drive Space and Storage needs throughout the Environment.

Conceptual knowledge on Clustering.

•

Capable to work under Tight Schedule of the Project.

•

Ability to learn new Languages and cope up with new Scenarios quickly.

•

Adoptable to the environment and willing to work in shifts

•

Skills:

Database : SQL Server 2000/2005.

Database Tools : Enterprise Manager, Management Studio, SQL Server

Profiler, Query Analyzer, MMC, I SQL, T SQL, PL/SQL,

DTS, ODBC, DBCC.

Operating System : Windows 2000/2003/2008 Server

Work History:

Reliance Tech Service Pvt Ltd Mumbai

Sql Dba Oct’2010 to Till Date

Cinterco Tech Solutions Pvt Ltd Bangalore

Sql Dba Feb’2008 to Oct’2010

Education:

Computer Science Engineering from M.G.R University, Chennai, in

2007

Microsoft Certified Professional (MCP):

Microsoft SQL Server 2005 ID: 7617141

Microsoft SQL Server 2008 ID: 9828900

Projects:

Project #1

Organization : Reliance Tech Service Pvt Ltd,

Project : Vanco

Team Size : 5

Role : Database Administrator

Duration : Oct’2010 to till date

Environment & Tools : Sql Server 2000/2005

Roles & Responsibilities:

Backup databases and perform database restores as required.

•

Effective implementation in running consistency checks from SQL

•

Server. Perform and monitor daily database operations and set up backup

schedules.

Monitor the Server and fine tune to obtain optimal performance by

•

advising and assisting testing and development teams.

Monitor database activities (i.e. database status, logs, space utilization,

•

locks and long transactions).

Troubleshooting any SQL related issues in client Servers.

•

Monitor the status of Maintenance jobs – schedule to run daily and on

•

weekends (tasks like rebuilding indexes, defragmenting Databases,

Shrink Database, and Database Full backups).

Managing security both at database level and server level.

•

Maintenance and troubleshooting Transactional Replication, log shipping

•

and DB mirroring.

To set up SQL Server configuration settings

•

Installing latest service packs and patches on SQL Servers.

•

Project #2

Organization : Reliance Tech Service Pvt Ltd,

Team Size : 5

Project : Recon

Role : Database Administrator

Duration : Oct’2010 to till date

Environment & Tools : Sql Server 2000/2005

Roles & Responsibilities:

Installing and Configuring the SQL Server 2005.

•

Migrating the database from SQL Server 2000 to 2005.

•

Verify Backups and Error Logs on the Servers and troubleshoot on any

•

Failures or Alerts, open Trouble Tickets if necessary to work with

Technicians from other Departments.

Creating dropping and refreshing the databases as per Client requirement.

•

Respond to Trouble Tickets assigned to me and fix any Database issues

•

promptly.

Database Maintenance Plan creation and Troubleshooting.

•

Creating and Scheduling the Jobs as per Client requirement.

•

Configuring, Monitoring and Testing the Log Shipping.

•

Tuning Databases for Performance.

•

Installing latest service packs and patches on SQL Servers.

•

Using Profiler for trace down SQL Server activities on week basis.

•

Monitoring and resolving the Blocking issues.

•

Solving the Disk Space issues.

•

Backing up of all the databases along with the verification.

•

Creation of user database, users and assigning roles to the users.

•

Restoration of the databases.

•

Created and modified stored procedures

•

Backup client databases and perform database restores as required.

•

Effective implementation in running consistency checks from SQL

•

Server. Perform and monitor daily database operations and set up backup

schedules.

Monitor the Server and fine tune to obtain optimal performance by

•

advising and assisting testing and development teams.

Monitor database activities (i.e. database status, logs, space utilization,

•

locks and long transactions).

Troubleshooting any SQL related issues in client Servers.

•

Monitor the status of Maintenance jobs – schedule to run daily and on

•

weekends (tasks like rebuilding indexes, defragmenting Databases,

Shrink Database, and Database Full backups).

Managing security both at database level and server level.

•

Maintenance and troubleshooting Transactional Replication, log shipping

•

and DB mirroring.

To set up SQL Server configuration settings

•

Project #3

Organization : Cinterco Tech Solutions Pvt Ltd

Team Size : 4

Role : Database Administrator

Duration : Feb ’2008 to Oct’2010

Environment & Tools : Sql Server 2000

Roles & Responsibilities:

Installing and Configuring the SQL Server 2000, 2005.

•

Verify Backups and Error Logs on the Servers and troubleshoot on any

•

Failures or Alerts, open Trouble Tickets if necessary to work with

Technicians from other Departments.

Creating, Dropping and refreshing the databases as per Client requirement.

•

Respond to Trouble Tickets assigned to me and fix any Database issues

•

promptly.

Database Maintenance Plan creation and Troubleshooting.

•

Creating and Scheduling the Jobs as per Client requirement.

•

Tuning Databases for Performance.

•

Using Profiler for trace down SQL Server activities on week basis.

•

Monitoring and resolving the Blocking issues.

•

Solving the Disk Space issues.

•

Backing up of all the databases along with the verification.

•

Creation of user database, users and assigning roles to the users.

•

Restoration of the databases.

•

Created and modified stored procedures

•

Sarath Chandra

Contact this candidate