PROFESSIONAL SUMMARY:

• Around 9 years of experience in Data design, development, implementation, architecture, performance, integrity and security of SQL Server databases on a High Availability, clustered server farm with failover to Azure for disaster recovery and proficient with MS SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016.
• Expert in System Analysis and Design, Development, Support MS SQL Servers (2000 to 2014) in Production, Development and Testing in Clustered and Standalone Server Environment.
• Expert in installing MS SQL SERVER 2016, 2014, 2012, 2008r2, 2008, 2005, 2000 updating with the hot fix and service packs.
• Migrating and new installations of SQL Server on Hyper - V & VMWARE environments and Supporting the SQL Server instances, which are lying on the Windows Hyper-V servers.
• Expert on installing and using the new features of SQL 2012 and 2014.
• Implemented Always On Availability Group as High Availability and Disaster Recovery solution on SQL Server 2012 and 2014
• Proficient in configuring, implementing, and monitoring different types of High Availability and disaster recovery scenarios like AlwaysOn, Mirroring, Replication, log shipping, and clustering.
• Hands on Experience on Changed Data Capture (CDC), Policy Based Management, Data Compression, Resource Governor, Performance Data Collector, Partitioning and Transparent Data Encryption (TDE).
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Experience on Cloud Computing on Microsoft Windows Azure.
• Suggesting the rite hardware for hosting SQL Server on Hyper-V like suggesting the different types of VHD's supporting Dynamic, Virtual, and Pass through.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance, activity monitor, Event viewer for performance analysis.
• Experience in administrative activities comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, and Updating Statistics.
• Expertise in Configuring and managing Database Mirroring, Log Shipping and Replication.
• Well Knowledge on SQL Server Consolidation & Virtualization (VMWare, Hyper-V)
• Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
• Configured Security at ACTIVE DIRECTORY AND SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions).
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic SQL queries.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS).
• Experience in handling Partitioned cubes in SSAS both in star and snow flake schema.
• Experience in creating CUBES in BIDS with Fact and Dimension Tables.
• Created linked servers between Oracle 10g and MS SQL SERVER 2005 and also deployed SSIS packages for data transfer.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers, My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines
• Involved in all phases of the SDLC (software development life cycle).
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS:

RDBMS: MSSQL Server 2000/2005/2008/2012, MS ACCESS.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQL Query Analyzer, SQL Refractor, SQL Server Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP

BI Tools: SSIS, SSRS, SSAS, Crystal Reports, Power BI, BIRT, Plateau Report Designer, Tablue.

Other Tools: SQL DB Access, Performance Monitor, Backup Utility, SQL LiteSpeed, Visio 2000.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook

Management Tools: SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator.

Languages: T-SQL, MS SQL, MDX, C/C++, VB, VBA, HTML, XML.

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

O/S: Windows 2008/2007/2003/2000/ NT Servers, XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

MS SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2000, 2005 and 2008 to 2008 R2, 2012,2014 and 2016.
• Migrated Databases from SQL Server 2000, 2005 and 2008 to 2008 R2, 2012 and SQL 2008r2 to SQL 2012.
• Installed and configured SQL 2012 AlwaysOn Availability Groups.
• Installed and Configured Active-Passive, and AlwaysOn Availability Groups environment as a High availability DR solution.
• Migrating and new installations of SQL Server on Hyper-V & VMWARE environments and Supporting the SQL Server instances, which are lying on the Windows Hyper-V servers.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Upgraded SharePoint 2007 to SharePoint 2013 (SQL server 2005 to SQL Server 2012)
• Performing Backup/Restore to/from Legato server (Tape) and Disk
• 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.
• Expert in configuring TempDB.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Prepared Documentation for the Disaster Recovery plan
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server2016,2014,2012, 2008 R2,T-SQL, Erwin, ASP.Net 3.0, SSAS, SSIS (ETL), SSRS, SharePoint Server 2007, 2010 and 2013, Windows 2008 and 2012 Servers.

Confidential, Salt Lake City, UT

SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2000, 2005 and 2008 to 2008 R2, 2012, 2014.
• Migrated Databases from SQL Server 2000, 2005 and 2008 to 2008 R2, 2012 and SQL 2008r2 to SQL 2012 and 2014.
• Migrating and new installations of SQL Server on VMWARE environment and supporting the SQL Server instances, which are lying on the VM servers.
• Installed and configured SQL 2012 AlwaysOn Availability Groups.
• Installed and configured clustering and AlwaysOn Availability Groups environment as a High availability DR solution.
• 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.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Routine DBA jobs like Backups and Restores.
• Experience in Encryption on table level, TDE encryption (database level) and SSL encryption (server level).
• Setup and maintained Linked Servers.
• Used SQL compare tool to generate SQL upgrade advisory reports for the application teams.
• Monitored SQL server performance using spotlight.

Environment: MS SQL Server 2014, 2012, 2008 R2, 2008, 2005 and 2000, T-SQL, SSAS, SSIS (ETL), SSRS, SharePoint Server 2007, 2010 and 2013, Windows 2003, 2008, 2012 Servers.

Confidential, Chicago, IL

SQL Server Developer/ SSIS/ SSRS

Responsibilities:

• Understanding the report design Requirements and Constraints.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Involved in understanding of Power Shell scripts and Wrote simple Power Shell command line scripts.
• Developed Tabular Reports, Matrix Reports, drill down Reports, Bar Graph Reports using Power BI.
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
• Transformed and combined the data using Query Editor in the Power BI and published Power BI Desktop reports created in Report view to the Power BI service and installed on premise data gateway and scheduled daily data refresh in Power BI.
• Created scorecards with executive summary dashboards using MS Office Performance point server 2007 Dashboard designer that display performance monitoring measures.
• Designed and developed Data-mart using SSAS.
• Build Cubes on Enterprise Date Warehouse (EDW).
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Performed DBCC checks and fixing data corruption in Application databases.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS),Power BI, Microsoft Visual source Safe.

Confidential

SQL server Developer/SSIS/SSRS

Responsibilities:

• Developed SSIS Packages to extract data from various data sources such as MS Access, Excel and flat files into SQL server 2008 using different transformations, Derived column, Sort, Row count.
• Developed, deployed and monitored SSIS Packages.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Made SSIS packages parameterized using Configuration files.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Studied the existing OLTP system(s) and Created facts, dimensions and Star Schema representation for the data mart.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions and optimized cubes for better query performance.
• Created and integrated User defined functions and stored procedures for reporting purposes.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Defined relationships between Dimensions and Measure groups.
• Expert in calculating measures and dimension members using mathematical formulas, and user-defined functions.
• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.

Environment: MS SQL Server 2008 Enterprise Edition, MS SQL Analysis Services 2008,MS SQL Reporting Services 2008, MS Access, MS SQL SSIS/SSRS 2008, Windows XP Professional, Relational DBMS, data warehousing, Insurance Systems.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.