Sql Server Data
Resume:
Naishal
Senior SQL Server DBA
*******.******@*****.***
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