SUMMARY

• Having 8+ years of experience in Database Administration, Development and Design Extensive experience with SQL Server 2014/ 2012/2008/2008 r 2/2005/2000.
• Experience in supporting Very Large OLTP Databases of size 5 TB and troubleshooting the performance bottle necks.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Setup and configured AlwaysOn Availability Groups for DR and Reporting.
• Procedures, managing indexes and locks, troubleshooting deadlocks and blocking, Checking the threshold values and baselines.
• Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Verifying and tuning stored procedures created by developers by using Execution plans, SQL Server Profiler, Data Tuning Advisor.
• Debugging stored procedures, optimizing code and improving efficiency in database including re - indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering (Active/Active and Active/Passive).
• Proficient in SQL programming, physical database design, and SQL Performance tuning, replication.
• Development of Automated notification when SQL Server Backups and schedule maintained jobs
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata.
• Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Extensive experience in Deploying and Consolidating Remote Instances.
• Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Experience with analyzing query plans, writing stored procedures, try-catch blocks, using extended Stored
• 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.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Designing and Deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
• 24/7 Production Databases on Call Support. Excellent Analytical, problem solving and communication skills.
• Excellent Communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS

Databases: MS-SQL Server 2000/2005/2008/2012/2014 , MS Access 2003,2007,2010, Oracle 10g and 11g

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

SQLServer Tools: Management Studio, DTS, SSIS,SSRS,SSAS, Erwin, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import, Precise i3 for SQL Server.

Operating system: Windows 2012/2008/ 2003/ 2000/ Professional/ NT 4.0 Advanced Server

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Load Test Tools: WAPT 7.5, WAPT Pro 3.1

PROFESSIONAL EXPERIENCE

Confidential, Ivring, TX

Sr SQL DBA, SSIS/SSRS Developer

Responsibilities:

• Extract, Transform and Load source data into respective target tables to build the required data tables.
• Created Technical Specification document.
• Created Partition Tables based upon Partition Functions and Partition Schemas.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created Complex ETL Packages using SSIS which upserts data from staging table to database tables.
• Fine tuned SSAS cube.
• 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.
• Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.
• 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.
• Worked with Disaster Recovery Team to define, implement and maintain global disaster recovery plans.
• 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.
• 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.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored production servers using Spotlight and resolved database tickets that are assigned.
• Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.
• Performingrootcauseanalysis on the production issues.

Environment: Windows Server2008 R2 and 2012, SQL Server 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, Tampa, Fl

SQL Server Developer/ DBA, SSRS/ SSIS Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries using execution plan for tuning the database. Implemented different types of constraints on tables.
• Used Try catch and error for exceptional handling.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Developed logical and physical data models using data modeling tools such as Erwin and ER/Studio
• Used Active Directory for Identity management designed to provide strong authentication and authorization for internal and external websites.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Created queries for generating drill down reports in SSRS 2008/2005.
• Formatted the SSRS reports using the Global variables, expressions and Functions.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) 2008/2005 and Worked with users in training and support and also have experience in incremental data loading.
• Managed upgradation of DTS packages to SSIS packages
• Responsible for developing, monitoring and deploying SSIS 2008/2005 packages.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Identified and defined Fact relationships in SSAS.
• Involved in developmentof ASP .NET / C# / SQL Server web application.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Responsible for providing 24X7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.
• Implemented and successfully tested Log Shipping in SQL Server 2000 and SQL Server 2005. Experience using REDGATE to compare and synchronize all database objects.

Environment: SQL Server 2012/ 2008/2005/2000 Enterprise Edition, SSRS, SSIS, SSAS, SQL Server 2005 Partitioning .NET Framework, C#, ASP.NET, ADO.NET, Oracle 9i/ 10g, Visio 2003, MS IIS, Windows 2000/2003 Advance Server, XML, MS Excel, Access and Visual source safe.

Confidential, Columbus, OH

Sr.SQL DBA/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
• Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Used XML and environmental variables in the package configuration for Deploying SSIS packages.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created Cross-Tabs, Drill-down and Sub-Reports using SSRS. Deployed RDLs to Report Server.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Designed SSAS cube to hold summary data for Targit dashboards.
• Created User Defined Hierarchies depending on the business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different measure groups and calculations using SSAS.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
• Successfully migrated content from MS Access to SQL Server 2000,SQL server 2000 to SQL server 2005, SQL Server 2005 to Oracle 10.g,
• Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created datasets for reports using T-SQL and stored procedures
• Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
• Involved in creating windows installer to install the application in SIT/UAT/Production environments.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2000, .Net 2002, MS SQL 2005/2008, 2008 RS, SSIS,SSRS, Windows 2000 Advance Server, ASP, VB .Net, XML, T-SQL, MS Excel, SharePoint Portal Server 2003/2007, Targit, MS Access. Visual Studio 2005, Oracle 9i/10g

Confidential

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.

Confidential

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.

Environment: SQL Server 2008 R2/2005/2000, SSIS, SSRS, Report Builder, T-SQL, Windows 2003, DTS, Erwin, SQLProfiler, MS Office.