Oracle Database Administrator
Resume:
MARCELLIN LEUGUEN NOUBISSIE
Personal Information
Professional Summary
*********.*********@*****.***
Over 5 years of strong experience in Oracle database administration in heterogeneous system environment running Solaris, UNIX, and Windows.
Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
Expertise in Oracle's Data protection, high availability, and performance technologies such as Oracle RAC, Oracle Dataguard, ASM, and Oracle goldengate.
Experience in administration and tuning of Oracle databases running on Windows and all types of UNIX platforms.
Experience in Oracle Grid Infrastructure implementation, administration, & performance tuning on ASM and implementing Third party clusterware file systems.
Experience in Dataguard for different types of Standby Databases such as Active for reporting, Physical, Logical, and Snapshot standby on implementation, administration, & performance tuning.
Experience in implementation, configuration, troubleshooting, and performance tuning of Oracle Goldengate replication between Unidirectional, bidirectional, and cascaded Oracle Databases.
Experience in Performance Tuning Oracle Databases with respect to all aspects of IT Infrastructure such as Network, OS, Storage, and Application.
Experience in using various performance tools or utilities like EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ASH, and ADDM, and analyzing reports for tuning recommendations.
Experience in implementing Oracle Enterprise Manager Grid Control (11g) and Cloud Control (12c) for database monitoring/performance/diagnostics.
Experience in implementing desired database backup solutions based on environment, affordability, and other key IT Infrastructure aspects. Experience with Oracle RMAN backup utility and in traditional hot (online)/cold (offline) backups, Experience in logical backups and Database migration tools such as DATA PUMP, Export/Import, and Transportable Tablespaces.
Experience in writing/modifying UNIX Shell Scripts for various scenarios and requirements.
Experience in upgrading Oracle Databases from 10g & 11g, to 11g & 12c.
Knowledge and experience on managing very large Data Warehouse databases.
Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.
Experience in implementing Oracle Flash-Back Technology and utilizing it for various rollback purposes such as Critical Application bug fixes, Load Testing, and QA Testing.
Experience in Capacity Planning and Bench Marking.
Oracle GoldenGate experience with Installation, configuration and troubleshooting of Oracle GoldenGate 11g/12c replication setup across heterogeneous database servers and ensure data synchronization.
Experience in Performance tuning of Oracle GoldenGate Processes to achieve zero lag times.
Hands on experience on using of macros, conflict resolution, filtering and transformation, exception handlers and Security.
Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF and OEM.
Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.
Experience in Database capacity planning, monitoring object growth and Storage Management.
Performed data migration from flat files into an Oracle database using SQL*Loader.
Experience in performing Cloning and Refresh using RMAN and Datapump.
Experience in Oracle Advanced Compression techniques.
Experience in Online/Offline Re-Organization of database objects.
Experience in Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modeling.
Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.
Experience working with database security tools TDE, DB Vault / VPD.
Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
Experience in upgrading Oracle Binaries and databases from 10g to 11g and 11g to 12c.
Experience in handling very large databases (VLDB) ranging up to 3 TB.
Proficient in writing SQL, PL/SQL (Stored Procedures, functions, packages and triggers) scripts
Technical Proficiencies
Databases:
Oracle 10g, 11g, 12c
Database Tools:
Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy
Operating Systems:
MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX
Hardware:
Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2
Education
Bachelor of Science in Technology in Negotiation-Communication-Sales at the University Institute of Technology Cameroon (Africa).
Experience Summary
Valmont Industries - Omaha, NE Jun ’14 – March 2018
Oracle Database Administrator
Supporting multiple databases for production, development, test and staging running on Sun Solaris and Windows environments.
Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
Implemented oracle 12c active standby database for test database environment.
Implemented oracle 12c flexi asm for pre-prod environment.
Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.
Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.
Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
Providing database administrative support and 24x7 on call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5
Experience with large databases (1.5 Tb) for OLTP and OLAP applications.
Performed installation, configuration and maintenance of oracle 11g/12c, 11g RAC databases.
Experience in configuring oracle 10g, 11g Real application cluster (RAC) (2 and 3 nodes) using cluster ware and automatic storage management(ASM).
Performed migration of oracle 10g/11g non RAC single instance to RAC database instances.
Experience with 11g cluster maintenance using CRSCTL command.
Experience in using SRVCTL command for Oracle 11g RAC database.
Implemented Disaster Recovery database 10g/11gData Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.
Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
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.
Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.
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.
Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption
Extensively worked with ASMCMD for managing ASM environment.
Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.
Proactive performance monitoring, and capacity planning for future database and server growth using OEM.
Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
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
Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
Resolved data integration issues.
Performed version upgrades and patch installs.
Solid discipline in providing end-users timely updates on their problems. Installing server software.
ASM implementation & maintenance. Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
Environment: Oracle 12c/11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.
Equifax - Atlanta, GA
Jun ‘12 – May ‘14
Oracle Database Administrator
Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Supported off-hour on call support for database related issues.
Created logical and physical design installed and upgraded databases.
Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.
Responsible for Datacenter Migration from old Datacenter to new datacenter and Migrated and upgraded single instance database to multiple instance databases using export/import, data pump.
Configure Data Guard on both standby and primary for 45 production databases.
Fail over and switch over between standby and primary databases.
Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
Hands-on experience for various performance tuning issues using VM sphere client.
Experience in working with virtual machine (VM Ware) and oracle virtual machine (OVM).
Experience in migrating from multiple Oracle 10gR2 database to oracle 12cR2 on virtual machine (VM Ware).
Hands-on experience in taking snapshots and rebooting the server's and performance monitoring for Oracle databases in virtual machines (VM Ware).
Experience in adding and expanding the disk volumes to oracle servers on virtual machines (VM Ware).
Experience in installing oracle software and creating standalone databases on virtual machines (VM Ware).
Hands-on experience in working with virtual machine (VM Ware) under different operating system like Linux, sun Solaris and windows.
Experience in configuration and administration of Data Guard (Physical/Logical standby Databases).
Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes.
Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard). Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
Maintained the data integrity and security using integrity constraints and database triggers.
Provided 24X7 support for all the production and development databases.
Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN
Contact this candidate