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