Johanna Tesfaye

Rosenberg, TX. 832-***-****.

adv6fz@r.postjobfree.com

www.linkedin.com/in/Yohannatesfaye

PROFILE OF QUALIFICATIONS

Passionate database administrator with 10+ years of experience in Microsoft SQL Server Database installation, Configuration, Administration, and performance Turning, Backup and duster recovery experience in SQL Services 2016/2014/2012/2019/2008R2.

Hands-on experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, cursors, and functions to meet business requirements.

Experts in implementation different types of high availability and disaster recovery maintenance using visual studio and reporting services.

Worked on Clustering and server consolidation, troubleshooting production issues.

Experienced in RDBMS concepts and constructions to design relational database model and implementation as per business needs.

Worked on performance enhancement features such as partitioning, compression, and materialized views.

In-depth knowledge of Redshift architecture, performance tuning, and optimization techniques.

Resource Capacity Planning for database servers, design and deploy databases to a development, test, training, and production environment.

Experienced in Extracting, Transforming, and loading ETL data from excel, Flat file, Oracle to MS SQL server by using DTS and SSIS services.

Expert in turning database by choosing index and using Database Engine Turning Advisors profiler, and other native and other third-party tools.

Experienced monitoring and optimizing the performance of the database.

24/7 production Database on call support.

Supported database availability and performance in cloud service including on Amazon Web Services (AWS)and Microsoft AZURE.

Knowledgeable in implementing SQL Server Security and maintaining user permissions, configuring database authentication models, and assigning roles to users.

Dynamic communication and interpersonal relation skills with a continual commitment to cultivating strong client relations, motivating teams, and aligning all daily operations with long-term client and company objectives.

EDUCATION

University of Houston-Downtown, HOUSTON, TX

• Bachelor's Degree in Computer Science

KEY AREAS OF EXPERTISE

Languages

Proficient with: T-SQL, HTML, CSS, JavaScript, XML, C++ and Python

Familiar with: Java

Client Side: HTML, JavaScript & CSS

RDBMS: Microsoft SQL server 2007/2010/2013/2016/2019

DevOps: AWS, GitHub, EC2, Maven, S3

Testing: Unit Testing, Selenium, Cucumber, API, Mockito, Postman SQL

Backup/Recovery: SQL Server Native & Third-Party Tools (Redgate SQL Backup Pro)

Server Virtualization: Worked on migrating and managing database systems on VMware virtual machines.

Service Tools: Management studio, SQL Profiler, DTS/SSIS (ETL), Database Turning Advisor (DTA), Redgate, Golden Gate

BI and Modeling Tool: SSIS, SSRS, SSMS and SSAS

Software

Database: MySQL, Microsoft Access, Oracle, and NoSQL

Testing tools: Postman, Selenium web driver

Platforms: Microsoft Windows®, MacOS, UNIX/LINUX, Salesforce, and Android.

SENIOR SQL DATABASE ADMINSTRATOR

TENET HEALTHCARE CORPORATION 04/2021-present

Houston, TX

Supported SQL Server 2008R2 and 2012 SQL Server Administration and Maintenance.

Design and implement security plans for databases by specifying appropriate access for users, develop plans/policies to monitor and prevent inappropriate access.

Applied patches and services packs, hot fixes to update different, versions of MS SQL server.

Implementing and configuring Always-On High Availability on MSSQL server 201-2016.

Experienced in implementing HARD solutions like clustering Replication and log shipping and Always-0n.

Responsible for Deploying, scheduling a job, alerting, and maintaining SSIS packages.

Implement and manage Event Handlers, Package Configuration, Logging System and User- defined Variables, Check points and Expressions for SSIS packages.

Use SSIS to move data from heterogeneous sources to SQL Server in a timely manner.

Collaborate with users, team lead, DBA, and the technical manager to understand the system requirements.

Experienced in T-SQL Programming, tuning SQL queries and creating different database objects.

Implement Log shipping and Transactional Replication for multiple databases.

Install, Manage, and administer SQL server 2008R2/2012/2014 SQL servers.

Developed automated Jobs to handle routine tasks and SSIS Packages deployments.

Performed Database backup, Integrity checks, index Rebuild, index Reorganize and Update statistics.

Troubleshoot, evaluate, and resolve connectivity issues for applications on Azure.

Responsible for installing, maintaining, and tuning MS SQL Databases

Review Stored Procedures for optimization and improved performance.

Develop Power Shell Scripts to execute batch files and other tasks.

Document Database Installations, Upgrades and Conversions.

Participated in SQL server Logical and Physical Database Designs, Implementations, Maintenance and Data Modeling Process.

Built SSIS packages involved ETL process, extracted data from various flat files, excel files, legacy systems and loaded into SQL server.

Used SSIS tools like Import/ Export Wizard, Package Installation, Package Designer and organizing components into containers (sequential, for loop and for each container).

SENIOR SQL DATABASE ADMINSTRATOR

BCFS EMERGENCY MANAGEMENT 08/2019-04/2021

SAN ANTONIO, TX

Actively participated in all phases of the Software Development Life Cycle (SDLC).

Overseeing program intakes, hotline staff and coverage, tracking program data, developing data collection, and providing regular and ad hoc programmatic reports.

Responsible for data migration from Excel, Flat file to Microsoft SQL server by using BCP and DTS utilities as well as Extracting, Transforming and Loading of data using Microsoft SQL server SSIS and DTS.

Administered and maintained large-scale Redshift clusters, ensuring high availability, reliability, and performance.

Created and executed test cases and created input data values for functional testing including positive and negative testing.

Manually executed test cases and reporting results to development teams.

Created Alerts and Notifications for System Errors, insufficient Resources, fatal Database errors and hardware errors.

Implemented database replication and mirroring as of High availability options to cloud database.

Implement and manage Event Handlers, Package Configuration, Logging System and User- defined Variables, Check points and Expressions for SSIS packages.

Deploy technical services and handle incidents by using the Microsoft Azure platform to enhance customer experiences.

Knowledge of monitoring, logging and cost management tools that integrate with AWS.

Expertise in driving deployment of customers’ workloads into Azure and increasing satisfaction of by providing deployment guidance and support performed Database Migration from On-Premises SQL environment to Azure Database.

Installed SSIS services and maintain SSISDB database for successful package deployment.

SQL DATABASE ADMINSTRATOR

NUECES INFUSION CENTER, 05/2014-08/2019

Corpus Christi, TX

Actively work as a member of our team to develop and implement improvements into the way the team completes its work.

Installed SQL Server, applied hot fixes, cumulative and service packs per Business Required Docs.

Configured instances, updated, modified, moved, dropped, and Truncated objects/data files per application owner’s request.

Generated and run scripts with appropriate procedures and ticketing of the company policy.

Create T-SQL scripts to perform complex queries and complex data manipulations.

Created tables, views, store procedures, functions, cursors, indexes, and triggers as per management requested using either GUI or T-SQL script. I have extensive experience in writing T-SQL script.

Granted, revoked, denied logins, and mapped users with appropriate object/database and assigned roles, linked servers with each other, and created audit, specification, policy, condition and TDE depending on company policy.

simple, full, and bulk logged recovery models, and took full, differential, transactional log and copy-only backups and restoring them.

Migrated and updated databases into different platform, software, and versions.

Deployed some databases from on-prem to Azure cloud and synchronized securities.

Configured different HADR solutions like log shipping, mirroring, AlwaysOn, cluster and transactional replication.

Installed SQL server on window cluster environment, setup quorum, added roles like Distribute Transaction Coordinate (DTC), added nodes, checked/added available disks, brought them online, and configured critical databases for HA.

Through Failover management, managed all services of SQL server failover cluster.

Configured transactional replication, created distributor, selected articles to create publisher and then replicated to subscriber to off load tasks or load balancing between publisher server and subscriber servers.

Built SSIS packages involved ETL process, extracted data from various flat files, excel files, legacy systems and loaded into SQL server.

Used SSIS tools like Import/ Export Wizard, Package Installation, Package Designer, BCP and organizing components into containers (sequential, for loop and for each container).

Generated reports and analyzed data. Day-to-day monitoring and maintenance of database.

Monitored and managed Redshift clusters to ensure high availability, reliability, and performance.

Used DBCC Utilities to maintain the consistency and integrity of a database.

Maintained SQL server performance with native tools like index tuning wizard, data base tuning-advisor, profiler, performance monitor, activity monitor, Event Viewer.

Comprised Performance Tuning, Query Optimization, Client/Server Connectivity, and database health check, Indexing, Updating Statistics.

SQL SERVER DATABASE ADMINSTRATOR,

MD ANDERSON 02/2011 – 04/2014

Houston, Tx

Created maintenance jobs by using PowerShell scripts. Help the application team identify the blocking process by collecting on blocked processes.

Responsible for test Design, Test Development, Test Cases execution.

Modified stored procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL Joints for SQL server.

Administering large postgre database ability to do performance turning/Index maintenance experience of backing up and restoring Postgre SQL database on a regular basis.

Monitoring SQL Server performance using 3rd party system monitors and SQL profiler.

Implemented Data collector to capture the CPU, DISK, and Memory Counters.

Monitored all scheduled Jobs and identified the root causes of failed Jobs.

Performed Backup Compression for efficient utilization of disk space in SQL Servers.

Implemented table and index partitioning for performance and manageability.

Worked on different business processes and understood the data flow, criticality, and dependencies.

Transferred Data from various Data sources/Business Systems including MS Excel, MS Access and Flat Files to SQL Server using SSIS Packages.

Involved in SQL Server Reporting Services (SSRS) reports and SQL Server Integration Services (SSIS) projects.

Perform all database management responsibilities in Microsoft Azure for production and non-production workloads.

Managed Server/Database level Security by creating appropriate Server/Database roles and object level permissions.

ACHIEVEMENTS

Fall 2019 Honor Roll Student, University of Houston-Downtown

National Leadership Honor Society

Contact this candidate