Mail Agent Database Administrator

HILINA BEKELE

Email: ************@*****.***

Phone: 224-***-****

•Career Objective

To seek an organization where my abilities and talents will be utilized to the fullest and where my desire to succeed will be an asset. I am seeking a position where I will be given an opportunity to work effectively and efficiently.

•Professional Summary

•6+ years of experience in Database Administration, Database Design, Data Warehousing, Development & Support of MS SQL Server 20019/2017/2016/2014 in Production & Development environments.

•Proficient of MS SQL Server implementing new features like Row and Page compression mechanism, Change Data Capture, Shrinking Databases, Resource Governor, Performance Data Collector and Transparent Data Encryption.

•Performed Log Shipping and implemented Replication as High Availability techniques.

•Experience in Database Mirroring as Disaster Recovery Solution.

•Experience in Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions, and other Transact-SQL (DDL, DML) statements for various applications.

•Tracked Server Activity, Query Performance and Disk usage activity statistics via Performance Data Collection.

•Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

•Implemented concepts like Data partitioning, Snapshot Isolation, Online Indexing, Try-Cache Blocks, DDL Triggers and DMV & DMF.

•Experience in Data Migration (using tools like DTS, BULK_INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.

•Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor.

•Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.

•Experience in creation of logins, users and configuring permissions and assigning roles to users.

•Good understanding of Normalization /De-normalization, Normal Form, and database design methodology.

•Experience in Migrating of SQL Server 2014 to SQL Server 2016 & SQL Server 20017 to SQL Server 2019 using suitable approach.

•Experience in working with Windows Server 2012 Enterprise Edition, Windows 2000 Advanced Server, Windows 2000 Server, and Windows NT.

•Education

•Bachelor of Science in Information Science and Systems, Radford University, Virginia.

•Technical Skills

•Databases : MS SQL Server 2019, 2017, MS SQL Server 2016, 2014

•Programming : Visual Basic 6, Visual Basic 5, C, C++ & SQL

•DBA : Database administration of MS SQL Server 2012,2008, 2005

•OS : Windows 2014/2012 Advanced Server, NT & Windows 9x, Linux

•Tools : Backup Utility, SQL LiteSpeed, Visio

•Network Topologies : TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

•Certifications

•CompTIA Security+ Certified

•Project Details

•CareMetx, LLC Bethesda, MD September 2017 – Current

SQL Database Administrator

CareMetx, LLC is a full spectrum of post-commercialization “hub” services for specialty pharmaceutical, biotech and device manufacturers. CareMetx delivers customized reimbursement, clinical and alternative coverage solutions to support complex and often high-cost products.

Responsibilities

•Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration

•Migrated SQL server 2014 to SQL Server 2016 in Microsoft Windows Server 2012 Enterprise Edition.

•Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2014.

•Expert in Using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.

•Rebuilding / Monitoring the indexes at regular intervals for better performance.

•Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

•Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

•Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

•Expert in implementing the snapshot isolation and DDL triggers.

•Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

•Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).

•Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).

Environment: SQL Server 2017/2016 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services.

•Pulse Community Care, LLC, Silver Spring, MD November 2014 – August 2017

SQL Database Administrator

Pulse Community Care LLC, an Acupuncture clinic in Silver Spring, offers acupuncture, Chinese herbal medicine, and cupping, at affordable prices. They are a practice founded on the belief that everyone deserves heartfelt healthcare, and they are committed to leading by example.

Responsibilities:

•Database Administrator, Database Programming.

•Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

•Rebuilding the indexes at regular intervals for better performance

•Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

•Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

•Monitored and modified Performance using execution plans and Index tuning.

•Rebuilding the indexes at regular intervals for better performance.

•Deploying new code base release to UAT and Production Environments.

•Perform SQL Server service pack and Windows Service pack upgrades.

•Extensively worked on Enterprise Manager for managing the database.

•Troubleshoot performance problems and fine-tuning of databases.

•Involved in Index Analysis and Performance Tuning.

•Migrating SQL Server 2014 data bases into SQL Server 2016.

Environment: SQL Server 2016, SQL Server 2014, Windows 2014/2012 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Contact this candidate