Sql Server Data

Ruvina

Phone: 408-***-****

****@********.***[pic]

SUMMARY:

> 7+ years of Extensive experience in installation, configuration and

administration of SQL Server 7/2000/2005/2008. Extensive experience in

installing, configuration and administration of MS clustering, T-SQL

Programming and performance tuning, optimization.

> Experience in Project Management, Structured Systems Design and

Analysis, Application and Systems Programming, Database

Administration, Data Modeling, Data Communication, Networking of IBM

PC to IBM Mainframes and Software Engineering.

> Skill set includes defining, developing, and modifying database

systems, building the logical design model of a database,

administering databases, meeting schedules and budgets, working with

developers in performance tuning design and functioning as a change

agent.

AREAS OF STRENGTH INCLUDE:

TECHNICAL

> Setup SQL trace, PeopleCode trace, and Application Engine trace.

Monitored and tuned AppServer performance.

> Identified, resolved, or provided recommendations to other different

kinds of the performance problems ranging from Database performance

problems to I/O hardware performance problems.

> Upgraded People Tools for Dev, Test, and Production environments.

> Created domains, configured AppServer, setup Process Scheduler,

brought up Web Server, updated report repository and changed passwords

through Application Design, etc

> Provided database administrative supports for different applications.

> Implement and maintain database security, replication, SQL Clustering,

Stand by server, DTS, SSIS, Log shipping, Database Mirroring, SQL

Mail, database mail.

> Trained a new DBA in our environment.

> Responsible for logical and physical databases design, implementation

and maintenance on UNIX and NT.

> Managed and resolved design issues during development.

> Moved database Schema changes to stage or production.

> Experience writing SQL queries, Stored Procedures, Triggers, and

Functions, creating Tables, Views and Indexes.

> A hands-on SQL Server Database Administrator (DBA) and Web

Administrator with a proven track record of team leadership and

technical skills.

> Performed database tuning using Explain Plan, hints,

utlbstat/utlbstat, Toad, PowerExplain, and Enterprise Manager.

> Provided on-call production database support.

> Experience writing SQL queries, Stored Procedures, Triggers, and

Functions, creating Tables, Views and Indexes.

> Created materialized views.

> Experience with data management and data processing flowcharting

techniques

> Knowledge of reporting and query tools and practices.

PROFESSIONAL SKILLS

DATABASE Microsoft Access, SQL Server 7, 2000, 2005, SQL

2008

Tools DBArtisan 8.x, Quest (Lite Speed, SQL Watch), Idera

(SQLSafe, SQL compliance manager)

OPerating Systems Windows NT/Windows 2000/2003/2008

LANGUAGE Transact-SQL, SQL, PL/SQL, BASIC, C, and C++, ASP

APPLICATIONS Active Directory, MSCS Clustering

SOFTWARE PL/SQL, MS SQL Server 2005/2000/7.0, T-SQL, DTS, MS

Access 2000/97, ODBC, Visual Basic 6.0, Visual

Source Safe 6.0 and Crystal Reports 7.0/8.0

HARDWARE DELL 6850 Servers, DELL 6300 Servers, SAN arrays,

Pentium PC's and Windows 2000 Servers

NETWORK SERVICES TCP/IP, DNS, HTTP, SMTP, DHCP, Load Balancers

PROFESSIONAL EXPERIENCE

Project #1

CIT, NY

Role Senior MS SQL Server DBA

October 2012 - Present

Responsibilit Responsible for installation and configuration of SQL server

ies 2005 database on Dell Servers.

Built up a data warehouse along with an intermediate log

processing database.

Got into production the replication system for processing web

server logs and aggregating the data into a warehouse.

Set-up a complete backup and recovery system

Administration and installation, performance tuning, Backup and

recovery, SQL, PL/SQL, Technical documentation.

Successfully developed and implemented several new database

systems as well as the supporting processes.

Worked on the design team that re-engineered the complete data

transformation process for incoming client data streams to be

loaded to a profile repository data warehouse.

Developed the concepts for the metadata portion of the data

transformation processes including a database driven job control

section.

Designed and implemented a statistical gathering, reporting and

data aging system for profile repositories.

Involved in data modeling for the application and created ER

diagram using ERWin.

Database Objects like Tables, Stored Procedures, Views,

Triggers, Rules, Defaults, user defined data types and functions

for this project

Developed DTS packages to extract, transform and load into the

Campaign database from OLTP database.

Worked with developers to tune the SQL queries using SQL

Profiler.

Worked with Star Schema, Cubes and Analytical services.

Setup and tested a 7 x 24 database fail over system and data

recovery.

Environment DEL 6850 Servers, MS SQL Server 2005/2000, T-SQL, Visual Source

Safe 6.0,Windows 2003 Server and Compuware QA Load test

Project #2

2. Kenexa, Wayne, PA

Role Senior MS SQL Server DBA

June 2011 - September 2012

Responsibilit Setup SQL trace, PeopleCode trace, and Application Engine trace.

ies Monitored and tuned AppServer performance.

Identified, resolved, or provided recommendations to other

different kinds of the performance problems ranging from

Database performance problems to I/O hardware performance

problems.

The tools used mainly are Savant, TKPROF, Explain Plan, and some

my own scripts. The tool called SQL Expert from Leccotech for

SQL statement tuning was also used.

Created domains, configured AppServer, setup Process Scheduler,

brought up Web Server, updated report repository and changed

passwords through Application Design, etc.

Involved in installation and configuration of SQL server 2000 on

Dell Servers. Applied patches and service packs to keep the

database at current patch level.

Created Database Objects like Tables, Stored Procedures, Views,

Triggers, Rules, Defaults, user defined data types and

functions.

Suggested Disk Capacity, Processors and Memory based on the

Capacity planning.

Implemented database standards and naming convention for the

database objects.

Conversion the legacy systems data into MS SQL server using DTS

packages.

Developing SQL scripts for maintaining administration tasks.

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

database.

Upgrade the MS SQL server from 7.0 to 2000.

Updating with latest service packs and security patches.

Based on the business need created all three replication models

on different applications.

Implementing stand by servers and Log shipping.

Involved in developing stored procedures, triggers for the

application.

Estimating of Table sizes and Record sizes. Maintaining proper

licenses.

Maintain all the SQL documents includes installation and data

conversion Procedures documents.

Trouble shooting Problems by using SQL server profiler.

Solved critical production problems and performed point in time

recovery plans.

Provided 24x7 on call production support.

Environment DEL 6300 Servers, MS SQL Server 2000/7.0, T-SQL, DTS, Visual

Basic 6.0, Visual Source Safe 6.0,Windows 2003 Server and

Compuware QA Load test

Project #3

Qualcomm, Inc. San Diego

Role MS SQL Server DBA

October 2009 - May 2011

Responsibilit Evaluate the Database Server Hardware.

ies Define/Recommend/Maintain database Standards and Architecture.

Expert in Database Design of tablespaces, bufferpool and table

Future Release management for database/instance and Impact

Analysis.

Research/Recommend Migration/Upgradation.

Involved in installation and configuration of SQL server 2000 on

Dell Servers. Applied patches and service packs to keep the

database at current patch level.

Responsible for configuration of Microsoft Server/Client

Products and implementation.

Created Database and Database Objects like Tables, Stored

Procedures, Views, Triggers, Rules, Defaults, user defined data

types and functions.

Defined relationship between tables and enforced the referential

integrity constraints. Created Clustered and Non-Clustered

Indexes.

Responsible for General Database Administration and Performance

tuning.

Experienced in resolving deadlock and blocking issues for

concurrent users

Worked with DTS packages to load the massaged data into Data

warehousing system.

Data Migration from legacy to master tables using DTS-Import and

Export wizard.

Performance tuning ERP on SQL Server 7.0 and 2000.

Developed Database Backup Scripts and automated this process

Used MS Visual Source Safe 6.0 as a Version Control System.

Partly Participated in system study and analysis of software

applications.

Experienced in support, applications and software development.

Environment DELL 6300 Servers, MS SQL Server 2000/7.0, T-SQL, DTS, Visual

Basic 6.0, Visual Source Safe 6.0, Windows 2003 Server,

Compuware QA Load test

Project #4

Nihar Info Global, India

Role MS SQL Server DBA

February 2008 - August 2009

Responsibilit Developed multi user system with VB, Crystal Report & MS SQL

ies Server

Maintained SQL Server database

Maintained Windows 2000 server

Involved in configuring and converting MS SQL server 6.5

database to MS SQL Server 7.0.

Partially involved in Database design and Database objects.

Created backups for databases.

Partly Involved in Performance tuning

Created ActiveX DLL COM Components using Visual Basic 6.0.

Responsible for Developing GUI Screens

Involved in developing E-R diagrams, logical & physical data

modeling, development and implementation of the system.

Responsible for creating COM Components using ActiveX DLLs and

for creating database and database objects like Tables, Stored

Procedures, Views, Triggers, Rules and functions.

Developed various management reports using Crystal reports 8.0.

Maintain the application as per the user requirement.

Environment MS SQL Server 7.0/6.5, T-SQL, DTS, Microsoft Visual Source Safe

6.0, Visual Basic 6.0,Crystal Reports 8.0 and windows 2000.

Project #5

5. SRM

solutions Pvt Ltd, India

Role MS SQL Server Junior DBA

August 2006 - January 2008

Responsibilit Partly Involved in System study and database designing.

ies Install, configure and upgrade MS SQL Server.

Porting the old data in to the new database using of BCP

Assisted for Development and design the GUI with ActiveX

Controls like MS Flex Grid, List View, Tree View, etc.

Used MS Visual Source Safe 6.0 as a Version Control System.

Generated MIS reports using Crystal Reports.

Coding, Testing, designing the Active X controls.

Client side implementation and testing.

Maintain the application as per the user's requirement.

Environment MS SQL Server 6.5, Microsoft Visual Source Safe 6.0, Visual

Basic 6.0, Crystal Reports 8.0 and Windows 98.

EDUCATIONAL DETAILS

Bachelor of Computer Science

Contact this candidate