Naishal

Senior SQL Server DBA

acok4f@r.postjobfree.com

567-***-****

SUMMARY

. 7+ years of IT experience with more than seven years in Database

Architecture, Administration, System Analysis, Design, Development

and Support of MS SQL Server 2012,2008 R2, also specialize in MS SQL

Server 2005/2000 in Production, Test, Development, Replication and

Cluster Server Environments.

. Experience working with 24x7 Production support and On-Call rotation.

. Extensive knowledge of Relational Database Management Systems.

. Experience in data normalization and de-normalization.

. Knowledge of implementation of System Development Life Cycle (SDLC).

. Experience in working with high transaction OLTP systems in SQL Server

2012/2008 R2/2008/2005/2000.

. Experience in SQL database designing, warehousing, architecture, Data

Modeling using AllFusion Erwin 7.1 and Visio.

. Expert in MS SQL Server installation and configuration.

. Experience in installing Service Packs for SQL Server and OS.

. Experience in capacity planning, performance tuning, disaster

recovery, troubleshooting, backup and restore procedures.

. Expert in installation, upgrade and configuration of 64 bit MS SQL

Server databases in clustered (active/active, active/passive) and non

clustered environments in SQL 2008 R2/2005.

. Expert in Log shipping with SQL Server 2000/2005.

. Expert in implementing SQL Server 2008/2005 Database Mirroring.

. Experience in implementing Snapshot and Transactional replication

models.

. Documented disaster recovery plans and participated in disaster

recovery drills.

. Developed backup and recovery strategies for production environment.

. Experience in SQL Server Integration Services (SSIS).

. Expert in Upgrading SQL Server 2000/2005 to SQL 2005/2008

environments.

. T-SQL coding and testing: indexes, views, triggers, functions,

cursors, stored procedures, etc.

. Experience in Performance Tuning, Query Optimization, Client/Server

Connectivity, Database Consistency Checks using DBCC Utilities.

. Excellent in system tables, DMV's and stored procedures using T-SQL

. Experience in Extracting, Transforming and Loading of Data from Excel,

Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS

Import/Export utility, SQL Server Integration Services (SSIS).

. Expert in T-SQL Server Reporting Services (SSRS), SQL Server Analysis

Services (SSAS), SQL Server Integration Services (SSIS), and Data

Transform Services (DTS).

. Extensive experience in data Extraction Transformation and Loading

(ETL) between homogenous and heterogeneous systems using SQL SSIS

tools, Data Transformation Services (DTS), bulk insert/delete(BCP),

and XML operations.

. Good Knowledge of LiteSpeed, Diagnostic Manager and Log explorer for

MS SQL Server.

. Excellent communication skills.

. Good team player with strong analytical skills.

EDUCATION/CERTIFICATION:

. Bachelor of Engineering, India

TECHNICAL SKILLS:

Windows Server 2008 R2, Windows Server 2003, MS SQL Server 2012,2008

R2/2008/2005/2000, Enterprise Manager, Query Analyzer, DTS, MS SQL SSRS,

SSAS, SSIS, SQL Profiler, ASP.Net 2.0, SQL, PL/SQL, Visual Studio

2008/2005, T-SQL, ERWIN, Database Modeling, Microsoft VISIO, IDERA SQL

Diagnostic Manager, SQL Litespeed, IDERA, Lumigent Log Explorer, Dell

PowerEdge, HP Blade, VMWare.

Good Application Experience in

. Setting up Active/Active and Active/Passive Clustering on SQL

Server 64 bit environment.

. Setting up Replication using MS SQL Server 2008 R2/2005/2000.

. SSIS (SQL Server Integration Services).

. SSRS (SQL Server Reporting Services).

. Setting up Log Shipping (Manual/Wizard) in SQL 2008 R2/2005.

. Setting up SQL Server Database Mirroring in SQL Server 2008 R2

PROFESSIONAL EXPERIENCE:

Barclays, Wilmington, DE

Mar 2013 - Present

Senior MS SQL Server DBA

Responsibilities

. 24/7 Production support for SQL server environment.

. Installing, Upgradation and configuring of SQL Server 2012, 2008 and

2008R2.

. Fine tuned and Monitored SQL Servers in Web based and Transaction

intensive environments. Implemented Active/Passive, Active/Active SQL

Server Cluster servers.

. Configured and maintained database mirroring for high availability.

. Implemented different types of Replication Models like Snapshot and

Transactional.

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

. Patched server with latest SQL Server service packs and Cumulative

updates.

. Managed Microsoft Active\Active and Active\Passive Clustered SQL

Server 2000, 2005 and 2008/R2 environments.

. Performed DBCC utilities and fixed data corruption in User databases.

. Developed, deployed and monitored SSIS Packages tool of SQL Server to

populate data from various data sources, created packages for

different data loading operations for application including upgrading

DTS to SSIS.

. Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005

to SQL Server 2008/2008R2 which include installing of SQL Server.

. Strong in developing, deploying packages using SSIS from OLTP to OLAP

. Worked on monitoring and tuning of SQL scripts.

. Created upgrade scripts for production database and supported it.

. Created and managed schema objects such as tables, views, indexes,

procedures, triggers & maintained Referential Integrity.

. Performed Server & Application fine-tuning & troubleshooting.

. Monitored MS SQL Server performance and network issues.

. Helped Development Team in deploying and testing the application,

which uses SQL Server as a database.

. Worked on more than 10 Data modeling projects and generated E-R

Diagram

. Monitored Databases for lock escalation, dead Lock, resource

utilization by sessions, package caching, buffer pool hit-ratios,

Captured long running SQL/runaway queries.

. Maintained Log Shipping, Mirroring and SRDF for disaster recovery.

. Scheduled the backups for Databases and Transaction log. Performed

restoration operations. Suggested backup strategies.

. Controlled user access rights, and managed data security.

. Involved in trouble shooting, Performance Tuning, Query Tuning, Index

Tuning using DMV's, Wizards and SQL Profiler.

. Implemented Backup and Restore in SQL Server using Third party tool

VERITAS Net Backup, SRDF, TSM and LITESPEED.

. Maintained multiple instances SQL Servers with maximum availability.

. Involved in 24x7 on call support

AIG INTERNATIONAL, Fort Worth, TX

April 2012 - Feb 2013

Senior MS SQL Server DBA

American International Group, Inc. NYSE: AIG, also known as AIG, is an

American multinational insurance corporation. Its corporate headquarters is

reported as 180 Maiden Lane in New York City. According to the 2011 Forbes

Global 2000 list, AIG was the 29th-largest public company in the world.

Responsibilities

. As a Production and development support DBA responsible for

maintaining 150 SQL Servers out of which 170 servers are production

servers in which 100 were mission critical and 70 were business

critical servers, remaining test and development servers.

. Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2,

applied service packs and security fix for all servers.

. Implemented Failover clustering for ACTIVE/ACTIVE and Active/Passive

SQL Server 64 bit environment

. Managed SQL Servers in 32/64 bit Clustered environments

. Implemented Database Mirroring on SQL Server 2008 environments.

. Configured and maintained Log shipping architecture to provide backup

server solution for 4 environments.

. Implemented transactional replication for data refresh

. Managed all Publisher, Distributor and Subscriber database

environments for the replication

. Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot

problems and queries

. Upgraded server from MS SQL Server 2005 to MS SQL Server 2008

. Created the DTS, SSIS packages to import the data from MS Access and

Oracle server to SQL Servers.

. Created SSIS packages to Extract and Load data from diverse source

(flat file, excel, xml and oracle)

. Created Data Flow's for Aggregate, sort, lookup, merge, union all and

fuzzy lookups.

. Used containers for repetitive control flow tasks

. Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export

control extensively in SSIS

. Performed Multi File Imports, Package configuration, Debugging Tasks

and Scripts in SSIS

. Scheduled package execution in SSIS

. Installing packages on multiple servers in SSIS

. Extensively worked on SSIS for data manipulation and data extraction,

ETL Load

. Created extensive reports using SSRS

. Installed, configured and maintained MS SQL Fail over clustering to

provide server high availability solution for 6 different

environments.

. Involved in tuning SQL Server databases using available tuning methods

like index tuning wizards, profiler and execution plans.

. Created the standard documents for Disaster recovery testing and

implemented them.

. Experienced with database sizing and capacity planning for production

servers.

. Experienced with creating logical and physical database design for

development projects.

. Experienced with improving SQL Server using windows performance

monitor to improve the server performance.

. Created the backup schedule for production, test and development

servers.

. Worked with developers to do the database schema changes and database

restore requests.

. Involved in restore operations to refresh the data from production to

test servers.

. Experienced in troubleshooting production servers and fixed the user

and application issues.

Verizon Wireless, Baskin Ridge, NJ

Sep 2010 - March 2012

MS SQL Server DBA

Verizon Communications (NYSE: VZ), branded as, is an American broadband and

telecommunications company and a corporate component of the Dow Jones

Industrial Average. The company is based in New York City at 1095 Avenue of

the Americas.

Responsibilities:

. Installing multiple instances of SQL Server 2008 R2 and database

migration from SQL Server 2000 to SQL Server 2008 R2.

. Implemented SQL Server with high availability architecture using SAN.

. Migration of New SQL server 2008 R2 from SQL server 2000.

. Create and modification of the database according to the requirement.

. Data migration using BCP utility and attach/ detach database.

. Create the jobs and also maintain the jobs as daily basis as well as

weekly basis.

. Implemented a Disaster Recovery plans.

. Creating snapshot replication and transactional replication in the SQL

Server 2008 R2.

. Transfer bunch of tables using SSIS packages.

. Partitioned a lot of tables, which had frequent inserts, deletes and

updates to reduce the contention and to improve the performance.

. Wrote SSIS Script for data transfer and involved in the system designing.

. Installing service packs and security patches SQL Server 2005/2008 R2.

. Created logical and physical data modeling for development projects.

. Rebuild the indexes using DBCC re-index and also check index

fragmentation.

. Testing QA server data with production servers.

. Check blocking process and send them vial e-mail notification.

. Actively involved in Normalization and de-normalization database.

. Capacity planning in estimating and sizing of tables.

. Provided a support for data issues and support to the application

developers on application database and given appropriate solutions.

. Set up SQL Mail and crated Jobs to automate and scheduling many tasks.

. Created heavy SSIS packages on SQL Server and Reporting Services on SQL

Server 2008.

. Refreshing production databases. Development of policies and procedures

for ensuring their security and integrity, analyzing the queries for

performance.

. As a DBA, managing 10 different production Servers and several QA Servers

in multiple countries supporting several hundreds of users.

. Maintained the production, test and development databases, tuned the

database by improving relations, integrity constraints and written T-SQL

procedures for transactions.

. Created documentation of database design, reporting, data analysis,

security, administration.

Environment: SQL Server v2008 R2, SQL Server v 2005/2000, Used 40+

database, SQL Optimizer, DTS, SQL Log Manager, Win 2003, Win 2008 R2

Server, ASP, ASP.Net, SSIS, Reporting Service, PCAnywhere

Client: Cond Nast

Dec'09 - Sep'10

Wilmington, DE.

Role: SQL Server DBA

Responsibilities:

. Worked on SQL Server 2008 R2/2008/2005/2000 Database Administration.

. Migrated databases from SQL Server 2000 to SQL Server 2005 and 2008

R2.

. Implemented the disaster recovery models like clustering, mirroring,

log shipping and transactional replication.

. Installing, Configuring and Maintaining SQL Server 2008R2/2008/2005

(64 bit) on Active/Active Cluster with latest Service Packs, Hot

Fixes.

. Worked as Primary DBA for 50 Instances and 70 as Alternate DBA.

. Experience working with CRM Application issues.

. Installed and configured Microsoft SQL 2 node Clustering

(Active/Passive).

. Created documentation to install SQL Server, apply service pack, hot

fix and clustering installation.

. Experience in Database security and integrity planning.

. Created Maintenance Plans for Regular Backups and Rebuilding of

Indexes.

. Deployed multi-campus backup environment based on EMC Data domain

storage.

. Installed and configured Storage Area Networks (SAN) in a

heterogeneous environment.

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

using different Methods in terms of evaluating joins, indexes,

updating Statistics and code modifications.

. Successfully implemented the Capacity planning for different servers.

. Experienced in configuring Powershell environment for SQL support.

. Implemented new T-SQL features added in SQL Server 2005 that are Data

partitioning, Error handling through Try- Catch statement, Common

Table Expression (CTE).

. Worked in Active/passive and Active/Active cluster environment and

Installed and Configured more than 50 Clustered SQL Instances

. Installed Service packs and Builds and Worked with SQL Server 2008 in

place and side by side upgrade from SQL server 2005

. Worked on Project for setting up DB mirroring and troubleshooting.

. Worked on setting up Transactional Replication (push and pull) and

Merge Replication and troubleshooting along with Slip stream

installations and TDE.

. Working on daily tasks include Backup failures, Login creations, Data

refresh and Disk space issues.

. Implementation of SQL failover cluster and setting up backup jobs and

Checking Control Jobs.

. Creating and Maintaining Database Maintenance Plans and Worked in

migrating database to different collations

. Implementing and Maintaining Server Level Auditing for auditing of

Logins, Creating and Dropping Objects.

. Checking the performance issues on servers as per request by using

profiler, perfmon, DBCC and DMVs.

. Monitoring servers by checking Error Logs, Windows Logs, Creating

Logins and Roles with appropriate permissions.

. Worked in Configurations of IIS (Internet Information Service) in ISP

environment with access to SQL DBs

. Installed and Configured SSRS and Deploying SSIS packages.

. Analyzed execution plans, and tuned queries and databases for better

optimal performance.

. Fixing Missing Indexes and Excess indexes using Data Tuning Advisor.

. Managed schema objects like Triggers, cursors, indexes, procedures.

Environment: SQL Server 2000/2005/2008/2008 R2, Windows Enterprise Server

2000/2003/2008,IIS 6.0, .NET, T-SQL, Microsoft Reporting Service, Microsoft

Dynamic NAV 4.0,

JOHNSON & JOHNSON, Bridgewater, New Jersey

March 2008 - December 2009

Senior MS SQL Server DBA

Johnson & Johnson (NYSE: JNJ) is an international American pharmaceutical,

medical devices and consumer packaged goods manufacturer founded in 1886.

Its common stock is a component of the Dow Jones Industrial Average and the

company is listed among the Fortune 500. Johnson & Johnson's brands include

numerous household names of medications and first aid supplies. Among its

well-known consumer products is the Band-Aid Brand line of bandages,

Tylenol medications, Johnson's baby products, Neutrogena skin and beauty

products, Clean & Clear facial wash and Acuvue contact lenses

Responsibilities

. Upgraded most of SQL Server 2000 to SQL Server 2005

. Involved with upgrade of databases from 2000 to 2005 in a Clustered

environment.

. Worked on SQL Server 2005 with latest Service Packs.

. Involved in Performance Tuning on Production, QA and Staging servers

of the current project.

. Involved in Monitoring Performance of different production servers.

. Implemented Database mirroring for disaster recovery.

. Maintained various databases for Production and Testing using SQL

Server 2005.

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

disk.

. Performance tuning, and optimization of procedures and queries.

. Worked with SQL server Profiler.

. Created the backup and restore strategy for production and development

environment.

. Created Database Maintenance Planner for the Performance of SQL Server

which covers Database Integrity Checks, Update Database Statistics and

Re-indexing.

. Using SQL Server Integration Services (SSIS) tool of SQL Server to

populate data from various data sources, creating packages for

different data loading operations for application.

. Experience in creating and executing SQL Server Integration Services

(SSIS) packages.

. Managing schema objects such as tables, views, clusters, indexes,

procedures, triggers & maintaining Referential Integrity depending on

user requirements and converting them into technical specifications.

. Administering the MS SQL Server by creating user logins with

appropriate roles, dropping and locking the logins, monitoring the

user accounts, creation of groups, granting the privileges to users

and groups.

. Database and Transaction log backups & restoration, backup strategies,

scheduling the backups. Backing up system & user databases and

restoring them.

. Performing fine Tuning of Database Application. Cleansing and solving

Database troubles.

. Used BCP and Bulk Insert utilities.

. Worked with SQL Server Reporting Services (SSRS).

HDFC (Housing Development Finance Corporation), India

August 2007 - Jan 2008

MS SQL Server DBA

HDFC was incorporated in 1977 with the primary objective of meeting a

social need - that of promoting home ownership by providing long-term

finance to households for their housing needs

Responsibilities

. Created Database Maintenance Planner for the Performance of SQL

Server which covers Database Integrity Checks, Update Database

Statistics and Re-indexing.

. Planned the Complete Backing up of Database and restoring the

Database from Disaster Recovery.

. Planned and modified the permission issues in the server.

. Designed a report on the monitoring of SQL Server Performance. This

report gives a detail report to the management on the Performance

of the server.

. Fine tuning the Database Settings as well as the Server Settings.

. Configured Mail Profile for sending automatic mails to the

respective people when a job is failed or succeed. Maintaining SQL

Script for creation of Database Objects.

. Creating, maintaining the users, roles and granting privileges.

. Logical and Physical Data Modeling using AllFusion, ERWIN.

. Configured Snapshot Replication (Creating Distribution Databases,

updating Publishers, creating & managing Publications, managing

Replication monitors).

. Performed System Study and Requirements Analysis, prepared Data

Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table

Structures, with a lot of interaction with the client.

. Performed analysis and design of the application.

. Did the database administrative job of Security, Backup/recovery,

ODBC connections etc.,

. Performed Database backups (operating system, flat file backups &

export/import).

Contact this candidate