SUMMARY

• Support several highly active and mission critical custom cloud application and software development groups in controlled, audited Dev/test/UAT/Perf/Prod/DMZ/DR environments split across Azure IaaS and PaaS solution.
• Expertise in Installing, configuring, administrating and supporting SQL Server 2016/2017 in Azure VM, compute Managed Instances, and Azure SQL Databases with Elastic pool.
• Strong experience in Backup/Restore, DR and High Availability strategies for Azure Environments.
• Expertise in managing and configuring Azure cloud services including RG, Azure VM, ASR, HA - AZ, Azure AD, RBAC, Monitor, Azure storage, Azure Blob storage, Active Geo replication, Azure Data factory, policy, Security, DNS, VNet, Gateway, Peering, NSG, Firewall and Endpoint.
• Advanced Experience in Migrating On-Prem SQL Server to Azure VM and Azure SQL Databases using lift and shift process.
• Create, Install, configure, manage and troubleshoot SQL Server 2016/2017 in Azure VM.
• Create and configure Azure SQL Databases, Elastic poll Databases and Managed Instance.
• Experienced in Installing, Configuring, Managing, Monitoring, Troubleshooting of Sql Server 2017, 2016, 2014, 2012, 2008r2, 2005 and Windows server 2016, 2012, 2008r2, 2003r2 in Production, Development, Test, UAT and Perf Environment.
• Strong Leadership working experience in Azure Cloud and On-Premises Configuring, Managing and Troubleshooting Log shipping, Mirroring, Replication, Clustering and AlwaysOn availability Group.
• 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, Server and Database health, backup verification, cleaning history and solving problem as needed.
• Resolve Lock, Block, Dead locks/Long running queries, High CPU & Memory and managing TempDB. Good experience in Table partitioning and Archiving.
• Upgrading and Migrating Oracle 10gR2, 11g and MySQL 5.1.23/5.5.6 Databases to SQL Server 2014/2012/2008 r2/2005.
• Strong working experience in High Availability and Disaster Recovery solutions in On-premises and Azure Cloud (Log shipping, Mirroring, Replication, SQL Server Fail Over-clustering and AlwaysOn).
• Capacity planning and implementing disaster recovery solutions, Managing Storage/Azure storage, Backup, Restore, Point-in-Time Recovery with RTO, RPO and SLA.
• Decent experienced in maintaining and supporting OLTP & OLAP Very Large Database more than 7 TB.
• Expertise in implementing Security Management: SQL Servers and Databases, users, column and row level security, Data Encryption, configure TDE on erver and Database level and data masking.
• Very good knowledge in Database Architecture and Design.
• Decent understanding in T-SQL, using DMV, 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/SSIS Packages for integrating data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Good experience in physical storage configuration and optimization of SAN with different RAID levels.
• Proficient in Active Directory, Azure AD and managing Security Group.

TECHNICAL SKILLS

Database Expertise: SQL Server 2017, 2016, 2014, 2012, 2008r2, 2005, MS Access 2007& 2003

Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server

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

Azure Cloud Services: Portal, ARM, Monitor, ASR, HA-AZ, Azure AD, RBAC, Monitor, Azure storage, Azure Blob storage, Active Geo replication, Azure Backup, Azure Data factory, policy, Security, DNS, VNet, Gateway, Peering, NSG, Firewall and Endpoint.

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: Idera, EMC Appsync, XIO, DDBoost, Royal TS, SolarWinds, Data Domain, CA UIM, Emcopy, Robocopy, NetApp, Splunk, ERWin, Entrust, Visio, Service-Now, ControlM, Toad Data Modeler, RedGate, Cisco, Webx, Imperva, PagerDuty.

Networking: Active Directory, DNS, TCP/IP, VNet, FireWall.

Hardware/Storage: SAN, NAS, RAID, iSCSI, Blob, Dell EMC, NetApp

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

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL DBA-Azure Admin

Responsibilities:

• Lead medium scale datacenter/services migration to Azure cloud, gathering requirements and recommending optimal target IaaS and PaaS solution migration path to target architecture.
• Strong experience in data migration from On-Premises SQL Server to Azure SQL Databases (DBaaS) and SQL server on Azure VM (IaaS) Instance using different tools like AlwaysOn, DMA, DMS, DEA, ASR, Data Sync, Azure Data Factory, AzCopy, Backup/Restore, generate Scripting.
• Configured and Manage HA solutions on AlwaysOn Availability Group on Azure VM using SQL Server 2017 with asynchronous and synchronous Commit automatic-failover mode in same and different region.
• Automate monitoring tools to monitor system health reliability with Azure log analytics.
• Create, configure and managing Azure SQL Databases and Managed Instances using different purchase model.
• Securing Azure Databases and servers by configuring Database and server level firewall.
• Leadership working experience on Managing & Troubleshooting SQL Server Failover Cluster Environment with Replication in SQL Server 2012/2014/2016/2017 to support Santander’s Business Infrastructure.
• Configuring & Managing cluster Active/Passive on Microsoft Windows Server 2012/2016 and Sql server 2012/2014/2016/2017 Enterprise Edition on SAN environment.
• Supports day to day operational activities for the database platform like health checks, Implementation and Deployment, DDL & DML operation, managing Security for server and Database level, Dealing with service requests tickets, C-Task, Incidents through Service-Now.
• Installed, configured, monitor, troubleshoot and Administer SQL Server 2017, 2016, 2014, 2012 in Development, Test, UAT, Perf and Production environment.
• Handle multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Performed performance tuning activities in different aspects using different tools like Execution Plan, Extended Event, SQL Profiler, DTA, standard report, costumed stored procedure, Performance Monitor, create Index, Index rebuild & reorganize, setup automated jobs for index management tasks for monitoring and tuning MS SQL Server performance.
• Resolve Lock, Block, Dead locks/Long running queries, High CPU, I/O, Memory bottlenecks using DMV, DBCC, Standard Report, custom SP, queries and managing TempDB.
• System performance monitoring by I/O, processes wait-time, response time, physical memory, network bandwidth with traffic, connection conjunction, and space availability.
• Upgraded & Migrated SQL Server 2008r2, 2012, 2014 instances and databases to 2016/2017.
• Developed, maintained and implemented database backup and recovery plans by using RTO and RPO in SLA level for Production, Development, Test, and UAT environments.
• Expertise in Database Backup and Recovery procedures by using N ative and third-party tools such as DDBoost, EMC Appsync.
• DR planning, coordination and implementation. Planned, Developed and Manage Databases Refresh strategies, maintenance plan jobs, monitoring and troubleshooting jobs.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for cluster, software and hardware related errors.
• Configure, Manage and Troubleshoot Linked server to enable the SQL Server Database Engine to execute T-SQL commands in another instance of SQL Server, or database against OLE DB data sources outside of the Database and Instance.
• Write SQL/T-SQL Scripts, Stored Procedures, Triggers, Functions and setup jobs for various Automation Purposes.
• Perform Table partitioning, monthly & yearly data Archival activities.
• Automate and enhance daily administrative tasks including space management, object alteration, Database Refresh, Scrubbing classified data.
• 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.
• Capacity planning for Database and generating the Database growth.
• Apply patches such as SP, Hot Fix, Featured Pack, Cumulative updates.
• Work with developers for writing T-SQL Scripts for applications and tuning up application performance.

Confidential

SQL Server DBA/Administrator

Responsibilities:

• Cloud/Azure experience includes Microsoft Azure Services including RG, ASR, Azure VM, Vnet, Active Geo-replication, PaaS, IaaS.
• Migrated SQL Server On-Premise Databases and legacy products on Azure SQL Databases. configured Dev, Test, UAT and Prod environment on Azure VM (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.
• 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 CPU, I/O, Memory bottlenecks Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Resolve Dead locks/Long running queries. Proven working experience in Query Optimization, Indexing, and Troubleshooting SQL Server related issues.
• Responsible for securing SQL Server environment, involved in creation and granting permissions on various Objects, created the guide line to secure SQL Servers.
• Capacity & DR planning for Database and generating the Database growth.
• Planned, and Developed Backup strategies, setup backup jobs, maintenance plan jobs, monitoring and troubleshooting jobs.
• 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.

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.
• Expertise in SQL Server Replication (snapshot and Transactional), Backup/Recovery, Disaster recovery and planning.
• Managed Security of SQL Servers and Databases Logins, Users, Granting/ deny/ revoke access and Database Encryption/Decryption.
• Installed, Configured and maintain SQL Server 2008 R2, 2012, 2014 in Development, Test, UAT, 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 2008r2 to 2012/2014.
• 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, DMV, DBCC, Activity Monitor, Extended Events, SQL Server Profiler, 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: Microsoft Azure Cloud, Windows Server 2016, 2012, 2008r2, SQL Server 2017, 2016, 2014, 2012, 2008r2, AD (Active Directory), CyberArk, Idera, DDBoost, EMC Appsync, Data Domain, ControlM, CA UIM, PagerDuty, Beyond Compare, SQL search 2, TortoiseGit, Netapp, Royal TS, Entrust, Viewfinity, Emcopy, Splunk, Outlook, PowerShell, ASP and ASP.net. Service-Now, Loopup, TFS, Visio, SharePoint, Cisco, WebEx, SolarWinds, My SQL, Oracle, Redgate, ETL Processing.