NJIE JOE

adhj3f@r.postjobfree.com

240-***-****

Oracle Database Administrator

SUMMARY

I am a highly experienced and self-motivated Oracle Database Administrator with over 5+ years, 1+ years PostgreSQL and 1+ years in AWS Solution Architect with extensive experience. I do have a good reputation for professionalism, loyalty, exceptional customer service, a willingness to learn quickly and commitment to high standard in all areas of my work. I recognize the importance of strong customer service, efficiency, time management and can be relied upon to work unsupervised while delivering the objectives of my role. I do have many transferable qualities which include excellent communication skills, both verbal and written. I am a flexible individual who will work very well in a team structure and as well as on my own initiative. My duties have involved Installation, Configuration, Patch, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Data Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Oracle Golden Gate.

• Good in upgrading the databases from Oracle 11g to Oracle 12c.

• Installation, Configuration and Administration of Oracle 11g and,12c RAC.

• Experienced in implementing RMAN backup (Full, incremental, and cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.

• Strong experience in SQL and database performance tuning, high-availability, backups, and recovery.

• Experienced in implementing secure backup of the data using RMAN

• Performance Tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA,

Distribution of disk I/O, sizing of tables and indexes.

• Installation and configuration of Oracle 12c multitenant container and pluggable databases with Flex Cluster and Flex ASM.

• Installation, configuration, and maintenance of Grid Control 12c to monitor all the hardware, applications, and network status.

• Shell scripting and SQL programming to automate day-to-day jobs like storage, system resource monitoring

• Upgrading and migrating Oracle 11gR2 RAC databases running on legacy infrastructure to Oracle 12c pluggable databases running on the latest platforms.

• Implemented High availability using Golden Gate replication. Implanted Unidirectional and Bi-directional replication using golden gate.

• Experienced in designing and implementing Oracle Disaster Recovery Solutions using Oracle Data Guard and Storage based replication technologies.

EDUCATION

Bachelor’s Degree in Economics 2013

University of Yaoundé II SOA, Cameroon

CERTIFICATIONS

Oracle SQL Certified

Oracle Certified Associate

AWS Solution Architect Associate

PostgreSQL Associate (In Progress)

TECHNICAL SUMMARY

Databases: Oracle 11g, 12c, 13c, and 19c, Postgres 11, Aurora, DynamoDB,

Oracle Database tools: SQL*Loader, TKPROF, OEM, Toad, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, SQL Developer, Grid

Control, Putty, WinSCP

Operating Systems: Linux Operating System, Unix, Windows 10, Cloud Computing: AWS (solution Architect), IAM, EC2, RDS, S3, Glacier, SQS, SNS, SES, CloudFormation, VPC, IAM, Route53, EBS, DynamoDB, Lambda, Kinesis, CloudWatch.

WORK HISTORY

Oracle Database Administrator, 05/2019 to 08/2020

Anthobex Solution LLC, Maryland, USA

• Planned and implemented Disaster Recovery solutions using Oracle Standby Database / Data Guard and performed data Replication using Golden Gate Technology.

• Rebuilt indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, TKPROF and Statspack for best performance.

• Automated the Data Replication process using Materialized Views for reporting databases.

• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple databases and notification of database alerts, and configured EM agents on multiple database servers.

• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 11g Grid Control.

• Developed PL/SQL packages, DML, DDL, Oracle tables, stored procedures, functions, cursors, triggers, and UNIX shell scripts.

• Excellent knowledge of application development concepts and practices.

• Good experience in managing complex, cross-functional projects and driving technical innovation.

• Great experience designing and implementing technology enabled solutions

AWS Solution Architect:

• Setup and Managing Linux Servers on Amazon (EC2, EBS, ELB, SSL, Security Groups, RDS VPCs and IAM).

• Create and Managing buckets on S3 (CLI) and store db. and logs backup, upload images for CDN serve.

• Setup and Managing Databases on Amazon RDS. Monitoring servers thorough Amazon CloudWatch, SNS.

Creating AWS Instances and Resources Bills.

• Cloud Migration

Oracle Database Administrator 02/2015 to 12/2018 MTN CAMEROON

• Loaded data from flat files to database using SQL*Loader, External Tables.

• Extensively used AWR, ADDM and explain plan for periodic performance tuning.

• Experience with Oracle eBusiness Suite versions 12.1 or 12.2

• Experience in patching, upgrading, cloning Oracle Database and EBS.

• 2 years of Oracle Database and EBS application Administration experience.

• Implemented Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing databases/schemas/tables to improve the performance.

• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption and configured user log on load balancing and failover on RAC database

• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 databases.

• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best cluster architecture, choosing the best hardware configuration for Oracle RAC.

• Developed PL/SQL packages, DML, DDL, Oracle tables, stored procedures, functions, cursors, triggers, and UNIX shell scripts.

• Performed database upgrade from Oracle 11g (11.2.0.3) and to Oracle 12c

(12.1.0.1) RAC database.

• Successful in installation and configuration of Oracle E-Business Single and multiple nodes.

REFERENCES

1) Mr. Besong Anthony,(Supervisor) Sr. Oracle DBA

Tel: (240) 423- 6817 Email: adhj3f@r.postjobfree.com 2) Mr Fru Charle, Sr. Oracle DBA

Tel: 240-***-**** Email: adhj3f@r.postjobfree.com

Contact this candidate