VIJAY METTUKURU

SQL Server DBA

EMail: acfae9@r.postjobfree.com PH: 304-***-****

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,2008R2,2012; updating

with hot fix and service packs

. Strong understanding of RDBMS concepts as well as Data Modeling Concepts.

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

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

on call production support.

. Implemented Inplace and Side by Side Migration of MS SQL SERVER 2000/2005

to 2008.

. Experience with Microsoft SQL Server Integration Services or any

comparable ETL tool and Reporting tool with SQL Server Reporting Services

using Business Intelligence Development Studio (BIDS)

. Experienced in budgeting and licensing. Knowledge of Remedy

Administration

. Expert in developing T-SQL (DDL, DML, DCL) statements.

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

Migration Wizard.

. Good at SQL Server 2008 new features like Policy Based Management, Data

Compression, Resource Governor, Performance Data Collector and

Transparent Data Encryption (TDE).

. Experience in using the DMVS, DMFS, SP_PROCS, INFORMATION_SCHEMA, SYSTEM

VIEWS and in-built GLOBAL VARIABLES for the instant analysis.

. Good experience on tools like Microsoft SCOM, BMC Remedy ITSM tool, SQL

Litespeed and Precise.

. Expert in Data Integrity, Performance Tuning, Query Optimization

. Expert level skills in Objects creation such as Table, Normalization,

Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and

query writing.

. Expert in creating Views.

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

Data Sources.

.

. Worked with a team of business analysts, data architects, application

developers, ETL developers and testers. My objective was to deliver

projects within scope, time and costs while following department

standards, methodologies and guidelines.

. Experience in using SSIS tools like Import and Export Wizard, Package

Installation, and SSIS Package Designer.

. Experience in building SSIS packages (.dtsx) involving ETL process,

extracting data from various flat files, Excel files, legacy systems and

loading into SQL server.

. Experience in creating deployment utility to deploy SSIS packages over

Production, QA and Local System.

. Expert in creating SQL Server Reports using SSRS 2008.

. Have good knowledge on Always on new features.

. Extensive experience in the development of Reports using SQL Server

2000/2005 Reporting Services (SSRS) and Microsoft Access and developed

Custom Report and different types of Tabular Reports, Matrix Reports, and

drilldown reports in multiple formats using multi - dimensional objects.

. Strong ability in Scheduling and deploying reports on Report manger.

. Experience working with change control process

. Expert in using Ms Office suite 2007 including Ms Access.

. Knowledge in JAVA, VB.net, C#.

. Strong analytical, logical, Communication and problem solving skills and

ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Languages T-SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, Java

Script

Operating Windows 2000/2003/2008/2012/2012R2/XP/VISTA/7, UNIX

Systems (Sun Solar), LINUX

Databases MS-SQL Server 6.5/7.0/2000/2005/2008,2012 MS Access,

Oracle 9i/10g.

ETL Tools Data Transformation Services, SSIS

Reporting Tools SSRS, SSAS

DB Utilities SQL Server Management Utility, Query Analyzer

Application Visual Studio 2005/2008, Visual Source Safe, TFS, MS

Software Office Suite

Third party Erwin, Visio, Red gate, Lite Speed,Remedy ITSM

Tools

PROFESSIONAL EXPERIENCE:

Project #1 : Coca-Cola, Atlanta

Role : SQL Server DBA

Duration : December 2012 to till date

Project Description: The Coca-Cola Company is the world's largest beverage

company, refreshing consumers with more than 500 sparkling and still

brands. The company's portfolio features 15 billion dollar brands. Together

with the bottling partners, company rank among the world's top 10 private

employers with more than 700,000 system employees.

Environment: Microsoft Windows 2008/2012/2012(R2) Server, Microsoft SQL

Server 2008 (R2)/2012, Microsoft SQL Server 2005, Windows 2003/2008 Server,

IIS Server 7,Hyper MS Visual Source Safe, IIS 6.0, XML.

Responsibilities:

. Installation and Maintenance of SQL Server 2005/2008(R2) on Test,

Development and Production Environments.

. Create and manage databases across Development and Production

instances using SQL Server Management Studio.

. Usage of new compression Techniques in SQL Server 2005/2008(R2)/2012

for backup and restore jobs.

. Involved in various Disaster Recovery and High Availability techniques

such as Log Shipping, Database Mirroring, Replication, Clustering, and

Always On High Availability.

. Experience working with TSM Backups and Restore.

. Manage and Administer SQL server 2012 on VMware environment.

. Implementation and management of operating systems (Windows), and

virtualization (VMware/HyperV)

. Transactional Replication with Multiple publishers and centralized

subscriber.

. Deployment of Replication and mirroring in both Test and Production

environments

. Disaster Recovery Planning, Testing and analyzing and continuous

update of documentation.

. Implemented Database Mirroring and Transactional Replication as a part

of DR plan.

. Developed, configured, and support to new incident, problem, and

change functionality within ITSM based on agreed business requirements

. Creating Logins and Roles with appropriate permissions.

. Creating and Maintaining Database Maintenance Plans.

. Configured Database Mail for failure Job notifications

. Modify Stored Procedures and complex T-SQL Queries to improve query

execution process.

. Write T-SQL Scripts for database backup jobs and daily/weekly jobs.

. Tune slow running queries using SQL Server Profiler

. Transferred data from Oracle to SQL server using SSIS.

. Worked with database tuning advisor, SQL server profiler, Performance

monitor and activity monitor for Performance tuning

.

Software and hardware related errors.

. Avoiding

. Mentored team members to optimize SQL Queries.

Project #2 : Georgia Dept. of Transportation GA

Role : SQL Server DBA

Duration : January 2010 to November 2012

Project Description: The Georgia Department of Transportation (Georgia

DOT) consists of approximately 4,300 employees. Georgia DOT plans,

constructs and maintains Georgia's state and federal highways. We're

involved in bridge, waterway, public transit, rail, general aviation, bike

and pedestrian programs. And we help local governments maintain their

roads.

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

server, IIS Server 5.0, SSIS, Reporting Services, XML.

Responsibilities:

. Installed and configured SQL Server 2005/2008 on the server and client

machines, provide connections and manage databases.

. Create and maintain various databases for Production, Development

Servers using MS SQL Server 2005/2008.

. Planning the location of data, indexes, and Transaction log files on

the disk.

. Use of DBCC Utilities to maintain the consistency and integrity of

each database in the production server.

. Implemented high availability solutions for mission critical SQL

Server databases with Clustering and Mirroring.

. Implementing new features of SQL 2012 like Always on, Column Stored

Indexes & Contained Databases in newly migrated servers.

. Conducted root cause analysis of application availability and narrow

down the issues related to coding practices, database bottlenecks, or

network latency.

. Resolve locking and blocking issues.

. Experience in memory configuration for SQL server on 32-bit boxes

. Provided break-fix support for forms & workflow within ITSM.

. Tuning the Production server to get the performance improvement.

. Running Index tuning wizard for optimal query performance.

. Implemented Database Mirroring/Transactional Replication as a part of

high availability and disaster recovery

. Periodically involved in executing ETL process on Oracle databases.

. Reviewed third party tools to automate routine tasks such as

monitoring, blocking and consolidate status of scheduled jobs.

. Experience working with IDERA in Server Monitoring for Performance

Monitoring, Dead Lock, Blocking.

. Converted Postgre SQL Database to SQL Server, wrote DTS Packages to

load Database

. Monitoring SQL Server LOGS, Application logs and analyzing the logs.

. Providing 24*7 support to SQL application developers in implementing

the applications on production server.

. Reorganizing or Rebuilding Indexes based on the Index fragmentation

. Maintaining both DEVELOPMENT and PRODUCTION Servers in sync.

. Implementation of SQL Logins, Roles and Authentication Modes as a part

of Security Policies for various categories of users.

. Creating Backup strategies and scheduling them as a part of database

maintenance plans.

. Created the SSIS packages for executing the required tasks. Created

the Jobs and scheduled for daily running.

. Involved in Performance Tuning for source databases, target databases

Project #3 : Molina Health Care, Long Beach, CA

Role : SQL Server DBA

Duration : January 2008 to December 2009

Project Description: Molina Healthcare provides quality healthcare for

financially vulnerable individuals and families. Molina Healthcare arranges

for the delivery of healthcare services or offers health information

management solutions for nearly 4.3 million individuals and families who

receive their care through Medicaid, Medicare and other government funded

programs in 16 states.

Environment: TSQL, MS SQL SERVER 2000/2005/2008, SSRS, QUERY

ANALYSER,HIPAA, VISUAL STUDIO 2005, IIS Server 5.0, VB.NET, C#, WINOWS

SERVER 2003/2008, SSAS.

Responsibilities:

. Worked on Client/Server tools like SQL Server Management studio

(2005)/ (2008), SQL Server Enterprise Manager (2000) and Query

Analyzer to Administer SQL Server.

. Migrated SQL server 2000 databases into SQL server 2005 and SQL server

2005 databases into SQL server 2008 databases by In-place upgrade

process and also used upgrade advisor tool in up-gradation.

. Setting up and Monitored transactional replication, Database mirroring

on Production, QA and Development servers.

. Migrated DTS packages into SSIS packages.

. Handled up to 2 TB Size databases with clustered and stand alone

environment

. Configured Transactional replication on migrated server.

. Wrote the packages using SSIS in SQL2005.

. Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards

according to the business requirement.

. Performed Logical and Physical Data Modeling for the Warehouse.

. Extensively worked on Dynamic Management Views (DMV's) and Dynamic

Management Functions (DMF's).

. Successfully installed SQL servers 2008 on cluster server.

. Developed, deployed and monitored SSIS Packages including upgrading

DTS to SSIS.

. Integrated SQL traces with Perfmon log to have better graphical

analysis to find system bottlenecks.

. Implementation of SQL Principle, Securable, Permission, Roles and

Authentication Modes as a part of Security Policies for various

categories of users.

. Maintaining SQL Script for creation of Database Objects using VSS

(Visual Source Safe).

. Created Database Maintenance Planner for the Performance of SQL Server

which covers Database Integrity Checks.

. Planned the Complete Backing up of Database and Restoring the Database

from Disaster Recovery.

. Used DTS packages to move logins and jobs from one server to another

server.

. Used log shipping for synchronization of database.

. Good experience in data modeling and metadata services.

. Monitoring SQL server performance using profiler to find performance

and deadlocks.

. Created Stored Procedures, Triggers, Views and Functions for the

Application.

. Extensive testing on the Performance of the Stored Procedures.

Project #4 : Bay View Financial Trading Group, FL

Role : MS SQL Server Developer/DBA

Duration : September 2006 to November 2007

Project Description: Bay View Financial Trading Group offers commercial

real estate loans to real estate investors, mortgage companies, and

brokers. It sources business through a wide network of thousands of

financial institutions, mortgage companies, third-party brokers and

advisors throughout the country.

Environment: MS SQL Server 2000/2005, IIS Server 5.0, Windows 2000/2003

servers, Outlook Express, .NET, MS Access.

Responsibilities:

. Installing and configuring and tuning and providing 24X7 support for SQL

Server 2000 and 2005 in development and production environments.

. Created and scheduled jobs to setup log shipping between production

servers.

. Implemented Database Mirroring on the SQL Server 2005 production

databases.

. Job Monitoring and making sure all jobs run successfully every night.

. Creating databases and logins with permissions in SQL Server 2005 as per

the developer's request.

. Worked extensively on SQL Server Reporting Services to generate reports.

. Created Linked Servers between SQL server 2000 and 2005 servers.

. Involved in Migration from SQL Server 2000 to 2005.

. Created Database Diagrams using ERWin Data Modeler.

. Performed Logical and Physical Data Modeling for the Warehouse.

. Developing stored procedures, triggers, views and adding/changing tables

for data load and transformation and data extraction.

. Migrated and tested DTS packages to SQL Server 2005 Integration Services.

. Created Database Maintenance Plans for the Performance of SQL Server,

which covers Database Integrity Checks, Update Database Statistics and Re-

indexing.

. Involved in the creation of cubes in the MS SQL Analysis Services.

. Restore Development and Staging databases from production backups as per

the requirement.

. Extensively used SSIS to move data from text files to SQL Server.

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

. Extensively used Database Performance Monitoring tools for performance

tuning.

. Designed and implemented database maintenance plan.

. Used Index tuning wizard and rebuilding indexes for faster Query

Performance.

. Involved in resolving dead lock issues and performance issues.

Project #5 : Navayuga InfoTech, Hyderabad, India

Role : SQL Server Developer

Duration : August 2005 to August 2006

Project Description: NIT is a full-service IT global outsourcing company.

It is our goal to ensure that our clients receive the multiple benefits of

world-class infrastructure, deep domain knowledge and streamlined processes

combined with speed of design and implementation at the best cost.

Environment: MS SQL Server 2000/2003, Excel, Query Analyzer windows NT/2000

server & Professional

Responsibilities:

. Installation and configuration of MS SQL Server 2003/2000/7.0

. Created Stored Procedures, User defined functions, Views and Wrote T-

SQL codes maintaining query standards for the project.

. Created ER diagrams

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

involving multiple tables, added Columns, triggers and configured IIS

and Worked on Index tuning, stored Procedure tuning.

. Involved in Optimization and normalization of database and tables.

. Involved in conceptual and physical modeling of data using ERWin tool.

. Developed stored procedures, triggers and functions and added/changed

tables for data extraction and transformation, and data loading (ETL).

. Part of team for analyzing and implementing the physical design for

database.

.

Contact this candidate