SUMMARY

• Over 13+ years of experience in SQL Server DevOps/Database Administration for Azure High Availability with very large and complex Production Servers databases in SQL Server 2016/2014/2012/2008 R2, 2008/ 2005 and 2000 with Performance Tuning and Maintenance with Outstanding Troubleshooting capabilities.
• Strong Experience with TSQL language, writing and optimizing stored procedures having very good of knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.
• Created SSIS Packages to extract data from Excel files, MS Access files using Pivot Transformation, Condition Split, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MA Access and CSV files to enterprise databases.
• Participates in all phases of the ETL development lifecycle including unit testing and ongoing support.
• Developed and maintained ETL (Data Extraction, Transformation and Loading) to extract the data from multiple source systems that comprise databases like Oracle 10g,NoSQL SQL Server 7.2, flat files to the Staging area, and then to the Data Marts.
• Expertise in supporting Very Large Databases (VLDB)/LOB XML Data with more than 5 TB and troubleshooting the problems.
• Good Exposure knowledge on Big Data technologies.
• Expertise in troubleshooting performance problems, fine - tuning of databases and index Analysis using tools like Extended Tools, Data Collector MDW, Profiler, Extended Events, Performance Monitor, and including DMV's.
• Extensive troubleshooting skills on SQL issues by using SQL Tools, execution plans, Trace, statistics, created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
• Extensive troubleshooting in proactive and reactive SQL Server Problem Engineering and root cause analysis for Mission Critical applications
• Extensively worked on Design and support high availability solutions using SQL Server Log
• Shipping, SQL Server Mirroring, sQl Server Replication and SQL Server Always On Technologies with Azure High Availability.
• Implemented new SQL Server 2005 concepts like Data partitioning, Snapshot isolation, database mirroring, database snapshot, DDL triggers, try-catch blocks, CTE, Online indexing, DMV's, DMF's, Mail Setup, Jobs and Alerts, DTA and Dedicated Admin Connection.
• Strong experience in mentoring team members and writing documentation.
• Worked on 24 X 7 X 365 Production Database on Call Support.
• Thorough knowledge on scripting languages like Batch scripting, VB Scripting, PowerShell.

TECHNICAL SKILLS

Operating System: Windows 2012, Windows 2008, Windows XP, Windows NT

Database: SQLServer, SSRS, SSIS, SSAS, DTS, Oracle, NoSQL,PostgreSQL

Tools: PerfMon, Extended Events, MDW, Diagnostic Manager. C#. NET, VB.NET, ASP.NET, TSQL, ASP, XML. SSRS, Crystal Reports MS Visual Studio, Visual Source Safe, CVS PowerShell Scripts, Batch Scripts, VB Scripts

PROFESSIONAL EXPERIENCE

Lead Senior SQL DBA

Confidential, Redmond, WA

Responsibilities:

• Focused on automation integration monitoring and configuration management.
• Expertise in creating database schemas for Relational database objects, models and DB designs/systems.
• Extensively worked on Design and support for AZURE High Availability solutions using SQL Server Always On Technologies.
• Created SSIS Packages to extract data from Excel files, MS Access files using Pivot Transformation, Condition Split, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MA Access and CSV files to enterprise databases.
• Streamlined applications delivery to get applications out to customers faster.
• Utilized SQL database systems.
• Relied on solid systems network stack experience.

Lead Senior SQL DBA

Confidential, Redmond, WA

Responsibilities:

• Expertise in managing /advice developers on best practices, review code and implement changes into development and production environments.
• Expertise in creating database schemas for Relational database objects, models and DB designs/systems.
• Developed and maintained ETL (Data Extraction, Transformation and Loading) to extract the data from multiple source systems that comprise databases like Oracle 10g, NoSQL, SQL Server 7.2, flat files to the Staging area, and then to the Data Marts.
• Expertise in Performance Tuning using Extended Events for 2008 and 2012 SQL, Data Collector and MDW, Profiler, Service Broker, DMV's and Windows Performance Monitor.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert with Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g/DB2. Also created DTS package for data transfer between the two environments.
• Extensively worked on Design and support high availability solutions using SQL Server Log Shipping, SQL Server Mirroring, SQL Server Replication and SQL Server Always On Technologies.

Senior SQL DBA

Confidential, Redmond, WA

Responsibilities:

• Administered and responsible for all production, pre-production SQL Servers and related systems for giving database support, troubleshooting, planning and migration for MPSIT.
• Provided and Implemented extensive workarounds on SQL bugs on the LOB XML data, blocking, Subscription Streams parameter and various issues related to Replication Latency issues and other problem engineering issues.
• Expertise in Performance Tuning using Extended Events for 2008 and 2012 SQL, Data Collector and MDW, Profiler, Service Broker, DMV's and Windows Performance Monitor.
• Extensively worked on Design and support for AZURE High Availability solutions using SQL Server Always On Technologies.
• Expertise in Configuring Data Collector Management Data Warehouse(MDW) for performance monitoring on multiple instances configured to a single central instance for detailed reporting.
• Created SSIS Packages to extract data from Excel files, MS Access files using Pivot Transformation, Condition Split, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MA Access and CSV files to enterprise databases.
• Design and Configured Transactional Replication, Log Shipping and SQL Mirroring
• Extensive troubleshooting skills on problem engineering issues like deadlocks, tracing long running queries, data compression, Service Broker and various other technologies like Azure High Availability Always On, Log Shipping, Mirroring and Replication.
• Configured Database mail, linked servers in SQL server 2008 and SQL server 2012.
• Created and worked on various support related reporting tools of using SSRS (SQL Server Reporting Services) for the operations use for Subject Matter Expertise.

Senior SQL DBA

Confidential, Bellevue, WA

Responsibilities:

• Expertise in troubleshooting and performing routine Data Imports, Backup & Restore, Log Shipping, and Mirroring of databases SmartArt database functionalities that can only be performed using bulk load or build updates.
• Used the Remedy to track and analyze open defects found during the Design.
• Manage tickets and work on it to ensure production is left with no issue. Involved in design, review specifications meetings as required.
• Expert in Performance Tuning, analyzed long running queries and tuned them to optimize the system performance.
• Used PerfMon, DMV's, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Expertise in pulling the production reports from OLTP systems into OLAP databases

Senior DBA

Confidential, Bothell, WA

Responsibilities:

• Expertise in writing complex database queries, Stored Procedures, Triggers, SQL Cursors using joins with multiple databases database designs and relational database concepts and identify Data Integrity issues by SQL queries.
• Performing routine Data Imports, Backup & Restore, SQL Agent Jobs, and Data Modeling/Architecture of databases Mediation database functionalities that can only be performed using bulk load or build updates.
• Used the Quality Center Defect Manager System to track and analyze open defects found during the Design.
• Responsible for testing of Confidential & Confidential Balance Manager Web Service Application.
• Expertise in troubleshooting and performing routine performance tuning and troubleshooting issues on Log Shipping, and Mirroring of databases SBP Balance Manager
• Manage tickets and work on it to ensure production is left with no issue.

Senior SQL DBA

Confidential, Redmond, WA

Responsibilities:

• Expertise in supporting Very Large Databases (VLDB)/LOB Data with more than 2 TB and troubleshooting the problems.
• Involved in troubleshooting and performing routine Data Imports, Backup & Restore, and Log Shipping of databases for AdCenter Analytics (ACA) Behavioral Targeting (BT) functionalities that can only be performed using bulk load or build updates.
• Strong process background in change control, source control, backup strategies.
• Identify Data Integrity issues by SQL queries and correct them.
• Remove data anomalies in Inter World Product catalog data by importing the data into Microsoft Excel

SQL Developer/SQL DBA

Confidential, Bellevue, WA

Responsibilities:

• Identify Data Integrity issues by SQL queries and correct them.
• Data analysis & validation using Microsoft Excel & VBA programs.
• Remove data anomalies in Inter World Product catalog data by importing the data into Microsoft Excel.

SQL Developer/SQL DBA

Confidential

Responsibilities:

• The aim of the project Eros Web is to simplify the process of Data entry by company officials from different parts of the country into their respective tables. This involves daily visits, Tour Program, Expenses, Mails and various reports.
• This project involves various security features to prevent unauthorized entry for the pages that are exclusively for the company people and again only to the allowed areas of the application depending on their privileges.

SQL Developer/SQL DBA

Confidential

Responsibilities:

• This project deals with Student Admission and their Registration details developed through Visual Basic 5.0 and Oracle 7.3 for Confidential
• When once the student joins a batch, the corresponding batch faculty maintains records pertaining to the student's performance. Necessary Validation is taken care that a student can take more than one semester and not less than three semesters. His performance in their module tests and Student Installment fees are generated using Crystal Reports.