Dawit Ejigu
SQL Server DBA at The Kardel Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Amharic -
Topline Score
Bio
Credentials
-
MCSA: SQL Server 2012/2014
MicrosoftJan, 2016- Nov, 2024 -
MCPS: Microsoft Certified Professional
MicrosoftAug, 2015- Nov, 2024 -
MCSA: SQL Server 2012
Microsoft
Experience
-
The Kardel Group
-
United States
-
Staffing and Recruiting
-
1 - 100 Employee
-
SQL Server DBA
-
Jul 2014 - Present
• Installed, Configured, and Managed SQL Server 2012, 2008/R2 and 2005 in Development, Test, and Production environment. • Provide general database administration and support for SQL Server Databases. • Create logins and match orphan users with their respective logins. • Backup and Restore mission critical databases and system databases. • Applied log backups for point in time recovery. • Used SQL Profiler extensively to capture slow running queries and other performance issues. • Experienced in using SQL dynamic views (DMVs) and functions for alleviation of database problems and monitoring database activities. • Extensively used SQL Server Agents to automate jobs, create alerts and operators. • Administered SQL server disaster recovery for high availability using database mirroring, log shipping. • Perform data movement using imports, exports, BCP and bulk inserts. • Created transactional and snapshot replication to increase object availability. • Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012. • Configured Snapshot and Transactional Replication • Developed set of administrative scripts to automate most daily operations. • Expert in Using DMVs, Performance dash board and tracking Performance Counters. • Rebuilding / monitoring the indexes at regular intervals for better performance. • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. • Involved in Source Data Analysis, designing and mapping for data extraction also responsible for Deployment and scheduling SSIS Packages to load the Data from various Databases and Files. • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This includes index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases. • Performed installation of SQL Enterprise Service packs on 2012, 2008 R2 and 2005 SQL Server
-
-
-
PACIFIC SYSTEMS
-
Georgia
-
SQL Server Database Administrator
-
Oct 2011 - May 2014
Installed SQL server 2008 and 2012 and upgrade SQL server from 2005, 2008 to 2012. •Designed a maintenance plan for index reorganize and index rebuild to increase performance. •Created and automated SQL server agent jobs that do backups of the database and logs on defined schedule and making sure the backups taken are successful and are restorable. •Applied transactional log backups for point in time recovery of restored databases. •Administered SQL server disaster recovery for high availability using Failover Clustering, Always ON and Database Mirroring to minimize downtime. •Monitored Windows and SQL Server logs for regular and irregular activities. •Refreshed the test server on regular basis and fixed orphan users. •Assisted developers in tuning SQL queries using execution plan, SQL server profiler and database engine tuning advisor. •Created databases, tables, clustered and non-clustered indexes, file and file groups for several instances as required. •Prepared templates for capturing traces using SQL profiler to resolve performance issue such as long running queries, lock escalation and deadlocks. •Experienced in using SQL dynamic views (DMVs) and functions for alleviating database problems and monitoring database activities. •Automated databases using SQL server agents by creating jobs, steps, schedules for a mixture activities. •Created alerts and notifications for system errors, insufficient resources (hardware, memory, CPU) and fatal database errors. •Experienced in implanting SQL server security by creating logins, user accounts and assign permissions for accounts created. •Encrypted databases using Transparent Data Encryption. •Employed extensive ETL (Extract, Transform, and Load) work using SSIS. •Created customized report using SQL Server Reporting Services to assist in decision support procedure. •Partitioned large tables that are difficult to manage into different file groups and different drives.
-
-
Education
-
2004 - 2008
Unity University
Bachelors of Science, Management -
1999 - 2003
Unity University
Associate Degree, Accounting -
1999 - 2000
Cambridge Education Group
Diploma, Business Administration/Management
Community
