SUMMARY:

• 9+ years of experience as SQL Server DBA (2014, 2012, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP) with Healthcare, Financial, Insurance and Retail Management Domains.
• 24/7 on Call Support for Production Databases.
• Experience in implementation of SQL Server new features like Always On Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User - Defined server roles.
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions Using Log Shipping, Transactional in SQL Server 2008/2005.
• Extensive experience in Deploying and Consolidating Remote Instances.
• Extensive experience in Installation, Configuration, Patches, Upgrades and Administration for SQL Servers in Clustered (Failover) and Non-Clustered Environments.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and partial blocking Transformations.
• Experience in working with PIVOT topologies for MS Excel with SSAS 2008.
• Extensive experience in end to end life cycle of SSRS using Scale-Out, Scale-Up and Local topologies.
• Designing and Deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Object Level Audits using Change Data Capture (CDC).
• Managing database systems using Query Governor and Activity Monitor.
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 201 2/ 2008/2005/2000 /7 with T-SQL
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Good knowledge in OOP’s concepts and Business Objects & Database analysis and design experience using Erwin.
• Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries.
• Working knowledge of .Net Framework 2.0 (VB.Net, ASP.Net, ADO.Net), IIS 6.0
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication & Management skills and Excellent Team player.
• 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.

TECHNICAL SKILLS:

Databases: SQL SERVER 2014/2012/2008 R 2/ 2008/2005/2000, MS-Access, DB2, Oracle Database 10g and 11g.

Operating System: Windows Server 2003 / Server 2008 / Server 2008R2/ Server 2012, Server 2014, Unix, Linux.

Programming Languages: TSQL, PL/SQL, PowerShell, C, C#, VBScript, HTML, XML.

Web Technologies and Network Topologies: Asp.Net, HTML, DHTML, XML, IIS 6.0/7.0/8.0, Java Script, TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Security Tools: Microsoft Baseline Security Analyzer (MBSA), NGSSquirrel for SQL Server, Scuba by imperva.

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, PerformancePoint, 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.

PROFESSIONAL EXPERIENCE:

Confidential, Richfield, MN

Sr. 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 Always on Availability Groups for DR and Reporting.
• Migrated all MDX (Central management server) servers from 2008 R2 to 2012 and resoled issues during migration.
• Worked with Disaster Recovery Team to define, implement and maintain global disaster recovery plans.
• 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 PowerShell 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.
• Designed database standards as per HIPAA and PHI specifics.

Environment: Windows Server2008 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.

Sr. SQL Server 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.
• Worked on GIS to store the large amount of data in a large database.
• Developed SSIS packages to load data from different source systems in to 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 VM Ware, resolved issues during consolidation.
• Worked in migration of Non - Clustered instances from physical environment to VM Ware environment.
• Involved in regular DR exercises.
• 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 File groups.
• 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 201 2/ 2008/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.

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 LITE Speed.

Senior SQL Server DBA

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008R2/2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.
• 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 DB Artisan for troubleshooting, monitoring, optimization of SQL Server.
• Monitored database status including CPU, Memory, I/O, Space and dead lock 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 Web server, BizTalk Server, Toad for SQL Server, LiteSpeed, JavaScript, CSS,HTML, Microsoft CRM, SSIS, SSRS, SCOM, SharePoint, Prolaw, VERITAS NetBackup,ERWIN,C#,VB.Net and ASP.Net.

SQL Server DBA/Developer

Responsibilities:

• Installed and configured SQL Server 2008 and maintained 50 servers.
• Upgraded and migrated the servers from SQL Server 2000 to 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 File groups.
• 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 2008/2005/2000, MS Reporting Server 2005, Windows 2000/2003 Server, SSIS, Visual Studio, IIS 5.0, VERITAS NetBackup and VB.Net.

DBA/Developer

Responsibilities:

• Planned and Successfully Installed SQL Server 2000, 2005 & 2008 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 Non-Clustered 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 dead locks.
• 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.