LAKSHMI ANUSHA JETTY

479-***-****

aceq56@r.postjobfree.com

SUMMARY

8+ years of experience with the 32bit, 64-bit Microsoft SQL SERVER in Production,

•

Development and Testing in Clustered and Stand alone Server Environment.

Experience installing MS SQL SERVER 2000,2005,2008,2008 R2,2012 updating with

•

hot fix and service packs

Extensive experience in implementing High availability solutions like different

•

Replication models (Snapshot and Transactional), Log shipping, Clustering and

Mirroring on physical and virtual machines.

Extensively worked on Active-Active and Active-Passive Clustering.

•

Implemented Side by Side Migration of MS SQL SERVER 2000/2005 to 2008.

•

Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration

•

Wizard.

Installation, upgrade, configuration and administration of MS SQL Server 2012 and

•

2008 on VM Servers.

Good knowledge of new features like Column store indexes, contained database,

•

always on availability group in SQL server 2012

Performed BCP, BULK INSERT, Imported and Exported data from different Data

•

Sources.

Deployed and Debugged SSIS packages for import, export and bulk insert data with

•

transformations from various data sources.

Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003

•

Server.

Extensively used the XML, FLAT FILE, BULK INSERT AND FILE SYTEM control

•

flow tasks and data flow tasks SSIS.

Experience in generating Reports (SSRS) in Business Intelligence Development Studio

•

(BIDS)

Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and

•

Concurrency Effects.

Extensively used the native tools like index tuning wizard, data base tuning advisor,

•

profiler, performance monitor, activity monitor, Event viewer for performance

analysis.

Experience in comprising Performance Tuning, Query Optimization, Client/Server

•

Connectivity, and Database health Check, Indexing, Updating Statistics.

Experience in Backing up, restoring the data base manually and also by scheduling the

•

jobs and Maintenance Plans.

Expert in analyzing the execution plan and index management for better Query

•

Optimization.

Expertise in Identifying the bottlenecks caused by complex queries using Activity

•

Monitor/SQL Profiler and handling them by implementing better Query Execution

plans

• Expertise on administration, change management processes,

performance analysis, production Support for large database.

Extensively worked on Security Management, Managing server and client

•

Connections

Configured SMTP Server for Database Mail setup and received Alerts for the

•

Threshold values.

Created SSIS packages to load robust data from different Heterogeneous data sources

•

like .NET, Oracle, DB2 to SQL server.

Experience in using DMV and dynamic management functions (DMF) Of Tables,

•

Triggers, Store Procedure etc for finding out long running queries.

Explicitly used third party tools like Lite Speed, Fog light and spotlight.

•

Auditing of database for users transaction, login and database action and removing

•

orphan users

Worked with a team of business analysts, data architects, application developers, ETL

•

developers and testers.

Strong experience in mentoring with team members, documentation and 24/7 on call

•

production support.

Excellent Problem Solving Skills, Communication, presentation and interpersonal skills.

•

Strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Operating Windows Vista/XP/2000/NT, Server 2003, Exchange 2003, Linux, Unix.

Systems:

Databases: MS SQL Server 2008/2005/2000/7.0, MYSQL, Oracle, MS Office Access

97/2000/2003.

ETL TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services

(SSRS), Data transformation services (DTS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server

Management Studio.

Data Modeling Spotlight, Red gate, Light speed, fog lite.

Tools:

Languages: T-SQL, C/C++, Java, HTML scripts, java script

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Geisinger Health Plan, PA Feb’12- Till Date

SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Server 2005/2008/2008R2/2012 on Virtual and

physical servers.

• Upgrading SQL server from 2008 to 2008R2 and 2012

• Upgrading SQL server 2008 from standard edition to enterprise

• Migration of SQL Server 2005 to 2008, 2008 to 2008R2 and 2012.

• Configuring, administration and troubleshooting multiple databases including very large

database in

• Development, QA and Production environments.

• Installing and configuring two node active/passive Cluster environments with SQL

Server 2008

• Implemented Database Mirroring with High Availability Mode in MS SQL Server

2008R2/2008.

• Successfully implemented Log Shipping.

• Setting up and Maintaining Snapshot and Transactional Replication

• Working with end user gathering requirement for the system.

• Responsible for creating logins, Users, roles, managing user permission for individual

logins and domain group and Resolving security issues.

• Build a new server from scratch to test a Disaster Recovery and update DR document

• Create automated jobs to Archive production tables and data to TAPE.

• Designed and Implemented Full, Transactional and Differential Backup plans.

• Developing and maintaining automated daily, weekly and monthly maintenance tasks.

• Working closely with developer and tester while creating and testing new databases,

stored procedure, Jobs on Development and QA environments before production.

• Working with Data masking team to create database de-identify job in Dmsuite

• Deploying database objects from development/testing environment to production

environment.

• Used Third party backup tool like SQL Litespeed for object level recovery and backup

encryption.

• Used SSIS Packages for data flow SQL Server to Flat files and used control flow

task to perform administration related tasks.

• Installing third party monitoring and backup tools across the servers and configuring

instances on tool.

• Providing excellent 24X7 Production support.

Quest Diagnostics, Kansas Oct ‘11-

Jan’12

SQL Server DBA

Description: Quest Diagnostics Incorporated is the world's leading provider of diagnostic

testing, information and services that patients and physicians need to make better decisions

through a vast network of over 2,000 patient service centers. It is the leading provider of esoteric

testing, including gene-based testing, drugs of abuse testing, and non-hospital-based anatomic

pathology testing. Millions of test results are transformed into valuable information products to

identify patterns and trends, helping physicians and other healthcare providers identify people at

risk for certain diseases and enabling pharma companies in the commercial development of their

products.

Responsibilities:

Managed and Administrated the SQL Server 2008/2005/2000 production and Non-

•

production servers.

Installation of SQL Server 2008/05 on Windows Server Clustered environment.

•

prepared maintained and modified SQL server installation and configuration documents

•

Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008

•

databases and mentored Junior DBAs and other technical staff.

Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS

•

to SSIS packages.

Handled up to 2.5 TB Size databases with clustered environment.

•

Application support for front end feeds and Resolved Application connectivity issues

•

like connection timeouts, connection pooling issues and memory leaks.

Setting up and Monitored transactional replication, Database mirroring on

•

Production, QA and Dev servers.

Monitored Log shipping/ Transactional Replication and trouble shooting of errors.

•

Managed Security using SQL Logins, Roles and Security Modes for various users.

•

Rebuilding the indexes on regular intervals and placing the huge table/non-clustered

•

index on the separate file group to improve the performance.

Developed and created the new database objects including tables, views, index, stored

•

procedures and functions, advanced queries and also updated statistics using Query

Analyzer and Enterprise Manager on the existing servers.

Analyze execution plans and generate suggestions for improvement.

•

Handled numerous change management requests on production servers

•

Designed and developed SSIS packages using different control flow tasks,

•

Transformations and dataflow tasks.

Created SSIS packages to load robust data from different Heterogeneous data

•

sources like Oracle, DB2 to SQL server.

Created, scheduled database maintenance plan using SSIS Maintenance plan task.

•

Configured and deployed SSIS Packages from Test to Production Environments.

•

Supported 24 X 7 Production environment

•

BBVA Compass Bank, Birmingham July ‘11- Oct

‘11

SQL Server DBA/SSIS

Description: Compass Bancshares, Inc. is a Sunbelt-based bank holding company headquartered

in Birmingham, Alabama. BBVA Compass – operates 577 branches in Alabama, Arizona,

Colorado, Florida, New Mexico and Texas. Compass is among the top 25 largest banks in the

U.S. based on deposit market share and ranks among the largest banks in Texas (4th) and

Alabama (3rd). Through three major business units – Corporate Banking, Retail Banking, and

Wealth Management – Compass offers customers unique and industry-leading products and

services.

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-

production servers.

• Developed logical design and physical design.

• Administered and maintained production/Development servers with more than 2 TB of

database size with complex structures.

• Designed a report on the monitoring of SQL Server Performance. This report gives a detail

report to the management on the Performance of the server.

• Fine tuning of database objects and server.

• Worked with SQL Server 2005 side by side upgrade from sql server 2000.

• Installed couple of SQL Server 2005/2008 on cluster environment.

• Worked with SQL server Profiler to generate traces.

• Identified long running stored procedures and SQLs using profiler and fine tuned for

maximum performance.

• Expertise in setting up and troubleshooting Database mirroring.

• Optimized working process.

• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on

Production and Semi-Production Servers and handling maintenance Jobs.

• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to

SQL server 2005.

• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL

Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine

Tuning Advisor

• Implementation 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

• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.

• Export or Import data from other data sources like flat files using Import/Export through

DTS, SSIS.

• Huge data of Insurance policies and customer information in XML, Flat file data

transforming using SSIS Packages.

• Developed SSIS packages, stored procedures, functions, triggers.

• Tuned servers to the peak for maximum performance by configuring memory and various

server level parameters.

• Hands of experience in writing batch files.

• Extensively worked on extraction, transformation and loading of data from various data

sources to SQL Server.

JP Morgan Chase, Chicago, IL Jan’09 –

July’11

SQL Server DBA/SSIS

Description: One of the major banking systems in unites states-offers and operates financial

planning; individual retirement accounts (IRAs), mutual funds, auto loans, home mortgage loans,

small business loans, share drafts (checking accounts), credit cards, and ATM and debit

cards. Provides online financial services to over 300,000 customers; assistance to smaller banks

and credit unions. My initial responsibility here was to implement and maintain industry

standards across the domain for financial services and to provide and support high availability

solutions for consumer’s services. The project was extended to support and maintain the entire

employee related records and payroll system.

Responsibilities

• Installation and configuration of SQL Server 2000 components

• Administration of Clustered SQL servers in 24 x 7 Windows data center environment

• Designed and implemented Security policy for SQL Servers

• Implementation 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 and Scheduled Replication process for updating our parallel servers

• Automated messaging services on server failures, for task completion and success.

• To analyze long running queries and tune the same to optimize application and system

performance.

• To set up SQL Server configuration settings to resolve various resource allocation &

memory issues for SQL Server databases and to setup Ideal Memory, Min/Max server

options.

• Creating Automatic data loading Procedures from the host system to master systems

• Extensively Involved in Query Optimization and data Tuning

AMICA Insurance, Bangalore, India May’06 –

Dec’08

SQL Server DBA/Developer

Description: AMICA deals with all processes of insurance. The application I worked on deals

predominantly with Insurance Processing. This is mainly divided into 4-modules according to

their functional aspects like Policy module, Premium Collection, Accounting Admin and

Claim & reporting modules. The policy module deals with all policy related issues such as

customer, quotations and application submission. Accounting module deals with all accounts

related processes like deposits, commissions and adjustments. The claim module processes

customer claims. Admin module allows the administrators to create users and groups. The

security is implemented in terms of login and privileges. Logically related tasks are grouped into

sub modules within each modules based on the functionality. All modules talk to each other in

life cycle of a policy.

Responsibilities:

Installed and configured MS SQL Server and Clients.

•

Created and managed schema objects such as tables, views, clusters, indexes,

•

procedures, triggers and maintained Referential Integrity

Managed Disk space, memory and User connections

•

Generated Script files of the databases whenever changes were made to stored procedures

•

or views.

Excellent knowledge in Import / Export using DTS and BCP utility.

•

Established DR sites using log-shipping and Wrote dynamic stored procedures for

•

moving Databases from production server to DR server

Implemented and maintained Replication (Transactional, snapshot) using Dynamic

•

scripts and solving problems

Participated in discussions with product team for new features

•

Performed query plans and enforced indexing in each and every query

•

Wrote dynamic stored procedures to create Database Roles and grant permission to

•

roles and adding logins to specified roles

Designed new schema for data partition and created Partition views for better

•

performance.

Programmed in T-SQL to implement Stored Procedures and Functions for different

•

tasks

Implemented Performance Tuning, Analysis, tuning and optimization of SQL Server

•

Applications using performance monitor. Assisted the SQL Developers in query tuning

and optimization.

Created updatable partitioned views

•

Created Stored Procedures and triggers to perform automated rules and updation of

•

related tables

EDUCATION

Bachelor of Computer Science Engineering, Acharya Nagarjuna University,India.

Contact this candidate