PROFESSIONAL SUMMARY:

• More than 7 years of experience as a DBA in Microsoft SQL Server and over 3 years of experience as a Migration Engineer and SQL Database architecture with experience in requirement analysis, design, development, testing of client/server, web, Data warehouse and n - tier architecture applications.
• Microsoft Certified Technology Associate - Database Fundamentals.
• Expertise on RDBMS concepts as well as Data Modeling Concepts.
• Extensive experience in implementing High availability solutions like Always on, Replication models (Snapshot and Transactional), Log shipping, dynamic management views, clustering and mirroring on physical and virtual machines.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting.
• Experience in extracting data and creating SAS Version 6 datasets from various sources like SQL database, Access database, Excel and flat files using Import techniques.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Strong in standard Software Development Life Cycle (SDLC) and software development methodologies.
• Experienced in different phases of Software Development Life Cycle (SDLC) including Strategic Systems Planning, Designing, Object Oriented Programming (OOP) concepts, Programming, Testing, Documentation, and Presentation to clients and preparing customer specifications as part of software technical requirements and Customer support.
• Having good experience of Microsoft SQL Server 2008, 2008R2, 2012, 2014 and 2016, Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) using Business Intelligence Development Studio (BIDS) and Crystal Reports 7.0/8.0.
• Knowledge on PostgreSQL 9.1, Oracle 10g, 11g, 12c and MySQL.
• Good at SQL Server 2012 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in Data Modeling, Normalization, and Building Referential Integrity Constraints.
• Developed complex Stored Procedures, Triggers, Views, Functions, Indexes, Normalization, Data types using MS SQL Server 2000, 2005, 2008, 2012 and 2014.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Experience in Query Optimization and Performance Tuning.
• Experience in Data Base backup, Windows Azure and disaster recovery procedure.
• Experience in Replication - Snapshot, Merge and Transactional.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Worked in In-Memory OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Experience with the Cognos Reportnet suite (Framework Manager, Cognos Connection, Report Studio, and Query Studio) on Windows.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT, Dimensional tables and Operational Data Store (ODS).
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Worked on configuring VLAN’s and IP’s for the new SQL DB cluster.
• Strong Business and Application analysis skills with excellent communication & professional skills.
• A self -motivated Individual with exemplary analytical and problem solving skills.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems: Windows, UNIX (Sun Solar), LINUX

Databases: MS-SQL Server 2016, 2014, 2012, 2008R2, 2008/2005/2000 , PostgreSQL 9.1, Oracle 10g, 11g, 12c and MySQL.

ETL Tools: Data Transformation Services(DTS), SQL Server Integration Services (SSIS)

Scripting: Shell Scripting

Business Intelligence: SSRS, SSIS, SSAS

DB Utilities: SQL Server Management Utility, Query Analyzer

Software Tools: Visual Studio 2005/2008/2010 , VMware, AWS, Azure Visual Source Safe, TFS, MS Office Suite, SCOM

Data Modeling Tools: Erwin, Red gate, Lite Speed,  Embarcadero

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

Microsoft SQL Server DBA/ Migration Engineer/ Architecture

Responsibilities:

• The ability to assist in finalizing a Microsoft SQL Server migration design in which to migrate older Microsoft SQL server machines into a right-sized Virtual Machine (VM) residing within the customer’s environment. Includes analyzing previous discovery data.
• Physical to Virtual SQL Server migration.
• Oracle to SQL server migration via SQL Server Migration Assistance for Oracle and SSIS.
• Sizing the environment bases on empirical performance metrics and best practices
• Implementation on Always On and Windows Azure.
• The ability to understand and tune how a database interacts with a specific application.
• The ability to understand and make use of tools available (vSphere Web Client, MS Windows Server Perfmon) to troubleshoot and tune SQL DB performance after DB migrations where applicable.
• Worked on configuring VLAN’s and IP’s for the new SQL DB cluster.
• The ability to minimize downtime completing SQL server migrations with knowledge in detailed troubleshooting of their infrastructure environment  SQL 2000, SQL 2005, SQL 2008/R2, SQL 2012/R2 and 2016
• Ability to script within SQL server effectively
• Hands-on understanding of the VMware admin clients and the ability modify Virtual Machine properties appropriately.

Environment: Microsoft Windows 2014, 2012, 2007 Server, Microsoft SQL Server 2016, 2014, 2012, 2008 R2, 2005, 2000, VMware admin clients, vSphere Web Client, SCOM.

Confidential, San Ramon, CA

Microsoft SQL Server DBA/ Migration Engineer

Responsibilities:

• Joined as a part of SQL Server 2012 upgrade project in December 2014.
• Migrated more than 500 databases to SQL server 2012 environment from the older versions in production, UAT, Testing and Development server.
• Worked on the SQL Server 2014 upgrade project.
• Co-ordinate with the DR migration to their new Denver, CO location.
• Installation and Maintenance of SQL Server 2012 on Test, Development and Production Environments.
• Seamlessly transitioned AWS infrastructure from EC-2 classic to VPC.
• Implemented Clustering and used VM Ware as part of Server consolidation project.
• Co-ordinate with the Online Banking, CRM, First Hawaiian Bank (FHB) and other major projects.
• Familiar with the Shell scripting which we used for the database inventory project for the Cherwell application.
• Implemented Query Optimization, Indexing and Table Partitioning, along with In-Memory OLTP to improve the performance for the CCAR project.
• Familiar with the SSRS, SSAS and SSIS in SQL Server 2012.
• Co-ordinate with the application team and the Business Users for a successful project completion.
• Maintained database warehouse for the online banking application and on building staging data as per new requirement 
• Usage of new compression Techniques in SQL Server 2012 for backup and restore jobs along with the Windows Azure for the cloud backup.
• Involved in the implementation of Always On Availability Group as a High Availability solution on clustered and stand-alone scenarios on SQL Server 2012.
• Implemented Database Mirroring, Log shipping, Transactional Replication and Always On as a part of DR plan.
• Closely monitored the performance for the reporting DB’s by SQL Profiler tool.
• Worked on Oracle 12c and 11g, PostgreSQL 9.1 and MySQL as a part of migration project.
• Created Logins and Roles with appropriate permissions.
• Created and Maintained Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Familiar with the SQL Server Profiler for the performance tuning for the SQL query.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Hands-on experience in Performance Tuning and Index Tuning.
• Able to communicate effectively with a wide range of people, by showing interest and carefully listening to their needs.
• Familiar with Team Foundation Server (TFS).
• Created User Groups, Roles to implement the Cognos Security.
• Worked in MS Access for the inbound consolidation project.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SSRS.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Closely worked with the production environment for the upgrade, security patching and RFC.
• Closely worked on fail over clustering as a part of database consolidation project.

Environment: Microsoft Windows 2014 Server, Microsoft Windows 2012 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Windows 2007 Server, Windows 2012 Server.

Confidential, Alexandria, VA

Microsoft SQL Server DBA/ Data Modeler

Responsibilities:

• Installation and Maintenance of SQL Server 2008 R2 on Test, Development and Production Environments.
• Project name called Credit Dispute and Deduction Management, good accounts payable addresses both supplier relationships, cash flow and reports tries to wring every dollar of profitability.
• Usage of new compression Techniques in SQL Server 2012 for backup and restore jobs.
• Developed SAS macros for data cleaning and reporting.
• Worked on VM Ware for the Virtual Machine implementation as a part of the migration project.
• Implemented Clustering, Database Mirroring, Log shipping and Transactional Replication as a part of DR plan.
• Worked on ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Created Logins and Roles with appropriate permissions.
• Created and Maintained Database Maintenance Plans.
• Modified Stored Procedures and complex T-SQL Queries to improve query execution process.
• Performed Query optimization with Indexing and Table partition.
• Worked on Oracle Database 10g and MySQL Administration (2006).
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SSRS.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Experienced in Performance Tuning and Index Tuning.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Created User Groups, Roles to implement the Cognos Security, using LDAP.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitored Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Implemented DTS packages for the SSIS.
• Implemented Lite speed for the SQL server 2008 server.

Environment: Microsoft Windows 2012 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Windows 2007 Server, Windows 2003 Server.

Confidential

Microsoft SQL Server DBA/ Developer

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Wrote complex stored procedures to process employee’s requirement and generating.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Debugged the T-SQL queries for performance tuning.
• Checked & updated Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.

Environment: SQL Server 2005, 2008, 2008R2 Windows NT Server, SQL Profiler, C# ASP. NET.