Oracle Manager
Resume:
JOIE ANNIH NJINGANG
************@*****.***
Oracle Database Administrator
SUMMARY
Highly skilled professional with hands-on experience in Oracle database administration. Areas of expertise include; Installation and Configuration, Database Upgrades and Patch Management, Database Migrations, Backup and Recovery, Performance Tuning, Database Cloning and Security Management. I am also proficient in the configuration and management of High Availability solutions like Data Guard, Golden gate and RAC.
TECHNOLOGIES:
Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000
RDBMS: Oracle 10g, 11g, 12c, MS SQL Server
Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL
Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH and ADDM, Toad, Putty, NX client, Winscp, SQL Server Management studio
Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import
EXPERIENCE
Riley Technologies June 2015 – Jan 2018
Oracle Database Administrator
Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
Installing, configuring and maintenance of Oracle Replication Tool Oracle Golden Gate.
Configured Goldengate 12c, RAC Active configuration with 11g database.
Configured and worked in Oracle GoldenGate installation, configuration, troubleshooting GoldenGate issues.
Refreshing Dev and Test instances with data from Production on a regular basis.
Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
Thorough knowledge in setting up infrastructure for databases in huge datacenters.
Installed Oracle 11g on Linux platform using ASM.
Worked on Configuring OEM 12c console and installed OEM12c agents on all different platforms using push method from console and also using silent method.
Applied database patches using Opatch utility for RAC and Non RAC databases & building Clone instances for Development and Test teams.
Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.
Planning, Implementing and Validating various versions of Oracle Databases to 12c Release & upgrades on all the environments (in a procedural approach Dev, Test, Stage, QA and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 12c upgrades.
RMAN point in time recovery and Instance recovery done on 11g.
Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
Developed compliance reports and performed auditing at higher levels.
Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
Setup and monitored multi node RAC to RAC Dataguard with real time apply for Disaster recovery and offload backups.
Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 and 6 Node RAC Clusters and Upgraded single instance 10g databases to 11gR2 RAC.
Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
Installed and configured Oracle OEM 12C on test environments. Used OEM extensively to monitor the general health and troubleshoot/diagnose problems in the environment both on server, database level and also most importantly at the Sql level to identify and subpar Sql queries. Configuring custom metrics, monitoring templates and alerts set up based on individual dba preference and also tailored to application requirements.
Redesigned table and index partitioning strategies, using HINTS to improve the query Performance.
Developed, modified and optimized very complex queries to data retrieval Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning using techniques.
Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, SAR, glance, vmstat etc.
Analyzing STATSPACK, AWR, ADDM and TKPROF and 10046 traces for diagnosing the root cause of the issue.
Experience in writing UNIX/SHELL scripts for providing the reports.
Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture
Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
Extensive experience in RMAN recovery testing, RAC and standalone database
Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC)
Experience in setting up Oracle ASM storage for Oracle RAC databases.
Performed database replication through Golden Gate.
Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
Responsible for the smooth functioning of all ecommerce activities of the organization.
Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF. Performing monthly and annual performance reports for trend analysis and capacity planning.
Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
Worked on both VMS and UNIX environments.
Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.
Duke Energy June 2011 – May 2015
Oracle Database Administrator
Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.
Disaster Recovery (DR) Plan Implemented using DATAGUARD (Physical Standby) for high availability/disaster recovery purpose on Oracle 11g.
Implemented 11g Database compression feature for Development and test Instances to reduce the size of databases which help the client to save huge disk space.
Performing DR switchover and failover operations.
Syncing of DR databases with the Primary Database for any archival gaps.
Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.
Responsible for network configuration and involved in a Client -Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
Used Data pump for exporting and importing tables, schemas and table spaces.
Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 11g, 10g.
Extensively used AWR, ADDM and explain plan for periodic performance tuning.
Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.
Worked with application developers to address and clarify data requirements to resolve technical and functional issues.
Enforced corporate business rules through adequate user/resource/object management.
Reconcile functional and technical problems through interaction with the client by researching and identifying the defined issue and by fully testing and confirming possible solutions to the problem.
Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.
Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, DataGaurd, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH, TOAD 11.0.
EDUCATION
Bachelor Degree in Anthropology - University of Yaoundé 1 CAMEROON
CERTIFICATIONS:
Oracle Certified Associate: Oracle Database 11g Administrator
Contact this candidate