HENOK B. BEALEM

Address: **** * **** **., *********-VA 22202

Phone: 202-***-****

Email: ad43oh@r.postjobfree.com

www.linkedin.com/in/henok-bealem

PROFESSIONAL SUMMARY: Experienced Database Administrator with Ten years of expertise and extensive knowledge of Relational Database Management System including Database Monitoring, Installation, upgrade Management, High Availability, Disaster Recovery, Log Shipping, Clustering, configuration of Alerts, Operators and Agent Jobs. Well experienced in Performance Tuning and Security. Proficient in diverse range of development native and third-party tools as well as T-SQ languages. Experienced with SQL server Azure Cloud, MS Access, and Power BI. Experienced in Disaster Recovery (DR) Testing and planning. Excellent communication, presentation and delivery skills. Recognized consistently for performance excellence and contributions to success in IT, financial and healthcare industries. Microsoft certified SQL Server Database Administrator for SQL server 2012/2014/2016 and 2017.

EXPERIENCE

03/2019 - CURRENT

SQL SERVER DATABASE ADMINISTRATOR EPIC SYSTEMS INC., HERNDON, VA,

COMPANY INFORMATION: EPIC systems is a company with broad-based IT professionals that

provides reliable IT solutions and consulting services for government

agencies and privately owned commercial clients.

ROLES AND RESPONSIBILITIES:

Installed, upgraded, configured and tuned SQL Server 2012/2014/2016 and 2017 systems and all associated middleware in Windows environments.

Experience in monitoring and setting up High Availability and Disaster Recovery (HADR) Solutions like Database Mirroring, Replication (Snapshot, Merge, transactional), Log Shipping, and Availability Groups.

Proactively monitored database systems to ensure secure services with minimum downtime.

Worked in performance enhancement by running index tuning wizard for creating, rebuilding, and reorganizing indexes on various tables.

Monitored Performance and Fine-Tuned Stored Procedures, SQL Queries and User Defined Functions to optimize performance and reliability.

Worked to ensure all database servers are managed to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) as per the Service Level Agreement.

Built databases, tables, and various database objects per business requirement following SQL Server Database Modeler and ER Studio Data Architecture methodology.

Wrote and maintained technical and functional specifications to document database integrations and requirements;

Participated in on-call rotation supporting systems after-hours, weekends and holidays.

Analyzed and resolved performance issues, database capacity issues, replication, and other distributed data issues for all production and test databases.

Monitored Daily backup jobs and automation of daily restores of development databases. (Using Red gate, Idera, and Native backups)

Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.

Monitored and Troubleshoot Server performance and database activities of users using SQL Profiler, Performance Monitor, Extended Event, Trace flags, Activity Monitors, Stored Procedures, DBCC, and DMVs.

Monitored user accounts, created groups, granted necessary privileges to users and groups.

Created various server and databases alerts that helps to take actions proactively and reactively;

12/2017 - 03/2019

DATABASE ADMIN AND DEVELOPER AETNA HEALTH - DALLAS, TX

COMPANY INFORMATION: AETNA offers health insurance, dental, vision and other

plans to its customers. Data management regarding clients’

information, coverage, plan and payment systems are part of the

business.

ROLES AND RESPONSIBILITIES:

Evaluated, designed, implemented and modified databases and database applications.

Provided trend analysis to the service management team enabling them to make informed decisions regarding resource management;

Designed, reviewed, and created database objects like views, indexes, stored procedures, functions, and triggers based on logical and physical design models and user requirements;

Administered MS SQL Server security through access control mechanisms like creating accounts, roles, and providing privilege.

Maintained proper security procedures by dropping and locking unnecessary logins;

Configure SQL Server monitoring utilities to minimize false alarms;

Authored and coded logical and physical database descriptions

Collected and reviewed database performance metrics and proactively address performance concerns;

Configured and monitored log shipping and Database mirroring on Disaster recovery Servers;

Evaluate CPU, Disk I/O and Memory related bottlenecks using Performance Monitor and improved SQL server performance;

Utilized Alteryx to automate data preparation tasks, reducing manual effort by 50% and increasing efficiency in data processing.

Developed complex workflows in Alteryx to clean, blend, and transform large datasets from disparate sources, ensuring data integrity and consistency.

Conducted exploratory data analysis using Alteryx to identify trends, patterns, and outliers, providing actionable insights to stakeholders.

Created predictive models and performed advanced statistical analysis in Alteryx to forecast sales, customer behavior, and other key business metrics.

Collaborated with cross-functional teams to design and implement Alteryx workflows that address specific business challenges and drive decision-making.

Rebuild clustered and non-clustered Indexes as part of performance tuning

Delivered complex business requirements without any issues by leveraging strong troubleshooting skills and extensive oversight

Planned and implemented security measures to safeguard vital business data

Identified issues within databases, performed troubleshooting and implemented effective solutions

Created technical documentation for database technologies, providing updates as needed

06/2016 - 11/2017

SQL DATABASE ADMINISTRATOR- CAPITAL ONE FINANCIAL CORP.-WASHINGTON D.C

COMPANY INFORMATION: Capital One is one of the largest financial and banking

institution that serves millions of customers, businesses and

companies by providing loans and other financial services.

ROLES AND RESPONIBILITIES:

Designed and implemented TSQL queries for reporting and complex solution development.

Tune slow running T-SQL queries using Execution Plan and Database engine tuning advisor.

Developed and produced high-standard database solutions to meet stability, reliability and performance metrics.

Worked on data encryption to ensure security of data at rest and data in motion.

Participated and support Service Level Agreement (SLA) and operational performance monitoring and reporting.

Performed replication for updating a critical table to various branches (Subscribers).

Participated in root cause analysis and problem management activities;

Administered SQL Server/Database level Security and utilized Auditing and Data Encryption according to requirements.

Led incident resolution efforts, participated in incident management activities and engaged appropriate resources to complete corrective actions.

Enhanced performance by running index tuning wizard for creating, rebuilding, and reorganizing indexes on various tables.

Set up and controlled user profiles and access levels for each database segment to protect important data.

Created and managed database objects, stored procedures, triggers, views, and functions.

03/2014 - 05/2016

SQL SERVER DATABASE ADMIN AND CONSULTANT LEIDOS HOLDINGS INC. – RESTON, VA

COMPANY INFORMATION: LEIDOS HOLDINGS, INC. is a company which

engages in the provision of scientific, engineering

and information technology services and solutions in the areas

of defense, intelligence, civil and health markets.

ROLES AND RESPONSIBILITIES:

Participated in implementing database architecture and strategies, and defining standards for database environment;

Administered, maintained, developed and implemented policies and procedures for ensuring security and integrity of SQL Server databases;

Implemented disaster recovery strategy;

Developed and maintained standards for documentation, database security, and audit compliance;

Explained data results clearly and discussed how it can be utilized to support project objectives;

Contributed to internal activities for overall process improvements, efficiencies and innovation;

Respond to production incidents and address them with in Service Level Agreement (SLA) framework;

Undertook Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools and DMV's

Translated logical data models into physical database designs and developed physical databases

07/2011-02/2014

JUNIOR DATABASE ADMINISTRATOR AND DATA ANALYST CENTRAL STASTICS AGENCY: ADDIS ABABA, ETHIOPIA

COMPANY INFORMATION: Central Statistics Agency (CSA) of Ethiopia is a government agency

which is responsible to conduct census, collect data, and generate

statistical data related to the economic and social conditions of the

country.

ACTIVITIES:

Created and maintained databases in a client/server environment

Implemented and supported SQL Database transactional and data warehouse infrastructure on-prem.

Exported and Imported data from text files and excel to SQL server databases using bulk copy insert and BCP utility.

Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraints.

Worked to ensure the performance, availability, and security of databases.

Led upgrades, backups, and configuration of databases and instances.

Installed, authored and managed reports using SQL server Reporting Services.

Created Logon trigger to validate users connecting through different applications

Perform Database security, creating users, roles, and assigning permission to them

Created groups, roles, users and assigned access privileges to users as well as fixing issues related to orphaned users

Worked on Auditing logins and users in multiple servers

Created SQL scripts and defined functions, check constraints, indexes, and views.

EDUCATION

BACHELOR OF SOCIAL SCIENCE, ALEMAYA UNIVERSITY, ETHIOPIA; July 2008

Master of science: American University, Washington D.C, MAy 2017

SKILLS

Reporting and documentation

Implementing security measures

Systems Administration

Performance management and tuning.

Pl/SQL

CORE QUALIFICATIONS

MS SQL server 2005/2008/2008R2/2012-2019

MS Access 2005/2007/2010/2013/2016

Database Tools: SSMS, Database Engine Tuning Advisor, Query Analyzer, Query Store, Visual Studio, SQL Profiler, Power BI, SQL Schema compare, ER Studio,

Programming: SQL, T-SQL, XML, Power Shell Scripting

Operating Systems: Windows2012/2008R2/2003,

Project management and change management tools like Jira and ServiceNow

Network Topologies: TCP/IP, DNS, FTP, SNMP, SMTP

ETL And Reporting tools: SSRS, SSRS, DTS, BCP

Microsoft .NET framework

Data audits

Ensuring data integrity.

Backup and recovery

T-SQL

CERTIFICATION

MS Certified Database Admin for MS SQL servers 2012/14

ITIL Foundation V4 Certified

MS Certified Azure Database Administrator Associate

MS Certified Azure Data Fundamentals

Contact this candidate