• SQL Server Database Administrator with over 8 Years of extensive experience in Administering, Managing and Supporting SQL Servers 2008R2/2012/2014/2016/2017/2019.
• Over 3 years of experience with Azure Administration in IaaS and PaaS Platform.
• Strong expertise in AlwaysOn, Replication, Log shipping, Mirroring, Performance tuning, Stored Procedures, Triggers, Functions & Active monitoring in 24x7x365 environment.
• Over 10 years of experience in Information Technology as Systems Admin & Systems Engineer with solid understanding of the Company’s core values and Resourceful.

Technical Knowledge:

• Databases: Azure SQL & SQL Server 2019/2017/2016/2014/2012/2008R2
• Operating System: Windows Server 2016/2012/2008R2/2003R2, Solaris, Linux, VMware
• Languages: SQL/T-SQL/XML/HTML/DML/DDL/CRUD
• ETL Tools: SSDT, SSIS, Import/Export Wizard, Bulk Insert
• Reporting: SQL Server Reporting Services, Report Builder
• Data Modeling: SSDD (SQL Server Database Diagram), ERWin
• Upgrade/Migrate: SQL to SQL, Oracle to SQL, MySQL to SQL, DB2 to SQL
• Third Party Tools: SentryOne, Idera, RedGate, ERWin, ServiceNow, Remedy, Trekker
• Native tools: SSMS, Performance Monitor, Query Analyzer, Extended Events, SQL Server Profiler, Database Tuning Advisor, Execution Plan, Activity Monitor, Resource Monitor, Job Activity Monitor, DMVs & DMFs, DBCC, and SSCM, Data Migration Assistant (DMA), Data Migration Services (DMS), Microsoft Azure Storage Explorer
• Hardware/Storage: SAN, NAS, RAID, IBM Storage, iSCSI, Azure Managed Disks
• Networking: TCP/IP, DNS, WAN, LAN, SFTP, FTP
• Other Tools: Git, Team Foundation Service (TFS), SharePoint, Active Directory

Training and Certification:

• CompTIA Security+: SYO-501, Verification Code: WQFYR0RH6LB4QE91, Dec,2020
• Microsoft® Certified Azure Database Administrator (AZ-104, DP-300, AZ-900)
• Microsoft Certified MCSA: SQL 2016 Database Administration Charter Member
• Microsoft® Certified Administrator, Database Infrastructure, SQL Server 2016
• Microsoft® Certified MCP, MCITP & MCTS, SQL Server 2008
• Microsoft® Certified Systems Engineer, MCSE
• SUN Certified Network Administrator and Solaris Systems Administrator

Professional Summary:

• 8 years of experience as SQL Server DBA (2008R2, 2012, 2014, 2016, 2017, 2019) in Prod, Dev and Non-Prod Environments.
• Extensive experience in Installation, Migration, Upgrades, Configuration and Administration for SQL Server in Clustered, Non-Clustered, VMWare & Azure Environment.
• Migrated/Upgraded On-Premise SQL Server Databases of 2008R2/2012/2014 to SQL 2016/2017/2019 to SQL Server in Azure VM (IaaS)
• Configured Database Maintenance Solutions for SQL Servers in Azure VM using ARM templates to automate maintenance tasks.
• Provisioned and Managed Azure SQL Databases (PaaS) in Prod and Non-Prod Environment for application Migration and Load Testing.
• Migrated On-Prem SQL DBs to Azure SQL DBs, and Configured Geo-Replication and Failover-Group for managing HA/DR for Azure SQL Databases
• Configure azure managed backup including long-term retention policy for Azure SQL DBs
• Working experience in controlling and coordinating with Patch management (Security patches, Service packs/Cumulative Update) and system performance on pre-deployment.
• Extensive experience in Configuration, Implementation and Maintenance for High Availability & Disaster Recovery solutions Using AlwaysOn, Log Shipping, Database Mirroring, and Replication.
• Experienced in automating Backups and Restore, Point-in-Time Recovery in accordance with RTO and RPO guidelines, and Maintenance plans.
• Set Up Jobs, Alerts, Emails, Controlling User Privileges, Security and Audit.
• Expertise in Performance Monitoring, Database Tuning Advisor, Profiler, Extended Events, and Performance Monitor & Third-party tools like Idera SQL Diagnostic Manager.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Index tuning, Update Statistics, Error and Event Handling.
• Worked on Database refresh in Dev/Test servers with PROD data.
• Implemented Transparent Data Encryption (TDE), Creating and managing logins/users, granting/revoking access at database or Server level.
• Solid experience in Installation, Configuration and Migration of SSRS, SSIS.
• Proven work experience in TempDB configuration, shrinking and Linked Servers.
• Exported / Imported data from SQL Server to Flat file, CSV file, Oracle, MySQL
• Extensive knowledge of Normalization and Relational Database Management Systems
• Solid Experience with Verbal/Written Communication, on-call Rotation, Multi-tasking and Task prioritizing.