TEHETINA G. TESSEMA

Tel. 571-***-****

Email: ad060o@r.postjobfree.com

EDUCATION

Bachelor of Science

A.S. – Computer Information Systems Technology – Northern Virginia Community College

Microsoft Certified: Azure

CERTIFICATION:

Microsoft Certified: Azure

MCSA (Microsoft Certified Solutions Associate) – SQL Server 2012/2014

Training on ETL Database Processing using SSIS, Sufia Institute of Science & Technology

Training on Report Development, Deployment, and Administration using SSRS(SQL Server Reporting Services, Sufia Institute of Science & Technology

Training on IIS 7.5: Application & Web Server Administration, Sufia Institute of Science & Technology

SKILLS:

Databases: Microsoft 2016, SQL Server 2014, 2012, 2008 R2, 2005, 2000, MS Access

Migration Skills: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server Oracle Database version 19c, Data Architecture, Data Modeling

Operating System: Windows Server 2012R2, 2008 R2, 2003 R2, 2000, UNIX/Linux, VMware, Azure, AWS

Languages: SQL, T-SQL, HTML, DHTML, XML, JavaScript, ASP, ASP.net

ETL/Data Warehouse Tools: SSIS/DTS, BCP

Reporting: SSRS (SQL Server Reporting Services) – Enterprise Reporting Experience in supporting SSIS, SSRS, replication, database mirroring,

SQL Reporting Services, DACPAC, BACPAC, ISPAC concept and deployment/automation of database objects,

Skilled in supporting SSIS, SSRS, replication, database mirroring,

SQL Reporting Services, ETL operations by SSIS using DTS, BIDS, SSDT, Informatica and SSMA tools.

Data Modeling Tools: ERWin, Toad Data Modeler, Visio, SSDD (SQL Server Database

Third Party Tools: SolarWinds, OpNet, RedGate, Idera, SpotLite, ERWin, Visio, SentryOne Toad Data Modeler Azure IaaS and using tools like IDERA/Redgate/OMS MMA or Dynatrace

Networking: Active Directory, DNS, TCP/IP

Hardware/Storage: SAN, RAID, iSCSI

EXPERIENCE:

05/2022 – Present

LexisNexis Reed Tech.

SQL Database Administrator

Administer and fine-tune PostgreSQL, Oracle (19c and above), MongoDB, and Redis databases in a large-scale enterprise environment.

Implement and manage Oracle Golden Gate replication, oracle Enterprise Manager, and Mongo Ops for ensuring data integrity and high availability.

Lead the design and implementation of AWS GovCloud solutions, including AWS RDS Oracle instances, and design multi-region data architectures of fault tolerance.

Develop and maintain dashboards for performance and data trend analysis, providing valuable insights to the management team.

Manage and administer Oracle and Mango DB databases, ensuring their performance, security, and availability.

Troubleshoot and resolve database-related issues promptly to minimize downtime and maintain high system availability.

Designs, installs, monitors, and maintains Dev, QA, and production Oracle (19c) database environments.

Backup/Recovery: Work experience and strong knowledge in disaster recovery. Rebuild databases using backups.

Installed, Configured and Maintained HA (High Availability) Solutions – AlwaysOn, Failover Database administrators needed to support, run, and change activities in the DBMS lifecycle.

Added new Servers to the current availability group based offered per AGL and created a new availability group based on the new server’s name.

Developed, Deployed, and Managed SSIS Packages using different types of sources such as Database, Flat file, CSV, Excel, and OLE DB supporting sources.

Work with the team to ensure appropriate security controls (i.e., Security Technical Implementation Guides (STIGs) are built into all databases and database instances. Oversee the database processes using industry best practices. Setup and STIGs validation and remediation experience Oracle Database version 19c versions.

Troubleshoot and Resolve Incident Requests (IRs) and Problem Requests (PRs)

Plan and execute Service Requests (SRs) and CRs as per SLA

Build, plan & implement System Maintenance change requests (CRs)

Administrated Azure AD users, groups, and pieces and participated in migration between on-premises and Azure AD through AD Connect.

Providing support, run and change activities in the DBMS lifecycle. Work closely with dba peers, product and project leaders/managers, and other in-house software developers.

Skills: STIG · TDE · Data Backup Solutions · System Deployment · Transact-SQL (T-SQL), Database Security Management, Documentation and reporting, Backup and Recovery Strategies,

Database replication and Clustering, Oracle Database Administration, MongoDB Administration, Database Performance Tuning and Disaster Recovery planning.

08/2018 – 05/2022

BarnAllen-ZAI, BA-ZAI JV, LLC - Fairfax, VA

SQL Database Administrator/QA

Conduct quality assurance reviews of government documents as part of the Warning Letter Quality Assurance Team to ensure accuracy prior to dissemination to tobacco retailers being reviewed by the FDA.

Review various documents from different sources and databases to make certain that all information detailed within such documents is accurate and consistent throughout.

Follow regulatory standards and prepare data for dissemination.

Maintain accurate and up-to-date documentation of project details.

Utilize quality control techniques to analyze data provided by subject matter experts and other such analysts. Report inaccuracies found through review of data to recommend corrective actions, so adjustments can be made prior to dissemination to retail establishments.

Apply a quality assurance plan to ensure that all the objectives are met and that standard operating procedures (SPOS)are followed.

Installed, Configured, and Administered SQL Server 2012, 2014, 2016 and 2017 in development, test, and production environment.

Designs, installs, monitors, and maintains Dev, QA, and production Oracle Database version 19c, database environments.

Installed new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.

Database High Availability: Installed, Configured and Managed Database Mirroring, AlwaysOn, and FailOver Cluster SQL/T-SQL, Triggers, And Stored Procedures: Wrote SQL, T-SQL, Stored-Procedures and triggers. Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers

Monitoring and Performance Tuning: Performed database monitoring and Performance tuning. Monitor Servers activity and worked with clients to solve different problems. Performed index and statistics management. Managed SQL Server Error Logs, space usage, and growth patterns. Used DBCC and ALTER C statements to check and manage database consistency, index fragmentation/rebuilding, and statistics.

Managed BLOCK and LOCK

Database Automation: Created Backup jobs for different types of backup like FULL, Differential, and Transaction Log. Created Jobs for database maintenance Index fragmentation, rebuild, database statistics

Data Modeling: Worked on different Data Modeling projects using ERwin for designing Logical & Physical database. Used Backward & Forward Engineering to create Logical and Physical database.

Index/Constraints, Triggers, Stored Procedure: Created and managed Index (Cluster/Non-Cluster), Constraints

Security Management: Created and Managed users, group roles, schema, and security at object level, data encryption Export & Import data from/to Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files to SQL Server 2005/2008

Database Migration: Migrated MS Access databases into MS SQL Server. Migrated Oracle 10g, MySQL database into MS SQL Server 2008R2. Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database,

Backup/Recovery: Work experience and strong knowledge in disaster recovery. Rebuild databases using backups.

Reports: Installed, Configured, and administered SQL Server Reporting Services (SSRS). Developed Reports using SSRS. Developed Ad-hoc Reports using Report Builder 3.0, 2.0. Deployed Reports. Managed security for reports

07/2020 – 09/2020

Veterans United Home Loans- United Drive Columbia

SQL Database Administrator/Architect

Installed, Configured and Managed Microsoft 2016, 2019, AlwaysON and Fail-Over Cluster, Mirroring SQL/T-SQL, Triggers, And Stored Procedure: Wrote SQL, T-SQL, Stored-Procedures and triggers. Always On (Spilt Brain in SQL)

Worked as cloud administrator on Microsoft Azure, involved in configuring virtual machines' storage accounts and resource groups.

Assisted in database backup and recovery operations, ensuring data integrity and availability.

Strong Endpoint devise support experience (i.e., desktop Computers, laptops, Surface hubs, surface pro)

Administrated Azure AD users, groups, and pieces and participated in migration between on -premises and Azure AD through AD connect.

Installed, Configured, and Maintained HA (High Availability) Solutions – AlwaysOn, Failover Clustering, Replications, Mirroring, and Log Shipping.

Designed packages that utilized tasks and transformations such as executing SQL tasks, executing process tasks, send mail tasks, FTP tasks, executing package tasks, xml tasks, data flow tasks, sequence container, for each loop container, lookup, aggregate, expression, ole db command, and derived column. Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.

Installed, Configured, and Administered SQL Server 2014, 2016, and 2017 in development, test, and production environment Database High Availability:

Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers and monitoring and Performance Tuning: Performed database monitoring and Performance tuning.

Security Management: Created and Managed users, group roles, schema, and security at object level, data encryption

Decom the server and Database, Installed, Configured, and Managed Instances and Databases in SQL Server 2016, 2014, 2012, and 2008R2 in development, Training, Staging, Test/UAT, and Production Environment

Database Automation: Created Backup jobs for different types of backups like FULL, Differential and

Transaction Log. Created Jobs for database maintenance Index fragmentation, rebuild, database statistics.

Designed and Developed ETL Process for integrating data from sources like Excel, CSV, Flat Files, Web Services, XML Source and Microsoft SQL Server 2016

11/2016 – 08/2018

Prism-Perspecta, HPE Contract with the DOD (DMDC), Alexandria, VA

SQL Database Administrator/SPOT-Application Database.

Installed, Configured, and Managed Instances and Databases in SQL Server 2016, 2014, 2012, and 2008R2 in development, Training, Staging, Test/UAT, and Production Environment

Installed, Configured and Maintained HA (High Availability) Solutions – AlwaysOn, Failover Clustering, Replications, Mirroring, and Log Shipping

Installed, Configured, and Managed Instances of SQL Server Reporting Services (SSRS)

Developed, Deployed and Managed Reports using different data sources like SQL Server, Oracle, Excel, CSV files

Upgraded/Migrated SQL Server and Reporting Server Instances

Applied SP (Service Packs) and Hot fixes.

Migrated Databases and Instances

oSQL Server to SQL Server

oOracle Databases to SQL Server

oMySQL Databases to SQL Server

oMS Access Databases to MS SQL Server

oMonitoring, Troubleshooting Instances, Databases, Queries using different tools.

oQuery Execution plans

oDatabase Tuning Advisor

oPerfMon

oServer Logs, Agent Logs and Error Logs, Event Logs

oDMV (Dynamic Management View)

oProfiler

oIndexing, Index and Statistics Management

Developed and Tune-up Queries

oQueries including JOIN, Stored Procedures, Functions and other queries.

oWorked developers to tune-up queries related to performance issues.

Database Design

oDesigned new database systems for applications and redesigned existing database systems.

oDesigned Relationship, Keys, constraints, indexes, and other constraints for data integrity and performance.

oConceptual, Logical and Physical Design

oBackward and Forward Engineering

oUsed native and Third-Party tools – ERWin, Visio, Toad Data Modeler

Database Architecture – Solid experience on architecting Database Server Instances

Automations – Create jobs, setup schedules, configure mail server, operators, notifications and other related services Database Backup – Designed backup strategies for development, Training, Staging, Test/UAT, and Production Environment, setup automated backup verification process for backups.

Database Recovery, Refresh and Deployment – Performed Database Recovery, Refresh/Deployment across the environment including Point-In-Time Recovery

Data Masking, Encryption (TDE: Transparent Data Encryption)

Monitoring database and server health, lock, block, disk, CPU, jobs and other related services

ETL Processing Installed, Configured, and Managed SSIS (SQL Server Integration Services) Instance

Developed, Deployed and Managed SSIS Packages using different types of sources such as Database, Flat file, CSV, Excel and OLE DB supporting sources

Migrated and Upgraded SSIS Packages

Setup jobs using SSIS Packages

Managed security

Used SSIS packages for many other purposes – Moving logins, databases, data, and for other objects, • Instance, Databases, and Users Security Management

Work Environment: Windows Server 2012, 2008 R2, 2003 R2, SQL Server 2014, 2012, 2008R2, 2005, AD (Active Directory), Applications, Reporting System and Databases

Help Desk Support/SPOT-Application Database.

Answered Incoming calls regarding Deployment and LOA Questions in SPOT (SYNCHRONIZED PREDEPLOYMENT OPERATIONAL TRACKER)

Entered all customer inquiries into the call/problem tracking system CRM in a timely manner.

Helped User to Register In SPOT

Maintained confidentiality of client information.

Handled Sensitive Data and Dispose of Sensitive information in Database, also physically helped the team organize for the week and push forward with the objective

Verbally led users through diagnostic procedures to determine error source(s).

Evaluated, prioritized and provided technical support for incoming calls and emails.

Assisted Customer, user to log-in SPOT Account and Reactivation.

08/2010 – 10/2016

Intersections, Inc., Chantilly, VA

Database Administrator/Help Desk/Web Support

Working individually, as a member of a team, and lead small teams to design and model systems at a high level prior to construction.

Evaluated, prioritized, and provided first-level technical support for incoming calls and emails. Maintained confidentiality of client information.

Verbally led users through diagnostic procedures to determine error source(s).

Troubleshot website issues.

Reset passwords, pins and authorizations in adherence with established guidelines.

Utilized Remedy ticketing system.

Database Administrator

Migrated and upgraded from SQL Server 2005, 2008/2008 R2 to SQL Server 2012

Configured database software, associated database tools and performance monitoring software.

Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.

Performed acceptance testing to verify that database changes perform without adverse consequences.

Managed High Availability Solutions in Database Clustering, Mirroring, and Log Shipping

Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.

Developed & maintained scripts, utility jobs or implement needed software for database maintenance.

Developed, tested & implemented database backup and recovery strategy with client assistance.

Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.

Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.

Adhered to Change Control Procedures and developed & executed script changes requests in accordance with change control procedures.

Set up security and access profiles and procedures for database system administrators.

Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.

Managed security by defining roles and rights.

Expertise in database Performance tuning

Working individually, as a member of a team, and lead small teams to design and model systems at a high level prior to construction.

Work Environment: Windows Server 2012, 2008 R2, 2003 R2, SQL Server 2012, 2008R2, 2005, AD (Active Directory), Applications, Reporting System and Databases

Contact this candidate