Anita Uwamahoro
Denver,CO
Summary
I hold 7 years of IT and related experience with extensive knowledge and proficiency in Oracle 11g, 12c, 18c and 19c database administration and system analysis within a multifaceted environment. Possess excellent communication skills and a talented team player with a fast-learning curve. Works perfectly and effectively under stressful conditions where speed and accuracy are necessary for mission critical databases. Remarkable attention-to-detail with the ability to coordinate multiple activities; determine and analyze problems and implement corrective actions. Worked on various operating systems like UNIX, LINUX, Windows, AIX and Solaris. Experience includes Patching, Cloning, Memory Management, Database Security, System maintenance, Database design and Modeling, Capacity planning, deployment, backup/recovery and Documentation.
Overview
7
7
years of professional experience
Work History
Oracle Database Administrator (DBA)
Info Way Solutions
08.2019 - Current
- Partitioned tables & indexes and, created and optimized indexes for high-performance applications
- Created physical databases with multiple tablespaces from logical and physical data model
- Cloned production databases as needed for testing and development using RMAN and Grid Control
- Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies
- Refreshed/cloned databases using RMAN utility
- Performed Database upgrade from Oracle 10g, 11g to 12c, 18c and 19c
- Built and configured RMAN Recovery Catalog for Backup and Recovery strategy
- Configured Physical Standby on Oracle 12c
- Scheduled daily Exports/Imports to serve as temporary backups
- Implemented Oracle Database advanced security practices such as Virtual Database Privacy, TDE and Data Masking
- Worked on on-call and queue manager roles as part of the DBA team
- Configured and managed standby databases using Data Guard
- Performed SQL tuning using tools such as SQL Tuning Advisor, SQL Trace, ASH, AWR, and Explain Plan
- 24x7 remote support and on call Database support using RSA-VPN
- Utilized the broker to manage Dataguard physical and standby databases
- Designed, tested, implemented, and documented database migration procedures involving the use of the export/import utilities and Transportable Tablespace
- Identified and worked with developers on automating processes using shell scripts to minimize errors
- Hands on experience in UNIX scripting
- Worked on database security including Auditing (standard auditing, fine grain, valued based and statement auditing), Encrypting (Transparent Table Encryption – TDE)
- Used a varied range of backup optimization techniques including incremental backup, stripping, resilient or mirror, compressed backup and backup with checksum
- Automated process using CRONTAB
- Performed daily database security tasks like login issues, access privileges, installing client software on pc, creating, and managing tables and indexes
- Performed Oracle Database LifeCycle Management (LCM) tasks that included migrations, patching, upgrades, automation, and decommissioning legacy databases
- Upgraded databases from 10g, 11g to 12c, 18c, 19c by doing either in place upgrades for dedicated databases or migrations for shared databases
- Installed and configured Oracle 11g, 12c, 18c and 19c software on AIX / UNIX / LINUX operating systems
- Applied Oracle quarterly patches of the current PSU version to non-RAC and RAC configured databases
- Performed data and metadata transfer from legacy servers to newly installed servers using Data Pump
- Implemented Oracle Database advanced security practices such as Virtual Database Privacy, TDE and Data Masking
- Performed database security and user administration via roles, profile, auditing and TDE
- Refreshed databases from Production to Test environments using a hot backup and data pump.
Oracle Database Administrator
Jostens
Bloomington, MN
07.2017 - 08.2019
- Performed Oracle Database LifeCycle Management (LCM) tasks that included migrations, patching, upgrades, automation and decommissioning legacy databases
- Upgraded databases from 10g, 11g to 12c (12.1.0.1 and 12.1.0.2) by doing either in place upgrades for dedicated databases or migrations for shared databases
- Installed and configured Oracle 11g software on AIX / UNIX / LINUX operating systems
- Applied Oracle quarterly patches of the current PSU version to non-RAC and RAC configured databases
- Performed data and metadata transfer from legacy servers to newly installed servers using Data Pump
- Implemented Oracle Database advanced security practices such as Virtual Database Privacy, TDE and Data Masking
- 24x7 remote support and on call Database support using RSA-VPN
- Configured and managed standby databases using Data Guard
- Performed SQL tuning using tools such as SQL Tuning Advisor, SQL Trace, ASH, AWR, and Explain Plan
- Built and configured RMAN Recovery Catalog for Backup and Recovery strategy
- Cloned production databases as needed for testing and development using RMAN and Grid Control
- Managed database security by creating and assigning appropriate roles and privileges to users depending on the user activity
- Utilized the broker to manage Dataguard physical and standby databases
- Designed, tested, implemented, and documented database migration procedures involving the use of the export/import utilities and Transportable Tablespace
- Identified and worked with developers on automating processes using shell scripts to minimize errors
- 24x7 remote support and on call Database support using RSA-VPN
- Configured and managed standby databases using Data Guard
- Performed SQL tuning using tools such as SQL Tuning Advisor, SQL Trace, ASH, AWR, and Explain Plan
- Built and configured RMAN Recovery Catalog for Backup and Recovery strategy
- Cloned production databases as needed for testing and development using RMAN and Grid Control
- Managed database security by creating and assigning appropriate roles and privileges to users depending on the user activity
- Documentation
- Created primary objects (tables, views, indexes, synonyms, procedures, functions, and triggers) using SQL DDL and DML scripts/commands using primary and foreign keys
- Data loading using external tables, SQL
- LOADER, Logical backups using full export and DATAPUMP
- Identify long-running database queries, refine queries for better performance, and work with end- users to implement changes
- Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases Installed and configured Oracle OEM 12c and 13c on Dev and test environments
- Successfully configured and managed Data Guard for disaster recovery, data protection and high availability
- Performed Data Guard failover as required for maintenance
- This includes coordinating with application owners and sys admins to when the failover can be performed
- Performed data and metadata migration to newly installed servers using Data Pump Expdp/Impdp.
Education
Associate of Science in Computer Science -
NHCC (North Hennepin Community College)
Minneapolis, MinnesotaOracle University
Skills
- Database Technologies
- Microsoft SQL Server 2000
- Oracle 11g
- 12c
- 18c
- 19c
- Operating Systems
- Windows 2008 Server
- Red Hat Linux
- Sun Solaris
- HP-AIX
- Tools
- Toad
- Data Pump
- SQL loader
- OEM 13C
- SQL Developer
- AWR
- ASH
- TKPROF
- Explain Plan
- Opatch
- Utilities
- RMAN
- ADRCI
- SQL
- Plus
- High Availability Solutions
- RAC
- Data Guard
- Golden Gate
- ASM
- Networking
- NET
Websites
Personal Information
Title: ORACLE DATABASE ADMINISTRATOR
Timeline
Oracle Database Administrator (DBA)
Info Way Solutions
08.2019 - Current
Oracle Database Administrator
Jostens
07.2017 - 08.2019
Associate of Science in Computer Science -
NHCC (North Hennepin Community College)
Oracle University