SUMMARY

• Over 8+ yearsof experience in Database Administration and Development for very large and complex databases related to Financial, Medical and Insurance etc.., in SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 .
• Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client - server environments.
• Experience in migrating SQL Server 2000/2005/2008 to 2008R 2/2012/2014/2016 .
• Experience in implementing Always on Availability Groups in SQL Server 2012.
• Expert in RDBMS S/W installation, applying patches, upgrading, configuring, trouble shooting of SQL SERVER on Windows 98/2000/03/03 R2/08/08R2/2012 servers and Clustered VMware Environments.
• Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered Environment.
• Good knowledge on new features Data Compression, Transparent Data Encryption (TDE), Policy Based Management, Backup Compression and Change data capture in SQL SERVER 2008.
• Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
• Handled up to 3 TB databases in Clustered environment with good Physical storage configuration and Optimizing of SAN with different Raid Levels.
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Experience in configuring Replication and troubleshooting the issues with transactional replication.
• Very good T-SQL Programming skills. Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Hands on configuring Temp DB with considerable Memory and Raid Levels for better performance.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defragging Tables, Replication, Linked Servers and Database Maintenance Plan.
• Maintained User Permissions, Logins and Security Issues. Monitored Event Viewer’ s, SQL Error logs and Log Files Viewer for S/W and H/W errors.
• Good knowledge in using DMVs and DMFs to be finding and solving Performance Issue.
• Hands on experience in Planning and Scheduling Maintenance Tasks and Scheduling Jobs and Alerts using SQL Mail.
• Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Involved in Change Control Management Process for maintaining the consistency of databases.
• Working knowledge of SOX Compliance for maintaining roles and responsibilities, data integrity and database management.
• Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Maintaining the Service Level Agreements (SLA’s) according to the client’s requirement.
• Very Strong Experience withOLTPandOLAPEnvironment.
• Written PowerShell scripts that are customized for a particular dataset - such as a morning health check, which outputs different base information on reporting every morning.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, optimizing code and improving Efficiency.
• Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS.
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
• Expert in migrating the DTS Packages to SSIS Packages by using Package migration Wizard.
• Expert in Deploying, Scheduling and running SSIS jobs by using Proxy Accounts.
• Experience in managing OLAP Database Warehouse by using services like Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Data Modeling Experience including Physical and Logical data modeling using Erwin tool
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Good Team player, Strong Communication skills and interpersonal with Self-motivation.
• 24/7 on call production support.

TECHNICAL SKILLS

Operating Systems: Windows Server 2012/2008R 2/2008/2003/2003 R2/98/XP/Vista/7, Unix (Sun Solar), Linux.

Databases: MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , MS Office Access 97/2000/2003 , Oracle.

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

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

Other Tools: Erwin, Red gate, LiteSpeed, Spot Light Foglight, Idera,Visio, Powershell

Languages: T-SQL, C/C++, C#, java script, Visual Studio 2005/2008/2010 /2012 , ASP.NET, VB.Net

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Reviewed and analyzed requirements for New Projects with Application and Business teams.
• Coordinated with SAN Team and involved in Capacity Planning and Storage allocation for Test, Dev, Stage and Prod environments.
• Installed SQL Server 2008R 2/2012/2014/2016 manually and by using HP Server Automation tool.
• Installed, configured and administered SQL Server Integration and Reporting Services.
• Migrated Servers from SQL Server 2000 and 2005 and 2008R2 to 2008R2 and 2012,2014 and 2016 based on the application team requests.
• Based on the business need created Transactional Replication on Different applications.
• Configured and maintained database mirroring for high availability.
• Implemented Always on Availability Group as a High Availability solution on SQL Server 2012.
• Applying the Hot fixes and patches based on the requirements for different stores within the maintenance window.
• Applying the Service packs and Cumulative Updates based on the Requirement to fix the issues.
• Routine DBA activities: Backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management.
• Created Database Maintenance Plan to implement Database backups, Integrity Checks and indexing.
• Evaluated 3rd party SQL Server Monitoring Tools that could be used for database administration.
• Configured SQL Server 2008R2/2012 Active/Passive Clusters in different environments applying the installation and configuration standards.
• Handling of the database backup failures, fixing the issues and make sure the availability of daily backups.
• Resolving the Database, I/O Consistency errors and Allocation errors.
• Performing Health checks and Monitoring performance of the Production Servers.
• Implemented SQL Server Security Standards by granting minimal permissions, using database Roles, Windows Authentication and Active Directory Groups.
• Providing the access to users based on the Requirement to the Production/UAT/QA/Development Servers with Appropriate Approvals.
• Handling of the low Logical disk space issues, Temp DB issues, Data file and Log file issues.
• Monitored the event logs and server logs fortroubleshootingand problem solving.
• Used PowerShell to automate admin tasks.
• Querying the databases using the PowerShell scripts.
• Used the PowerShell scripting to get the most consistent production environment.
• Database refreshments from Production to DEV/UAT/QA environments.
• Maintained SQL Inventory documented backup strategies, SQL Server best practices, and installation and configuration procedures.
• Used DMVs, Alerts, SQL Profiler, Performance Monitor to proactively monitor and tune the Database Environment
• Adhered to the Change Management procedures.
• Evaluated new features in SQL Server 2012, 2014 and SQL Server 2016 in lab environment namely Enhanced to Backups, contained databases, Security Principals and AAG.
• Provided 24/7 Production Support (on-call) and resolved all tickets related to SQL Server Database and tickets opened by application and operations team including SSIS/SQL Job failures, Disk space, Blocking.

Environment: MS SQL Server 2000/ 2005/2008/2008 R 2/2012/2014/2016 , Windows 2003/2003R2/2008/2008R2/2012 servers, Sybase, DB2, Outlook Express, SQL Monitor-Red Gate, BIDS, SQL Diagnostic manager-IDERA, ehealth, CA Service Desk, BMC Remedy Tool, Net Veritas Backup Tool, PowerShell, SSIS, SSRS, Visual Studio 2005/2008/2010 /2012 , Quest Software TPAM, IT Service Catalog, Incident Request, ECHO, OMDB TMEIM, HP Server Automation Tool.

Confidential, Fairfax, Virginia

SQL Server DBA

Responsibilities:

• SQL Server 2012/2008R2/2005/2000 Database Administration.
• Migrated databases from SQL Server 2005 to SQL Server 2008R2 & to SQL Server 2012.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Implemented and maintained Always ON new concept in SQL Server 2012.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2008R2.
• Worked on SQL Server 2012 Features.
• Captured DDL changes using CDC (Change Data Capture) on Table and Database level. Experience in Database security and integrity planning.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• 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.
• Configured more than 2 GB ram on 32 bit Environment.
• Successfully implemented the Capacity planning for different servers.
• Implemented new T-SQL features like Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Migrated DTS packages to SSIS packages.
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Worked in Active passive cluster environment.
• Recovered the System and User databases from suspect mode.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Extensively worked on trouble shooting and fine-tuning of databases for its performance.
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues, Backups and Restores on Production and Semi-Production Servers and handling maintenance Jobs.
• Performance Tuning of the Stored Procedures.
• Rebuilding the indexes at regular intervals for better performance
• Analyzed query execution plans and tuning queries and databases for optimal performance
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Performed all basic Database activities like moving databases between servers, copy databases etc
• Used Update statistics, database integrity check and Backup operations
• Used SQL server Reporting Services (SSRS) to create reports.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call 24/7 Support on weekly basis.

Environment: Windows Server 2003/2003R2/2008/2008R2/2012, MS SQL Server 2012/2008R2/2005/2000, SAN, Visual Studio 2005/2008/2010 /2012 , Business Intelligence Development Studio - SSIS, SSRS, SSAS, Performance Monitor, Clustering,VERITAS Netbackup, LiteSpeed, Idera, Fog light, Idera, SQL Profiler,Database Engine Tuning Advisor,T- SQL.

Confidential

SQL Server DBA

Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER 2000/2005/2008 to 2008R2/2012 on Windows.
• Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
• Configured the AWE and 3 GB switch for the 32-bit 2005 server.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2008R2.
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA, SQLCMD and dedicated admin connection, Common table Expression(CTE).
• Used CDC (Change data capture), Table valued parameters and other new features in new applications.
• Implemented DATABASE MIRRORING ON MS SQL SERVER 2008R2.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Extensively used lightspeed backup with MS SQL SERVER 2008R2.
• Utilized the new features of 2008 like TDE, MERGE STATEMENT and Compressed Backups.
• Good knowledge on new concepts of 2008 like PowerShell.
• Documented and performed the database health checks regularly.
• Re-factored and fine-tuned the queries and stored procedures in T-Sql.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Implemented log shipping for Production server database as part of the disaster recovery.
• Created baseline and sampling intervals in the perfmon considering threshold values of the counters.
• Rebuilding indexes with different fill factors and update statistics manually.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
• Deployed SSIS package for bulk insert and maintained archival data.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: TSQL, MS SQL SERVER 2000/ 2005/2008/2008 R2/2012, SSIS/SSRS/SSAS, SAN, NetAPP, EMC, Query Analyzer, Business Intelligence Development Studio (BIDS)Visual Studio 2005/2008/2010 /2012 , VBScript, .NET, C#, Windows Server 2003/2003R2/2008/2008R2, LiteSpeed, SpotLight, Redgate, IIS.

Confidential

SQL Server DBA

Responsibilities:

• Database Administrator, Database Programming.
• Migrated SQL server 2000 databases into SQL server 2005 and 2005/2008 to 2008R2 databases by In-place upgrade and Side-by-Side migration.
• Designed and implemented Security policy for SQL Servers.
• 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. Implemented and Scheduled Replication process for updating our parallel servers
• Automated messaging services on server failures, for task completion and success.
• Intensively used Litespeed to take backups.
• 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
• Configured log shipping for synchronization of database.
• Good experience in data modeling a metadata service.
• Expertise in SQL Server Analysis Services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• To provide 24x7 production support for over 150 SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Involved in Change Data Capture process.
• To provide direction and development DBA support to over 50 software developers located in various branches in US, Europe, and Asia.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
• To setup, implement, and maintain industry standards in database management.
• To maintain change control and release management process for all database objects like tables, views, procedures, and triggers.
• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• To design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.
• Provided 24/7 Support for Production, Development & Test Servers.

Environment: SQL Server 2000/ 2005/2008/2008 R2, Clustering, Replication, Windows Server 2003/2003R2/2008/2008R2, Visual Studio 2005/2008/2010 , SSIS/SSRS/SSAS, SQL Profiler, Database Engine Tuning Advisor, ERWIN, Litespeed, Sybase, T-SQL, SpotLight, VB Script and ASP.NET.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Installed SQL SERVER 2005/2008/2008 R2 in PROD/TEST/DEV from scratch.
• Installed and administered two node cluster Active/passive.
• Migrated and Documented SQL SERVER 2000/2005/2008 to 2008R2.
• Configured the compatibility levels of the database and updated software with service packs.
• Implemented Transactional Replication, Log shipping and Mirroring for database high availability.
• Regularly installed service packs and hot fixes for both clustered and standalone environment.
• Implemented and Maintained routine DBA tasks like job scheduling, creating maintenance plans.
• Creating logins and mapping the user to roles by assigning permissions.
• Configured the alerts and jobs for the regular monitoring of the database Server.
• Detected and Resolved locks and deadlocks using the trace flags and native tools like profiler and the activity monitor.
• Designed and applied schema change scripts to existing objects to synchronize with changing business rules.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity andadditional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2005.
• 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.
• Used DTS Xchange tool for Migrating DTS packages to SSIS.
• Troubleshooted SSIS packages which failed to execute in the scheduled jobs.
• Transferred data from various data sources/business systems including MS Excel, MS Access, FlatFiles etc to SQL Server using SSIS.
• Performed development support, document reviews, test plan, integration of the system.
• Developed and debugged the SSIS packages with lookup, union all, Conditional split and Script task extensively.
• Involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Experience in improving SQL Server performance by using Index tuning wizards, performance tuning methods, execution plans and SQL Profiler.
• Retrieved data from partition of the Cube from DATA WARE HOUSE(OLAP ) using the BIDS
• Interacted with the testing team to fix the bugs.
• Involved in 24/7 production support.

Environment: SQL SERVER 7/ 2000/ 2005/2008/2008 R2, MS-Access, Visual Basic, Windows Sever 2003/2003R2/2008/2008R2, Visual Studio 2005/2008/2010 , LiteSpeed, SpotLight, Database Engine tuning Advisor, SSIS, SSRS, SSAS, BCP, SQL Profiler, Enterprise Manager, SSMS, SQL Query Analyzer Business Intelligence Development Studio, Index Tuning Wizard, Data Transformation Services (DTS)