Demas B Kefale

**** ***** ****** **. *******, NC 28025, 704-***-****

ad2p2p@r.postjobfree.com

PROFESSIONAL SUMMARY

An experienced, dedicated, and hard-working data professional with 5 years of experience on SQL Server Database Developer and Database Administration

Server Installation and Configuration, Server/Database Security

High Availability and Disaster Recovery

Automating administrative tasks

Performance Tuning and Query Optimization

Expertise in implementing different types of high availability and disaster recovery mechanisms such as log shipping, clustering and Always on Availability group setup and configuration.

Working Knowledge in Extracting, Transforming and Loading (ETL) data from Flat file to relational RDBMS like MS SQL Server by using BCP utility and SSIS services.

Familiar with T-SQL Programming skills in creating triggers, tables, stored procedures, and other applications.

Writing complex Queries based on parameters.

Azure cloud infrastructure and services

Migrate numerous databases across multiple environments while coordinating with different teams.

Work well 24 x 7 production database on call support.

Great working experience on Physical Servers, VMs and power shell scripting

Maintained positive communications and working relationships at all business levels.

Amazon Concord, North Carolina (Jul 2018-Jul 2023)

SQL Database Developer / SQL Server Database Administrator (DBA)

Support database administration tasks including configuration management, backup/recovery, performance optimization, and space management.

Install SQL Server on Test and Development environments; applied applicable service packs.

Responsible for setting up security and providing user access to SQL Server instances and objects.

Re-build or re-organize fragmented indexes to improve and ensure the overall database performance.

Monitor backup jobs on all enterprise databases and perform routine disaster recovery scenarios.

Plan and coordinate database refresh from one environment to another.

Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor.

Maintain proper documentation of server and database configuration changes.

Configure SQL Server Transactional Replication onto servers.

Implement and maintain Always on Availability Groups and Disaster Recovery Procedures.

Design Database Maintenance Plans to check database consistency, reorganize indexes, and update stats.

Retrieve business required data from different tables using complex queries like nested or subqueries and different joins (self, outer and cross).

Use SSIS (SQL Server Integration Services) to produce a more efficient Data Warehouse for reporting that comes from different daily transactions.

Creating SSIS packages using proper control and data flow elements with error handling.

Data transformation from source to destination with data type change based on business needs.

Designed SSIS packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Conditional split, Data conversion, Derived column and Multi casting.

Education:

Associate Degree of Pharmacy at Jimma University

Undergraduate of Pharmacy D at Central Piedmont Community College

Licensed Pharmacy Technician at Pharmacy Board

Associate degree of Medical Ultrasound at Caldwell Community College

SQL Server DBA from my Vision Match Training Center

Certification:

Certified with Completion of Pharmacy Technician Training

Certified with completion of Microsoft office at Goodwill University

Contact this candidate