Shifa Maxmariam

Sr Database Administrator @Amerisourcebergen

US

Designed backup strategies following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. Used block change tracking (BCT), reducing backup time from 5hrs down to 45mins. Resolved space issues with backup optimization, reducing storage costs by 20%.Applied Oracle\'s quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances. Implemented database migration from 11g to 12c using the Oracle Data pump and DBUA respectively. Cloned databases for testing using RMAN and DATAPUMP utilities for all database sizes. Installed and administered Physical Standby databases for single and multiple instances to achieve high availability and disaster recovery solution (DATA GUARD).Implemented table and index partitioning and materialized views to minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query. Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS_STATS, Trace files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports. Constructed database security policy using passwords, privileges, user profiles, Transparent Data Encryption to encrypt tables and Tablespaces; implemented auditing policies as well as data redaction and data masking.

Makerere University

Bachelor of Business Administration - BBA