Sql Server Project

[pic] Praveen Reddy

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

Contact Number: 91+720*******

CAREER OBJECTIVE

I aspire to have a challenging and a rewarding position

in an organisation where I can put in all my efforts out to attain my

personal and organisational objectives harnessing competent technical

skills.

synoptic

. Over 3.5 years of IT experience in SQL Server Database

Administration.

. Experience in Installation, Configuration, Maintenance and

Administration of SQL Server2005 and SQL Server 2008

. Experience in upgrading SQL Server from version 2005 to 2008

. Good experience with implementing High Availability of database

servers using Replication, Log Shipping, Database Mirroring and

failover clustering

. Experience in implementing SQL Server security and Object

permissions like maintaining creation of users, configuring

permissions and assigning roles to users

. Experience in Automating Database maintenance plans,Scheduling and

Configuring SQL Server agent Jobs, Alerts,operators and Database

Mail Configuration

. Extensive experience with Monitoring, Tuning and analyzing DB

performance issues

EXPERIENCE:

. Working as SQL Server Database Administrator for Vess Technology

Solutions, Bangalore from Aug 2011 to till Date

ACADMICS:

. M.C.A from JNTU University,

SKILLS:

Programming languages : T-SQL, SQL DBA

Platforms : Windows Server 2003/2008,

Database : SQL Server 2005/2008 (SSRS,

SSIS, SSAS).

Tools : Microsoft Visio, Microsoft

office 2003/2007.

PROJECT EXPERIENCE:

Project #1

Project Name : OHC (Online Healthcare System)

Client : Trillion-Mind.

Duration : Oct 2012 to till date

Role : DBA

Environment : SQL Server 2005/SQL Server 2008

Description:

OHC is a Health Care Online Web portal which

helps Physicians and patients to interact with each other. This Online

application has an effective messaging system where patient can send

query's to corresponding doctors and can request an appointment. The

physician in turn will respond to the patient's request. This application

maintains the Personal Health Record for each patient and Physicians

History

Roles &Responsibilities:

> Creation of user databases

> Creation of users and assigning roles to the users

> Providing Security by giving access permission to users at various levels

> Responsible for space allocation, backup strategies, table maintenance

> Backing up of all the databases along with the verification

> Checking the status of Backups and Restoration of databases

> Created Database Maintenance Plans for the Performance of SQL Server

which covers Database Integrity Checks, Update Database Statistics and Re-

indexing

> Ensuring high availability of the database by exploiting the concepts of

replication, log shipping and database mirroring

> Making required schema changes, adding triggers, stored procedures

> Conducted Performance Tuning using SQL Profiler and Windows

Performance Monitor

> Scheduling replicated database for regular backups and checking the

status

> Involving in designing, coding, testing for SSIS Packages.

> Involving in deploying and scheduling SSIS packages.

> Involved in database for creating stored procedures and functions.

> Preparation and execution of unit test cases.

Project #2

Project Title : Business Process Management for Scotland Solutions.

Client : Scotland Solutions.

Period : Aug 2011 to Sep 2012

Role : SQL Server DBA &Report Developer.

Environment : SSIS, SSRS and SQL Server 2008

Description:

Scotland Solutions is a retail business

company of consumer electronic goods spread over United Kingdom

(U.K).The Data warehouse has many applications and it has a high volume

of transactions and data. Data warehouse has many functional and

technical groups and ETL is one among them performing the development

activities for Data warehouse. Retail Business Process Management (BPM)

project is to provide a single source of reporting for managing

store/retail operations using data warehousing ETL Sql Server 2008

Integration Services.

Roles &Responsibilities:

> Installation, Configuration of SQL Server 2005.

> Implemented of SQL logins, roles, and authentication modes as a part

of security policies for various categories of users.

> Rebuilding the indexes at regular intervals for better performance.

> Designed and implemented comprehensive backup plan and disaster

recovery strategies implemented.

> Manage trouble shooting and fine tuning of databases for its

performance and concurrency.

> Maintained and modified performance using execution plans and index

tuning.

> Designed a report on the monitoring of SQL server performance.

> Configured and Maintained Database mirroring and Log shipping.

> Optimized the performance of queries with modifications in T-SQL

queries,

> Involving in designing, coding, testing for SSIS Packages.

> Involving in deploying and scheduling SSIS packages.

Strengths

V Adequate Problem Solving Ability.

V Ability to grasp and learn new things at a much better pace.

V Thirst for learning new things and updating myself with the latest.

Contact this candidate