Rahel Konche

About Rahel Konche

Over seven plus years of experience in Database Administration on production servers and expert in HADR solution, performance tuning, replication, database design, writing stored procedures, views, functions, triggers, and maintenance with excellent troubleshooting skills.

Experience

1. Senior Database Administrator

   Star Furniture

   Mar 2022 — Present

   Manage over 250 databases that are Terabytes in size hosted on over 150 standalone and cluster servers.• Support complex Replication system between hundreds of SQL Servers. • Having experience in Migrating on Premises SQL Databases to SQL Azure using DMA & DMS (Offline & Online) and Azure Data Studio.• Perform Database query tuning and optimization using tools such as SQL Server Tuning Advisor, SQL server Profiler, Performance, and best practice analyzer. • Migrated VMs, SQL Databases from On Prem to AZURE, configure Geo-replication for High availability, Azure Site Recover and manage database on Elastic pools and Massage instances.• Experienced in High Availability Groups/Disaster Recovery (HADR) solutions, Failover Clusters and AlwaysOn Availability Groups, Log shipping.• Expert using third-party tools such as Redgate for tuning and optimization.• Having experience in creating alerts for azure resources based on different metrices.• Configured on-premises SQL database backups to Azure using Microsoft Azure Backup tool.• Having experience in configuring Virtual machines, Azure Virtual Machines, SQL servers on azure and azure SQL databases. • Azure Cloud professional with strong experience in migrating resources to Azure, Azure Administration, Azure Infrastructure Operations, and end to end Project Management. Produced high-standard database solutions to meet stability, reliability. Bash and PowerShell• Implement & manage database failover as well as load balancing technologies per client’s request.• Monitor and troubleshoot jobs, backups and restore database based on policies. • Coordinate physical changes and performance monitoring between replication servers. • Extensively work with SQL Server Integration Services (SSIS) & SQL Server Reporting Services (SSRS)•Responsible for the Design and Development of SSIS Packages to load the Data from various Involved in Source Data Analysis and design mappings for data extraction.