Sql Server Project

ABDUR RAHEEM .V.C

D-*** KAKKAN COLONY,

BESANT NAGAR,

CHENNAI-600090, TAMIL NADU,

INDIA.

Mobile: +91-984*******

E-mail: ***************@*****.***

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

Objective

Obtain a challenging technology position in an organization that enables growth and offers advancement opportunity with increasing job knowledge.

Summary

2 years 11 months of experience in Information Technology as SQL Server DBA.

Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server.

Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support.

Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes.

Experience in Database Backup and Recovery procedures.

Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.

Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.

Migration of databases from SQL server 2000 to SQL server 2005.

Disaster recovery and Log shipping of SQL Servers meeting the Service level agreements for the various customers.

Experience in implementing different types of Replication models like Transactional replication.

Successfully planned and implemented SQL Server 2005 Database Mirroring.

Has conceptual exposure of Clustering.

Providing 24x7 technical database support for SQL Database systems.

Experience in supporting and managing multiple Production, Staging & Development instances.

Good interpersonal skills, committed team player with team driven skills.

Good communication skills, written and verbal presentation skills.

Educational Details

B.C.A. Computer Applications, 2008

Mohamed Sathak College Of Arts and Science, Chennai, Tamil Nadu.

First Class (74.5%)

Higher Secondary, 2005

Besant L.v.r Matriculation Higher Secondary School, Chennai, Tamil Nadu.

First Class (62%)

Matriculation,2003

Besant L.v.r Matriculation Higher Secondary School, Chennai, Tamil Nadu.

First Class (67.3%)

Certification

Microsoft Certification ID : 9034199

Certification Number : D726-2671

70432-Microsoft SQL Server 2008, Implementation and Maintenance.

Technical Skills

Operating systems : Windows 2000/2003 Servers & XP Sp3

Databases : SQL Server 2005, 2008

Languages : C, C++, Java.

Tools : SSMS, Enterprise Manager, Perfmon, SQL Profiler

Web Tools : HTML, XML

Professional Experience

NOV 2009 – Till date with Soho India Pvt Ltd, Pune, INDIA as SQL Server DBA

Client : San Francisco, USA.

Project Title : Esurance

Environment : SQL Server 2005,Windows 2008,Windows 2003 EE,Oracle10g, BO XI,Essbase

Duration : Jan 2011 to Till date

Position : SQL SERVER DBA

Team Size : 6

Description: The system developed by Esurance is specific to automobile insurance based on the compliances of all the states in America. The system helps in creation of new policy, endorsement of an existing policy, cancellation of an existing policy and renewal of the policy. The system also helps the customer to collect their SRF (State Required Forms) acceptance through online.

Policy Administration system allows transactional history tracking of all policy activity. The solution implements a pipeline design pattern that emphasizes “Service Oriented Architecture” (SOA). Along with delivering emails, the “Email Services” product also tracks and manages them for reliability and customer satisfaction.

Roles & Responsibilities

• Performing SQL server daily health check and preparing a report based on it.

• Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.

• Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.

• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

• Applying Service Packs and Security patches for the Servers as released.

• Monitoring the Log Space for successful execution of all the specified jobs.

• Managing backups on a daily basis and recovery (as per request).

• Reviewing SQL Server and SQL Server Agent Error Logs.

• Monitoring of server performance by profiler during peak periods of server utilization.

• Have prepared User-Manuals and Technical documents for the project, which includes ED (Environment Description) documents/ Run Books / RCA’s within the team.

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.

• Setting Perform counters for monitoring the server as per request about degraded performance from Application Team and then passing the trace files for L3 for an advanced review.

• Configuration and Maintenance of Log Shipping, Mirroring & Replication across different environments.

• Develop, implement and administer database policies and procedures and provide technical support and assistance to all database end-users.

Project #2

Client : San Bruno, CA, USA.

Project Title : GAP

Environment : Net(C# and ASP), SQL Server 2005, Windows 2003 EE,

Duration : Nov 2009 to Jan 2011

Position : Production Support DBA Member

Team Size : 8

Description:

The Gap is a specialty retailer, which operates stores selling Casual / Fashion apparel for men, women and children under five brand names like GAP, GAPKIDS, BABYGAP, BANANA REPUBLIC and OLD NAVY Clothing Co. GAP has outlets throughout the United States, Canada, United Kingdom, France, Germany and Japan. We are the responsible for the Maintenance and Enhancement of IT operations of GAP

Roles & Responsibilities

● Involved in Migration of data from Access database to SQL Server 2005.

● Responsible for daily backups and restoring databases.

● Monitoring the Scheduled Jobs and ensure that the database of the DC and DR are synchronizing.

● Monitoring the Database size at regular interval.

● Monitoring the performance of production servers (I/O,Cpu,Memory).

● Involved in report generation for various modules using MS SQL Reporting Service.

● Built Test Plans and Test Cases, Provided assistance to the Testing Team.

● Client Coordination in production environment.

● On Time issue fixing for smooth completion of day end and Month End Activity.

● Responsible to Up-grade patches for both the window server and sql server and ensure smooth running in both the Pre-Production and production Environment.

Personal Profile

Name : ABDUR RAHEEM.V.C

Father's Name : V.Chelladurai

Date of Birth : 21th Dec 1987

Gender : Male

Marital Status : Single

Nationality : Indian

Languages Known : English & Tamil (R/W/S)

Declaration

I hereby declare that the above particulars furnished by me are true to the best of my Knowledge and belief. I assure you, if I’m given a chance, I will execute my duty to the fullest satisfaction of my superiors.

Place: Signature

Date: (ABDUR RAHEEM.V.C)

Contact this candidate