Backup/recovery,logshipping, replication,managing database objects etc

VIKAS e-mail: *********@*****.***

Contact: #963-***-****

OBJECTIVE

Seeking a challenging role in a world class organization that gives me the opportunity to utilize my skills & experience for growth and development of the organization.

SUMMARY OF EXPERIENCE

Over 1 year of experience as a SQL Server Database Administrator, providing 24/7 support of over 20 databases including test, development, quality and production SQL Server 2005/2008 running on various platforms like Window 7, XP, Windows Server 2003/2008R2.

Extensive experience in testing, maintaining and implementation of Disaster Recovery sites (DR) for production databases.

Performance and Tuning: Tuned various large critical databases. Extensive experience in Performance Analysis and Tuning of Databases and SQL Queries in a slow running Application.

Backup & Recovery: Extensive experience in planning and implementation (Hot/Cold) Backups and restoration strategies.

Expert in Configuration and troubleshooting of log shipping.

Good knowledge of Clustering.

Expert in configuration Merge/Snapshot/Transactional replications.

Expert in installation of SQL Server 2005/2008/2008R2.

Expert in Post-Installation Configuration of SQL Server 2005/2008/2008R2, Service Packs and Cumulative Updates.

Good experience in creating user and granting permissions.

Good experience in scheduling jobs through SQL Server Agent.

Good experience in creating Tables, Stored Procedures, Functions using T-SQL and SSMS.

Worked on SQL Server Profiler for performance tuning.

Worked on tool LiteSpeed.

Worked on tool Data Comparer.

Worked on Database Engine Tuning Advisor.

Experience in Windows environment (Windows XP, Windows 7, Windows Server 2003/2008R2).

Worked on Microsoft Project Server 2010.

Good knowledge of installing and configuring SQL server in Virtual envirionment.

EMPLOYMENT HISTORY

Working with NOWTIX INFOTECH, Bangalore.

1.4 years experience as MS SQL Server DBA

EXPERIENCE

JULY, 2011 TO TILL DATE

ROLE: JR. DATABASE ADMINISTRATOR

COMPANY NAME: NOWTIX INFOTECH

ENVIORNMENT: MS SQL SERVER 2005/2008/2008 R2, WINDOWS XP, WINDOWS 7, WINDOWS SERVER 2003/2008R2

COMPANY PROFILE: Nowtix aims to provide end to end IT Solutions and services that address the customer’s requirements. Nowtix also understand that each and every customer is unique and there is no one technology or solution that meets all requirements.The company’s clear focus on its core competencies enables it to constantly add value to its customer base. The company is able to integrate technology and innovation into customer environments by providing a range of services which include customization and development. Nowtix Infotech capabilities in Workflow, DM, DW, are the back bone of all its service offerings.Nowtix Infotech is a company that showcases the best of the entrepreneurial practices and committed technical talent in the industry.

RESPONSIBILITIES:

Providing 24/7 support on Test, Development, Quality and Production servers running SQL Server 2005/2008 on various platform Windows XP, Windows 7, Windows Server 2003, Windows Server 2008R2.

Installation of SQL Server, Service Packs and Cumulative Updates.

Extensive experience in planning and implementation (Hot/Cold) Backups and restoration strategies.

Managing database objects.

Creating user and granting permissions.

Configuring and Troubleshooting Database Backup and Recovery.

Configuring and troubleshooting Logshiping and Replication.

Implementation of clustering.

Worked on reporting services to produce reports.

Performance analysis and tuning of databases and slow running applications.

Creating Stored Procedures, Triggers, Cursors, Functions and Tables using T-SQL and SSMS.

Troubleshooting database errors.

PROFESSIONAL TRAININGS

1. MS SQL SERVER 2005

PROJECT NAME: Integrated Land Management System

Front-End: VB.NET 2.0

Back-end: SQL Server 2005

Client: Punjab Land Record Society Jalandhar

Description: This project is implemented in all districts of Punjab. The land records are managed through this project and land owner can see their land's report on website.

Responsibilities:

• Installation of SQL Server, Service Packs and Cumulative Updates.

• Backup and restore database.

• Monitoring server.

• Configure and troubleshooting Logshiping and Replication.

• Managing database objects.

• Configuring job through SQL Server Agent.

• Troubleshooting application related errors.

2. ASP.NET 4.0 Duration 5 Months from CS InfoTech Chandigarh (June, 2010 to Nov, 2010).

Project Name: Event Brite

Front-End: ASP.NET 4.0

Back-End: MS SQL Server 2008

Description: The information about events is published on website. People can view the information and purchase ticket online.

Responsibilities:

• Designed the GUI.

• Designed the database.

• Built the code to achieve functionality.

• Prepared the presentation documents.

• Performance analysis and tuning of database and slow running application.

• Configuring and troubleshooting Backup and Recovery jobs.

COMPUTER/ITS SKILLS

Languages: C, C++, VB, JAVA,T-SQL,HTML,ASP .NET

Operating System: Windows Server 2003/2008R2, Window- XP, Window 7, Window Vista.

Databases: Microsoft SQL Server 2005/2008, MS Access

SPECIALIZATION

MS SQL Server 2005\2008\2008R2

EDUCATIONAL DETAILS

MCA. From Sahibzada Ajit Singh Institute of Information Technology & Research affiliated to Punjab Technical University.

B.Sc. From Gurunanak Khalsa College affiliated to Kurukshetra University

10+2 from UP Board

10th from UP Board

PERSONAL INFORMATION

Nationality: Indian

Marital Status: Single

Languages Known: English, Punjabi and Hindi

Contact this candidate