SURESH THAPA

Senior MS SQL Server DBA

acc4za@r.postjobfree.com

732-***-****

SUMMARY:

. Senior MS SQL Server Database Administrator with EIGHT+ years of

experience managing SQL Server in PRODUCTION, DEVELOPMENT, QA and UAT

environments

. Expertise in Managing PRODUCTION Databases on MS SQL Server 2012/2008

R2/2008/2005/2000 in VIRTUAL and PHYSICAL environments.

. Expertise in ACTIVE/ACTIVE and ACTIVE/PASSIVE Clustering

. Experience in implementing Disaster Recovery(DR) and High Availability

Solutions(HA) using Database Mirroring and Log Shipping.

. Provided 24/7 and On-call Support for PRODUCTION environment

. Expertise in Database Administration activities like Installation,

Configuration, Backup & Recovery, Database Security, Data Transformation

Services, Database Designing and Query Optimization.

. Extensive use of Powershell Scripting.

. Expertise in VMWARE and managing multiple SQL Server Instances on

Physical and VMWARE

. Hands on experience in implementing SNAPSHOT,TRANSACTIONAL and MERGE

replication

. Hands on experience in implementing FULL, TRANSACTION and DIFFERENTIAL

Backups

. Used third party tools like Redgate, SQL Litespeed and Netbackup for

Backups

. Used IDERA, FOGLIGHT and SQL Sentry for Monitoring and Performance tuning

. Upgraded and Migrated SQL Server Systems from SQL 2000/2005 to SQL Server

2008 R2

. Expert in performance tuning SQL Server using PROFLER, QUERY EXECUTION

PLAN and INDEX TUNING WIZARD

. Extensive use of SQL Server DMV's for Performance Tuning.

. 5+ years experience in SSIS/SSRS

. Created heavy duty SSIS packages and deployed the packages from

development to different environments

. Worked heavily on SSIS transformations and layed out strong SSIS packages

. Expertise in MS SQL Installation, Migration, Upgrade, Configuration &

Maintenance of multiple SQL server environments.

. Performed Capacity Planning, Data Modeling and Logical/Physical database

design.

. Performed Logical/Physical Modeling and Reverse engineering with ERWIN

and VISIO

. Strong experience in performing database consistency checks and planning

and scheduling Recovery Procedures.

. Experience in developing and managing Stored Procedures, Triggers,

Indexes, Views, Data Transformation Services and Locking.

. Monitoring and tuning SQL Server performance with multiple tools

including Performance Monitor, SQL Profiler, Event Viewer, Index Tuning

Wizard and Spotlight to achieve better performance, accessibility and

efficiency.

. Experience in resolving Database Performance, Capacity and Distributed

data issues.

. Proficient with SQL Enterprise Manager, SQL Query Analyzer and scheduling

jobs with SQL Server Agent and SQL Profiler.

. Created extensive reports using SSRS ( Tabular, Matrix)

. Experience working with Very Large Databases (VLDBs) and Good knowledge

of RDBMS and Data Warehouse concepts.

TECHNICAL SKILLS:

Databases: MS SQL server 2012/2008 R2/2008/2005/2000

Operating Systems: Windows NT/98/2000/XP/Vista/2003, 2007, VMWare

ETL Tools: SQL Server Integration Services (SSIS), INFORMATICA, SQL Server

DTS

Other Tools: Microsoft Visual Source Safe, IDERA, Redgate, Foglight,

Sentry

Data Modeling Tools: Erwin, Microsoft Visio 2007

SQL Server Tools: SQL server Management Studio, SQL server Query

Analyzer, SQL server mail service, DBCC, DTS, BCP,

SQL server profiler, Event Viewer, and Index Tuning

Wizard, SQL Server Agent, SSRS Log Shipping, T-SQL,

DDL, SQLCMD, BIDS, Triggers

PROFESSIONAL EXPERIENCE:

GAIN CAPITAL, Bridewater, NJ

January 2012 - Present

Senior SQL Server DBA/Production Support

Played the role of a Production DBA giving 24/7 support to crucial OLTP and

DSS systems on standalone and Virtual systems.

Responsibilities:

. Worked on Migration Project to migrate SQL Server from Lower Version to

Higher Version

. Migrated SQL Server from SQL Server 2000/2005 to 2008 R2/2012

. Worked primarily as a PRODUCTION support DBA giving 24/7 Support on SQL

2012/2008 R2

. Managed OLTP, DSS applications/databases in Physical and Virtual

Environment

. Worked extensively on Virtual and VMware Environments.

. Worked on managing SQL Server Environment in High Availability(HA) and

Disaster Recovery(DR)

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

the current project.

. Managed Production environment for High Availability in Active/Active and

Active/Passive mode

. Worked on setting up and managing Snapshot and Transactional Replication

. Involved in Monitoring Performance of different production servers.

. Implemented Database mirroring and Log Shipping for disaster recovery.

. Worked on PowerShell Scripting

. Maintained various databases for Production and Testing using SQL Server

2012/2008 R2.

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

disk.

. Performance tuning and optimization of procedures and queries.

. extensive use of SQL Server DMV's for Performance Tuning

. Worked extensively with SQL server Profiler, Execution plan and Index

Tuning Wizard for performance bottlenecks

. 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, Re-

indexing and online Indexes.

. Worked on creating SSAS cubes and laying out SSAS designs

. 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 ETL application.

. created extensive SQL Server Integration Services (SSIS) packages for

ETL.

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

. created database logical/physical modeling with ERWIN

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

procedures, triggers & maintaining Referential Integrity depending on

user requirements and converting them into technical specifications.

. 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.

. Heavy migration using SSIS, DTS and Data Integrator.

. Created Linked Servers for data retrieval using OLE DB data sources and

providers.

Environment: SQL Server 2012/2008 R2/2005/2000, VMware, Virtualization,

SSAS, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log

Shipping, Windows 2008 R2/2003/2000, ERWIN, LiteSpeed Backup,

IDera Diagnostic Manager

Alcon Labs, Fort Worth, TX

November 2009 - December 2011

Senior SQL Server DBA

Role was to manage SQL Servers and troubleshoot and support Production

issues. Also, help in upgrades / migration of lower versions of SQL Server

to Higher version.

Responsibilities:

. Managing Production SQL Servers on VIRTUAL and PHYSICAL environments

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

. Supporting the business 24/7, maintaining 99.999 uptimes depending on the

application and business SLA requirements.

. Involved in upgrading SQL Server 2000 instances to SQL Server 2008 R2

. Involved in database design, database standards, T-SQL code reviews.

. Configured Active/Active and Active/passive SQL Server Clusters.

. Implemented Mirroring and Log Shipping for Disaster recovery

. 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 ( Tabular, Matrix )

. Configured transactional and snapshot replication and managed

publications, articles.

. Proactively involved in SQL Server Performance tuning at Database level,

T-SQL level and operating system level. Maintained database response

times and proactively generated performance reports.

. Automated most of the DBA Tasks and monitoring stats.

. Responsible for SQL Server Edition upgrades and SQL Server patch

management.

. Created a mirrored database for reporting using Database Mirroring with

high performance mode.

. Created database snapshots and stored procedures to load data from the

snapshot database to the report database.

. Involved in data modeling for the application and created ER diagrams

using Erwin and VISIO.

. Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes,

Views, Functions and Stored Procedures.

. Trouble shooting and supporting all user problems by using SQL server

profiler, network traces, Windows logs etc.

. Migrated DTS Packages to SSIS Package.

. Monitored event and server error logs for troubleshooting.

Environment: MS SQL server 2000/2005/2008 R2, Windows 2003/2008 R2,

Enterprise Manager, Query Analyzer, SQL Server Profiler, SSIS,

SSRS, Erwin, VISIO.

CATERPILLAR, Radnor, PA

May 2008 - September 2009

SQL Server DBA/ Production

Role was to provide production support to all SQL Server instances in

Production, Development and QA environment. Implement Installation best

practices and configure patches

Responsibilities:

. Installed SQL Server 2008 in production, test and development

environments.

. Managed servers in Clustered, Mirrored and Log Shipping environment

. Managed SQL Servers in Virtual and Standalone environments for OLTP and

DSS systems

. Provided technical support for the database environment including

overseeing the development and organization of the databases, assessment

and implementation of new technologies.

. Designed and implemented database changes.

. Reviewed and tune up SQL queries, stored procedures, views and triggers.

. Worked with architecture, application development and operations to help

achieve a state-of-the-art environment that meets current and future

business objectives.

. Help in-house developers improve performance of their stored procedures,

TSQL codes and database design.

. Managed health of SQL Servers including backups, restores and monitoring.

. Provide a working model of transaction processing environment for

capacity assessment and planning.

. Developed a methodology for the ongoing assessment of database

performance and the identification of problem areas.

. Develop a security scheme for the database environment, as well as

assisting in set up of disaster recovery.

. Provided technical support during the development, design enhancement and

implementation of production databases.

. Worked with the transaction processing area to develop both the physical

and the logical database administration functions.

. Work with others in IT to build the logical database area and provide

technical guidance during all phases of the development process.

. Worked with vendors in evaluating and implementing new technologies.

Environment: MSSQL Server 2005 and 2008, MS Windows Server 2003, 2008,

SSIS, SSRS.

Farmers Insurance, Los Angeles, CA

March 2007 - April 2008

SQL Server DBA

Role was more of supporting Developers with builds and releases and

performance tuning of SQL Server Instances and databases.

Responsibilities:

. Responsible for Query optimization and Performance tuning.

. Rebuilding of indexes to improve data retrieval performance

. Managed Microsoft Clustered SQL Server 2000 and 2005 environments.

. Involved in Migration from SQL 2000 to SQL 2005.

. Managing server logins, database users and permissions.

. Created Clustered Indices and Non-Clustered Indices to increase the

performance of database.

. Managing and scheduling daily jobs relating to data transfers, backup and

recovery, transaction log dumps.

. Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.

. Used Data Transformation Services (DTS) an Extract Transform Loading

(ETL) tool of SQL Server to populate data from various data sources,

created packages for different data loading operations for application.

. Used the SQL server integration services (SSIS) as a part top transfer

logins from SQL server 2000 to 2005 and to move data from one server to

another server.

. Configuration and Administration of IIS 6.0, Windows 2003 server.

. Created the Database Objects like Tables, Views, Functions, Stored

Procedures and Triggers.

. Managing security tasks like granting and revoking permissions

Environment: Windows Server 2000/2003, VMware, SQL Server 2005, Windows

2003, DTS, T-SQL.

AT&T, Bridgewater, New jersey

April 2006 - January 2007

SQL Server DBA

Role was to administrator multiple SQL Servers in Production environment.

Responsibilities:

. Database Administration for Development, Test and Production servers with

MS SQL Server 2005 on Windows 2000/2003.

. Administered MS SQL Server by creating user logins with appropriate

roles, dropping and locking the logins, monitoring user accounts,

creation of groups, granting the privileges to users and groups.

. Created DTS package to export and import data from SQL Server to Access,

text and excel files.

. Checked performance tuning, indexing and query optimization.

. Used database consistency checks using DBCC utilities.

. Implemented Snapshot Replication and Transactional Replication.

. Developed administrative tasks of SQL Server of performing daily backups

and recovery procedures.

. Created Linked Servers for data retrieval using OLE DB data sources and

providers.

Environment: Windows Server 2000/2003, MS SQL Server 2005/2000, XML and

Erwin.

Novartis Pharmaceutical, Delhi, India

February 2005 - March 2006

SQL Server DBA

Worked as a Junior SQL Server DBA managing multiple SQL

Responsibilities:

. Database Administration for Development, Test and Production servers with

MS SQL Server 2000/2005 on Windows 2000/2003.

. Created backups for databases.

. Involved in Performance tuning.

. Involved in developing E-R diagrams, logical & physical data modeling,

development and implementation of the system with ERWIN.

. Gathered requirements from business users.

. Wrote user requirement documents based on functional specification.

. Designed physical data models.

. Created functions, views and triggers.

. Developed source to target specifications.

. Created DTS package and schedule the jobs for batch processing.

. Created indexes, constraints and rules on database objects to improve the

data base performance to have best out of it

Environment: Windows Server 2000/2003, MS SQL Server 2005,2000 and

Erwin, Stored Procedure, Views, Triggers.

EDUCATION:

MSC IT, Delhi University, India

Contact this candidate