Endegena Beyene

Phone: 832-***-****

adxx4c@r.postjobfree.com

SQL Database Administrator

OBJECTIVE:

Five years of experience in IT, as a SQL Server Database Administrator, I have administered and provisioned SQL servers 2012, 2014, 2016, 2017, and 2019 in Production, Test, Development, and Clustered Environments. I am a highly motivated self-starter with strong interpersonal and persuasive communication, outstanding problem-solving, and active listening skills. Having worked in several agile environments as the only DBA and with teams. My experience spans; Installation and Configuration of SQL Servers, Performance Tuning, High Availability and Disaster Recovery/Disaster prevention, Database Refresh, SQL Server Upgrades, and Patches, and the preparation and deployment of SSIS packages, SSRS packages, Active directories, and other Windows server features.

PROFESSIONAL SUMMARY:

Experience in High availability (Always-On) SQL Server solutions, including Replication Models (Snapshot/ Transactional), Mirroring, and HADR Setup Configuration based on the RPO/RTO objective of the application.

Practice in monitoring SQL Server with Red Gate, SQL Sentry monitoring tool.

Proficient in Setting Up encryption (Transparent Data Encryption (TDE), Always Encrypted, and Masking).

Skill in supporting a Very Large Database (VLDB) of about 8TB.

Operates in RDBMS database design, performance tuning, query optimization, backup, and recovery.

Experience in Disaster Recovery Planning and Setup, Server Tools like Import/Export Wizard, SQL Server Profiler, and SSDT.

Skillful in T-SQL & PowerShell Scripting

Experienced in setting up maintenance plans, creating jobs, and automating processes.

Expert in ETL processes like SSIS, SSAS and SSRS, and Power BI.

Professional in monitoring SQL Server with Red Gate monitoring tool.

Competent working with SSRS, Power Bi for Reporting and Data Visualization

Experienced in Setting Up Encryption (Transparent Data Encryption (TDE), Always Encrypted, and Dynamic Data Masking).

Implemented and granted SQL Server Logins, Roles & Permissions. Endegena Beyene

Phone: 832-***-****

adxx4c@r.postjobfree.com

SQL Database Administrator

Experienced in Migration from OnPrem to the Cloud (Microsoft Azure SQL Database, Managed Instance, and VMs) using Data Migration Assistance and PowerShell.

Supported MS SQL Server versions 2005/2008/2008R2/2012/2014/2016/ 2017 and 2019.

Experienced in setting up maintenance plans, creating jobs, and automating processes.

Good Knowledge of System Administration 2008/2012 R2/2016 Server.

Proficient in using the Service Now Ticketing system. EDUCATION BACKGROUND

● Bachelor's in Business Management

● Associate of Science in Aviation Technology

TECHNICAL SKILLS

● Database: MS SQL server 2000/2005/2008/2008R2/2012

● Technology Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server DTS, Visual Studio, Crystal Reports, and Knowledge of SQL Server

● Tech Stack: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio Net

● Microsoft Tools: MS Office, Management Studio, Visual Studio

● Cloud Database: Azure

EXPERIENCE

Citi Bank, Warren, NJ Dec 2020 – Present

SQL Database Administrator

Responsibilities:

Planning the Installation of Microsoft SQL Server 2012, 2014, 2016, 2017, and 2019, building, designing, Configuration, Upgrading, Migration, and application of Windows and SQL Patches during scheduled database nonproduction hours to ensure databases are up to date in Virtualized environments. Endegena Beyene

Phone: 832-***-****

adxx4c@r.postjobfree.com

SQL Database Administrator

Implementing and defining a vigorous Backup and Recovery strategy and Capacity planning following the company's SLA that its Recovery Point Objective (RPO) and Recovery Time Objective (RTO) and the Retention Policy.

Recommend and implement data security by creating users and assigning permissions based on the principle of least privileges and with technologies such as Always Encrypted, Transparent Data Encryption, and Dynamic Data Masking to secure clients’ sensitive data.

Using SQL servers’ in-built tools such as SQL Server profiler, Extended Events, and activity monitor to monitor performance and system health; Database Integrity checks to ensure database integrity, stability, and system availability.

Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlock issues, and updating statistics for query optimization using performance and activity monitor, event viewers, and extended events.

Creating and monitoring maintenance plans and agent jobs that automate backups and reorganize/rebuild indexes for query performance.

Review scripts submitted by the development team and work with other teams like systems analysts, developers, business analysts, and project teams to perform the capacity planning required to create and maintain the Databases.

Controlling and establishing appropriate database user access control levels by provisioning and deprovisioning users based upon company policy to control access for each segment of the Databases. Develop database security guidelines and perform audits.

Migrating SQL server databases from on-premises to AZURE using Data Migration Assistant.

Develop and monitor system and application alerts to ensure Health monitoring and performance tuning.

Creating and maintaining Azure, also managing SQL instances and databases. Comcast, Philadelphia, PA Jul 2018 –Sep 2020

SQL Database Administrator

Responsibilities:

Designed and implemented comprehensive Backup plans and disaster recovery strategies.

Managed SQL Servers in 32/64bit Clustered environments. Implemented Database Mirroring on SQL Server 2008 environments. Endegena Beyene

Phone: 832-***-****

adxx4c@r.postjobfree.com

SQL Database Administrator

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Web Services) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance.

Created and optimized database objects such as views, functions, and stored procedures as per requirement.

Used Notification services to generate error messages and send them to the user through emails.

Contact this candidate