Sql Server Project

V.Manakshaw

Mobile Number : +91-996*******

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

[pic]

Objective:

6.5 years of Professional experience and relevant 5.5 years experience

in SQL Server DBA including about, Development & Support of MS SQL

Servers 2008, 2005, 2000 and 7.0 in Production Support, QA, Clustering,

Replication, Logshipping, Database mirroring, Performance Tuning, Query

optimization, Security audit, Disk Management and HP Open view

environments. Seeking a challenging position to utilize and expand my

current experience and knowledge in Database administration.

Profile Summary

> Involved in installation and configuration of SQL server 2000 on

Production Server and Applied patches, service packs to keep the

database at current patch level.

> Suggested Disk Capacity, Processors and Memory based on the Capacity

planning.

> Resolved and rectified all Production Issues within SLAs

> Maintained Backup and Recovery Plans for all Databases

> Monitored Jobs, Error Logs, Server Space, Health of Databases &

Servers.

> Troubleshooted Operating System with respect to SQL Server.

> Tuned the SQL queries using SQL profiler. Involved in tuning the

database.

> Upgraded the MS SQL server from 7.0 to 2000, SQL Server 2000 to 2005

> Created all three replication models on different applications to suit

the business need.

> Implemented stand by servers and Log shipping.

> Maintained all the SQL documents include installation and data

conversion Procedures documents.

> Maintained the SQL Clustering and install the new instances in

Clustering administrator.

Technology Environment

Database: MS SQL Servers 2008, 2005, 2000 and 7.0, MS Access

Operating System: Windows Enterprise Server 2003 and 2000, Window XP,

Windows Vista, Citrix Server

Web Technologies: Photoshop, Front Page, Dream weaver

Third Party Tools

. HP Open View Service Desk

. HP DBSPI monitoring

. Citrix Metaframe

Professional Qualifications

B.I.T : Bachelor of Information Technology, (Manipal Academy), Deemed

University,

Manipal-India

Certifications and Training:

MCTS (Microsoft Certified Technology Specialist) 70-431

Oracle 9i (SQL, PLSQL)

(Oracle University, SQL International-Chennai)

Experience History

Technosoft Global Services (Chennai-India) Mar 2008 -Till date

CLIENT : Quintiles

Designation : Senior SQL Database Administrator

Project Description

The Quintiles family of companies is a global leader in pharmaceutical

services, improving healthcare worldwide by providing innovative, quality

professional expertise, market intelligence partnering solutions to meet

the dynamic needs of the pharmaceutical, bio technology and healthcare

industries.

Role and Responsibility in Technosoft Global Services:

> Performed and managed database administration to ensure database

availability and enable the proper database monitoring.

> Supported request using HP Open View Tool for error correction.

> Worked in SQL Server 2000 Enterprise Manager, SQL Server Profiler, SQL

Server Agent, and SQL Server Surface Area Configuration.

> Maintained T-SQL stored procedures, functions, triggers and scripts.

> Resolved various database issues and T-SQL queries

> Performed Backup & recovery and Quarterly password test as per the SOX

audit compliance.

> DTS, database design, creation, performance tuning, rights management,

administration

> Managed and maintained data distribution in all production and non-

production databases and replication servers.

> Corrected numerous nightly failing jobs and brought stability to their

production systems.

> Resolved user security, performance issues

> Worked to implement performance monitoring.

> Supported clustering and replication for servers

> Experienced in implementing different types of Replication models like

Snapshot, Merge and Transactional.

> Maintained Database authentication modes, creation of users,

configuring permissions and assigning roles to users.

> Automated and Monitored the Drive Space Allocation.

> Documented the Policies and Process of Capacity Planning, Adhoc

Request, Backup Process, Database Creation, Database Restoration.

> Defined relationship between tables and enforced the referential

integrity constraints. Created Clustered and Non-Clustered Indexes.

Helios & Matheson (Chennai-India) Aug 2006 -Nov 2007

CLIENT : ALLPOSTERS.COM (United States Of America)

Designation : DATABASE ADMINISTRATION AND

PRODUCTION SUPPORT

Project Description

AllPosters.Com is the world's largest poster and print store which

offers hundreds of thousands of posters and art prints. AllPosters.com

allows the customers to select the posters/arts and place orders online.

AllPosters.Com has it's own IT division and developed several web

applications, windows applications for its business processing.

Role and Responsibility:

> Corrected numerous nightly failing jobs and brought stability to their

production systems.

> Resolved user security and performance issues.

> Performed DBA duties including database backups, restores, performance

tuning and capacity analysis

> Resolved conversion data issues. Optimized SQL Statements

> Strong knowledge in Backup and Recovery

> Transformed data from one server to other servers using tools like Bulk

Copy Program (BCP) and Data Transformation Services (DTS).

> Managed and maintained data distribution in all production and non-

production databases and replication servers.

> Performed and managed database administration to ensure database

availability and enable the proper database monitoring

> Generated Scripts for Tables, Stored Procedures, Functions, Triggers etc.

> Experienced in Site scope monitoring for components like CPU Utilization,

Disk Space, Memory, Services, Network and Bandwidth Utilization.

> Performed performance Tuning, Query Optimization, Client/Server

Connectivity, Database consistency checks using DBCC Utilities.

> Reviewed SQL Logs and Windows Event Logs.

> Resolved and rectified all Production Issues within SLAs

E2P Allied Consultancy (Dubai and Chennai) Mar2004-July2006

CLIENT : E2P Allied

PROJECT : Web Development

DURATION : Feb2006-June2006

TECHNOLOGY : Dreamweaver, Front page, Photoshop, Flash Etc

Project Description

Leading provider of Business and IT consulting services and Managing the

full lifecycle deployment of IT solutions. There unique approach,

emphasizing IT advantage, enables us to drive creative solutions to complex

business challenges. E2P used following products for web development

Dreamweaver, Front page, Photoshop, Flash Etc

Roles and Responsibilities

> Designed web pages

> Creating Logos

> Created Character Design

> Created Flash Layouts

> Importing webpage from Dreamweaver to FrontPage

> HTML coding

E2P Allied Consultancy -Jeevan Technologies (Contract)

CLIENT : Jeevan Technologies (Chennai-India)

PROJECT : De Los Santos Hospitals,

Philippines.

DURATION : June 2004-July2005

TEAM SIZE : 3

TECHNOLOGY : Microsoft SQL Server 2000, Windows 2000

Project

Hospital Management Information System (HMIS) has been designed to

streamline the business practices of hospitals and clinics. HMIS ensures

optimum use of the medical records of patients. 2000.

Roles and Responsibilities

> Created Databases and database objects.

> Resolved database issues.

> Wrote /maintained Scripts in support of DBA.

> Data Import / export using SQL Server data transformation service (DTS).

> Experienced in tuning SQL queries and databases to improve performance.

> Managed and maintained data distribution in all production and non-

production databases.

> Experienced in Database Backup, Recovery and Disaster Recovery

procedures.

> Created and maintained users and Logins

Contact this candidate