SUMMARY

• Over 8 years of IT experience in Database Administration, Design Development and Support of MS SQL Server in Production, Test, Development and Cluster Server Environments.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Server Management Studio, SQL Profiler and SQL Query Analyzer.
• Migration experience from MS SQL Server 2000 to MS SQL Server, MS SQL Server 2005 to MS SQL Server 2008 & SQL Server .
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third - party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, Always on High Availability, data integration and synchronization.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Good knowledge on Advanced features like MSDTC, and Full Text Indexing etc. Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server.
• Good experience with SQL Server Online Database Indexing and Recovery. Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive).
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Successfully Migrated SQL 2000 DTS packages to SSIS using DTS Xchange tool.
• Made some server level changes for SSAS project.
• Production Support Experience in Administration of MSSQL Servers.
• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Object Level Audits using Change Data Capture (CDC).
• Used Idera SQL safe backup which provides a high-performance backup and recovery solution.
• Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005 Reporting Services (SSRS).
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio.

Languages: C#.ASP.NET, T-SQL, MySQL, VB.Net, HTML, XML, C/C++, CSS, DHTML, Java Script.

OS: Windows UNIX (Sun Solaris), LINUX.

Databases: MS SQL Server, ETL Tools Data Transformation Services (DTS), SQL Server Integration Services (SSIS).

Reporting Tools: SSRS, SSAS, Crystal Reports, DB Utilities SQL Server Management Utility, Query Analyzer.

Application Software: Visual Studio, Visual Source Safe, TFS, MS Office Suite, Data Modeling Tools Erwin, Red Gate, LiteSpeed.

PROFESSIONAL EXPERIENCE

Sr.SQL SERVER DBA

Confidential - McLean, VA

Responsibilities:

• Administration and support on large number of SQL Server instances in multiple data centers including Production, Validation, QA, Staging, Test and Development Environment.
• Successful in Knowledge Transition from Gilead Spoc, and prepared a High level document for Document of Understanding and Playback session.
• Installed MS SQL Server Performed Database Design and created User Databases
• Installed SQL Server hot fixes from SQL Server.
• Worked mostly on Windows servers.
• Experience in ITSM ticketing tool by fulfilling SLA.
• Monitoring Production servers with the help of FOGLIGHT and SCOM
• Supported various applications out of which ITSM, G-Net, EQMS, Business Intelligence, GVD,
• E-Vault, Infrastructure are some of important applications.
• Centralized the environment by fixing the issues with their necessary maintenance plans and service accounts.
• Worked with Application System Managers directly and provide suggestions under database side.
• Worked on various qualified applications and prepared standard ITOP before implementing on production environments.
• Close monitoring of critical production applications
• Involved in Planning/Implementation/Support for database migration from SQL Server 2005 to SQL server 2008R2.
• Implemented Database Mirroring for critical operational databases to provide no loss of data.
• Successful in implementing and setting up the replication (Snapshot /Transactional/ Merge/Peer-Peer).
• Successfully implemented Log shipping by placing the secondary database in Read-only mode.
• Configured and Implemented Active/Passive and Active/Active clustering for large size databases.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Creation of Maintenance plans of the SQL Jobs using SQL Server Agent
• Worked on Disk monitoring in various Production servers by cleaning unused space and making space available for database growth.
• Moving TEMPDB folder to another drive on Production Environment to improve Performance.
• Moving System databases to different drives for data security and availability.
• Scheduled Maintenance plans for Backups, Rebuild-Index and Update statistics.
• Install OLA script and configure to automate maintenance plains.
• Install Database monitoring software Imperva client version in windows machines.
• Have Experience in working with Onsite/Offshore team.
• Available production support for 24*7 whenever required.

Environment: SQL Server T-SQL, Excel, Power point, Windows Server, Visual Source Safe 6.0, ITSM, Foglight, Scom, Net App Snap manager, DB Monitoring software Impreva.

Sr.SQL SERVER DBA

Confidential - Ivyland, PA

Responsibilities:

• Optimized the performance of queries with modifications in T-SQLqueries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Worked onSQL*Loader to load data from flat files obtained from various facilities every day.
• Created PL/SQLstored procedures, functions and packages for moving the data from staging area to data mart.
• Migrated DTS packages fromSQLServer2000 toSQLServer2008 as SSIS Packages.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access intoSQLServer2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages andSQLscripts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Deploying the Packages and Reports on to theserver.
• Created different Power Pivot reports as per the client requirement.
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.
• Scheduled the Packages inSQLServerAgent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts

Environment: SQLServer2008R2 & 2012 Enterprise Edition,SQL, T-SQL, MS Access, MS Excel,& Windows 2003server, Business Intelligent Integration Services (SSIS … Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance PointServer2007, MS Excel.

SQL Server DBA

Confidential - Greensboro, NC

Responsibilities:

• Installed SQL Patches on all SharePoint Database servers including standalone, Active/Passive or Active/Active or n+1 clusters.
• Participated in Database Monitoring POC Tests for different products like Quest Foglight, IBM ITM, IPSoft, and Valkyrie.
• Installed 2nd Cluster SQL Instance on multiple Windows clusters to support migration of SharePoint 2007 farms to SharePoint 2010.
• Troubleshooting performance issues using bank internal tools like precise, native SQL Server tools like profiler, DMVs and Database Tuning Wizard and windows Performance Monitor.
• Given solid capacity planning to LOBs for their future Data growth.
• Coordinating with Offshore DBAs and sharing changes or any scheduled work seamlessly to appear as on one global team to Customers.
• Diligently remediating any SQL Server database violations reported by Enterprise Security Management.
• Actively participated in implementing Change Requests.
• Troubleshooting SQL Server production issues handed over by the offshore team.
• Installing, upgrading/migrating, Configuring database servers applying Service Packs and Cumulative Updates.
• Periodically conducting health check on all the database servers that I am responsible for and ensure the stabilization of the servers all the time.
• Participating on Schedule DR Exercise conducted by LOBs.
• Preparing database Standard Operating Procedure documents and DR Plan document for the servers that I support.
• Installing and Supporting SQL Servers in Multi Node Cluster Environments.
• Rolling out bank approved latest SQL Server service packs starting from Lower environments to higher environments.
• Involved in SQL Patching activities on both standalone database servers and Failover Cluster Instances.
• Controlling changes by implementing them first in Lower environments followed by Production by following the change management process.
• Validating daily/weekly/monthly checklist against all business critical database servers.
• Automating refreshes to lower environments.
• Ensure all production jobs are running successfully.
• Monitoring and troubleshooting SQL Server Jobs (SQL Server Agent and Maintenance Plans Jobs).
• Remediation of Security issues in database servers reported by Enterprise Security Management tools.
• Installing Oracle, Sybase, DB2, Teradata client software on SQL Servers and setting up DSNs and setting up Linked servers.
• Configuring and troubleshooting and management of Log Shipping, DB Mirroring, Clustering and Replication on database servers
• Managing SQL Server security by granting required access to Active directory groups wherever possible.
• Coordinating with BTG/LOB teams and educating them importance of upgrading servers/applying service packs etc.

Environment: Windows Server 2008, Windows Server 2008R2, SQL Server 2005,SQL Server 2012, SSIS, SQL LiteSpeed, Precise, SCOM, ServiceNow.

SQL SERVER DBA

Confidential - Winston-Salem, NC

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables
• Wrote complex stored procedures to process employee's requirement and generating.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Debugged the T-SQL queries for performance tuning.
• Checked & updated Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008, Windows XP, Windows NT 4.0, Erwin 3.5.2, Enterprise Manager, SSIS, SQL Query Analyzer, SQL Light speed Backup Software.