SUMMARY:

• Over7+ years of Experience in SQL Server database admin, System Analysis, Design, Development and Support of Microsoft SQL Server 2014/2012/2008 R 2 / 2008 / 2005 / 2000 in Development, Test and Production Environments on various business fields like Financial, Insurance and Manufacturing.
• Hands on experience of Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2016/2014/201 2/2008/2005/2000 on Clustered and Standby Environments.
• Movement from SQL server 2000 to 2005 and 2000/2005 to 2008 by using In - Place upgrade process and as well as side-by-side upgrade process, and documented the Upgrade Process and expert in drifting DTS packages to SSIS Packages
• Experience in implementing and Supervised distinct types HA and DR scenarios like Replication, log shipping and Configure Database Mirroring in Cluster Environment on Production, QA and Dev environments.
• Configured the servers on 32-bit and 64-bit clustered and standalone server en vironments.
• Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems
• Expertise in Database Backup and Recovery procedures by using N ative, TDP/TSM and Lite Speed to/from Disk /Legato server (Tape).
• Broadly used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in using Performance Monitor/Profiler to resolve Dead locks /Long running queries. And valuable experience in data (table) partitioning.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV’s and DMF’s, Re-indexing, Updating Statistics and online indexing.
• Experience in data modeling like physical data modeling and logical data modeling by using ERWIN tool.
• Expert in data warehouse modeling (designing Star Schema, snowflake schemas with identifying Facts and Dimensions).
• Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and expert in tuning Complex Queries.
• Pleasant experience on physical storage configuration and optimization of SAN/NAS/DASD with different RAID levels.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Checking the threshold values and baselines and monitoring in perform on and SCOM
• Expertise on Business Intelligence Tools to Create SSRS Reports, SSIS Packages and SSAS with OLAP.
• Expertise in performing data transformations between servers using BCP, DTS, SSIS and bulk insert. And, Expert in using DMV’s, DMF’s.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000, ORACLE, MS Access, MySQL

Database Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Analysis Services, Business Intelligence & Development Studio and Erwin

Development skills: T-SQL, PL/SQL, SSIS/SSRS/SSAS, Oracle 8i/9i/10g

Languages: T-SQL, HTML, XML

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

Reporting Packages: SQL Server Reporting Services (SSRS), Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel

Operating Systems: Windows 98/NT/2000/XP, 2003 Servers, UNIX.

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader, TOAD for SQL Server and Oracle

PROFESSIONAL EXPERIENCE:

Confidential,Englewood, NJ

SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL server 2005, 2008 and 2008 R2, 2012, 2014, 2016 and Some server upgrades Standard to Enterprise edition.
• Migrated Databases from SQL Server 2000 to SQL server 2005 and 2008, 2012, 2014.
• Worked in Active-Passive, Active-Active Cluster and DB Mirroring environment as a High availability solution And Always on.
• Worked with the table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Used Policy Based Administration feature (SQL Server 2008).
• Worked with SCOM Monitoring.
• Created Table Valued Parameters (SQL Server 2008) of a table value data type and can pass this variable into a stored procedure.
• Rendered Reports to Microsoft Word using SQL Server 2008.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Performing Backup/Restore to/from Legato server (Tape) and Disk.
• Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• T uning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Expert to write the auditing scripts for SQL server
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning.
• Prepared Documentation for the Disaster Recovery plan.
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Routine DBA jobs like Backups and Restores.

Environment: MS SQL Server 2016,2014,2012,2008 R2, 2008, 2005 and 2000, T-SQL, Erwin, ASP.Net 3.0, SSAS, SSIS (ETL), SSRS, SharePoint Server 2007 and 2010, Windows 2003 and 2008 Servers.

Confidential, Lake Zurich, IL

SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2005 to 2014 on Various Production Servers.
• Implemented SQL Data Compression Using SQL server 2008 For Compressing Data and Log Files, Back up Level.
• Migrating Databases from SQL Server 2005 to SQL Server 2008 by using REDGATE.
• Worked with the table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Used Policy Based Administration feature (SQL Server 2008).
• Created Table Valued Parameters (SQL Server 2008) of a table value data type and can pass this variable into a stored procedure.
• Compare and synchronize your database schemas or data by using REDGATE
• Rendered Reports to Microsoft Word using SQL Server 2008.
• Worked With 'upsert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Used DTSX change tool for migrating DTS packages to SSIS
• Worked in Active-Active Cluster environment as a High availability solution.
• Recovered the System and User databases from suspect mode
• Performing Backup/Restore to/from Legato server (Tape) and Disk
• T uning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Extensively used Lite speed backups
• Expert in configuring Temp db.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Routine DBA jobs like Backups and Restores
• Enjoyable experience in data modeling and metadata services.

Environment: MSSQL Server 2014/2012/2008 R2/2008 and 2005, T-SQL, Erwin, ASP.Net 3.0, SSAS, SSIS (ETL), SSRS, SharePoint Server 2007, Windows 2003 Server, IIS 6.0.

Confidential, New York

SQL Server DBA

Responsibilities:

• Database Administrator, Database Programming.
• Relocation of Databases from one server to another server using attach and detach databases.
• Involved in Up gradation of Touch works Database.
• Touch works application was implemented in Active Passive clustered environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Using the Lite speed to take backups.
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters.
• Maintaining the database consistency with DBCC at regular intervals.
• Used DTS packages to move logins and jobs from one server to another server.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• To set up SQL Server configuration settings.
• Used Data Partitioning in SQL Server 2005.
• Using log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Expertise in SQL Server Analysis Services (SSAS).
• Expertise in SQL Server Reporting Services (SSRS).
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Maximum performance and uptime in production environment.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2012/2008 R2/2008/2005, SSIS, SSRS, DB2, ETL, Visual Studio.NET, Erwin, DB Artisan, Windows NT/2003, UNIX.

Confidential

SQL Server DBA

Responsibilities:

• SQL Server 2005 Database Administration.
• Installed and configured more than 2GB RAM in SQL Server 2008 R2.
• Performed the migration of SQL Server 2000 to SQL Server 2005.
• Configured the servers on 32-bit and 64-bit clustered and standalone server en vironments
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting Log Shipping.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
• Expertise in SQL Server Analysis Services.
• Expertise in creating and supporting in OLAP Cubes
• Managed VERITAS net backups and Lite speed backups .
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.
• Involved in creating and supporting in OLAP Cubes Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server 2008 R2/2008/2005, ANSI SQL, SSAS, SSIS, BO XI, Informatica, MS SQL Server Reporting Services 2005 (SSRS), COGNOS, DDL, Erwin, SharePoint Moss Server, ASP.Net, ETL, Erwin, C#.Net, SAP, CSS, Java Script, XML, HTML.

Confidential

SQL Server DBA

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirements, and implemented contemporary design into SQL Server 2000.
• Succeeded migrating old data from legacy system into SQL Server 2000 using DTS and Backup and Restore option.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer (execution Plan).
• Created Users and Roles, and managed security and permission of database.
• Created stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects.
• Actively participated in User Acceptance Testing, and debugging of the system.

Environment: SQL Server 2000/2005/2008 Enterprise Edition, .NET, VB, Crystal Reports.