CARINE ETONGWE

Oracle Database Administrator

Email:ac70hd@r.postjobfree.com

cell: 202-***-****

EXPERIENCE

November

**** - *******

Oracle Database Administrator

COX Automotive– Atlanta, GA

Implemented proactive Performance Monitoring Tuning and Troubleshooting - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using these Oracle's regular performance tuning tools like; Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH, SQL tuning advisor etc, and also Cluster InterConnect Tuning (RAC).

Supported 24x7 mission critical applications which include different versions Oracle 10g/11gR1/11gR2/12c for Standalone and RAC Databases.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager) 12C.

Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), hot and cold backup, and Database Flashback using PITR (Point in time recovery) and Export and Import (Datapump and Normal) for restoring the specific objects at the database level.

Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog. Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g/12c environments.

Supporting multiple database for and staging purposes on DEV, INT1, STAGING and PROD red hat enterprise Linux, HP-UIX UNIX, AIX windows and Solaris.

Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switchover and Export & Import.

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.

Configured and implemented Oracle 11g ACTIVE DATAGUARD for Database Disaster Recovery by using DATA GUARD broker (DGMDRL).

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.

Refreshing DEV and Staging instance with data from production on a regular basis and also when QA need to test an application and requires a refresh from me.

Made optimal use of Meta link in resolving the SRs.

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

Applying patches, maintaining an interim (opatch) patches on the database. Successful in applying RDBMS patches, security patches for improving the security and functionality of the database.

Upgrade databases from 11.2.0.2,11.2.0.3 and 11.2.0.4 to 12c as part of performance improvement by utilizing the new features.

Build oracle standby database for real-time replication and implementation of a bidirectional data guard configuring both the primary and the secondary or logical standby database in 11g and 12c.

Efficiently performed installation, setup and creation of a 2 node Oracle 11g RAC cluster using GRID infrastructure for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC with ASM file system.

Used PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts created by developers to manage/monitor databases.

Implemented and monitored ASM on RAC and stan-alone databases, managing disks groups with ASM in oracle 11g environment.

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

Automated the process of monitoring free space in tablespaces at regular intervals.

Production support database on 10g, 11g and 12c versions with standalone and RAC environment.

Set up user profiles and roles as per the access level of user for the data and application security.

Installation and configuration of Oracle Golden gate.

Re-wrote the shell scripts to monitor Golden Gate processes various states (like STOPPED/ABENDED/LAG/HUNG) to reduce number of alerts by grouping them together by environment.

Installed and configured 4 node server side load balancing Oracle RAC 11g, 12c databases on Linux with ASM and Data Guard.

Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, Streams, ASM, RMAN.

Configured deployed and administered 4 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 6.0, using ASM and Raw Devices on Oracle 11gR2.

Table created with Daily Range partition, indexes and script automated which add/remove partition as per client requirement.

Capacity planning: Allocate system storage and plan future storage requirements.

Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions

Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification.

Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

Developed compliance reports and performed auditing at higher levels.

Resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Upgrade and Migration of Database from 11.2.0.2to 12.2.0.2 and applying patches whenever required.

Efficiently performed installation, setup and creation of four node cluster RAC with Oracle11.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..

Performing monthly and annual performance reports for trend analysis and capacity planning.

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.

Writing UNIX/SHELL scripts for providing the reports..

Backup of Archive Logs, Control Files and SPFILE on Tapes to Ensure Complete Recovery can be achieved.

Worked closely with Performance testing team in providing Database support for all the application releases in reaching the required SLA standards.

Involved in engaging different people bringing them on-board whenever a triage need to be opened.

Contacting Oracle Support for technical assistance in resolving problems in a timely fashion.

Ensuring Database security by virtually separating databases and using VPD (Virtual Private Database) in RAC environment to support two different set of application users by making data non-transparent to each other.

Participate on project team as a database administrator, supporting and ensuring that databases are appropriate modified to support new business applications and requirements.

Environment: ORACLE 12c, 11g/10g, RAC, Red Hat Linux, unix, windows,Solaris, Data Guard, Golden Gate, VCS Storage, PL/SQL, RMAN, Toad, OEM GRID.

July- 2013 – November- 2016

ORACLE DATABASE ADMINISTRATOR –

Motorola Solutions-Schaumburg, IL

Supported 24x7 mission critical applications which include different versions Oracle 10g/11gR1/11gR2/12c for Stand alone and RAC Databases.

Upgrade Enterprise Manager and Agent from 10g to 11g and 12c.

Performance Troubleshooting using different oracle tools AWR, ASH, ADDM and SQL Tuning Advisor, SPM and SQLT etc...

Troubleshooting operational issues and documenting detailed resolution steps in ticketing system.

Utilized 11g/12c new features like Real Application Testing (RAT) and Database Replay (DB Replay) to validate database performance on new Hardware.

Diagnosing database server performance issue using commands like top, sar, iostat, prstat, mpstat, vmstat and OSWATCHER.

Optimizer statistics collection using DBMS_STATS package and Optimizer tuning using relevant init.ora parameters, Hints, SQL Profiles and SQL PLAN MANAGEMENT (SPM).

Tuning SQL statements using Explain Plan, Execution Plan and SQLT tool.

Migrating data between different database instances whenever required, using Data Pump or exp/imp utilities.

Cross Platform migration and upgrade of databases.

Performed huge amount of Data movements between Databases using Transportable Tablespaces.

Working off hours at times supporting issues when encountered in Production Environment.

Worked on upgrading of oracle databases from 11g to 12c

Implemented OEM 12c Repository database, OEM 12c Agent and Golden Gate plugin Installations

Working closely with upstream and downstream clients in migrating data using oracle replication tool Golden Gate.

Development of Shell scripts and reports for proactive maintenance.

Support of back-end logic for business applications, e.g. procedures/functions/packages and triggers.

Supporting Change and Release Management of database objects, code and data.

Troubleshooting and performing reorganization of tables/indexes. Reorganization of Tablespaces to reduce fragmentation.

Tuning SGA, troubleshooting I/O bottlenecks, identifying contention, waits and locks.

Improving database performance by utilizing OS features like huge pages.

Management of Archived logs, UNDO tablespaces, Flashback logs.

Scheduling backups depending upon Business Strategy: Daily, weekly and merged backups etc.)

Recovery of Database using RMAN (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, recovering from Block Corruption).

Placement of Oracle Files (Control Files, Redo Logs, Rollback Segments, System Data Files, etc) for Optimized Performance, Backup and Recovery.

Worked on Table Partitioning to simplify maintenance and improve Query Performance of very Large History Tables.

Worked closely with Performance testing team in providing Database support for all the application releases in reaching the required SLA standards.

Involved in engaging different people bringing them on-board whenever a triage need to be opened.

Working closely with development team in providing the required support from Database standpoint like creating required roles, granting required privileges and creating new schemas as and when required.

Modification of the database structure, as necessary, per directions given by the application developers.

Collecting Diagnostic information using tools like RDA, Oradebug utility and OSWatcher.

Contacting Oracle Support for technical assistance in resolving problems in a timely fashion.

Ensuring Database security by virtually separating databases and using VPD (Virtual Private Database) in RAC environment to support two different set of application users by making data non-transparent to each other.

Design, implementation and maintenance of database security procedures.Ensures compliance with Oracle License agreement.

Performed disk group management in ASM while installing 11gR2 RAC.

Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2).

Ensured that oracle database systems operate securely and efficiently.

Managing databases from planning and testing stages through implementation and support.

Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application Tuning.

Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.

Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

Monitoring several databases varying sizes using Oracle Enterprise Manager Grid Control.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs.

On call Production & Development database support and administration.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Documented the Standard Processes for peers to follow.

Worked on user management mainly on grants, privileges, roles and profiles.

Worked closely with project managers, programmers, and testers to ensure the database integrity and security and generated test data and tested new database consistency with existing databases to meet the functionalities requirements

Involved in query optimization and using rule-based optimizers and cost-based optimizers.

Environment: ORACLE 12c, 11g/10g, RAC, Red Hat Linux, Solaris, Data Guard, Golden Gate, VCS Storage, PL/SQL, RMAN, Toad, OEM GRID.

SKILLS

About 6 years of experience as Oracle DBA, providing 24*7 support of development and production 12c/11g/10g multi terabyte databases on Various Platforms.

Expert in high availability technologies such as Oracle 9i/10g/11g/12c RAC, ASM, Golden gate and Data Guard/Standby Database.

Excellent experience in Installation and configuration of Oracle, 10g, 11g and 12c in UNIX/LINUX and Windows environment.

Implemented strategy for partitioning and management of historical data tables.

Proficient in performing day to day DBA activities like creating schemas, users and table spaces management, performing export and Import, Loading flat file data using SQL loader, Creating DB links, Materialized view creation, index creation and fine-tune queries.

Planned and implemented DR & high availability solutions using Oracle Data Guard, Golden Gate and RAC.

Designed and implemented Oracle Real Application Clusters (RAC) on Linux for an OLTP application with Transparent Application Failover.

Experience in Installation, configuration of Oracle RAC, implemented 2 node RAC environments for a 1TB database.

Installation, configuration, upgrade and performance tuning of Oracle RAC.

Planned and implemented high availability solutions using Oracle 10g and 11g RAC, Standby Database using Oracle Data Guard (Physical as well as Logical).

Proficient in using Oracle Enterprise Manager (OEM), Quest TOAD and Oracle SQL Developer.

Expert in Backup of Databases (Creating Backup Schedules based upon Business Strategy: Daily Backup, weekly Backup, merged backups etc.). Design and implementation of Backup and Recovery strategies and performing periodical backup, restoration and recovery using RMAN (full and incremental)

Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).

Developed, Modified and maintained PL/SQL code for running Batch Jobs.

Experience in Upgrading databases (10g to 11g, 11g R1 to 11gR2).

Expertise in SQL, PL/SQL programming.

Expertise in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues.

Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.

Performed unidirectional as well as bi-directional replication between source and target Database using Golden Gate.

Utilized 11g new features like Real Application Testing (RAT) and Database Replay (DB Replay) to validate database performance on new Hardware.

Performing cross Platform migration and upgrade of databases.

Expertise in Database performance-tuning with EXPLAIN PLAN, TKPROF, AWR, SQLTRACE, 11g OEM Grid Monitoring.

Implemented SQL PLAN MANAGEMENT (SPM) based well performing well execution plans, running SQLT reports for queries on database to identify the best and worst execution plans and fixing them using SQL PLAN BASELINES.

Expert in SQL Tuning using Optimizer HINTS to speed up the SQL statements and Database Tuning using appropriate v$parameter settings.

Proficient in high-level Database/IT Skills such as System Analysis and Infrastructure Design, Operating Systems (UNIX/Sun Solaris/AIX, Linux, and Windows), Computer Networks, Database Storage (RAID, Raw Devices), Complex SQL queries, and data communication networks, data security, business model.

Expertise in supporting replication with Materialized Views and Streams.

Supporting Change and Release Management of database objects, code and data.

Expertise using Transportable Table spaces, Data Pump, Flashback Table, Flashback Database, Flashback Transaction Query, Flashback Version Query and Tablespace Management.

Troubleshooting operational issues and documenting detailed resolution steps in ticketing system.

Experience with Oracle Configuration Management.

Experience with creating stored procedures, triggers, functions, packages, UNIX Shell Scripting and Partitioning.

Experience on Script Programming using Korn shell, bash shell and Shell Scripting knowledge on archiving tools like tar, gzip.

Managed Oracle databases of very large (over 45 TB) sizes and Oracle Application environment to support over 3,000 concurrent users.

Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 10g and 11g ASM.

Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities.

Extensive hands on experience with Oracle Cluster ware, MC/Service Guard and configuration with Oracle 10g and 11g RAC.

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.

Strong skills on Configuration and Management of Data Guard on RHEL, OEL.

Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.

.

Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.

Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.x for Clustered Environments.

Experience in Applying Patches, Critical Patch (CPU)/Patch Set update (PSU)and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.

Extensive experience in installation and implemention of OEM and TOAD and setup of Oracle Grid Control.

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).

Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.

Expertise in regular database synchronization for test database environments through automation.

Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.

Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).

Proficient in Database Design (Physical and Logical Database Design) and Normalization.

Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).

Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and also identifying the poor SQL's, histograms, row chaining & row migrations.

Knowledge on Oracle Support processes for Service Request, bug fixes and Patch Planning.

Ability to function successfully in a highly stressful, 24x7 mission critical environment.

Detailed technical documentation of database design, implementation and procedures.

Excellent analytical and problem-solving skills.

Result oriented, self-motivated, team player, ability to work independently.

Excellent written and verbal communication skills.

TECHNICAL SKILLS

Operating Systems: Sun Solaris, Linux, HP-UX, IBM AIX, UNIX and Windows

Databases: Oracle 10g, Oracle 11g, Oracle 12c, MS SQL, MY SQL, SQL SERVER, POSTGRES SQL database

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: RMAN, OEM, SQL*Loader, FTP, WINSCP, EXP, IMP, Data Pump, TOAD, SPM, SQLT, OSWATCHER, SQL*Plus, Grid Control, DBCA, Data Guard, TKPROF, Golden Gate, TOAD, RDA, Streams, Oracle warehouse builder (OWB)

Other: EMC Storage, Net Backups, VERITAS, SAN Storage, PUTTY.

EDUCATION

-BSc in Biochemistry - University of Yaounde 1

-Diploma in Computerized Accounting – CITEC Yaounde

Contact this candidate