Manager Oracle

BELVAN OBEN

************@*****.*** 704-***-****

Certified Database Administrator

SUMMARY

Certified Oracle database administrator (OCA, OCI, AWS Certified Solutions Architect- Associate), offering over seven years of success assuring the availability, performance, integrity, and security of Oracle databases with extensive expertise in PostgreSQL. Particularly adept at installation, configuration, migration, backup and recovery, data guard implementation, tuning at both instance level and SQL level, cloning, space management, database security, auditing, and troubleshooting. Track record of executing upgrades, migrations, and disaster recovery in a range of heterogeneous system environments. Direct experience with Oracle versions 10g, 11g, 12c and PostgreSQL 9.6, 10, 11 and 12 across platforms including Solaris, AIX, Unix, Linux, and Windows. Thrive as a team member in complex, fast-paced environments.

CORE COMPETENCIES

Relational Database Management Systems Export & Import Testing GoldenGate Data Guard RAC Multitenant Architecture Server Migration Data Warehouse Application Upgrades Backup Pgbouncer Database Optimization Performance Tuning Transparent Data Encryption Upgrading Patches Disaster Recovery Troubleshooting Database Modeling Load Testing Shell Scripting Replication Vacuuming EFM3.9 Pg_dump Pg_basebackup Streaming Replication pgAdmin Pg_repack PEM PROFESSIONAL EXPERIENCE

DATABASE ADMINISTRATOR, July 2018 to Present

Riley Technologies, Mooresville, North Carolina

Ensure smooth functioning of all e-commerce activities by configuring, tuning, and troubleshooting Oracle 10g, 11g and 12c databases in Sun Solaris, Linux, and Windows environments. Configure, integrate, and maintain all development, QA, staging and production Oracle and PostgreSQL databases within the organization. Collaborate with team to develop and implement backup and disaster recovery strategy. Create compliance reports, perform auditing, and produce performance reports for trend analysis and capacity planning.

Key Contributions

• Currently creating proof of concept for Oracle 12c new features including redaction policy, adaptive query optimization, multiple indexes on a single column and restore table through RMAN.

• Recovered a 1-terabyte database after UNDO table space was corrupted in Real Application Cluster.

• Migrated the legacy system from non-RAC environment to RAC 11g cluster database.

• Configured OEM Grid to administer many databases and enterprise-wide targets.

• Installed and configured Oracle GoldenGate and provided troubleshooting of GoldenGate issues.

• Setup and monitored multi-node RAC to RAC Data Guard with real time apply for disaster recovery and offload backups.

• Adept at SQL, PL/SQL, Cursors, Stored Procedures, Triggers and Functions.

• Applied database patches using Opatch utility for RAC and Non RAC databases and built clone instances for development and test teams.

• Upgraded and migrated multiple versions of PostgreSQL databases across different hardware and between different systems (OS versions and RDBMS).

• Applied upgrade patch, maintenance, and interim patches on all the databases.

• Installed, configured, and currently managing PostgreSQL clusters in both on-prem Linux environments as well as Windows.

• Strong data warehouse skills related to administration and management of VLDB environments and Oracle OLTP.

• Manage PostgreSQL production databases and their associated non-production databases.

• Creating and maintaining PostgreSQL users, roles, and database objects on both AWS and on-prem environments.

• Configured PostgreSQL Streaming Replication and pgpool for load balancing.

• Configured Enterprise Failover Manager (EFM) to monitor streaming replication.

• Handled disasters including failover and loss of databases and storage for PostgreSQL databases.

• Improved performance by installing and managing monitoring tools for better performance including pgbadger and Nagios.

• Configured Backup and Recovery Tool (BART2.5) to manage backups.

• Responsible for all backup, recovery and upgrading of all PostgreSQL databases. DATABASE ADMINISTRATOR, June 2013 to July 2018

State Street Bank & Trust Company, Atlanta, Georgia Produced, developed and supported multiple versions of Oracle databases within a financial organization. Tuned performance issues and improved database performance. Upgraded and migrated databases to ensure optimal functioning. Provided 24/7 production and development database support and administration.

Key Contributions

• Designed and implemented disaster recovery for the PostgreSQL database.

• Implemented Oracle patches (CPU, PSU) on the compliance databases device with a plan to patch quarterly, covering all databases in one year.

• Converted a single instance database to Oracle 11g and 10g RAC databases.

• Implemented backup and recovery using RMAN, including hot backups and cold backups.

• Developed compliance reports and performed high-level auditing.

• Implemented Data Guard with high availability and performance configurations and participated in Data Guard failover tests.

• Migrated databases from Non-ASM to ASM after installing an ASM environment.

• Installed and configured new servers per customer specifications.

• Cloned the development, test and UAT environments with production data per customer request.

• Configured Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels.

• Configured redaction using OEM Policy Expression Builder.

• Used normal import and export as well as datapump exporting and importing schemas, tables, etc. from one database to another.

• Responsible for tuning the database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned tables and rebuilding of indexes for better performance.

• Made optimal use of Oracle Support in resolving the SRs.

• Monitored PostgreSQL environments using monitoring tools including Nagios, Check_Postgres.pl, pgOn, custom scripts and pgbadger.

• Configuring and troubleshooting with pgAdmin-III client application. TECHNICAL PROFICIENCY

Operating Systems: Windows, AIX, Solaris, Linux, Unix RDBMS: Oracle 10g, Oracle 11g, Oracle 12c, PostgreSQL 9.6/10/11/12 Tools: TOAD, TKPROF, OEM 12c, OEM 13c, EXPLAIN PLAN, STATSPACK, AWR, ADDM, SQL DEVELOPER, RMAN, PGPOOL, PGBadger, PG_REPACK, PEM, NAGIOS, PGAdmin

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import, EFM3.9, BART2.5, Vacuum Full

CERTIFICATIONS

Oracle Cloud Infrastructure 2019 Architect Associate (OCI) Oracle Advanced Administration (OCP)

Oracle Database Certified Associate (OCA)

Oracle SQL Fundamentals

AWS Certified Solutions Architect – Associate

EDUCATION

Bachelor of Arts, 2010 University of Buea, Cameroon

Contact this candidate