Resume

Sign in

Manager Oracle

Location:
Brunswick, Maryland, United States
Posted:
September 11, 2018

Contact this candidate

Resume:

Akwasi Owusu Akyaw

** ******** **, ********* **, 21758. ac60gc@r.postjobfree.com

PROFESSIONAL SUMMARY

Certified Oracle DBA with nine years of experience managing Oracle databases and Oracle applications. Monitored alerts and supported RAC, non-RAC, Data Guard databases on Unix, Linux and Windows servers using Oracle OEM, TOAD and other monitoring tools. Patched and upgraded databases and applications to latest releases and performed change requests. Managed physical and logical databases, designed and planned disaster recovery for Oracle data warehouse created documentation, maintenance plans and backups.

EDICATION

Walden University 2010 B.A Economics

SKILLS

Installing, deploying and upgrading production and non production databases

Installed OBIEE 11G and migrated and upgraded to 12C

Database refreshes during application development

Oracle Data Guard

RMAN

Patching

Oracle Advanced Security

RAC/ASM administration

Oracle Forms and Reports Builder

Oracle Business intelligence

TOAD, SQL Developer, Enterprise Manager

Oracle Database Appliance

Oracle WebLogic Server 11G and 12C

Oracle Database 12C pluggable and Container

Oracle Utilities OPatch, oakcli emcli, java, data pump

Data Masking Data Reduction

Data Mining

Senior Oracle DBA(2016 - Present) Dollar Bank, Pittsburgh, PA

Interfaced with business owners and other stakeholders about general health about Oracle in the data warehouse.

Primary conduit between technical team and business units for all Oracle software related issues including disaster recovery, product lifecycle management, hardware and software purchases patching and upgrades.

Had primary responsibility for managing Data Guard replication technology and all databases being replicated with this technology.

Designed patch schedule and test plans for Oracle products in data warehouse environment.

Attended bi-weekly and monthly meeting with Business Units to discuss issues, needs and upcoming projects by priority.

Configured data masking and redaction policies per users/departments and hierarchical/functional level in organization for appropriate access of application data.

Senior Oracle DBA (2015 - 2016) Dollar Bank, Pittsburgh, PA

Managed all Oracle activities related to Financial data warehouse.

Started documentation efforts to enhance team efficiency and organizational continuity.

Primarily responsible for the installation configuration and deployment of all Oracle Applications and databases including Discoverer, Apex Essbase and Oracle Business Intelligence.

Installed and configured Oracle Enterprise Manager for robust monitoring of our environment. Configured and deployed Enterprise Manager agents to monitor Oracle databases including Oracle Database Appliance, Oracle Business Intelligence, Essbase server, Microsoft Active Directory server for Oracle Authentication.

Also configured automatic patch plans via Enterprise Manager to administer non-PSU patches when available from Oracle Support.

Designed custom database Reports via BIPublisher to send alerts via emails about system issues and health.

Managed Oracle Business Intelligence application

Upgraded OBIEE from 11.1.1.7 to 12.2.1.0.0

Oracle DBA (2012 -2014) Dollar Bank, Pittsburgh, PA

Provided technical support and Application Support to members of the Development team and End Users

Assisted in project specifications for Oracle server and Application installs.

Assisted in loading data from mainframe to staging job servers during month end data uploads.

Tested new RDBMS features for future integration into infrastructure and other Oracle applications.

Supported development team by troubleshooting SQL statements, configuring ODBCs and JDBCs to connect applications desktops to applications and databases

Was responsible for managing all Oracle Applications leveraging Oracle databases as data sources including Discoverer, OBIEE, Application Express and Essbase.

ACCOMPLISHED PROJECTS

Introduced Oracle Object Partitioning for tables and indexes to improve performance.

Upgraded Enterprise Manager Grid Control from 11.1.0.0.0 to 12.2.0.5.0 and 13.2 current release.

Managed two different Database Appliance versions along with OAK patches.2.1.0.0 to 2.12.0.0.0

Implemented TDE for Data Warehouse databases

Upgraded Oracle Business Intelligence from 11.1.1.7 to 12.2.1.0.0 to 12.2.1.0.3

Upgraded Oracle databases from 11.2.0.4 to 12.1.2.0.1 to 12.2 current release

Operating Systems

Windows XP, 7 10, Red Hat 5, 6. Oracle Enterprise Linux 6, 7

Databases

Oracle Database 10G, 11G, 12C, SQL Server 2008 R2

Oracle Applications

Oracle Forms, Oracle Business Intelligence, Oracle Enterprise Manager, Oracle Application Express, Essbase, SQL Developer, Oracle WebLogic Server, Integrated Lights Out Manager(ILOM), Cluster Verification Utility, Enterprise Manager Plugins, VM VirtualBox



Contact this candidate