Senior Oracle Database Administrator
Resume:
FRANKLIN NGA
*************@*****.***
Oracle Database Administrator
QUALIFICATIONS SUMMARY
I am an Oracle 12C Certified Associate as well as a certified OCI architect associate and an autonomous database cloud specialist, with over 7 years hands-on experience as an Oracle Database Administrator. I have worked on projects demanding the support, Installation and configuration of Oracle 12c, 11g and 10g databases. I have performed Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, and Database Security. More so, I have managed databases running on AIX, Linux, UNIX and Windows platforms. I possess working knowledge on life cycle development, testing and UAT environments. I am well versed with Data guard, Golden gate and Oracle Real Application Cluster (RAC) for high availability. In addition, I am a professional scrum master with experience working within an agile environment.
Extensive experience designing and implementing backup and recovery strategy for databases using RMAN, traditional Export/Import, Export/Import Datapump as well as conventional Hot/Cold Backups.
Worked extensively on Cloning /Duplicate of databases using RMAN.
Experience with various database Backup and Recovery methods like PITR, TSPITR and Flashback Technologies.
Migrated databases from Non-ASM file system to ASM file system using RMAN.
Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump, SQL* Loader & Transportable Tablespace (TTS).
Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and materialized view for Oracle database.
Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.
Experience in 3 nodes RAC setup, configuration and cluster interconnection with ASM.
Experience in maintaining Data Guard to provide high availability by implementing physical standby database and snapshot standby and worked with Oracle 11g features, 11g Grid Control.
Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and utilities. Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.
Excellent analytical, problem solving, communication and interpersonal skills.
Knowledge on Exadata, AWS, e-business, Sql server, ETL, OUD,Informatica.
WORK EXPERIENCE
ORACLE CORPORATION – Santa Clara, CA
June 2019 – Present
Oracle Database Administrator
Tune existing data structures and indexes for optimal performance
Tune existing databases for optimal performance
Create and maintain database backup/archive strategy
Work with both immediate and extended team members to implement Oracle PaaS cloud solutions
Integrate corporate security tools, methods and procedures to be leveraged by both PaaS solutions and custom applications/tool
Install and configure Oracle, NoSQL and Graph databases as needed
Provide extended support to IT during maintenance windows
Monitored different databases and application servers using Oracle Enterprise Manager (OEM), Sql Developer
Loading data from flat files to database using SQL*Loader, External Tables.
Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM), Active Session History (ASH) and Explain plan.
Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
Experienced in cloning the databases using HOT and COLD backups.
Made optimal use of Oracle Support in resolving the SRs.
24 X 7 Production & Development database support and administration.
Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g and 12c environments.
Implemented proactive monitoring using SQL Trace & TKPROF.
Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) and Network Attached Storage (NAS).
Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery, Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
CIGNA HEALTHCARE - RALEIGH, NC
February 2015 – May 2019
Oracle Database Administrator
Development of policy and procedures as they relate to database maintenance, security and archiving.
Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.
Creating, granting and monitoring user access rights and privileges through roles and profiles.
Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.
Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)
Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
Ensuring load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.
Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
Installation of 12c OEM and customize it to our need, Installed Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
Automated the Data Replication process using Materialized Views for reporting databases.
Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
Refreshing Dev and Test instances with data from Production on a regular basis.
Thorough knowledge in setting up infrastructure for databases in huge datacenters.
Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Efficiently performed installation, setup and creation of 3 node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
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.
Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
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)
CORP SPECTRUM HEALTH - Grand Rapids, MI
December 2012 – January 2015
Oracle Database Administrator
Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control, toad
Loading data from flat files to database using SQL*Loader, External Tables.
Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
Involved in converting a single instance database to Oracle 11g, 12c RAC databases.
Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM), Active Session History (ASH) and Explain plan.
Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
Experienced in cloning the databases using HOT and COLD backups.
Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3. and Refreshed/cloned databases using RMAN utility.
Made optimal use of Oracle Support in resolving the SRs.
24 X 7 Production & Development database support and administration.
Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g and 12c environments.
Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF.
Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) and Network Attached Storage (NAS).
Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery, Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
Performed Database upgrade from Oracle 10g (10.2.0.5) and to Oracle 11g (11.2.0.8), 12c RAC database. Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
TECHNICAL SKILLS
Operating Systems
HP-UX, Sun Solaris, AIX, RHEL, Linux Enterprise Server, Windows 2012
RDBMS
Oracle 10g, 11g, 12c
Languages
SQL and PL/SQL
Tools
Sql Developer, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Toad, Putty, NX client, WinSCP, VNC, Cisco VPN Client, Jira/ Confluence
Database Utilities
SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import
EDUCATION
Bs In Information Technology (University of Buea Cameroon).
SQL Fundamentals (Oracle University).
ORACLE CERTIFIED ASSOCIATE (OCA 12C), Oracle University.
AUTONOMOUS DATABASE CLOUD SPECIALIST, Oracle University
LINUX ADMINISTRATOR, Oracle University
ORACLE CLOUD INFRASTRUCTURE ARCHITECT ASSOCIATE, Oracle University
AWS CERTIFIED SOLUTIONS ARCHITECT ASSOCIATE ( AMAZON)
PROFESSIONAL SCRUM MASTER ( SCRUM.ORG)
Contact this candidate