Dawit Sheno

6 Years of IT experience in Database Administration, Design and Development of SQL Server. On-Prem and in Azure. Strong experience in SQL Server 2019/2017/2016/2014/2012 installing, configuring and managing. Upgraded SQL Server version from 2012/2019 to higher versions. Applied Service Packs (SP), Cumulative Updates (CU) and hot fixes. Managed database backups and disaster recovery, restored databases from backup and performed Point-in-Time recovery. Scheduled jobs to automate different database relate activities including backup, Index DE-fragmentation, reorganize-indexing, update index statistics, history cleanup and notify operators tasks. Automated database tasks (created jobs, alerts, and schedules for database maintenance tasks). Implemented High Availability technologies of Database using Database Mirroring, Log shipping and Replication. Configured, Managed and Monitored High Availability and Disaster recovery Solutions using AlwasysOn Availability Groups. Installed, configured, and maintained Window Server Fail-Over Cluster (WSFC). Managed and maintained user’s security and permissions, creating logins with appropriate roles, creating users and groups account, and granting, denying and revoking permission. Scripting the Database Consistency Checks (DBCC), Scheduling the scripts to run daily and weekly basis. Skilled in Database Auditing, Security Configuration such as TDE (Transparent Data Encryption), SSL (Secure Sockets Layer) etc. Expertise in SQL Server Native tools Query Optimization, Performance Tuning, Activity Monitor, Profiler and Extended Events, Database Tuning Advisor and Windows Performance Monitor. Proficient in both DDL and DML query languages-T-SQL quires using Sub-queries, and merge joins. Expertise in creating and managing database objects, stored procedures, user defined functions, indexes (clustered and non-clustered), views and triggers using T-SQL. Experienced in Conceptual, Logical and Physical Database design. Managed large and very large databases (VLDB) in 24/7 environment. Creating and Deploying SSIS Package to automate table migration. Designed, developed, and implemented robust and extensible Extraction, Transformation and Loading (ETL) solutions to support key business data flows using SSIS. Establish backup and recovery strategies based on recovery point objectives (RPO) and recovery time objectives (RTO). Perform regular backups and test the restoration process to ensure data integrity. Define and implement data retention policies for backups. Experience in data migration from other platform to SQL and from On-Prem to Azure using DMA (Data Migration assistant). Experience on producing report and managing and deploying using SQL Server Reporting services (SSRS). Experience in Software Development Life Cycle (SDLC) especially in Agile and SCRUM methodology. Experience with IT Service Management-incident, change, configuration, and release management processes. Strong analytical and communication skills, team player and able to quickly grasp new technologies and products. Extensive exposure to Azure PaaS services, including Azure App Service, Azure SQL Database, Azure Functions, and Azure Logic Apps. Proficient in deploying and managing PaaS resources using Azure Resource Manager templates or Azure CLI. Experienced in monitoring and optimizing Azure PaaS solutions for performance, scalability, and cost-efficiency. Skilled in identifying and resolving issues related to Azure PaaS services, collaborating with teams for troubleshooting, and providing technical support. Extensive exposure in scripting and automation using PowerShell, Azure CLI, or other relevant tools to streamline deployment and management tasks. Scaling and Capacity Planning: Monitor database resource usage and plan for scalability. Scale up or down database resources based on workload demands. Plan for data growth and storage requirements.