Sql Server DBA / Architect

Kanthi K Gadde

Email: ******.*****@*****.***

Phone: 347-***-****

Summary:

. 9+ years of experience in System Analysis, Design and Development of

complex software systems in IT, Health and Finance environments.

. Experienced in managing 400 + servers across a variety of operating

systems at Verizon Content Management Datacenter.

. Hands on experience in Installing, Configuring, Managing, Monitoring

and troubleshooting SQL Server 2005/2008/2012.

. Expert in SQL Server Administration skills using various backup

recovery models (simple, Bulk and full), database maintenance plan,

user (NT/SQL) security authorizations, Database creation, Tables,

indexes.

. Experienced in high availability systems, including Windows/SQL

clustering, database mirroring, Always ON, log shipping, and

replication.

. Expert in Extraction, Transforming and Loading (ETL) data flows using

SSIS; creating mappings/workflows to extract data from SQL Server and

Flat File sources and load into various Business Entities.

. Upgraded existing Windows servers to Windows server 2008 and Windows

server 2012.

. Expert in designing, creating and deploying reports using SQL Server

Reporting Services.

. Hands on experience in creating, deploying and automating report

delivery in SQL Server Reporting Services (SSRS) using SQL Server

Integration Services.

. Experience in data, metadata management and Business Intelligence (BI)

solutions using Microsoft SQL Server 2008 Integration Services (SSIS).

. Expert in Oracle 9i/10g/11g logical and physical databases design,

implementation, and maintenance.

. Experienced in working with VMware, Linux/Unix, Shell Scripts and

Cloud Computing technologies.

. Strong Experience in ETL Package design, such as Creation and

Modification of DTS& SSIS packages as per the business requirements.

. Experience in developing SSIS packages using C#.NET 2.0/3.0, VB.NET,

ASP.NET 2.0/3.0 and .NET Framework 2.0/3.0/3.5.

. Experienced in managing windows DNS servers and UNIX based Isilon

storage clusters in DMZ and non DMZ zones.

. Experienced in managing file transfers between Verizon and VOD content

providers in the Verizon Content Management Center.

. Hands of experience in managing Windows Active Directory within the

local Domain.

. Hands on experience in managing development and test environments.

. My core activities include: Plan, design, and create databases and

implement database objects, such as stored procedures and views,

triggers, cursors etc.

. I have strong analytical, customer and problem solving skills.

. I enjoy working with diverse teams focused on making information a

strategic asset.

Experience:

VERIZON Communications Inc

SQL Server DBA/Analyst

1880 Campus Commons Drive, Reston, VA

2008 - Present

. Implementing functions, installing, configuring and supporting SQL

Server based database systems.

. Design ETL Packages with the new SSIS Integration Services to migrate

data from a variety of systems such as Oracle, SQL Server and Text

Feeds etc.

. Upgraded existing Windows server to Windows server 2008 and Windows

server 2012.

. Creating and automating Ad-hoc reports using SSRS.

. Troubleshooting and managing high availability clusters without

customer impact.

. Migrated data from different sources (text based files, Excel

spreadsheets, and Access) to SQL Server databases using SQL Server

Integration Services (SSIS).

. Extracted data from Oracle and migrated into SQL Server 2005 using

SSIS.

. Built and implemented standard testing procedures for optimizing

system performance.

. Designed and drafted requirements for automated solutions to improve

performance and accuracy.

. Reviewed and developed data models and database designs with

development teams.

. Write scripts to improve access request processing, and reduce

security threats

. Create automated processes to backup servers and files systems on a

daily basis.

. Designed error reporting mechanisms for UN foreseen errors.

. Managed DNS server including new servers and users on the domains.

. Performed DBA functions, installing, configuring and supporting

database

. Create, evaluate, build, launch, and test new systems

. Coordinate customer problem resolutions on priority basis

. Designed and drafted requirements for automated solutions to improve

performance and accuracy.

. Configure, administer, monitor, and debug window-based servers.

. Identified and recommended emerging technologies to meet business

needs

. Maintain complete and accurate documentation of IT operations

. Perform database analysis and design, and enhance system resources

. Written stored procedures and scripts to automate solutions in SQL

Server 2008 and 2012.

. Created packages for complex work flows using SQL server Integration

services.

. Designed and automated reports in SQL Server 2012.

. Had worked on development project using VB.NET, ASP.NET, VB, ASP etc.

Environment: SQL Server 2005/2008, VB, ASP .Net, VB Script, SSIS, EMC

Isilon Storage Systems.

[pic]

Indbazaar, India

Software Engineer (2004- 2006)

Responsibilities:

. Involved in planning & design.

. Involved in the development of various forms and components using ASP

and VB.

. Developed calendar control using Java Script.

. Coding, debugging and testing of the application.

. Checking the validity of links.

. Used ODBC connectivity for fetching the data from the backend

database.

. Created SQL stored procedures and views in SQL Server database, and

developed various data collection and manipulation routines.

. Involved in Documentation of Projects.

Environment: Visual Interdev, ASP, VB, Oracle, IIS 5.0, Dreamweaver 3.0,

SQL Server 2005/2000, VB, ASP .Net, VB Script, SSIS.

Educational Qualifications

. Master's degree (MS) in Computer Science from University of Northern

Virginia, 2008.

Contact this candidate