Sisay Tegegne

Experience

• 

  CIBC Bank

  Nov 2017 - Apr 2019

  Junior SQL DBA

  Created tables, views, stored procedures as per design needs. Involved in Upgrading the Instance of SQL Server 2016 to SQL Server 2019 in testing and production. Implementing Database mirroring using high safety with automatic failover for Disaster Recovery. Implemented Constraints (Primary Key, Foreign Keys, Check and Not Null) and fine-tune Indexes Create and Modify Stored Procedures, as per business requirements. Able to write/manage scripts in TSQL, PowerShell. Designed and implemented a SQL backup strategy using full, differential, and transaction log backups to ensure data integrity. Developed various reports to validate the data between source and the target systems. Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries. Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer Database Engine Tuning AdvisorWorked on database refresh by taking backup from production database to development servers. Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis. Performed backups, DBCC utilities, updated index statistics, monitored database and disk space, security issues and scheduled tasks. Created & maintained databases, tables, indexes, store procedures, roles, profiles, partitions and other schema objects. Collaborate with cross-functional teams, including DBAs and developers, to ensure seamless integration of SQL-based solutions. Show less

• 

  Shoppers Drug Mart

  May 2019 - Feb 2022

  SQL Server DBA

  Administer and maintain SQL Server databases for Shoppers Drug Mart, ensuring their availability, security, and optimal performance. Administered disaster recovery solutions including log shipping and mirroring (SQL DBA focus). Maintained data integrity by performing validation checks. Optimized queries tuned and monitored server performance. Involved in fine-tuning of database objects and server to ensure efficient data retrieval. Designed backup strategy and implemented disaster recovery using log shipping and mirroring. (RTO &RPO). Monitored performance and optimize SQL queries for maximum efficiency. Performing query plans and making sure each query is using appropriate indexes. Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity. Created reports basing on the requirements using SSRS. Wrote queries for the drill down reports, parameterized reports. Resolve database integrity, performance, blocking, connectivity, and high availability issues. Implemented database Mirroring and Log Shipping for disaster recovery. Resolving performance related issues to blocking, deadlocks and long running queries. Checking Database Health and consistency by using DBCC Commands and DMVS. Creating Backup strategies and scheduling them as part of database maintenance plans. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies. Experienced in performing regular database backups to Azure Show less

• 

  Rogers Communications

  Mar 2022 - now

  SQL Server DBA

  Managed SQL Server databases, ensuring availability, security, and optimal performance. Install, Manage and administer SQL server 2016/2019/2022 SQL servers. Implemented side by side and In-place upgradation of MS SQL server 2016/2019 to 2022. Applied Patches and Service packs, hot fixes to update different versions of MS SQL server. Implemented and configured Always On High Availability in MSSQL Server 2019. Experience in implementing HADR solutions like Clustering, Replication, and Log shipping. Used shrinking/compression options in backup and restore jobs for storage space management. Created and modified Database objects as per change requests from Development teams. Performed database consistency checks using DBCC Utilities and handling data corruption. Experience in Rebuilding/ Reorganizing Indexes based on Index fragmentation levels. Design and implement stored procedures and triggers to enhance application performance and business logic. Configured the DB SMTP mail and Alert system for notification purposes. Created and scheduled maintenance plans for jobs like checking fragmentation and backup plans. Experienced in Automating Process by Creating jobs, and error reporting using Alerts, Mail Agent. Configured SQL Server Clustering on Windows Failover Clustering and Always On Availability Groups for high availability. (HA/Failover technologies). Used Database Tuning Advisor, Perf. Monitor and Activity Monitor for performance tuning. Automated and configured management tasks using PowerShell scripting language. Performing query plans and making sure each query is using appropriate indexes. Experience in SQL Server Reporting Services. Created Logins and Roles with appropriate Permissions. Fixed SQL server failed logins following migration projects following detach/attach decisions. Skilled at prioritizing and resolving issues within the framework of a ticketing system. Maintain comprehensive documentation for database configuration process and procedure. Show less