Sql Server Manager
Resume:
Name: Suresh Kumar [pic][pic]
Contact: 716-***-****
Email: ******.*****@*****.***
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