Sql Server Manager

SURESH THAPA

MS SQL Server DBA

Email:*******@*****.***.

Mob.No. : 720-***-****

SUMMARY:

MS SQL Server Database Administrator with Five+ years of experience managing SQL Server in PRODUCTION, DEVELOPMENT, QA and UAT environments

Expertise in Managing PRODUCTION Databases on MS SQL Server 2014/2012/2008 R2/2008/2005/2000 in VIRTUAL and PHYSICAL environments.

Experience in supporting and involvement in 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.

Experience 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 Commvault for Backups

Used SPOTLIGHT and FOGLIGHT for Monitoring and Performance tuning

Upgraded and Migrated SQL Server Systems from SQL 2000/2005 to SQL Server 2008 R2

Experience in performance tuning SQL Server using PROFLER, QUERY EXECUTION PLAN and INDEX TUNING WIZARD

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

Experience in SSIS.

Created basic and troubleshoot heavy duty SSIS packages and deployed the packages from development to different environments

Expertise in MS SQL Installation, Migration, Upgrade, Configuration & Maintenance of multiple SQL server environments.

Performed and involvement Capacity Planning and Logical/Physical database design.

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.

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

Understand C,C++,C#,VB, JAVA languages and Networking concepts.

TECHNICAL SKILLS:

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

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

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

Other Tools: Redgate, Foglight, commvault, Litespeed, Legato Tap Backup.

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, Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers.

PROFESSIONAL EXPERIENCE:

TSYS Total System Services,Inc., Golden,CO Oct 2015 - Present

Application SQL Server DBA/Production Support

Played the role of a Application SQL Server DBA and Production support DBA giving 24/7 support to crucial OLTP 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 rotating PRODUCTION support DBA giving 24/7 Support on SQL 2014/2012/2008 R2

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.

Worked on setting up and managing Snapshot and Transactional Replication

Involved in Monitoring Performance of different production servers.

Implemented Database Replicatioin and Log Shipping for disaster recovery.

Maintained various databases for Production and Testing using SQL Server 2014/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.

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

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 2014/2012/2008 R2/2005/2000, VMware, Rational, BandDAuto,Virtualization, SSIS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2003/2000, LiteSpeed Backup, IDera Diagnostic Manager.

Geisinger Health Plan, Bloomsburg PA Nov 2013 – May 2015

SQL Server DBA/Production Support

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.

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

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.

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.

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.

Environment: MS SQL server 2000/2005/2008 R2/2012, Windows 2003/2008 R2, Enterprise Manager, Query Analyzer, SQL Server Profiler, SSIS,Rational,BandDAuto.

iYogi Technical Services Ltd, New Delhi, India June 2010 – July 2013

Jr. MS SQL Server 2008/2005 DBA

Responsibilities:

As a Production and development support DBA responsible for maintaining 253 SQL Servers out of which 120 servers are production servers in which 70 were mission critical and 50 were business critical servers, remaining test and development servers.

Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.

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

Experience in upgrading from SQL Server 2000 to SQL Server 2005 servers.

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

Implemented SQL Server Mirroring on SQL 2008/2005 environments

Created and involved in DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.

Created SSIS packages in 2008 platform to Extract and Load data from diverse source (flat file, excel, xml and oracle)

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

Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.

Involved in setting up transactional replication in production environment.

Created the standard documents for Disaster recovery testing and implemented them.

Experienced with database sizing and capacity planning for production servers.

Experienced with improving SQL Server using windows performance monitor to improve the server performance.

Involved in securing the SQL Server environment and involved in setting up the user permissions.

Experienced with creating database maintenance plans for efficient operations.

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.

Environment: MS SQL Server 2008 /2005, Windows 2000/2003/2008 Server operating systems.

EDUCATION:

MSc(IT), India

Contact this candidate