SUMMARY

• 8 years of experience in Database Administration, Data Architecture and Development using SQL server 2000/2005/2008/2008 R2/2012/2014 systems in OLTP and OLAP environment.
• Performed migrations from SQL Server 2000 to 2005 and 2008 R2, SQL Server 2005, SQL Server 2008 to SQL Server 2012 and Expertise in installation, migration, applying Service Packs, Hotfixes and Critical Security Updates released by Microsoft.
• Experienced in different phases of Software Development Lifecycle(SDLC) including Design, Implementation/Coding,Testing,Deployment and Maintenance.
• Expertise in reading and understanding execution plan and fixing the query to execute with low cost using joins like merge, nested loops, hash join.
• Develop or modify SQL queries and stored procedures to meet business requirements and achieve desired performance.
• Performed BCP, Bulk Insert, Imported and Exported data from different Data Sources.
• Experience in monitoring database performance and tuning using various native tools namely Extended Events, Performance Monitor, Activity Monitor, SQL Profiler and Third Party Tools.
• Expertise in Creating Linked Servers between different Servers in SQL environmentsand between 32 and 64 bit servers to access database objects in remote locations.
• Experience in using DMV and DBCC commands for various performance issues.
• Configured and Maintained SQL Server Always On, Failover Cluster for Active - Active and Active-Passive Clustering.
• Extensively worked on implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, Clustering and mirroring on physical and virtual machines.
• Migrated SQL Server 2000/2005/2008 databases to SQL Server 2012.
• Experience in Configuring Replication and troubleshooting the issues with transactional replication
• Experience in performing database Backups
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
• Experience in SQL Upgrades SQL 2000 to 2005 and Building SQL Clustering.
• Monitoring Event Viewer, SQL Error logs and Log file viewer for software and hardware related errors.
• Created Linked Servers between SQL Servers
• Resolving blocking and deadlock issues using activity monitor and system stored procedures.
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods and refreshing databases in development, QA and stage environments using production backup
• Extensive testing and ETL experience using SSIS, SSRS and SSAS.
• Worked on SSIS package deployment, looping, logging and Error redirectingprocesses
• Experience in creating, reporting and Filtering basic parameters in SSRS
• Extensive experience in the ETL testing, manual testing and Business Intelligence Applications.
• Strong working experience on ETL applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Experience in analysis, development and deploying web services and window services in Microsoft Visual Studio ASP.NET and SQL Server.
• Strong in Troubleshooting/Problem Solving skills.
• Excellent Analytical, Communication skills and Leadership qualities working in a team.

TECHNICAL SKILLS

Operating Systems: Windows 2008 R2/2008/2003/XP/Vista/7, Linux(Ubuntu), Open Suse.

Databases: MS SQL Server 2014/ 2012/2008 r 2/2008/2005/2000. MS Office Access 97/2000/2003 & SQL Workbench.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data Transformation Services (DTS).

Web Server: IIS 5.0, 6.0, 7.0 & 8.0.

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Data Modeling Tools: Erwin, Red gate, Idera, Visio.

Languages: T-SQL, C, C#, java script, Visual Studio 2012/2008R 2/2008/2005/2003 , ASP.NET, VB.NET.

Applications: Microsoft Office 365, Adobe PhotoshopAcrobat Reader/Writer

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

MS SQL Server DBA

Responsibilities:

• 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 & testing environments.
• Configured ALWAYS ON setup between different Data Centers.
• Migrated the databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012/2014.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Re-porting Services (SSRS).
• Daily DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Managing alerts and security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
• Performed troubleshooting and fine-tuning of databases for its performance and concurrency.
• Performed Scheduling jobs and monitoring and troubleshootingthem.
• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and built in performance reports.
• Resolving blocking and deadlock issues using activity monitor and system stored procedures.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Integrated SQL traces with PerfMon log to have better graphical analysis to find system bottlenecks
• Worked on Reports and automated the Jobs for Running the Reports(SSRS).
• Setting up Clustered environment for SQL Server Administration.
• Used Microsoft Technical Implementation Guide(MTIG) to improve security.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
• Created linked servers between SQL Servers
• Used BCP utility to publish table output to text files.

Environment: SQL Server 2008R2/2012/2014, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2013, T-SQL, SQL Profiler,SQL databases,C#.NET, ASP.NET.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Migrated DTS packages from SQL Server 2008 toSQL server 2012.
• SQL 2012 - Performed installation of SQL Enterprise 2012 64-bit version on Windows servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers, Patch applications.
• Migrated and Documented SQL Server 2008 to SQL Server 2012and updated software with service packs.
• Upgradations of SQL server versions and applying patches and hot fixes.
• Created Documentation for steps needs to be taken while upgrading the SQL server 2008 to SQL server 2012.
• Configured the compatibility levels of the database
• Utilized fog light for monitoring the deadlocks, blockings and windows level performance.
• Configured High Availability Options to the SQL Server 2012
• Installed and Configured Clustered Instances for SQL Server
• Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
• Conducted Consistency Checks on the database and analyzed the fragmentation on the indexes.
• Worked with Transactional Replication to achieve Load balancing.
• Used DTS Xchange tool for Migrating DTS packages to SSIS.
• Troubleshooting SSIS packages which failed to execute in the scheduled jobs.
• Created ADHOC reports using SSRS in BIDS.
• Detected and Resolved locks and deadlocks using the trace flags and native tools like profiler and the activity monitor.
• Implemented and Maintained routine DBA tasks like job scheduling, creating maintenance plans
• Implementing DISASTER RECOVERY AND HIGH AVAILABLITY concepts like Log Shipping, Mirroring and Replication (Snap Shot and Transactional).
• Adding nodes to already existing clustered servers as a part of data load\High availability
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Work on weekly Issues reports which are generated as a part to improve Performance.
• Continuous monitoring server health with Idera monitoring tool.

Environment: MS SQL Server 2000/2005/2008/2008 R2/2012, Windows 2003/2008R2/2012, SSRS, SSIS, SSAS, PL/SQL.

Confidential, Chicago, IL

MS SQL Server DBA/ Dev.

Responsibilities:

• Performed migrations from SQL server 2005 to SQL Server 2008
• Implemented and Maintained Clustering (active/active, active/passive) as a high availability procedure.
• Implemented and Maintained Transactional and Snapshot Replication and Performed troubleshooting and fine-tuning of databases for its performance and concurrency.
• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and performance reports.
• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers and managing SQL server usingPowerShell scripts
• Creating logins and database users, roles and providing permissions to users and roles according to the requirement and security policy.
• Has implemented TDE (Transparent Data Encryption) and column level encryption.
• Deploying reports in reporting server and Creating and providing permissions to users on reports in a reporting server.
• Configured report manager for creating report subscriptions, snapshots, and caching.
• Uploaded Reports on to Report manager and Organized them based on Business Rules.
• Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages.
• Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points.
• Created SSIS packages to load data into staging table and data mart and also Performed logging in SSIS packages to capture error data and for error handling.
• Performed Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Created maintenance plans for Re-indexing/Reorganizing Indexes and for performing DBCC checks on databases and updating statistics for smooth execution of queries and purging old files for preventing space issue.
• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks.

Environment: SQL Server 2005/2008R2, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2008, T-SQL,VB Script, PowerShell, SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor,C#.NET, VB.NET.

Confidential

Database Administrator

Responsibilities:

• Responsible for installing and maintaining SQL 2008 Cluster environment and Performed migrations from SQL server 2005 to SQL server 2008.
• Applying existing servers with relevant Service Packs, Hotfixes and any Critical Security Updates released by Microsoft.
• Analyzed SQL Servers and Databases and came up with a plan for consolidation based on usage, performance, and compatibility.
• Implemented High availability & Disaster Recovery procedures, Cluster (active/active, active/ passive), DB Mirror, Replication and implemented log shipping.
• Used BCP utility to publish table output to text files and created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Developed Automated Backup jobs and DBCC scripts for databases and transaction logs.
• Configured Linked Servers between different servers
• Experience in configuring report manager for creating reports and snapshots.
• Used DBCC and DMV for optimization and better performance
• Used Replications like Snapshot, Merge and Transactional for Reporting, Data Transfer and Data Warehousing
• Uploading Reports on to Report manager and Organized them based on Business Rules.
• Installed and administered two node clusterActive/passive.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.

Environment: SQL Server 2005/2008, Windows 2008 server, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2010, T-SQL, PowerShell,SSRS, SSIS,SQL Profiler, Activity Monitor, Data Collector,Performance Monitor, Database Tuning Advisor, C# and .NET.

Confidential

Database Developer/ Administrator

Responsibilities:

• SQL Server 2000/2003/2005 Installation and Configuration.
• Migrated DTS packages from SQL Server 2000 to SSISSQL server 2005.
• SQL 2005 - Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers, Patch applications.
• Wrote SQL and batch scripts for automation and maintenance tasks.
• Wrote Stored Procedures, function, views and triggers as per the business requirement.
• Design SQL Server Inventory application.
• Experience with TFS and source safe.
• Worked on Transaction replication.
• Experience in checking Actual and estimated execution plans to find out performance issues for long running quires and find out how SQL Server optimizer is behaving while the query is running in terms of (Nested loop, Hash and Merge Join).
• Experience in checking each operator property compare that with SQL Server query to find what columns are needed to be indexed to get the better performance.
• Experience in running and stopping server side trace to get more information about performance issues on production servers.
• Developed reports using SSRS.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005.
• Worked on daily routine tasks like backup, refresh lower environments, security requests and issues.

Environment: SQL, PL/SQL,SQL Server Management Studio, Visual Studio 2005,SSAS 2005, SQL Server 2000/2005.