VIJAY BANDI

***-***-

****/ablmho@r.postjobfree.com

SUMMARY

. Over eight years of SQL server DBA experience in IT, commercial,

banking, health and finance environments.

. Experience in an operational environment providing support involving

coordination with release management and change management.

. Experience with SQL server 2000, SQL server 2005, SQL server 2008

installation, administration and management of multiple

instances/servers in highly transactional environments

. Extensively worked in OLTP & OLAP environment that includes production

(24x7), QA and development databases in SQL server.

. Experience in migration from SQL server 2000 to SQL server 2005 and

SQL server 2008 as well as DTS Xchange tool for migrating DTS packages

to SSIS packages

. Worked with IT staff on various projects like server upgrades, data

center migrations etc.

. Expert in disaster recovery planning with log shipping, replication

etc and high availability solutions like DB mirroring, clustering etc.

. Involved in a few very large data center migrations as the Sr. DBA

for DB2 and SQL Server inventories and developed an approach suited

to minimizing risks

. Worked with developers for query optimizations, performance tuning,

package deployments, code changes etc.

. Proficient with database backup/restore, recovery procedures, index

maintenance, production security standards, change requests etc

. Proficient with SQL enterprise manager, SQL Query analyzer, SSMS, BI

studio, SQL profiler, database tuning advisor, DMVs

. Extensive experience with data modeling, dimensional modeling, logical

and physical database design.

. Experience in query optimization & performance tuning. used SQL

profiler, execution plan, performance monitor and DBCC commands

. Experience in replication, snapshot, merge and transactional.

. Extensively worked and had good knowledge on integration and reporting

services and good experience in data migration from

Oracle/Access/Excel Sheets to SQL server 2005/2000/7.0

. Experience in using different transformation tools like DTS packages,

BCP, and BULKINSERT, SSIS.

EDUCATION

. Bachelor of Engineering, Electronics and Communication, Anna

University, Chennai, India

CERTIFICATIONS

. 70-445 Microsoft SQL server 2008 business intelligence,

implementation and maintenance

SKILLS

RDBMS MS SQL SERVER 2000/2005/2008/2014

Databases Tools SQL Server Management Studio, SQL Server Business

Intelligence Development Studio (BIS), Database

Engine Tuning Advisor, Enterprise Manager, Query

Analyzer, SQL Profiler, Data Transformation

Services, Upgrade Wizard, Replication, DTS xChange

MS Visio, DB artisan, SQL reporting, SSIS,MAP Tool,

SQL Compare

Programming Languages SQL, TSQL,

Web Tools MS-Front Page, Internet Information

Server(IIS),FTP,TCP/IP,LAN,MS-Outlook Express

Operating Systems Windows 95/98/2000/2003/XP/NT 4.0, Unix, MS-DOS.

Utility Tools MS Office, MS Project, ClearQuest, Visual Source

Safe 6.0, Rational ClearCase.

EXPERIENCE

Feb '12 - Present Sr. SQL DBA/Developer Financial,

King of Prussia, PA

SEI is a leading global provider of asset management, investment

processing, and investment operations solutions for institutional and

personal wealth management. The project was to transform data from Trust to

SQL and replicate Real Time data to subscriber using Perl Scripting.

Reviewed and approved SQL stored procedures and data modification scripts

to production and interacted with .Net Developers and a large DBA

Operations group to provide feedback on the scripts that were submitted.

. Involved in installing and configuring of SQL server 2008 and 2008R2

on standalone and clustered environments.

. Installed SQL 2008 standard edition with SP1 for testing present

application and migrating test databases to test any upgrade issues.

. Migrated vendor databases from SQL 2005 to SQL 2014

. Performed Disk swap on existing clusters

. Build 5 Node active passive cluster to use resources more effectively

. Work on effective solutions to bring data from M/F to SQL server

. Hands on experience in red gate data compare, schema compare and data

generator

. Task lead for migration of data from three sources two SQL databases

and a pro flat file database to two new SQL databases.

. Installed Idera diagnostic manager to monitor all PROD servers

. Involved in data modeling, designing and building relational databases

using Erwin tool.

. Implemented database mirroring between primary server and a standby

server.

. Running DBCC consistency checks, and fixing data corruption in user

databases.

. Creating and managing schema objects such as tables, views, indexes

and referential integrity depending on user requirements and

converting them into technical specifications.

. Creating databases and logins with permissions in SQL server 2008 as

per the developer's request.

. Monitor backup jobs daily and run the jobs manually in case of failure

depending upon the necessity.

. Prepare daily report on the job failures, backup failures and disk

space and implemented an e-mail notification solution to be notified

when a threshold or error is encountered.

. Involved in resolving dead lock issues and performance issues.

. Created and scheduled jobs to setup log shipping between production

servers as well as standby servers.

. Disk configuration to implement availability and reliability, which

usually transfers into Redundant Array of Inexpensive Disks (RAID) and

Storage Area Network (SAN)

. Experience in installing and configuring clustering to provide high

availability and scalability.

. Optimized queries and stored procedures for better performance

. Coordinating with the development team regarding tuning the SQL

queries and stored procedures.

. Identifying the bottlenecks and troubleshooting it for optimal

performance.

. Responsible for MS SQL Server 2008, configuration, tuning and provide

support to all production and development servers.

. Performed all aspects of database administration, including data

modeling, backups and recovery.

. Configured transactional replication between primary server and three

read only servers, with separate distributor server and experience in

troubleshooting replication problems.

. Extracted, transformed, and loaded data (ETL) by Writing SQL queries,

running queries, exporting data, importing and scrubbing data with

Excel or Access

. Additionally, designed and implemented a disaster recovery system.

. Running index tuning wizard and rebuilding indexes for faster query

response.

. Created the logical and physical data modeling using Erwin tool.

. Maintain operators, categories, alerts, notifications, jobs, job steps

and schedules. Monitor connections, locks and performance of SQL

server.

. Assign permission to user(s), role(s), and object. Support column

level permission. Administrate security for server's logins (Windows

and SQL accounts).

. Created documentation to install SQL server, apply service pack, hot

fix and clustering installation.

. Worked with various tasks of SSIS like transform data task, execute

SQL task, and active script task etc.

. Expertise in security issues such as creation and granting permissions

on various objects.

. Prepared the reports for the day-to-day as well as weekly/monthly

purposes.

. Scheduling SSIS packages, Fuzzy Look-up for cleaning bad data,

validating data using SSIS wizard

Environment: MS SQL Server 2000/2005/2008, Windows 2000/2003 servers,

Active Directory, IIS Web server, DTS, SQL Upgrade Advisor, MS Access,

Microsoft Analysis Services,VMware3.5, Diagnostic Manager, Microsoft

Reporting Services, UNIX, Power shell, Microsoft SQL Server Integration

Services(SSIS), Litespeed

Feb '11 - Jan '12 SQL DBA, WellPoint, Richmond, VA

WellPoint, Inc. is the largest health benefits company in terms of

commercial membership in the United States. Through its networks

nationwide, the company delivers a number of leading health benefit

solutions through a broad portfolio of integrated health care plans and

related services, along with a wide range of specialty products such as

life and disability insurance benefits, dental, vision, behavioral health

benefit services, as well as long term care insurance and flexible spending

accounts.

. Installation and configuration of SQL server 2008 and 2008R2 on

standalone and clustered environments.

. Configured SQL server clustering, log shipping, mirroring and

replication.

. Implemented active\passive and active\active clustering and installed

SQL 2008R2 for production application support.

. Worked on datacenter migration from VA to St. Louis.

. Using upgrade advisor analyzed and resolved all the issues encountered

in migrating from SQL Server 2000 to SQL Server 2008.

. Using DTS xchange tool to convert DTS packages to SQL Server 2008 SSIS

packages.

. Implementing database standards and naming convention for the database

objects.

. Converting and deploying of existing DTS packages to integration

service (SSIS) packages over the development, testing and production

environments.

. Using Microsoft business intelligence development studio for creating

ETL packages and reports. Creation of SSIS packages to extract,

transform and load into the campaign database

. Ensured constraints and writing triggers to apply business rules.

Performance tuning, backing up and restoring user databases.

. Involved in designing and implementation of data warehousing solution

which includes Building an OLAP database, creating data source.

. Configured and maintained transactional for different environments and

also setup the jobs to capture the latency instead of using tracer

tokens

. Extracted data from SQL Server for report, backup, testing purpose by

using SSIS

. Managed databases on multiple disks using RAID technology.

. Developed T-SQL stored procedures/functions to process data and

populate them in the appropriate destination tables.

. Setup change data capture on replicated tables

. Create MDW database to monitor all the instances of SQL server

. Assign permission to user(s), role(s), and object. Support column

level permission. Administrate security for server's logins (Windows

and SQL Accounts).

. Configured and maintained transactional and merge replication for

different environments.

. Creating various Jobs, scheduling & running jobs and troubleshooting

the failed jobs.

. Expertise in monitoring and troubleshooting SQL server performance

issues.

. Worked on various tools like SQL LiteSpeed for backups.

. Tuning of slow running queries or inefficient queries for optimal

performance using SQL profiler and managing indexes and statistics.

. Monitoring the database server's health and tuning accordingly.

. Provided 24 x 7 production supports for the database and application

issues.

Environment: MS SQL Server 2008, 2005, 2000, BPA, Performance Dashboard, T-

SQL, SSIS, SSRS, DTSxChage tool, TSM,TSRM and Windows 2008/2003/2000

Servers.

July 2009 - Jan 2011 SQL Server DBA, Commerce Insurance, Webster, MA

The Commerce Insurance Company provides personal and commercial property

and casualty insurance. It's assorted financial and investment products are

focused on personal automobile, private passenger and homeowners insurance,

business insurance, and commercial automobile insurance.

. Involved in installing and configuring of SQL Server 2005.

. Installed SQL 2008 standard edition with SP1 for testing present

application and migrating test databases to test any upgrade issues.

. Involved in Data modeling, designing and building relational databases

using Erwin tool.

. Implemented Database Mirroring between primary server and a standby

server.

. Running DBCC consistency checks, and fixing data corruption in user

databases.

. Creating and managing schema objects such as Tables, Views, Indexes

and referential integrity depending on user requirements and

converting them into technical specifications.

. Creating databases and logins with permissions in SQL server 2008 as

per the developer's request.

. Monitor backup jobs daily and run the jobs manually in case of failure

depending upon the necessity.

. Prepare daily report on the job failures, backup failures and disk

space and implemented an e-mail notification solution to be notified

when a threshold or error is encountered.

. Involved in resolving dead lock issues and performance issues.

. Created and scheduled jobs to setup log shipping between production

servers as well as standby servers.

. Experience in installing and configuring clustering to provide high

availability and scalability.

. Optimized queries and Stored Procedures for better performance

. Used SQL Assistant for writing advance SQL queries, and used xSQL data

compare to compare databases and tables for sync between dev, test and

production.

. Coordinating with the development team regarding tuning the SQL

queries and stored procedures.

. Identifying the bottlenecks and troubleshooting it for optimal

performance.

. Responsible for MS SQL Server 2008, configuration, tuning and provide

support to all Production and development servers.

. Performed all aspects of database administration, including data

modeling, backups and recovery.

. Used performance monitoring tool fog light for to check the health of

the databases and instances.

. Configured Transactional replication between Primary Server and three

Read-Only servers, with separate Distributor server and experience in

troubleshooting replication problems.

. Successfully Migrated SQL 2000 DTS packages to SSIS using DTS Xchange

tool.

. Additionally, designed and implemented a disaster recovery system.

. Running Index tuning wizard and rebuilding indexes for faster query

response.

. Created the logical and physical data modeling using Erwin tool.

. Generated SQL scripts using windows power shell to generate table

creation scripts and backing up the database with a windows powershell

script

. Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps

and Schedules. Monitor connections, locks and performance of SQL

server.

. Assign permission to user(s), role(s), and object. Support column

level permission. Administrate security for server's logins (Windows

and SQL Accounts).

. Created documentation to install SQL Server, apply service pack, hot

fix and clustering installation.

. Expertise in Security Issues such as creation and granting permissions

on various Objects.

. Prepared the reports for the day-to-day as well as weekly/monthly

purposes.

Environment:

MS SQL Server 2000/2005/2008, Windows 2000/2003 servers, Active Directory,

IIS Web server, DTS, SQL Upgrade Advisor, MS Access, Microsoft Analysis

Services, Diagnostic Manager, Microsoft Reporting Services, UNIX, Power

shell, Microsoft SQL Server Integration Services(SSIS), Litespeed

Mar '08 - May '09 SQL DBA American Family Insurance, Madison, WI

American Family has a long and successful history of providing quality

insurance products that dates back to 1950. Today, they are among the top

50 Property and Casualty Insurance companies in the country and rank as the

fourth largest writer of automobile insurance through independent insurance

agents.

. Responsible for MS SQL server 2005, configuration, tuning and provide

24 X 7 dedicated support to all production, development and clustered

servers.

. Involved in data migration from SQL 2005 to SQL 2008.

. Performed all aspects of database administration, including data

modeling, backups and recovery.

. Prepared technical specifications for the development of SSIS (ETL)

packages to load data into various target tables and defining ETL

standards.

. Resolved the SQL server 2005 upgrade hurdles and successfully migrated

SQL 2000 DTS packages to SSIS using upgrade advisor and package

migration wizard.

. For complex packages like password protected packages, packages

created using SQL native client used DTS Xchange tool.

. Worked as project lead on the actual tools and custom code

upgrade/conversions as well as lead on actual deployment team.

. Developed advanced queries,triggers, views, and indexes using T-SQL

. Installation of replication server, configuration and monitoring the

replication, implemented transactional replication writing scripts for

automation, for creating publications, articles and running the

snapshot agent job,so that the same scripts can be used from system

test to production

. Created logical and physical data modeling for development database

using ERWIN tool.

. Wrote and integrated stored procedures to generate the reports.

. Specialized in designing clustering environments (active/passive and

active/active) to further increase scalability and stability of

business critical systems.

. Wrote complex stored procedure, queries, triggers, functions, user-

defined functions and cursors for application.

. Created different types of reports such as drill-down, summary, form,

OLAP and sub reports, and formatting those using SSRS 2005.

. Experience in creating parameterized reports and linked reports with

thorough knowledge of report serving architecture. (table, chart and

matrix report)

. Additionally, designed and implemented a disaster recovery system.

. Running index tuning wizard and rebuilding indexes for faster query

response.

. Assign permission to user(s), role(s), and object. Support column

level permission. Administrate security for server's logins (Windows

and SQL accounts).

. Prepared estimates for database, table size growth.

. Setting up, configuring and troubleshooting Log shipping for databases

on disaster recovery (DR) servers.

. Expertise in security issues such as creation and granting permissions

on various objects.

. Prepared the reports for the day-to-day as well as weekly/monthly

purposes.

. Monitoring the event logs and server error logs for troubleshooting.

Environment: Windows 2003 Server, SQL 2005 / 2008 Enterprise Edition,

Oracle 10g,SSRS, SSAS, SSIS, Performance Point Sever 2007,T-SQL,

ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET

Framework 2.0, EXCEL2007.

Dec '05 - Feb '08 SQL DBA, Hexaware Technologies, Chennai, India

Hexaware is a global provider of IT and process outsourcing services. They

focus exclusively on maximizing client returns from outsourcing and off-

shoring; have an extensive experience in managing large IT applications in

real time as well as in providing high value services around packaged

enterprise applications such as SQL and PeopleSoft.

. Involved in installing and configuring of SQL Server 2000 and 2005,

both in unattended and remote installations.

. Involved in data modeling, designing and building relational

databases.

. Transferred data from Oracle to SQL server using SSIS.

. Implemented database mirroring.

. Running DBCC consistency checks, and fixing data corruption in user

databases.

. Creating and managing schema objects such as tables, views, indexes

and referential integrity depending on user requirements and

converting them into technical specifications.

. Creating databases and logins with permissions in SQL server 2005 as

per the developer's request.

. Created linked servers between SQL server 2000/2005 and Oracle servers

in the environment.

. Involved in migrating the backup jobs from SQL server to Lite Speed

. Monitor backup jobs daily and run the jobs manually in case of failure

depending upon the necessity.

. Prepare daily report on the job failures, backup failures and disk

space.

. Involved in resolving dead lock issues and performance issues.

. Created and scheduled jobs to setup log shipping between production

servers as well as standby servers.

. Coordinating with the development team regarding tuning the SQL

queries and stored procedures.

. Identifying the bottlenecks and troubleshooting it for optimal

performance.

. Responsible for MS SQL Server 2000, configuration, tuning and provide

24 X 7 dedicated support to all production, development and clustered

servers.

. Performed all aspects of database administration, including data

modeling, backups and recovery.

. Configured transactional replication between primary server and three

read only servers, with separate distributor server and experience in

troubleshooting replication problems.

. Resolved the SQL server 2005 upgrade hurdles and successfully migrated

SQL 2000 DTS packages to SSIS using upgrade advisor and package

migration wizard.

. For complex packages like password protected packages, packages

created using SQL Native client used DTS Xchange tool.

. Additionally, designed and implemented a disaster recovery system.

. Running Index tuning wizard and rebuilding indexes for faster query

response.

. Assign permission to user(s), role(s), and object. Support column

level permission. Administrate security for server's logins (Windows

and SQL accounts).

. Prepared estimates for database, table size growth.

. Created documentation to install SQL server, apply service pack, hot

fix and clustering installation.

. Expertise in security issues such as creation and granting permissions

on various objects.

. Prepared the reports for the day-to-day as well as weekly/monthly

purposes.

. Wrote and integrated stored procedures to generate the reports.

Environment: Microsoft SQL Server 2005, SQL Server Management Studio,

Business Intelligence Development Studio, SQL Server Integration Services

(SSIS), SSRS, Crystal Report v9.0, VB.Net, Windows XP, Office 2003.

Contact this candidate