SUMMARY:

• Detail oriented IT professional with 9 years of proven expertise in supporting and optimizing performance of SQL Server 2014/2012/2008 R 2/2008/2005/2000 as Database Administrator and Developer.
• Experience in Upgrade/migration of several instances and databases from SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008/2008 R2, from SQL Server 2008/2008R2 to SQL Server 2012/2014.
• Experience in documenting and implementing Disaster Recovery Plans using Database Mirroring, Log shipping and Replication with different topologies for production databases.
• Experience in Server administration in various environments - Window 2000 & 2003 with Active Directory Services (AD, DNS and DHCP).
• Monitored Sybase data servers and replication server for performance.
• Installed and administered multiple VLDB Oracle 8i, 9i, 10g and 11g databases.
• Experience in handling very large databases in OLTP and data warehouse environments, which are in Terabytes size.
• Experience in implementation of SQL Server new features like AlwaysOn Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User-Defined server roles.
• Strong in monitoring and optimizing the performance of Applications, databases, Stored Procedures, Queries and Indexes using Extended Events, SQL Profiler, server side trace, Activity Monitor, Dynamic Management Views and Functions, Execution Plans, Performance Monitor, DBCC commands, Database Engine Tuning Advisor and other third party tools like Red Gate SQL Monitor, idera SQL Diagnostic Manager, Quest Spotlight.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
• Administered DB2 subsystems in Prod, QA/Test and Development regions.
• Strong overall technical aptitude and experience with legal billing related systems and software products such as Elite and E-billing Hub.
• Strong in Power Shell scripting and automating day to day maintenance tasks using PowerShell scripts, converting existing TSQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.
• Experience in BI Development and Deployment of SSIS packages and loading data into SQL Server from MS-Access, Excel, Oracle, and Teradata.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extensive experience in end-to-end life cycle of SSRS using Scale-Out, Scale-Up and Local topologies.
• Experience in designing and deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).
• Experience in programming tasks like developing Stored Procedures, Functions, and Triggers, ad-hoc queries for reports, TSQL batches, PL/SQL packages and procedures, PowerShell scripts.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models and E-R Diagrams.
• Good working knowledge in .Net Framework 2.0/3.0/3.5,VB.Net, C#, ASP.Net, ADO.Net, XML and Web Services.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Experience in writing T-SQL (DDL, DML and DCL), Expert in implementing business logic in backend reviewing T-SQL code.
• Provided 24X7 supports through on call rotation for PROD and NON PROD Environments.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2000/2005/2008/2008 R2/2012/2014, MS Access 2003, DB2, Oracle Database 10g/11g

Languages: C, C++, T-SQL, VB Script, Java Script, HTML, XML

SQL Server Tools: SQL Server Management Studio, SQL Navigator, Microsoft Visual Studio 2008/2010/2012, SQL Server Enterprise Manager, BIDS, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, Performance Point, PLSQL Developer, Oracle SQL Developer, DB2, Toad, Excel Macro 2007/2010, Erwin, MS Visio, PerfMon, Quest LiteSpeed, Active Directory, Spotlight for SQL Server, red-gate SQL monitor, Elite Time, idera SQL Diagnostic Manager, SCOM Monitoring.

OLAP Tools: SQL Server Analysis Server 2008, 2005

Software Packages: MS Office 97/2000/XP, 2003, 2007, MS Outlook 2003, 2007

Operating Systems: Windows 2012/2008/2003/2000/ Professional/ NT 4.0 Advanced Server, Unix, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Newton, MA

Senior SQL DBA

Responsibilities:

• Developed PowerShell and T-SQL scripts for pre installation, post installation, pre migration and post migration checks for Data Center migration.
• Installed and configured SQL Server 2012/2014 on clustered (active-active environment) and non-clustered environments.
• Implemented and tested all the Microsoft recommended best practices and configurations during pre and post migration steps at instance and database level before going to production.
• Migrating databases from SQL Server 2005/2008 to SQL Server 2012/2014 as part of Data Center migration.
• Migrated the Data from an External Sybase SQL to an MS SQL Database by using SSMA.
• Developed scripts to script out existing replication topology in old data center.
• Implemented and monitored transactional replication for DR and reporting purposes.
• Setup and configured AlwaysOn Availability Groups for DR and Reporting.
• Migrated all MDX (Central management server) servers from 2008 R2 to 2012 and resolved issues during migration.
• Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Implemented Transparent Data Encryption (TDE) to protect sensitive data and backups.
• Responsible for the implementation, documentation, and day-to-day support of the Imperva Database Firewall.
• Performed data analysis for designing, developing data marts, cubes for BI Reports and analytical purposes.
• Created and designed data models using Erwin data modeling tool.
• Developed PowerShell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
• Responsible for the Design and development in PL/SQL and stored procedure.
• Used Quest LiteSpeed for backups and restore of very large databases.
• Developed database administration reports for disk utilization, backup check, daily Replication status check, Job status and other daily monitoring tasks.
• Created maintenance plans for database consistency and integrity checks, resolved issues related to database consistency and integrity.
• Deployed reports in native mode and SharePoint portal and scheduled reports to run on daily basis to send e-mails.
• Migrated 2008 SSIS packages to SQL 2012 project deployment model and configured SSIS Catalog, environments.
• Experience with SCOM to monitor and manage critical database servers from a centralized location.
• Worked extensively on data refreshes from production to test environments, automated the whole data refresh process at database level using Power Shell scripts, stored procedures, Backups and SQL Agent jobs without having any performance impact on Production server.
• Used SQL Profiler, Server side trace to identify performance issues on the server.
• Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used SQL Profiler for optimizing stored procedures.
• Monitored production servers using Spotlight and resolved database tickets that are assigned.
• Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.
• Performing root cause analysis on the production issues.

Environment: Windows Server 2008 R2 and 2012, SQL Server 2014/2012/2008 R2/2008/2005,SQL Query Analyzer, Sybase, SSRS, SSIS, SSMS, SCOM, Data Tools, Internet Information Server 6/7.5, JavaScript, CSS, HTML, .Net Framework 3.5/4.5, Quest LiteSpeed, BizTalk Server, Quest Spotlight, imperva SharePoint 2010 and SSAS.

Confidential, Sunnyvale, CA

Senior SQL DBA

Responsibilities:

• Worked extensively on Data Warehouse setup on SQL Server 2012.
• Installed and configured SQL Server 2012, involved in data warehouse design using Kimball’s methodology.
• Developed SSIS packages to load data from different source systems into data warehouse.
• Implemented Change data capture (CDC) to enable auditing of table changes and for incremental load to data warehouse (Slowly changing dimensions) using SSIS.
• Worked with business users, application developers for consolidation effort of several instances to VMWare, resolved issues during consolidation.
• Worked in migration of Non - Clustered instances from physical environment to VMWare environment.
• Worked extensively on two node cluster setup on Windows Server 2008R2 and SQL Server 2008 R2 as Active/Active Failover Cluster.
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and Filegroups.
• Upgraded and migrated several instances from SQL Server 2005 to SQL Server 2008 r2 and SharePoint instance from SQL Server 2008 to SQL Server 2012.
• Implemented SQL Server 2012 new features like AlwaysOn Availability Groups for high availability of multiple databases in place of database mirroring.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
• Experience in setting up BizTalk Server installation and configuration.
• Implemented contained databases and partially contained databases to reduce dependencies of application databases on instance and to ease portability of databases between different environments.
• Configured SQL Server 2008 R2 new feature Central management server to consolidate common jobs, remove duplicate jobs, to have multi-server jobs and maintenance plans.
• Used SCOM to monitor the health and performance of the critical database servers with help of various alerts and historic information stored on SCOM database.
• Configured master server to have a centralized maintenance for jobs and maintenance plans and to troubleshoot and run all the dependent jobs across the production servers.
• Performed online index rebuilds for critical tables and helped in reducing locks, improving query performance and made tables available during index rebuild operations.
• Worked on Elite Enterprise application, table structure, and provided support to related financial applications and interfaces.
• Worked on billing experience utilizing Elite Enterprise.
• Used SQL Server error logs and event viewer to troubleshoot issues, Windows performance monitor to find resource usage, profiler and server side trace for tuning SQL queries, stored procedures.
• Performed Data Analysis for automating various Customers Insurance Reports utilizing SQL Analysis Services.
• Worked with developers to tune the SQL queries and improve the Performance.
• Configured security and access as per SOX standards.
• Designed database standards as per HIPAA and PHI specifics.

Environment: Windows Server 2008R2/2008/2003,SQL Server 2012/2008R2/2008/2005, SSRS, SSIS, SSAS,SCOM,SQL Query Analyzer, Data Tools, BIDS, TFS, SharePoint 2010,BiZTalk Server, Crystal Reports, SSMS, PLSQL Developer, Oracle SQL Developer, Oracle 11g, Internet Information Server 6.0,7.0, Elite Enterprise, JavaScript, CSS, HTML, .Net Framework 3.5,4.0,BizTalk Server, VB.Net, C#, ASP.Net, ADO.Net and Quest LITESpeed.

Confidential, Lexington, MA

Senior SQL Server DBA

Responsibilities:

• Migrated from SQL Server 2000/2005 to SQL Server 2005/2008.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Implemented and monitored the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Worked in 24X7 production support with a rotation basis.
• Proactively monitored, determined and solved issues at SQL/database/server levels with the help of SCOM server and its agents
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Restored and recovered databases to point in time for testing, pre-prod and production environments.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Used 3rd party tools like idera SQL Diagnostic Manager in taking the backups to optimize performance and restoring.
• Evaluated the peak and no peak usage pattern of the application; effectively distributed database administration activities, such as full database backup and database defragmentation during no peak hours.
• Used SQL Profiler, Windows Performance Monitor and DBArtisan for troubleshooting, monitoring, optimization of SQL Server.
• Monitored database status including CPU, Memory, I/O, Space and deadlock using SQL Server Utilities.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Involved in ProLaw updates including design of SQL triggers, and correcting database errors.
• Experience in setting up BizTalk Server installation and configuration.
• Configured and worked on SSRS in SharePoint integration and native mode.
• Configured security and access as per SOX and PCI standards.

Environment: MS SQL Server 2008R 2/2008/2005/2000, Windows Enterprises, Standard 2003/2008 servers, IIS server, BizTalk Server, Toad for SQL Server, LiteSpeed, JavaScript, CSS,HTML, Microsoft CRM, SSIS, SSRS, SCOM, SharePoint 2010, Prolaw, VERITAS NetBackup,ERWIN,C#,VB.Net and ASP.Net.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Installed and configured SQL Server 2008 and maintained 50 servers.
• Upgraded and migrated the servers from SQL Server 2000to SQL Server 2005/2008.
• Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages and resolved issues during migration.
• Migrated Stored Procedures from 2000 to SQL Server 2005 to refer to Dynamic Management Views.
• Implemented Replication and Log Shipping to overcome Disaster Recovery plan.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and Filegroups.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Monitored the application & database performance using SQL Profiler, Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases and rebuilding only necessary indexes for faster query response.
• Extensively used Database Tuning Advisor to improve the performance of Query.
• Implemented backup and retention strategies based on business policies.
• Performed Backup/Restore by using VERITAS Net Backup.
• Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.
• Improved performance of slow running queries using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.

Environment: SQL server 2005/2000, MS Reporting Server 2005, Windows 2000/2003 Server, SSIS, Visual Studio, IIS 5.0, VERITAS Net Backup and VB.Net.

Confidential

DBA/ Developer

Responsibilities:

• Planned and Successfully Installed SQL Server 2000, 2005 on the Production and
• Development Servers.
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Involved in creating Logins, Tables, Clustered and NonClustered Indexes, Views, Functions and Stored Procedures.
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Transactional.
• Implementing Database maintenance plan for Database consistence & Integrity
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks.
• Monitoring SQL server performance using profiler to find the performance and deadlocks.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.

Environment: SQL Server 2000/2005/2008/2008 R2, Microsoft Business Intelligence, Visual Studio for SSIS, SSRS, SSAS, MS Office Access, Windows Server 2003/2008.