Samuel Dibaba Email & Phone Number

Chicago, Il, Us

Chicago, Illinois, United States

- My current day to day activity is making sure all the databases are up and running.- Responsible for Installation, Upgrade, Configuration and Migration of SQL Server in clustered and non-clustered production environments.- Responsible for developing and optimizing database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.- Assigned permissions to users and roles, administered secure authenticated logins and supported columns level permission and other security related issues including creation and granting permissions on various objects.- Backing up and restoring the database manually and also by scheduling the jobs and maintenance plan as required. Also setting up AlwaysOn Availability Groups.- Developed and maintained PowerShell scripts to automate database administration tasks.- Proficient in creating efficient data pipelines and ETL processes using T-SQL, SSIS, and SSRS.- I am working closely with the development team to optimize database performance, troubleshoot database issues, and design database solutions.

Pekin, Illinois, United States

- Worked with developers to troubleshoot database-related issues and provide guidance on database design and optimization.- Experience in Rebuilding/ Reorganizing Indexes based on Index fragmentation levels.- Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.- Created maintenance jobs by using PowerShell scripting.- Implemented SQL server logins, Roles and Authentication modes as a part of security policies.- Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.

Auburn Hills, Michigan, United States

- Installed and configured SQL Server instances and performed regular maintenance tasks such as backup and recovery, database consistency checks, and index maintenance.- Managed and maintained multiple SQL Server instances, ensuring optimal performance, high availability, and disaster recovery.- Work with cloud-based services such as Azure SQL Database, Azure Data Factory, and virtual machines.- Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Charlotte, North Carolina, United States

- Created & maintained databases, tables, indexes, store procedures, roles, profiles, partitions and other schema objects.- Administration of clustered SQL Servers in 24 X 7 windows data center environment and supporting developers with SQL queries.- Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.- Created regular backups of databases and transaction logs.