Sql Server Data

.

.

.

. Vamsi Krishna 510-***-**** *****@**********.***

.

Professional Summary

Over 8+ years of IT Experience in SQL Server database admin, System

Analysis, Design and Development and Support of Microsoft SQL Server

2012/2008 R2 / 2008 / 2005 / 2000 in production, development and test

Environments on various business domains like Financial, Insurance and

Manufacturing.

. Expert in Installing, Configuring, Managing, Monitoring,

Troubleshooting, Upgrading and Migrating SQL Server

2012/2008/2005/2000 on Clustered and Standby Environments.

. Experience in implementing and monitoring different types HA and DR

scenarios like Replication, log shipping in Cluster Environment on

Production, QA and Dev environments.

. Supported Very Large Database (VLDB) more than 6TB and troubleshooting

problems.

. Expertise in Database Backup and Recovery procedures by using Native,

and LiteSpeed to/from Disk /Tape.

. Extensively used tools like SQL Profiler, Index Tuning Wizard, and

Windows Performance Monitor for monitoring and Performance Tuning,

Query Optimization, Client/Server Connectivity, and Database

Consistency

. Setup, test and maintain business continuity/disaster recovery

infrastructure database and applications.

. Created Stored Procedures, Functions and Triggers using T-SQL and also

expert in tuning Complex Queries. Checks using DBCC Utilities and

DMV's and DMF's, Re-indexing, Updating Statistics and online indexing.

. Review of physical and logical database design; Promote the

reliability of database design by ensuring appropriate referential

data integrity is implemented and appropriate data types are used.

. Good in monitoring using SCOM Monitoring, Event Viewer, and SQL Error

logs.

. Extract Transform Load (ETL) development using SQL Server Integration

Services (SSIS).

. Experience in DTS Migration and Metadata Management: Migrating DTS

Packages to SSIS, Package Migration Wizard, and Storage Management.

. Extensive experience on Business Intelligence Tools to create SSRS

Reports, SSIS Packages and SSAS. Scheduled jobs to backup OLAP cubes.

. Performed data transformations between servers using BCP, DTS, SSIS

and bulk insert. And also Expert in using DMV's, DMF's.

. Good understanding in database and data warehousing concepts (OLTP &

OLAP). Experience with logical and physical data modelling and

database design using Erwin.

. Experience in Database administration activities for DB

Security (creating logins, users, roles, and assigning permission to

them).

. Design, document, and promote security "best practices", policies,

standards and protocols.

. Knowledge on In Line memory of SQL server 2014.

Technical Skills:

Languages

C, DDL, DML, T-SQL, J2EE

Tools

SQL DB Access, Performance Monitor, Backup Utility, TDP/TSM, LiteSpeed,

RedGate, SSRS, VSS, CPS, Quest Spotlight.

Web Server Technologies

IIS 5.1/6.0

Data Modelling Tool

Visio 2003, Office Visio 2007

Operating System

Windows 2008, 2003, 2000 Advanced Server, Windows 2000 data center, Windows

NT, Windows 95/98/2000 XP.

Certifications

. (070-457) SQL Server 2012 - Transition Your MCTS on SQL Server 2008 to

MCSA: SQL Server 2012, Part 1 .

. (070-432) SQL Server 2008 -Implementation and Maintenance.

. (070-431) SQL Server 2005 - Implementation and Maintenance.

Professional Experience

DMA Associates

Edison, NJ (April 2014 to

Till Date)

Role: LEAD DBA

Description:

The project involves in creation of applications for money lending company,

responsible for Developing database solutions by designing proposed system;

defining database physical structure and functional capabilities, security,

back-up, and recovery specifications, server architecture, Managing and

maintaining SQL Server 2012 & 2008 R2 Servers.

. Determine database structural requirements by analyzing client

operations, applications, and programming; reviewing objectives with

clients; evaluating current systems.

. Configuring and Maintaining 2 node Active-Passive, Active-Active

Cluster.

. Develop strategies for data acquisitions, archive recovery, and

implementation of a database.

. Setting up replication (snapshot, transactional), log shipping and

troubleshooting issues when encountered.

. Worked with the table partitioning (Sql Server 2008) mechanism to

allow the SQL Server engine to escalate locks to the partition level

before the table level.

. Developed SSIS package to automate daily debit and Credit

transactions.

. Creation of reports like Reports by Period, Demographic reports and

Comparative Reports.

. Maintains database performance by identifying and resolving production

and application development problems; calculating optimum values for

parameters; evaluating, integrating, and installing new releases;

completing maintenance; answering user questions

. Worked on DB performance issues.

. Created backup policy and archival jobs.

. Designed weekly job to De fragment the tables based on

fragmentation.

. Implemented Always On feature.

. Provide 24*7 database support by coding utilities, responding to user

questions, and resolving problems.

. Developed and optimized database structures, stored procedures,

Dynamic Management views, DDL triggers and user-defined functions.

BlueCross BlueShield

Baltimore, MD (MAY 2013 to March 2014)

India (June 2012 to

MAY 2013)

Role: LEAD DBA

Description:

The project involves in creating a contract creation application for

Carefirst, Inc. which is responsible for managing and maintaining SQL

Server 2008 R2 Servers and databases (SAP & Non-SAP) which involves

regular monitoring, backup & recovery of databases, performance tuning,

troubleshooting issues related to Cluster, disk space, memory, network,

SSIS and SSRS, capacity planning, disaster recovery planning, applying

security patches, hot-fixes, service packs, setting up replication

(snapshot, transactional), log shipping and troubleshooting issues when

encountered.

. Configuring and Maintaining 4 node cluster with 8 SQL instances.

. Setting up and Monitored transactional replication, Database mirroring

on Production and QA servers.

. Planning of architecture and Upgrade of SQL Server 2005 to 2008 and

2008 R2.

. Applying Service packs and patches on the SQL servers.

. Worked on Active-Passive, Active-Active Cluster environment as a High

availability solution.

. Created and maintained Database mirroring with automatic failover,

Replication, Metro Mirroring (SAN Mirroring) and Resilient

infrastructure as a High availability

. Tuning queries which are running slow using Profiler and Statistics Io

by using different Methods in terms of evaluating joins, indexes,

updating Statistics and code modifications.

. Worked with the table partitioning (Sql Server 2008) mechanism to

allow the SQL Server engine to escalate locks to the partition level

before the table level.

. Worked with Transparent Encryption, table compression, database

compression and merge statements using SQL server 2008.

. Used Policy Based Administration feature (SQL Server 2008) and Worked

with SCOM Monitoring.

. Implemented Always On feature.

. Extensively used Joins and sub-Queries to simplify complex queries

involving multiple tables.

. DR DB Restore in which we restore all the production databases to a DR

server to check whether the backups are fine or not.

. Creation and management of Database maintenance plan for various

database consistency checks.

. Providing a case studies on new features and tools like quest

spotlight, always on feature.

. Providing 24*7 supports for all database issues and activities.

GE Capital

San Francisco, CA (Sept 2011 to June 2012)

India (Dec 2010

to Sept 2011)

Role: SR SQL Developer / SQL Server DBA

GE Capital is a bank providing smart financing to the customers.

. SQL Server 2005 & 2008 Database Administration.

. Performed the migration of SQL Server 2005 to SQL Server 2008.

. Installed and maintained 2-Node (Active-Active) Clustering as a High

availability solution.

. Responsible to Monitor and troubleshooting Log Shipping.

. Involved in Source Data Analysis, analysis and designing mappings for

data extraction also responsible for Design and Development of SSIS

Packages to load the Data from various Databases and Files.

. Implemented and maintained Database mirroring as a Disaster Recovery

Solution.

. Setting up and Monitored transactional replication, Database mirroring

on Production and QA servers.

. Installed, authored, and managed reports using SQL Server 2005

Reporting Services

. Experience in trouble shooting Client connections, viewing error logs

and application logs.

. 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.

. Responsible for monitoring and making recommendations for performance

improvement in hosted databases. This involved index creation, index

removal, index modification, file group modifications, and adding

scheduled jobs to re-index and update statistics in databases.

. Developed and optimized database structures, stored procedures,

Dynamic Management views, DDL triggers and user-defined functions.

. Experience in implementing and maintaining new T-SQL features added in

SQL Server 2005 that are Data partitioning, Error handling through TRY-

CATCH statement, Common Table Expression (CTE).

. Transferred data (ETL) to Data ware house Environment using SSIS.

. Expertise and Interest include Administration, Database Design,

Performance Analysis, and Production Support for Large (VLDB) and

Complex Databases up to 2.5 TB.

. Expertise in SQL Server Analysis Services.

. Hands on creating, Deploying and supporting in OLAP Cubes

. Managed VERITAS net backups and Litespeed backups.

. To analyze long running queries and tune the same to optimize

application and system performance.

. Maintaining the database consistency with DBCC at regular intervals.

. Involved in creating and supporting in OLAP Cubes Involved in

development activities included hardware and network specification,

installation and configuration, and participation in database design,

architecture and SQL scripting.

Fidelity

(Jan 2009

to Dec 2010)

SR SQL Developer / SQL Server DBA

Fidelity Investments is among the most diversified financial services

companies in the world, offering a full range of product solutions.

. Setting Active-Passive, Active-Active Cluster and DB Mirroring

environment as a High availability solution.

. Installed SQL 2008 on stand-alone machines

. Created Transactional & Snapshot Replication as a High availability.

. Used Policy Based Administration feature (SQL Server 2008).

. Created Table Valued Parameters (SQL Server 2008) of a table value

data type and be able to pass this variable into a stored procedure.

. Created new database objects like Tables, Procedures, Functions,

Indexes and Views using T-SQL in Development and Production

environments.

. Used DTSXchange tool for migrating DTS packages to SSIS

. Performing Backup/Restore to/from Legato server (Tape) and Disk

. Designed the functional and technical documents, report templates and

reporting standards for the developers to work on the report

development

. Created complex stored Procedures, Triggers, Cursors, Tables and other

SQL Joins and Statements for Applications by using T-SQL.

. Expert in Performance Tuning of the Stored Procedures.

. Checking Database Health by using DBCC Commands and DMV'S

. Monitored and modified Performance using execution plans and Index

tuning.

. Experience in Database security and integrity planning

. Prepared Documentation for the Disaster Recovery plan

. Designed Data Integrator jobs with Error Handling and email

notifications.

. Managing Databases spread across multiple servers in Production,

Development, staging & testing environments.

. Generated periodic reports based on the statistical analysis of the

data using SQL Server Reporting Services (SSRS).

. Daily routine DBA tasks like handling user's permissions and space

issues on Production and Semi-Production Servers and handling

maintenance Jobs.

. Handled monthly Database Refresh in QA-Test environment for testing of

new Deployments and Build.

. Routine DBA jobs like Backups and Restores

. Good experience in data modeling and metadata services.

GE Money (London, UK)

(Aug 2006 to Jan 2009)

SQL Server DBA

General Electric Money is one of the Home Lending bank which helps the

customer by providing the mortgage loans.

. Installation, configuration of MS SQL Server 2000, 2005 for

development and testing purpose.

. Migration of SQL server 2000 to SQL server 2005 and monitoring and

solving the issues after migration.

. Setup, configure and monitoring Transaction Replication, snapshot

Replication on remote servers.

. Created and monitored database maintenance plans for checking database

integrity

. Creating databases, logins and Assign permission to user(s), role(s),

and object. Support column level permission. Administrate security for

server's logins (Windows and SQL Accounts).

. Responsible for database backups & restoration and scheduling backup

strategies.

. Implemented Disaster Recovery Plan using Log shipping, Mirroring and

Replication.

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

databases.

. Planning, implementing and troubleshooting Snapshot and Transaction

Replication.

. Prepared Estimates for Database, table size growth.

. Responsible to bring the awareness of the importance and techniques

involved in DB tuning and Performance, to the developers.

. Implemented Transactional Replication for Real time Reports (Database

Server as Publisher and Reporting Server as Subscriber).

. Expertise in Security Issues such as creation and granting permissions

on various Objects.

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

. Performance tuning, finding the CPU Bottlenecks, SQL Server

Bottlenecks.

. Performance tuning in Database level, T-SQL level and operating system

level.

. Upgraded all the servers from 2000/2005. Proactively involved in SQL

Server Performance tuning at Database level, T-SQL level and operating

system level. Maintained database response times, proactively

generated performance reports. Automating most of the DBA Tasks and

monitoring stats.

. Responsible for SQL server Edition upgrades and SQL Server patch

management.

. Supporting the business 24*7, maintaining 99.999 uptimes, depending on

the application and business SLA requirements.

. Trouble shooting and supporting all user problems by using SQL server

profiler and network traces, windows logs etc.

Contact this candidate