Ephrem Dinkineh

About Ephrem Dinkineh

with a Bachelor’s Degree in Computer Science and over seven years of hands-on experience as a SQL Database Administrator, I excel in deploying, configuring, migrating, and optimizing SQL Server environments across diverse settings. I am passionate about leveraging new technologies to solve complex database challenges, as demonstrated by my successful migration of critical databases to Windows Azure and my commitment to performance enhancement across multiple SQL Server platforms. My technical proficiency encompasses crafting robust T-SQL scripts, stored procedures, tables, views, functions, triggers, and indexes, ensuring optimal system performance. I am adept at utilizing tools such as Cohesity, RedGate, and ServiceNow, and I have extensive experience managing SQL Server versions from 2012 through 2022. Additionally, I provide reliable 24/7 production support and swift problem resolution, ensuring uninterrupted database operations.

Experience

1. Sql Server Database Administrator

   TransCore

   Feb 2021 — Present · Houston, TX, US

   Responsibilities :• Installation, Upgrade, Configuration and Migration of SQL Server in clustered and non-clustered environments. • Analyzed various SQL server environments and suggested best practices for better performance.• Create and maintain databases on production and development environments.• Responsible for implementing high availability with Always On Availability Groups and failover clustering.• Created necessary T-SQL Scripts, Stored Procedures, Tables, Views, Functions, Triggers and Indexes.• Experience in Windows Azure, migrating database to Azure.• Responsible for providing SQL server problem Resolution and 24x7 production support and server outages. • Create Automation of day to day operations of server alerts and repetitive tasks.• Setup and Maintain High Availability and Disaster Recovery Solutions, between various environments.• Involved in resolving deadlock and blocking issues for concurrent users. • Configure and maintain transactional and snapshot replication for the production environment. • Configure database mail, linked servers, transparent data encryption (TDE) and security Auditing.• Rebuilding and reorganizing indexes at regular intervals for better performance. • Evaluate database performance and performed maintenance duties such as tuning, backup, restoring and disaster recovery. • Create and maintain various logins and managed security based on the required access.• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary, to work with technicians from other departments.• Responsible for securing SQL Server, user management, and taking care of permissions and roles.• 24 x 7 on call production support.

Education

• Adama University

  Bachelor's degree

  2003 — 2007

• Admas University

  Bachelor's degree

  2008 — 2011