Name: Suresh Kumar [pic][pic]

Contact: 716-***-****

Email: acf7nr@r.postjobfree.com

Lead MS SQL Server DBA - Oracle DBA

Summary

A certified IT professional with over 9 years' experience in various

technologies such as databases and it systems. Worked in various domains

such as healthcare, finance, auditing (SOX, PII, HIPAA & PCI databases),

media/entertainment applications and oil & gas.

. Experience in 24x7 production support and worked on On-call

escalations.

. Experience working in SQL Azure databases.

. Experience in RDBMS database design, performance tuning, optimization,

Profiler, backup and recovery in SQL Server 2000/ 2005/2008/2008 R2,

2012 & 2014.

. Solid experience in 3rd party Tools IDERA (SQL Diagnostic Manager, SQL

Safe & SQL Secure), Light Speed, Foglight, Double Take, Cyber-Arc and

Service Now.

. Experience with different databases like Oracle 10g, 11g, 12c in

multiple OS environments like Windows, UNIX, Linux, AIX, Oracle

Solaris and VMware Environments.

. Performing Cloning and Refresh Oracle databases.

. Acted as a SQL Server implementation consultant, administration,

management and maintenance, SQL Server installation, Migrations & up

gradations including high-availability cluster configurations on

Windows cluster (2003, 2008 & 2012) and SQL server cluster.

. Extensive experience creating and maintaining SQL Server objects.

Database monitoring and optimization.

. Expertise in implementing Oracle Data guard.

. Developed and supported ETL processes using DTS, SSIS, or Microsoft

.NET programming using SQL Server Management Studio, ETL process using

tools like BULK_INSERT and BCP.

. Experience handling databases in large scale environments with max

size 2 TB.

. Exposure on Logical Backup and Physical Backup schedules using

Import/Export, Data pump and RMAN.

. Extensive experience in implementing logical model into Physical SQL

Server Database and creating SQL table and triggers using scripts.

. Good knowledge in Client and Oracle Database Up gradation and CPU

Patching.

. Experience in Replication, Mirroring and log shipping between

different Servers from different sites on different versions SQL

2005/2008/2008 R2/2012 and Configured Database disaster setups.

. Experience in implementing and managing the security of SQL database

environment (access/authentications), Roles and user permissions.

. Designed database capacity planning and Management.

. Good experience on HP Service Manager, HP Support Central & BMC

Remedy.

. Configured Monitoring using SQL Diagnostic Manager, Tivoli, HP OVO and

Oracle Enterprise Manager (OEM) and SCOM.

. Skilled in stored procedures, User Defined Functions, triggers, views,

Full Text Search Catalogs and Strong Performance monitoring, logs

reading, index tuning and troubleshooting skills.

. Fine/performance tuning SQL Queries and Stored Procedures using Data

Tuning Advisor (DTA) and worked on optimization of the stored

procedures and created indexes on the required tables. Created

distributed partition views, indexed views.

. Experience in linked servers setup to run distributed queries and

transactions between SQL servers and from different RDBMS databases.

. Experience in using Data Transformation Services (DTS) and SSIS to

import data from many different platforms to SQL Server.

. Worked with SQL Server 2005 and SQL Server 2008 SSRS and created

various reports using SQL Server reporting service (SSRS) and created

cubes using SQL Server 2005 analysis service (SSAS).

. Experience in Troubleshooting Techniques and Resolving Issues On

Standalone, MS Clusters and HP Poly Serv.

. Monitoring SQL server Agent jobs and responding to SQL server

notifications.

. Comprehensive knowledge in providing suggestions of using best RAID &

V-Blocks Technologies based on application requirement.

. Thorough understanding of the Requirements, Suggesting Change

Requests (CRs) & Enhancements.

. Expertise in various MS SQL High Availability technologies like

AlwaysOn, Replication, Log Shipping, Failover Clustering including

when to use one method over another, limitations, and alternatives.

. Build database tools and scripts to automate where possible.

. Experience in Documentation.

. Work with the various Engineering groups and ensure database changes

are in-line with operational standards and meet the strategies needed

to scale while maintaining a scalable, reliable, and robust database

environment.

. Flexible, enthusiastic and project oriented team player with solid

communication and leadership skills to develop creative solution for

challenging client needs.

Technical Skill Set

Database(s) MS SQL Server 2000/2005/2008/2008R2, 2012 and 2014, Oracle

10g & Oracle 11g.

Database Tools SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS (Data

transformation Service) tools, ISQL, Backup Server,

Replication server, SQL Agents, SQL Alerts, SQL Jobs,

T-SQL, SQL Client Configuration utility, Oracle Data Guard,

SSIS, SSRS, IIS 6.0.

Operating Systems Windows 2012/2008/2003/2000 server, Windows NT and XP,

Windows 95/98.

Languages T-SQL, C++, .Net, HTML.

Reporting Tools MS Excel, SQL Server Reporting Services, OSQL Scripts.

Other Tools SQL Diagnostic Manager, SQL Safe, SQL Secure, Cyber-Arc, HP

polyserv, Foglight, Service Now, Windows Cluster and Visual

Source Safe (VSS).

Professional experiences

Client: Disney Park & Resorts, Orlando, FL

Role: Technical Lead

Team Size 18

Period Jan'14 to till date

Operating Systems Windows 2012/2008/2003

Databases MS SQL Server 2000/2005/2008, and 2012

Tools & Techniques SQL Profiler, SQL Query Analyser, Index Analyser,

ISQL, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs,

T-SQL, SQL Client Configuration utility, HP Open View(HP OVO), Tivoli 5.6,

Oracle Enterprise Manager (OEM), HP Service Manager, SSIS and VERITAS

Cluster.

Project Description

WDPR is a leading diversified international family entertainment and media

enterprise. DWS (Disney Worldwide Services, Inc.) is the IT Services

Sourcing Division of The Walt Disney Company, a $38 Billion Global Media

and entertainment organization which consists a major Business Segment,

Walt Disney Parks and Resorts. WDPR Segment is comprised of several

individual business applications fast pass, Disney Cruise line, Disney

Reservations and dining etc., all the applications are manage their own IT

environments and supporting 24 X 7 DBA Support for QA, Pre Production and

Production.

Roles & Responsibilities:

. Was always available for production support (24/7 On-Call).

. Played a key role in database (DB Size 2 TB) administration for WDPR.

. Implemented Mirroring for Walt Disney Parks & Resorts critical

systems.

. Managed 3000 servers and database instances, monitor server

performance, fine tune database server and applications, and perform

backup and recovery by using SQL Native.

. Resolve SQL Server performance issues and experienced in query

optimization, index tuning.

. Configured monitoring for WDPR segment servers under Oracle Enterprise

Management (OEM).

. Performed day to day Database Maintenance tasks, Backups, Space

Management, Rebuild Statistics for all production database Servers.

. Configured SQL instances under Tivoli, Foglight & HP OVO monitoring.

. Utilized OSQL script for Automatic backup report for Production

databases.

. Document database environment and kept in document repository.

. Installed and Configured SQL Server 2005, 2008, 2008 R2 and 2012

versions on MS Clusters.

. Experience in Agile (Scrum) SDLC methodologies.

. Applied SQL patches on MS Cluster SQL Instances and Mirrored

databases.

. Taking database backups and recovery using RMAN on Oracle databases.

. Database Cloning from Production to QA and DEV Environments on Oracle

databases.

. Installation/Up gradation of Database and Client Software Configured

Database Mirroring & Log shipping for DR & reporting purpose.

. Established Transactional replication between Orlando to China

Databases.

. Implemented Minimum Security Base lines on PCI & PII data base

instances and Configured SPN's for service accounts.

. Implemented AlwaysOn for WDPR segment servers.

. Experience with SharePoint as a repository.

. Upgraded SQL server license on CAL based system and used V-Block

technologies for database restore.

Client: Disney Technologies Shared Services (DTSS), Anaheim,

CA

Role: Senior Technical Specialist

Team Size 9

Period May'12 to Dec 13

Operating Systems Windows 2012/2008/2003

Databases MS SQL Server 2000/2005/2008, and 2012

Tools & Techniques SQL Profiler, SQL Query Analyser, Index Analyser,

ISQL, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs,

T-SQL, SQL Client Configuration utility, HP Open View(HP OVO),HP Service

Snow, and VERITAS Cluster.

Project Description

Walt Disney (DTSS) is a leading diversified international family

entertainment and media enterprise. DWS (Disney Worldwide Services, Inc.)

is the IT Services Sourcing Division of The Walt Disney Company, a $38

Billion Global Media and entertainment organization which consists of 4

major Business Segments; Corporate, Walt Disney Studios, Disney Consumer

Products and Disney ABC television group. Each Business Segment is

comprised of several individual business units, all of whom have the

ability to use DWS services (provided by vendors to DWS) or manage their

own IT environments.

Walt Disney is a large concern involving higher efficient business

transactions annually and Walt Disney is supporting 24 X 7 DBA Support for

Development, Staging, QA and Production Support.

Roles & Responsibilities:

. 24/7 On-Call and administered File service management services large

databases.

. Supported 1500 servers from different GEO's and configured Mirroring

and Transactional Replication as part of Disaster recovery procedure.

. HP Open View is used for Data base monitoring and alerting system.

. Implemented Oracle Data Guard for Production databases.

. Performed day to day Database Maintenance tasks, Backups, Space

Management, Rebuild Statistics for all production database Servers.

. Installed SQL Server 2008, 2008 R2 and SQL Server 2012 on MS cluster

for Active-Active and Active-Passive environment.

. Experience with SharePoint as a repository services.

. Developed OSQL script for Disk free space report for Critical systems

and it will send email to customers.

. As per vulnerability management applied SQL Patches on Standalone and

MS Cluster servers.

. Configured SPN's for service accounts as per MSB controls from

compliance and experienced on Kerberos Configuration.

. Document database environment.

. Used Double Take for disk level mirroring in Disney Media segment.

Client: GE Health Care, Milwaukee, WI

Role: Technical associate

Team Size 12

Period Mar'10 to May 12

Operating Systems Windows servers 2008/2003/2000

Databases MS SQL Server 2000/2005 / 2008 and 2008 R2

Tools & Techniques SQL Profiler, SQL Query Analyser, DTA, OSQL, CMS (

Central Management Service), Replication server, SQL Agents, SQL Alerts,

SQL Jobs, T-SQL, SQL Diagnostic manager ( SQL DM),SQL Safe, SQL Secure,

Cyber-Arc, HP Support Central

Project Description

GE HealthCare is Billion Dollar Company with different business segments in

Diagnostic Image, Clinical Systems and Life Sciences. It is World's largest

leading medical systems sales and service provider and is the market leader

with unmatched distribution and service reach in Asia, Europe and America

poles.

GE Healthcare is a large concern involving higher efficient business

transactions annually. The databases systems are of highly efficient and

involve numerous transactions at any hours of a day. GE HealthCare is

supporting 24 X 7 DBA Support for Development, Staging Production Support.

Roles & Responsibilities:

. Implemented Mirroring for GE HealthCare critical systems from one Pole

to another pole.

. Configured Transactional Replication between Milwaukee to China.

. Administered a 1.2 TB of database for GE HealthCare and was available

24/7 On-Call Production support. Also Managed 2500 servers from

different poles.

. Troubleshoot SQL Server service outages as they occur, including after-

hours.

. Managed database instances, monitor server performance using SQL DM,

fine tune database server and applications, and perform backup and

recovery by using SQL Safe - IDERA tools.

. Performed day to day Database Maintenance tasks, Backups, Space

Management, Rebuild Statistics for all production database Servers.

. Performing Cloning and Refresh on Oracle databases.

. Documented database environment and Experience in Agile (Scrum) SDLC

methodologies.

. Scheduled backups and performed restore operations for system test

data depends on Change Requests/ Workflow Requests. Configured Linked

servers for Cross platform (Oracle & DB2 databases).

. Established logins and maintained user permissions appropriately.

Implemented Minimal Security Base line controls on PCI data bases

instances and setting up Kerberos.

. Migrated machine critical databases in less span of down time using

database Mirroring.

. Worked on increase performance including hardware purchases, server

configuration changes.

. Migrated Oracle databases to SQL Database using SSMA.

. Developed Stored Procedures, views and full text indexes and fine

tuned database queries with the help of Database Tuning Advisor (DTA).

Client: GE Energy (Oil & Gas), Fairfield, CT

Role: Technical Specialist

Team Size 9

Period Sep 09 to Mar 10

Operating Systems Windows servers 2008/2003/2000

Databases MS SQL Server 2000/2005 / 2008 and 2008 R2

Tools & Techniques SQL Profiler, SQL Query Analyser, DTA, DTS (Data

transformation Service) tools, OSQL, CMS ( Central Management Service),

Disaster Recovery setups, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, SQL

Diagnostic manager ( SQL DM), SQL Safe, SQL Secure, Cyber-Arc, HP Support

Central

Project Description

GE Oil and Gas is a division of GE Energy. GE oil and Gas is having

different kind of divisions like Industrial power Solutions, Gas storage

pipeline, Subsea solutions and Petrochemicals.

Industrial Power Solutions is the biggest revenue division and

critical systems we have in this division. Industrial power solutions are

involving in critical database transactions. GE is going to provide Power

systems by storing the data in to databases and relating to the databases

with machines, and rest of the divisions are inter linked with oil and gas

products and all the segments support is 24x7 for all the environments.

Roles & Responsibilities:

. 24/7 On-Call Production support and managed 1500 servers from

different poles.

. Administered Max size of database for GE Oil & Gas.

. Implemented Log shipping & mirroring for critical systems by

considering risk management disaster recovery plan and Configured

Transactional Replication between different data centers.

. Managed database instances, monitor server performance, fine tune

database server and applications, Index fine tuning, and perform

backup and recovery by using SQL Safe - IDERA tool, Light speed.

. Performed day to day Database Maintenance tasks, Backups, Space

Management, Rebuild Statistics for all production database Servers and

configured agent alerts when job fails.

. Scheduled backups and performed restore operations for system test

data depends on RFC's.

. Configured Linked servers & Network aliases and created logins and

maintained user permissions appropriately and implemented MSB's

practices tightly aligning with Security controls and implemented

Minimal Security Base on PCI data bases instances.

. Data base refreshing to development environments.

. Migrated databases from one version to another version and applied

security patches as per vulnerability management process.

. Developed Stored Procedures, views and Cursors as per business

requirements and reviewed Performance Tuning with the help of DTA.

. Documented database environment and RCA for Priority 1 & Priority 2

tickets on database outages.

Client: WOWzzy Inc, Sacramento, CA

Role: Technical Specialist

Team Size 10

Period Feb'09 to Sep 09

Operating Systems Windows servers 2008/2003/2000

Databases MS SQL Server 2000/2005 / 2008

Tools & Techniques SQL Profiler, SQL Query Analyzer, DTA, DTS (Data

transformation Service) tools, OSQL, CMS (Central Management Service),

Replication server, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, SQL Diagnostic

manager ( SQL DM), BMC remedy, SSIS and SSRS.

Project Description

WOWzzy.com has been designed to be used by both the business owner and the

consumer. Business Members: WOWzzy has been created for any business person

regardless of size or kind of product or service. The WOWzzy marketing

tools and the web presence for the Business Member is completely

customizable for any type of business. The WOWzzy Member Website can

function as a primary site or be linked to the member's other websites. By

linking to other sites the search engine optimization feature of WOWzzy

affects all the linked sites. The purpose of the website is to help the

local business owners to create their business profile and communicate with

consumers with business tools. Business owners can update their business

information, schedule meetings, adding business affiliates using the

resources available with the website. Consumers can register with this

website.

Roles & Responsibilities:

. 24/7 On-Call Production support.

. Administrate 900GB of database for WOWZZY.

. Implemented Mirroring for WOWZZY.

. Manage 450 servers from different locations and from different GEO's.

. Manage database instances, monitor server performance, fine tune

database server and applications, and perform backup and recovery.

. Extensively used DMV's and configured search mechanism by using Full

text Catalogs.

. Optimized Performance of SQL Queries by using DTA tool and 3rd Party

tools.

. Perform day to day Database Maintenance tasks, Backups, Space

Management, Rebuild Statistics for all production database Servers.

. Maintained Database Documentation.

. Created logins and maintained user permissions appropriately.

. DB refreshing to Production to development environments.

. Performed DBCC checks and fixing data corruption in Application

databases.

. Created network aliases as per business requirements.

. Developed SQL Server database stored procedures and functions to

process business rules and data logic.

Client: CES (California Educational System), Los Angeles,

CA.

Role: SQL Team Member

Team Size 8

Period Feb 08 to Jan -09

Operating Systems Windows servers 2003/2000

Databases MS SQL Server 2000/2005

Tools & Techniques SQL Profiler, SQL Query Analyser, DTS, Replication

server, DMV's, SQL Agents, SQL Alerts & notifications, SQL Jobs, T-SQL, BMC

remedy.

Project Description

CES is an online system for the teachers, Principals. Using this system we

are conducting online assessment exam. Depends on exam result CES will come

to conclusion like what is the status of that teacher or principal. That is

one part. Except this functionality we will maintain all the CES data. The

max data base is almost 900GB. Several applications are access this data

base for schools information which is located in California State. Many

applications are working online by using those data bases.

Roles & Responsibilities:

. Worked on Database Maintenance, Backups and Recovery Plans.

. Monitor SQL Error Logs/ Schedule tasks/data activity/ eliminate

blocking and deadlocks/ user counts and connections/ locks.

. Configured servers under monitoring by using SQL DM.

. Involved in the configuration, implementation and oversight of routine

database maintenance jobs, such as re-indexing and index defrag,

integrity checks, data / log file shrinks.

. Configured Disaster Recovery sites as per plan using Mirroring.

. Configured linked servers between SQL Server databases to DB2

destination.

. Implemented Log shipping for report purpose and as well DR setup.

. Experience in Agile (Scrum) SDLC methodologies.

. Good in Database Documentation.

. Enabled SQL agent service notifications for job failures.

. Installed SQL Server instances on different windows boxes using Split

stream installation.

Client: Aim Reality, Sacramento, CA.

Role: SQL Team Member

Team Size 6

Period Feb 07 to Jan -08

Operating Systems Windows servers 2003/2000

Databases MS SQL Server 2000/2005

Tools & Techniques SQL Profiler, SQL Query Analyser, DTS (Data

transformation Service) tools, Replication server, SQL Agents, SQL Alerts,

SQL Jobs, T-SQL, BMC remedy, HP Support Central

Project Description

Aim Realty Inc. has been providing management services to California state

area property Administrator: This module is to control complete website.

Users can send messages to administrator for any queries regarding website

usage. Owner: This page is for property owners who would like to rent out

their homes using Aim Realty's professional services. "Property Sale" This

website is tailored to help sell your home using tools.

Roles & Responsibilities:

. Maintained 20 servers and created logins, database users and assigning

roles.

. Configured Mirroring and Replication between different sites.

. Plan and implement backup, recovery strategy and used maintenance

plans for the databases.

. Migrated Oracle database to SQL using SQL Server Migration Assistant

(SSMA).

. Developed HTML Web pages and incorporated with .Net pages, configured

Web site under IIS 6.0.

. Maintained and managed documentation for Database environment.

. Written stored procedures and cursors as per business logic.

Client: ClassPedia - India

Role: SQL Team Member

Team Size 8

Period Mar 05 to Feb 07

Operating Systems Windows servers 2003/2000

Databases MS SQL Server 2000 and 2005

Tools & Techniques SQL Profiler, SQL Query Analyser, DTS (Data

transformation Service) tools, CMS ( Central Management Service),

Replication server, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, BMC remedy and

SSRS.

Project Description

ClassPedia Online question bank and examination is a repository of all the

questions from various subjects thought in ClassPedia educational

institutions. This online question bank in turn helps the various

institutions of ClassPedia to access the question for preparing the test

papers for their periodical examinations. This also helps the institutions

to assign homework's and assignments to the students online and review them

periodically.

Roles & Responsibilities:

. Managed Max size databases and Involved in Performance Tuning by using

DTA tool.

. Installed & Configured Database Mirroring between two poles on SQL

Server 2005.

. Troubleshoot SQL Server service outages as they occur, including after-

hours and weekends.

. Experience reading, writing and Debug code written in VB.NET &

C#.Net in a Web Based environment.

. Created regular backups of databases and transaction logs using SQL

Safe- IDERA.

. Configured database monitoring under SQL Diagnostic Manager ( SQL DM).

. Document database environment and pulled out reports by using SSRS.

. Ensured all database servers are backed up properly, and backups are

tested.

Core Competencies, Education & Certifications

. Solution Design & Validation, Requirements Gathering/Analysis.

. Risk Analysis and Management & Capacity Management .

Education:

. Bachelor's in computers.

Certifications:

. Microsoft Certified Technology Specialist (MCTS) in SQL Server.

. ITIL V3 Certified.

Awards & Achievements

As a SQL DBA:

. Awarded as a Best Value Creator and improved CSAT rating, based on

CSAT got more data bases in support.

. Received Best Automated script Developer Award.[pic]

Contact this candidate