SUMMARY

• Experienced in Installing, Configuring, Managing, Monitoring, Troubleshooting of Sql Server 2016, 2014, 2012, 2008r2, 2005 and Windows server 2012, 2008r2, 2003r2 in Production, Development, UAT and Test Environment.
• Strong experience to support data migration from On - Premises Server to Azure SQL Databases (DBaaS) and SQL server on Azure Virtual Machine (IaaS) Instance using different tolls like DMA, SSMW, Backup and Restore, generate Scripting.
• Database Performance Tuning using Execution Plan, SQL Server Profiler, Extended event, Database Tuning Advisor, Performance Monitor and Activity Monitor, Rebuild/Reorganize index, Updating Statistics, DMV, DBCC, Windows Event Viewer, SQL Server Error Log, Agent Error Log.
• Monitoring Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed.
• ResolveDead locks/Long running queries. Good experience in Table partitioning.
• Upgrading and MigratingOracle 10gR2, 11g and MySQL 5.1.23/5.5.6 Databases and SQL Server 2014/2012/2008 r2/2005.
• High Availabilityand Disaster Recovery solutions (Log shipping, Mirroring, Replication, SQL Server Fail Over-clustering and AlwaysOn).
• Capacity planning and implementing disaster recovery solutions, Backup, Restore, Point-in-Time Recovery with RTO, RPO and SLA.
• Experienced in maintaining and supportingVery Large Database more than 2TB.
• Expertise in implementing security Management: SQL Serversand Databases, users, Data Encryption, and data masking.
• Very good knowledge in Database Architecture and Design.
• Decent understanding in T-SQL, usingDMV, writing Stored Procedure, Functions, Triggers and proficient in Tuning Complex Queries.
• Experienced in System Databases configuration and Management such as TempDB, MSDB and Master DB.
• Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• ETL/SSISPackages for integrating data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Good experience in physical storage configurationand optimization ofSAN with differentRAIDlevels.
• Proficient in Active Directory.

TECHNICAL SKILLS

Database Expertise: SQL Server2016, 2014, 2012, 2008r2, 2005, MS Access 2007& 2003

Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

Operating System: Windows Server 2012, 2008 R2, 2003 R2, VMware, Cloud

Cloud: Migrated and Managed Databases in SQL Azure Databases & Azure VM from On-Premises databases systems. Extensive knowledge in AWS.

Native tools: SSMS, Performance Monitor, Query Analyzer, Extended Events, SQL Profiler, Execution Plan, Activity Monitor, DBCC, DMV, BIDS/DTS, Job Activity Monitor, Database Tuning Advisor, Built-in Standard Reports.

ETL/DataWarehouse Tools: SSIS/DTS, BCP

Reporting: SSRS (SQL Server Reporting Services) - Enterprise Reporting, Excel Report

Data Modeling Tools: ERWin, Toad Data Modeler, Visio, SSDD (SQL Server Database Diagram)

Third Party Tools: SolarWinds, RedGate, Idera, Spotlight, ERWin, Visio, Toad Data Modeler, WebWx.

Networking: Active Directory, DNS, TCP/IP

Hardware/Storage: SAN, NAS, RAID, iSCSI, Blob

Languages: SQL/T-SQL, HTML, DHTML, CSS, PHP, XML, JavaScript, ASP, ASP.net

PROFESSIONAL EXPERIENCE

Confidential, Honolulu, HI

SQL Server DBA/Administrator

Responsibilities:

• Cloud/Azure experience includes Microsoft Azure Services, PaaS, IaaS, Migrated SQL Server On-Premise Databases and legacy products on Azure, setup Development and Test environment on Azure Virtual Machines (IaaS).
• Decent experience in Configuring & Managing Log shipping & AlwaysOn availability Group on Azure Virtual Machine instance.
• Installed, configured, monitor, troubleshoot and Administer SQL Server 2016, 2014, 2012 in Development, Test, UAT, and Production environment.
• Configured and Manage HA solutions on AlwaysOn Availability Group using SQL Server 2014/2012 with synchronous Commit automatic-failover mode.
• Upgraded SQL Server 2005 and 2008r2 instances and databases to 2012/2016.
• Migrated Oracle 10gR2/11g and MySQL 5.1.23/5.5.6 databases to SQL Server 2012/2016.
• Migrated SSIS packages from SQL Server 2008 R2 to 2016.
• Developed, maintained and implemented database backup and recovery plans by using RTO and RPO in SLA level for Production, Test, UAT and Development environments including mission critical databases.
• Expertise in DatabaseBackup and Recoveryprocedures by using Native and third-party tools.
• Performed performance tuning activities in different aspects using different tools like Execution Plan,SQL Profiler, Performance Monitor/Profiler, Index Tuning, Index rebuild, reorganize, setup automated jobs for index management tasks, and WindowsPerformance Monitorfor monitoring and tuningMS SQL Server performance.
• ResolveDead locks/Long running queries.
• Proven working experience in Query Optimization, Indexing, and Troubleshooting SQL Server related issues.
• Experienced in usingDMV, DBCC.
• MonitoringEvent Viewer, SQL Error logsandLog File Viewerfor Software and hardware related errors.
• Use Business Intelligence ToolstoCreate SSRS Reports and SSIS packages
• Configure and manage Reporting Servers, Deploy, migrate, upgrade Reports, Reporting Server.
• Configure and manage SSIS packages, Deploy, migrate, upgrade SSIS projects and packages.
• Write SQL/T-SQL Scripts, Stored Procedures, Triggers, Functions and setup jobs for various automation purposes.
• Perform Table partitioning, data archival activities.
• Supports day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long running queries, locks, deadlocks and performance issue like CPU, I/O, Memory bottlenecks
• Automate and enhance daily administrative tasks including space management, object alteration, database backup and recovery.
• System performance monitoring by I/O, processes wait-time, response time, physical memory, network bandwidth with traffic, connection conjunction, and space availability.
• Defining SQL Server standards for HA based on Applications requirements.
• Responsible for securing SQL Server environment, involved in creation and granting permissions on various Objects, created the guide line to secure SQL Servers.
• DR planning, coordination and implementation.
• Capacity planning for Database and generating the Database growth.
• Managing cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Planned, and Developed Backup strategies, setup backup jobs, maintenance plan jobs, monitoring and troubleshooting jobs.
• Apply SP, Hot Fix, Featured Pack, Cumulative updates.
• Handle multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Export & Import data from Flat file (CSV, Excel) to SQL Server Database using EXP/Import.
• Work with developers for writing T-SQL Scripts for applications and tuning up application performance.

Work Environment: Windows Server 2012, 2008r2, 2003r2, IIS 7.5, SQL Server, 2016, 2014, 2012, 2008r2, 2005, AD (Active Directory), and Application in JavaScript, ASP and ASP.net. Service-Now, TFS, Visio, SharePoint, WebEx, SolarWinds, Idera, My SQL, Oracle, ETL Processing.

Confidential, Washington, DC

SQL Server DBA

Responsibilities:

• Responsible for monitoring and making recommendations/implementation for performance improvement in hosted HA databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Administered, Configured and Lead on Log Shipping and Mirroring.
• Experienced in using DMV and DMF for finding out long running queries.
• Expertise in SQL Server Replication (Transactional), Backup/Recovery, Disaster recovery and planning.
• Managed Security of SQL Serversand Databases Logins, Users, Granting/ deny/ revoke access and Database Encryption/Decryption.
• Having hands on experience in DR processes.
• Installed, Configured and maintain SQL Server 2005, 2008 R2, 2012, 2014 in Development, Test, and Production environment.
• Database backup plan, database health check, rebuild or reorganize indexes, database update statistics, history or maintenance clean up tasks (automated).
• Database Mail configuring and alert setup and notification for status.
• Upgraded SQL Server 2005 to 2012 and 2008r2 to 2014.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008r2 on Windows 2008r2.
• Rebuild / monitored the indexes at regular intervals for better performance.
• Recovered the databases from backup in disasters. Implemented Point-In-Time Recovery solutions.
• Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
• Performance Tuning - Execution plan, Performance Monitor, Activity Monitor, Extended Events, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Developed and deployed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
• Created database and new table, set identity, set constraints, modified design, created and updated index, defragged index, rebuild and updated statistics, file upload from different source to destination and directly worked with app/web team for any release and migration.

Work Environment: SQL Server 2005, 2008r2, 2012, 2014, IIS 7.5, 8.5, Windows Server 2003r2, 2008r2, 2012, ASP, ASP.net, Java, ETL and AD (Active Directory), ERWin, Expand-IT, Financial Application, JIRA, VM Server, Spotlight, RedGate, Idera.

Confidential, Alexandria, VA

MS SQL Server DBA

Responsibilities:

• Hands on Experience in installing, configuring, monitoring and troubleshooting & Administration of SQL Server 2005, 2008r2 & Windows 2003r2, 2008r2.
• Responsible for securing SQL Server environment, involved in creation and granting permissions on various Objects, created the guide line to secure SQL Servers.
• Created the SOP (Standard operating procedures) for all SQL Server activities like - Installing SQL Servers, applying service packs and security fixes.
• Backed up and restored user and System Databases. Imported and exported data between MS SQL servers and Non-Microsoft SQL servers using SQL Transfer manager and bulk copy program.
• Responsible for implemented and maintained different types of Replication Models such as Transactional, Snapshot.
• SQL server memory allocation configured Tempdb in RAM and monitoring locks.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check, and index defragmentation.
• Monitored database status including CPU, memory, I/O, space, and dead locks
• SQL Server tuning techniques to optimize the SQL queries and stored procedures.
• Configured securities and access to production databases in SQL Server 2008r2, Windows Server 2008r2.

Work Environment: SSIS, SSRS, MS SQL Server 2008r2/2005, C#, Visual studio 2008, MS Access, MS Excel, MS Office Access 2007, IIS 6.5/7.5, Service-Now, Spotlight, Toad Data Modeler, SharePoint Server.