SUMMARY

• Around 7 years of experience in Database Administration and Development for very large and complex databases in SQL Server 2014/2012/2008 R 2/2008/2005.
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security and Data Transformation Services.
• Migration of SQL Server databases into SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014.
• Dexterity inimplementingdifferent types ofHigh Availability &disaster recovery scenarios like Replication models (Snapshot, transactional), log shipping, Database mirroring and Clustering.
• Administered multipleSQL InstancesonCluster environmentfor Server Consolidation projects built onSANusingRAIDlevels.
• Exquisite skills in database Backup, Restoration, Recovery, Replication, Linked Servers, Database Maintenance Planning.
• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Outstanding experience inSQLEnterprises Manager and SSMS - creating and scheduling jobs, alert and operators withSQL Server Agent,SQL Profiler, Backup/Recovery databases.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoring SQL Server performance.
• Experience In VMware and Hyper -V tools to virtualized the server and allocating resources to each VM machine.
• Setting up SQL Server 2005, 2008, 2088R2, 2012, 2014 on MS Virtual, VMware.
• Good experience in Installing, configuring and maintaining SQL Server Active/Passive cluster.
• Expertise knowledge about windows clustering part. Configuration of Static & Dynamic IP addresses, heartbeat connection between the nodes using network editor, partition of disk through ISCSI, configuration of cluster and MSDTC IP address.
• Experience in Network aspect like, DHCP, Subnet mask, Default Gateway.
• Experience in creating maintenance plans, Jobs and Sending Alerts using SQL Mail.
• Experience in installing Service Packs for SQL Server and OS.
• Experience in data normalization and de-normalization.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Worked on DMVs, System tables and Stored Procedures for performance tuning.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database. knowledge about stored procedures, functions, packages, triggers.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experience in using tools like SQL Profiler and performance counters for Monitoring and Tuning MS SQL Server Performance.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Good experience in resolving blocking and dead lock Issues.
• Experience in SQL Server Integration Services (SSIS).
• Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).
• Migrated DTS Packages to SSIS Packages.
• Deployed SSIS Packages to MSDB and File system from development to Production environment.
• Flexible, enthusiastic and project oriented team player with solid leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Databases: MS SQL Server / 2014/2012/ 2008, 2005

Database Migration: Migrated Databases from SQL server to SQL server Migrated Oracle and My SQL Databases to SQL Server

Programming: Visual Basic 6, Visual Basic 5, SQL, T-SQL

SQL Tools: SSMS, Profiler, Execution Plan, Database Tuning Advisor, DMVs, DBCC, Perfmon.

ETL Tools: SSIS/DTS/BCP

Data Modeling: ERWIN, SSDD (SQL Server Database Diagram)

Operating System: Windows Server 2008/2005/2003/, NT.

VMware: Installing, configuring and administering.

Windows Clustering: Windows clustering (configuration of DNS, static, Dynamic, MSDTC, Cluster IPs)

Reporting Development & Management: SSRS (SQL server Reporting Services)

Web/Application Server: Deployed apps in development, test and production App Servers (IIS)

Hardware/Storage: San, RAID

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

SQL DBA

Responsibilities:

• Managed and Administrated theSQL Server 2014/2012/2008 R2/2008 production and Non-production servers.
• Installation ofSQL Server 2014/2012/2008 R2/2008onWindows Server Clustered environment.
• Upgraded/Migrated SQL Server 2008/2005 databasestoSQL Server 2014/12 databases.
• Migrated SQL Server 2008 databasestoSQL Server 2014/2012 databasesincludingDTS to SSIS packages.
• Performedbackup using backup compression and Data compression in SQL Server 2014 on clustered environment.
• Handled upto 2.5 TB Size databases with clustered environment.
• Implemented new features inSQL 2014/12likePolicy based Management, Table Compression & backup compression, SQL Server Auditing.
• Application support for front end feeds and ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Setting up and Monitoredtransactional replication, Database mirroring on Production, QA and Dev servers.
• MonitoredLog shipping/ Transactional Replicationand trouble shooting of errors.
• Extensively workedon Profiler, Perfmon, DMVs to tune the databases, servers and query tuning.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered indexon theseparate file group to improve the performance.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyze execution plans and generate suggestions for improvement.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks.
• CreatedSSIS packagesto load robust data from differentHeterogeneous data sourceslikeOracle, DB2 to SQL server.
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task.
• Configured and deployedSSIS PackagesfromTest to Production Environments.
• Created, deployed and managed reports usingSQL Server Reporting Services(SSRS)
• Virtualization of SQL server from P2V (Physical to virtual) environment. Strong Knowledge about windows clustering.
• Supported24 X 7 Production environment

Environment: SQL Server 2014/2012/2008 R2/2008(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server Analysis Server), ASP.net Applications, IIs Application Server Windows Server 2012, 2008R2, AD (Active Directory) . Third party Application.

Confidential, NEWYORK, NY

SQL DBA

Responsibilities:

• Installed, configured, and Managed SQL Server 2012, 2008 R2, 2005 database instances.
• Managed development, test and production environment of SQL server Database Server Instances.
• Upgraded from SQL server R2 and 2012.
• Involved in setting up, managing and maintaining High availability technologies: Logshipping, Mirroring and Replication
• Worked as a team member for 24X7 on call production support.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Involved in implementation of replications like Snapshot and Transactional.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Applied SP (service Pack) and Hot fixes on SQL serve database instance - standalone and HA environment (Log shipping, Mirroring, Replication and clustering Database servers)
• Managing security, which includes monitoring and controlling database access, assigning permissions to application owners.
• Involved in Partitioning Databases and Tables for better Performance issues.
• Implemented Databases log shipping using the Lite-speed.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Hand on Experience on Change control management tool - BMC Remedy user for problem tickets and Change requests.
• Have deployed packages on different servers by configuring it.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Involved in upgrading the instance of development environment of SQL Server
• Partitioning tables to achieve better performance for access and writes.
• Resolving locking (Dead Locks) and Blocking issues.
• Troubleshooting SQL server performance problems using Profiler and Performance monitor.
• Capacity-planning, Maintaining run book documentation on all the servers in word, pdf and excel formats.
• Managing and Coordinating with the off-shore team on daily Database maintenance activities
• Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Involved in SQL Server Cluster and Database Mirroring implementation.

Environment: Windows 2000, Windows NT, SQL Server 2005/2008, litespeed, Sql backup,SQL secure, ETL, SSIS, SSRS, MS Excel and MS Access, Oracle, SSAS, System Monitor / Performance Monitor.

Confidential, Boston,MA

SQL DBA

Responsibilities:

• As an administrator was responsible for Database backup and recovery such as build the master database; if crash, recover the master and user database in point in time.
• Migration of SQL Server 2008 to SQL Server 2008R2/2012 using side by side strategy.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Fine tune application logic for better performance.
• Responsible for SQL Performance tuning by using SQL tuning advisor, SQL Profiler.
• Identified and analyzed expensive T-SQL stored procedure by using the SQL Profiler (Tracing), SQL analyzer and Index tuning wizard. Optimized long running Stored Procedures & queries for effective data retrieval.
• Handled multiple tasks and responsibilities independently as well as a proactive team member.
• Design, develop and schedule the various DTS package for data migration, BCP (bulk copy program) for import / export of data.
• Experience in SQL Server troubleshooting guidelines DNS /Authentication /Data /Common errors.
• Experience in using partitioning in SQL Server 2012 by allowing tables and indexes to be partitioned across multiple file groups.
• Used SSIS (SQL Server integration services) 2012 for data extraction, transformation and loading (ETL).
• Performed regular reviews of database security and adjusted accordingly to ensure access and modification only to authorized users and/or applications.
• Involved in the design and implementation of Disaster Recovery or data recovery plan (DRP), involving database servers and application servers.
• Responsible for high availability methods like clustering, transaction log shipping, replication, database mirroring.
• Configured Active/Active and Active/passive SQL Server Clusters.
• Performed the peer to peer transactional log replication.
• Provided the data security by using encryption in SQL Server2008/08R2/12 like for protecting passwords used encryption by passphrase
• Create alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach
• Monitored the event logs and server logs by troubleshooting.

Environment: SQL SERVER 2012/2008R2/2008/2005, Microsoft Dynamics, Microsoft Dynamics GP 9.0, Microsoft SQL Server Integration services SSIS, Windows Server, DTS, SQL Profiler.

Confidential, Florence, KY

SQL DBA

Responsibilities:

• Successfully managedExtraction Transformation and Loading (ETL) processby pulling large volume of data from various data sources usingDTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data usingSQL Server Reporting Services,Report Builder.
• Designed and createdReport templates, bar graphs and pie charts based on the financial data.
• Written and executedcomplex T-SQL queries using enterprise manager for back end data validation testing.
• We handled lo t of production issues like data correction and resolves error handling
• Checked the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Loaded stored procedures and user defined functions implemented by developer teams into the databases.
• Configured the new servers using failover clustering and SAN technology.
• Migrated all the databases from old servers to new servers to test for a month.
• Generated test data and tested new databases consistency with existing databases to meet the functionalities requirements. Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
• Planned and co-coordinated database security measures.
• Writing and testing stored procedures.

Environment: SQL Server 2005/2008, T-SQL, Access, Excel, SSRS, Asp, Microsoft Visio, Windows Advanced Server, SQL Server Reporting services (SSRS).

Confidential, Tampa, FL

SQL DBA

Responsibilities:

• Responsible for Installation, configuration of SQL Server 2005 and 2008.
• Reviewed the SQL Codes while doing QA, UAT and Production Migrations.
• Improve theperformanceof SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Transfer data from flat files, Excel spreadsheets to and from SQL Server usingDTS, BCP and Bulk Insert.
• Created Email Notifications for critical events at database level.
• Created SSIS packages for Data Import from Data sources.
• Created and managed users, roles and groups and handled database security.
• Managed test data and their updates between development and production databases.
• Regularly monitor the system for bottlenecks (CPU, RAM, and Disk IO).
• Involved and Prepared Documentation for Server Consolidation according to CPU, Memory and Business.
• Use XMLdocuments to pass multiple parameters for Stored Procedures to read and write database table. Alsogenerate XML documents from tables.
• Handle development and production support, document reviews, test plans, integration of the system.
• Document all process and Data Flow involved in the database for future reference.

Environment: SQL Server 2005/2008, T-SQL, Access, Excel, SSRS, Asp, Windows Advanced Server.