Sql Server Manager

PRASANTHI

PROFESSIONAL SUMMARY:

> Over * years of IT experience on Database Administration and development

with MS SQL Server technology

> Experienced in Pharamaceutical,Clinical and Health, Finance, Insurance

domains

> Excellent knowledge in Relational Data Base Management System concepts

> Well experienced in upgrades and maintenance of SQL Server

2000/2005/2008

> Extensive experience in Installation and Configuration of SQL Server

2000/2005/2008 service packs and hot fixes

> Experience in implementing login and database security and managing

permissions

> Extensive experience in developing and implementing backup and restore

strategy and high availability solutions

> Strong SQL Server 2000/2005/2008 developer skills including writing

stored procedures, user defined functions, views, indexes, cursors,

triggers and queries

> Experience in tuning SQL queries and improving the performance of the

database.

> Very strong in implementing and maintaining Database Mirroring,

Replication(Transactional & snapshot), Log shipping

> Proficient in Migrating Databases from SQL Server 2000/2005/2008

> Experience in establishing routines to ensure that indexes are

defragmented regularly and statistics are up-to-date

> Experience configuring SQL Server Agent Jobs scheduling,creating,alerts

> Experience in resolving issues and identify root cause and proactively

improve the reliability of the data

> Monitoring and Troubleshooting SQL Server Performance using SQL Server

tools (Profiler, DTA, SSMS, PerfMon, DMVs, system sprocs)

> Developing SSIS packages to automate SQL Server day to day monitoring

tasks

> Developing and Managing in SSIS to populate the target database

repositories from the source systems

> Very good communication, conceptual, analytical, writing and

documentation skills

TECHNICAL SKILLS:

Operating Systems : Windows server 2000/2003/2008, Windows

NT/2000/XP/Vista, Unix, Linux

Databases : MS SQL Server 2000/2005/2008, MS Access

Database Tools : SSMS (SQL Server Management Studio), SQL

Server Enterprise Manager,

SQL Profiler, DTA, Query Analyzer, SQL Server

Configuration utility

ETL Tools : BCP, DTS (Data transformation services), SSIS (SQL

Server Integration Services)

Development skills : Transact SQL (T-SQL), HTML, DHTML

Data Modeling : CA ER-Win r7.3, MS Visio 12

Reporting Tools : SQL Server Reporting Services, Business

Objects

Back up tools : Quest- Lite Speed, EMC-Avamar

CERTIFICATION:

Certified Microsoft Technology Specialist with SQL Server 2005

PROFESSIONAL EXPERIENCE:

HCC Insurance Holdings, Inc. Houston, TX

May 2012 -Till Date

SQL Server DBA

HCC Insurance Holdings is leading international company with specialty

Insurance group.

The Company's operations consist of highly rated property and casualty and

life insurance companies. Provided expert support for production

development and test environment databases with respect to installation,

availability, reliability, and integrity

Responsibilities:

> Configure, patch, test, monitor, and support multiple heterogeneous

database instances, maintaining the databases at current release and

maintenance levels

> Configured and setup snapshot replication from production to Development

and stage environments.

> Resolve server and SQL job alerts server ping alerts for production

servers

> Working with developers in identifying locks and databases and proposed

resolution

> Setting up email alerts on the database for the log file growth and

drive space

> Created and scheduled SSIS package to monitor Idera's SQLcompliance

Manger on Monthly basis to check standards are followed.

> Created job to copy and restore backup files from Production (DMZ) across

domain in VBA Script

> Worked with network team to open firewall between DMZ servers and LAN

servers for SQLServer to communicate as required.

> Working on footprint tickets from users meeting SLA requirements.

> Checking Disk space alerts on Production server and to inform

Infrastructure to add more space if the disk is full.

> Start SQL Server in Single user mode to get access on to the Development

and Test servers

> Configured and maintained Report Manager and Report Server for SSRS and

update passwords for the quarterly password change.

> Participated in the organization's change management process for

production releases with different applications.

> Work with responsible applications personnel, coordinate testing of new

releases and upgrades from applications perspective.

> Perform problem determination (root cause analysis) and document the

source and proposed resolution.

> Worked on implementing SQL Compliance and standards on Tier 1 production

servers and scheduled reports as per audit team request.

> Worked in implementing yearly password changes on the production in

updating passwords for SQL Services, replication, Reporting services

database connection strings

> Development and implementation of database back-up and restore policies

and procedures

> Testing the functionality of the backup tool Avamar to see if that fits

our environment.

> Provided On-Call support on rotation

Environment:

SQLServer 2008 R2/2008/2005/2000, Windows 2008\2003, DTS\SSIS, SQL

Compliance Manger,EMC Avamar

Citrix Systems Inc,Fort Lauderdale, FL

Mar11 - Apr 12

SQL Server DBA

Citrix Inc helps various organizations worldwide to build simpler and more

cost effective IT environments enabling virtual work styles for users and

virtual datacenters for IT.

License Architecture Modernatisation Project involves redesigning Citrix

Licensing Portal. Involved

Supporting corresponding databases, migrating data and other database

servers in Development and QA

Responsibilities:

> Installing and configuring SQLServer2008/SQLServer 2008 R2 with backup

jobs, database mail and configuration options

> Upgraded SQL Servers with latest service packs.

> Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008

R2

> Created, administered & maintained SQL Server Databases on Production,

Test and Staging for various groups and ensured the availability of

the database Servers

> Configured and maintained transactional replication for flow of data

from QA and Dev. sever to the replica servers

> Monitored data activities like database status, logs, space

utilization, locks and long transactions.

> Configured transactional replication on databases with customer

information on to other servers for access of information

> Configured and maintained SQLServer database mirroring on SIEBEL

database servers.

> Implemented SQL standards in writing stored procedures, Triggers,

Views, Sql functions.

> Working with the developers to optimize code if required to minimize

the duration and look if the indexes are used appropriately.

> Experienced in resolving deadlock and blocking issues for concurrent

users.

> Provided appropriate access to users except system databases owners

and users will have access to their respective needed application

schema owners.

> Refreshed databases for pre or post data loads activities.

> Supporting SQL server developers working on different projects with

various requests.

> Converted and redesigned existing DTS packages to SSIS packages.

> Developed SSIS packages to import and export data from existing

systems to upgraded system.

> Used database utility programs and 3rd party utilities to monitor

database performance, such as

blocking, expensive queries, Memory utilization

> Escalated database issues to appropriate approvers where applicable.

Environment:

SQLServer 2008 R2/2008/2005/2000, Windows 2008\2003, DTS\SSIS, Precise I3,

Lite speed

Cephalon Inc, Malvern, PA

May10 - Feb11

SQL Server DBA

A global biopharmaceutical company with first-in-class research and

development of medication for treating various treatments. The project is

administering and maintaining 70 Servers which includes SQL Server

2000/2005/2008 SQL in production and development environments.

Responsibilities:

> Install, configure SQL Server 2008 and SQL Server 2005 versions.

> Configure relevant SQL Server components including database backup,

consistency, integrity and network utilities to ensure health and

access of each database.

> Resolving the day to day maintenance tasks.

> Applied service packs on SQL Server 2000 and SQL Server 2005.

> Worked extensively with SSIS SQL Server 2005 to automate DBA tasks.

> Migrated DTS packages and jobs from SQL Server 2000 to SQL Server 2005.

> Worked extensively with backup and restore requests.

> Worked with application development staff to enforce SQL Server

database architectures coding standards and quality assurance

requirements in accordance with Cephalon change control and testing

procedures and policies.

> Respond and resolve database access and performance issues to meet

business SLA's.

> Monitor database system details with in the database including the

stored procedures and execution times and implement efficiency

improvements .Also must be able to perform database transaction and

security audit.

> Support redundant systems for disaster recovery and data archiving to

ensure effective protection and integrity of data assets.

> Created a mirrored database on the report server using database

mirroring.

> Proactively monitor, optimize and allocate physical data storage for

SQL Server database systems to ensure minimum down time.

> Create or support creation of required reports in response to the

business user needs.

> Evaluate database monitoring tools including tasks to be monitored.

> Used space manager tool find space occupied on the disk

Environment: SQL Server2008/ 2005/2000, T-SQL, SQL Server Integration

Services, Window server 2008, Windows Server 2003

Freddie Mac, McLean VA

Dec09 - May10

SQL Server DBA

Freddie Mac, one of America's biggest buyers of home mortgages, is a

stockholder owned corporation to mortgage lenders in support of

homeownership and rental housing. The project is about implementing CIS

Bench marks for MSSQL 2005 for internal audit purposes.

Responsibilities:

> Installing and maintaining MS SQL Server 2005 Servers.

> Restricting permissions on database objects, proxy accounts and SQL

Logins.

> Configured Database Mirroring in MSSQL 2005 as Disaster recovery

solution.

> Configured and Implemented replication as Transactional replication to

provide high

availability.

> Written database maintenance scripts to increase Performance and

decrease downtime of the SQL server.

> Maintain scripts for all DB objects including triggers, constraints,

indexes, packages, procedures, and views for each build.

> Migrating database from Microsoft Access to SQL Server and worked with

application team in integrating Access forms with SQL Server.

> Designed SSIS packages to retrieve system configurations from all the

servers and loaded them in staging tables.

> Create stored procedures to be run as regular SQL Server jobs for

cleaning the violations.

> Created SQL Server Agent Jobs to automate tasks such as to run Index

Maintenance, Index defrag, Rebuild, Update Statistics etc (DBCC).

Also, created jobs to backup databases.

> To support development team in development and staging environments.

> Monitoring and resolving the tickets for development and testing boxes.

> Performed Root cause analysis to track down problems and used SQL

profiler for troubleshooting.

> Recommend R&D Developers on proper coding techniques to avoid Timeout

errors and Deadlock issues.

> Recommend, create and implement processes for clients to resolve

performance issues and data integrity issues.

> Modified and optimized complex queries for data retrieval and

modification.

> Configure and setting up database mail for sending out the violations

on all the servers.

> Formatted the reports according to the requirements using T-SQL

scripts.

> Used DBArtisan to conduct a majority of the daily database

administrative tasks.

> Created database objects according to the requirements.

> Create joins and sub-queries for complex queries involving multiple

tables.

> Writing Transact-SQL Query (DDL-Data definition language and DML-Data

manipulation language), involving sub queries and joins and experienced

in configuring linked servers to access heterogeneous databases.

> Testing scripts before deployment into production.

> Experience in writing and reviewing T-SQL code, maintaining coding

standards across the board in all SQL Server environments.

> Experience in writing for providing evidences for audit purposes.

Environment: SQL Server2008/ 2005/2000, T-SQL, SQL Server Integration

Services, SQL Server Reporting Services, MS Acess, Windows Server 2003

Cardinal Health, Dublin, OH

June 07 -Dec 09

SQL Server DBA

Cardinal Health is global manufacturer and distributor of medical and

surgical supplies and technologies dedicated to making healthcare safer and

more productive. The project dealt with managing the database regarding the

sales of the drugs.

Responsibilities:

> Installed and configured SQL Server 2005 set up and upgraded few of

them to SQL Server 2008.

> Involved in physical and logical modeling of databases.

> Created User defined roles on SQL Server 2005 to meet certain security

concerns.

> Created User access, SQL Logins, Roles and Schemas for different

database objects

> Implementation of Data Restoration strategy.

> Implemented Database Mirroring for high availability of the databases

in SQL Server 2005.

> Configured and maintained Microsoft SQL Server 2005 fail over clustered

environment.

> Configured and maintained Log Shipping as stand by server.

> Implemented and monitored Replication to make data available at

different locations.

> Created Jobs and scheduled them for database backup and to run scripts.

> Acknowledged SQL Server Alerts in the environment and resolving.

> Monitoring and resolving the alerts from SQL Server boxes in

Production, Test Environments.

> Involved in ETL architecture design to extract the data from source

systems load to Target.

> Developed, deployed and monitored SSIS Packages including upgrading DTS

to SSIS.

> Also responsible for Design and Development of SSIS Packages to load

the Data from various Databases and Files.

> Transferred data from various sources like MS Excel, MS Access, SQL

Server using SSIS and then created reports using this data using SSRS.

> Migrated Databases from SQL Server 2000 to SQL Server 2005.

> Generated various reports using SQL Server Reporting Services (SSRS).

> Configured and maintained Report Manager and Report Server for SSRS.

> Identified and added the report parameters and created the reports

based on the requirements using SSRS 2005.

> Developed reports using efficient data retrieval techniques and tested

the reports.

> Formatted reports for various Output formats as requested by the

management.

> Performed T- SQL Scripts vetting before deployment in the environment.

> Excellent skills in Optimization of T-SQL procedures using SQL Server

tools.

> Problem analysis/making proposals for alternative solutions.

> Performed SQL Server tuning to improve performance.

> Identified and made recommendations on streamlining and efficiency

improvements for DB related processes.

> Monitoring and resolving the alerts from SQL Server boxes in

Production, Test Environments.

> Auditing for secure logins for achieving security of systems while

following GxP practices in pharmaceutical environment.

> Involved in Hardware resource planning, scheduling and production

monitoring

> Documented the relationships among the SQL Server and Databases

> Coordinated with different teams during production releases

> Recommended next generation database enhancement

Environment: SQL Server 2005/2008, T-SQL, SQL Server Integration

Services, SQL Server Reporting Services, Windows Server 2003

CCSoft Inc, Broken Arrow,OK

Nov 06 - May 07

SQL Server DBA/ Database Developer

CC Soft is the First and most reliable automatic PIN delivery System in the

Market since 1998, and the leader in B2C e-business solutions for the phone

card/ telecom enterprises.

The project was on an advanced software package (CC Soft Phone card

Commerce Server), which allowed the phone card retailer company to maintain

their entire book of business over the Internet, keep track of purchasing,

inventory, vendors, clients and orders online.

Responsibilities:

> Installed and configured SQL Server 2000 /2005 servers

> Worked on Disaster Recovery with High availability systems, log

shipping, back up strategies and scheduling the regular backups,

Replication, Clustering, Client/Server Connectivity, Database

Consistency Checks using DBCC Utilities.

> Worked in the Active-Passive clustered environment.

> Implemented log shipping for synchronization of databases on the

downstream/

> Used SSIS as an ETL tool extensively for creating packages with

complex ETL logic for loading the target tables.

> Migrated data from legacy systems to SQL Server 2005 using SSIS, DTS

Packages and Bulk Inserts and also defined and scheduled several DTS

packages to move data between servers.

> Well versed with creating maintenance plan for reorganizing Indexes

and scheduling jobs.

> Developed and implemented maintenance procedures.

> Ensuring in update of databases regularly and accurately to achieve

integrity.

> Migrated databases from different instances.

> Validated the configuration and performance of the existing databases

including data file allocation, index, fragmentation and the impact on

system performance.

> Monitored and tuned databases to meet the performance and availability

requirements of on-line systems and multiple applications.

> Excellent skills in Optimization of T-SQL procedures & removing the

deadlocks.

> Developed and optimized complex queries to data retrieval and

modification.

> Experience using different SQL Server tools like SQL Server Profiler,

Database Tuning Advisor for performance tuning.

> Loaded stored procedures and user defined functions implemented by

developer teams into the database.

> Developed and created database objects including tables, views, index,

stored procedures and functions for advanced queries and also updated

statistics using Query Analyzer and Enterprise Manager on the existing

servers.

> Modified database structures including tables, data dictionary, stored

procedures, views, triggers, user-defined functions, as well as disk

configuration and storage allocation to support application

enhancements.

> Database Inventory, assessment and analysis for new databases.

> Provided timely suggestions to network team on disk configuration,

RAID level according to database sizing and capacity planning.

> Maintained day-to-day production support thereafter.

> Provided 24x7 support to mission critical databases

> Worked closely with IT project managers, programmers, and testers to

ensure the database integrity and security

Environment: SQL Server 2000,SQL Server 2005,T-SQL, DTS, ER Diagrams,

Erwin, Windows 2003 Server, MS Access, MS Visio, SIS, MS Analysis Services,

MS Reporting Services.

DBS Bank, Los Angeles, CA

Jan 06 - Oct 06

SQL Server DBA

DBS is a wholesale commercial bank providing wholesale banking facilities.

We cater to middle market companies in the US that have trade or investment

links with Asia.

The project was on an internet-mortgage application to provide on-line

housing loan approval. Customers were provided with an email id and

password for application access so as to register with the bank to provide

information for loan calculation and structuring.

Responsibilities:

> Installation, configuration and Setup of SQL Server 2005 on Windows

2003

> Involved in the life cycle of the databases, as a first step, created a

document for physical and logical design of databases

> Used SSIS to extract data from Excel files

> Involved in complete back up of Database and Restored the Database

using Disaster Recovery

> Configured Log shipping server to create stand by environment

> Implemented database clustering (Active-Active) with Windows 2000

(Advanced Server) and MS SQL Server 2005

> Worked on Client/Server tools like SQL Server Enterprise Manager and

Query Analyzer to Administer SQL Server

> Migration of databases from DTS packages to SSIS packages

> Worked on Client/Server tools like SQL Server Enterprise Manager and

Query Analyzer to Administer SQL Server

> Reorganization of database performed periodically for best performance

> Responsible for database performance monitoring and tuning

> Monitoring and optimizing database and transaction log space

> Online trouble shooting of the all types of problems with the aim of

proving best and quick services to the client

> Wrote triggers to put time stamp on the table columns last modified

date and username for insert and update

Environment: SQL Server2005, Windows2003/2000, Oracle, Microsoft Visio

2001, SSIS, SSRS

American International Group (AIG), Jersey city,NJ

May 05 - Dec 05

SQL Server DBA

AIG is one of the world's largest property casualty insurance

organizations. The Accident and Health Division (A&H) is a part of the

Foreign General Group of AIG.

The project was on a system that supported the automation of claim intake,

financials, diary/notes/billing, and litigation and allowed claims to be

electronically referred to other business units such as AI Recovery,

Investigative Services Division (ISD) and Fraud Investigations Division

(FID).

Responsibilities:

> Installed and configured various production SQL Server 2000 databases

> Tested and implementing hot fixes, security patches and service packs

> Managed and secured user logins and prevented users to enter data

incorrectly

> Implemented backup/restore and disaster recovery plans for production

servers

> Implemented and administered database replication between SQL Server

databases

> Created and configured DTS packages for the data generated at all

different locations

> Created jobs to automate repetitive tasks

> Configured DB backups, optimization and integrity check jobs.

Extensively worked on optimization of the stored procedures, created

indexes on the required tables

> Created distributed partition views, indexed views

> Secured the Data and log files by putting them on different physical

disks to minimize IO operations and easy recovery in case of failure

> Investigated DB performance and some of stored procedures were

optimized for 25-45% of execution time

> Created and configured DTS packages for the data generated at all

different locations

> Created jobs to automate repetitive tasks

> Worked in a 24x7 on call

Environment: SQL Server 2000, Windows server 2003,SQL Safe, Windows

2000/XP, MS SQL Server 2000, MS Visual Studio.

Deutsche Bank, NYC,NY

Dec 04 - Feb 05

SQL Server Developer/DBA

Deutsche Bank is one of the world's leading international financial service

providers.

This project was an integrated wealth management system. The basic

functionality of this complex data-driven system was to enhance a client's

personal wealth by letting him explore and choose numerous investment

options terms of Insurance, Mutual funds and Options.

Responsibilities:

> Interacted with users to gather business requirements

> Modified existing database by adding tables and relationships

> Configured database backup schedules to help in disaster recovery

> Created views as per the requirement of front-end developer for easier

implementation on ASP.NET pages

> Worked with BCP and DTS to load text files to SQL Server.

> Maintaining the data, database backups and restoration, backup

strategies, scheduling backups

> Created stored procedures and functions to support complex wealth

management logic

> Ensured the performance of queries by removing unnecessary columns,

normalizing tables, established joins and created indexes wherever

necessary

> Worked on Client/Server tools like SQL Server Enterprise Manager and

Query Analyzer to administer SQL Server

> Created Database Maintenance Plan for the performance of SQL Server,

which covers Database Integrity Checks, Update Database Statistics and

Re-indexing

> Involved in testing, bug fixing and documentation for the project

> Created stored procedures and functions to support complex wealth

management logic

Environment: SQL Server 2000, Windows server 2003, Windows 2000/XP, MS

Visual Studio

Illinois' Health care and Family services, Springfeild, IL

Jan 04 - Aug 04

SQL Server DBA

The Illinois Department of Healthcare and Family Services (HFS) is

responsible for providing healthcare coverage for adults and children who

qualify for Medical aid and for providing Child Support Enforcement

services to help ensure that Illinois children receive financial support

from both parents.

The Data Support Section of the bureau is charged with handling diverse

requests for data assistance from both inside the agency and outside.

Responsibilities:

> Installed and Configured SQL Server 2000 successfully on Windows 2003

Server

> Collected the user and system requirements and wrote technical

specifications

> Involved in Administration of the SQL Server by creating users & login

ids with appropriate roles & grant privileges to users and roles

> Created automatically running Stored Procedures and Triggers for the

day end operation using SQL Server agent

> Create joins and sub-queries for complex queries involving multiple

tables

> Mentor front end users about SQL Queries

> Involved in Administration of the SQL Server by creating users & login

ids with appropriate roles & grant privileges to users and roles

> Involved in developing Logical and Physical Data modeling using ERWIN

> Actively involved in application support, trouble-shooting server

configuration, backups, monitoring, performance planning, server

upgrading and improving security

> Created & used stored procedures for database transactions in SQL

Server

> Used Performance Monitor and SQL Profiler to optimize queries and

enhance the performance of database servers

> Written T-SQL statements for retrieval of data and involved in

performance tuning of TSQL queries and Stored Procedures

> Actively involved in Normalization & De-normalization of database

> Used DDL and DML for writing triggers, stored procedures, and data

manipulation

> Extensively used the SQL Analyzer and Profiler GUI tools for studying

the SQL statements and procedures

Environment:

SQL Server 2000, Enterprise Manager, SQL Profiler, Windows Server 2003

Yash Technologies, Hyderabad, INDIA

Jan 03 - Nov 03

SQL Server Developer

The project was about Production and Marketing activities. It allows the

users to perform insert, update and delete functions for operational

purpose.

EDUCATION QUALIFICATION: Bachelor of Engineering, Anna University, Chennai,

India

Contact this candidate