Oracle Manager

Serge-Thierry kouanang

Oracle Database Administrator

************@*****.***(6098510204)

PROFILE

Oracle DBA with strong experience of over 6 years in heterogeneous environments including UNIX/LINUX, WNDOWS, AIX, Sun Solaris HP-UX, AIX, Red Hat, operating systems.

Monitored and managed various databases (10g.R1, 11g.R1 &R2 and 12c) SQL Servers, My SQL Net Server and their components on an agile FDLC. As well as AWR

Expertise in installation, configuration creating databases using DBCA and scripts, as well as upgrading the database using DBUA, Data pump and upgrade scripts and applying patches (CPU/PSU) on oracle database.

Expertise in life cycle (SDLC) knowledge including production support, upgrades, performance tuning, cloning, space management, security patches, migration, backup and recovery, Data Guard, Golden Gate, and RAC (2 node).

Participated in the planning and implementation of off-site Disaster-Recovery planning and testing and configuration of physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan

Experience in Performance Tuning using ASH, ADDM, AWR, Explain Plan, STATSPACK, TKPROF and SQL Tuning Advisor, SQL TRACE.

Implemented Flashback technology and its various features in Oracle 10g.R1/11g.R1&2.

Performed Backup &Recovery for databases, Schemas & objects as well as recovering critical and Non-critical files using RMAN, User-Managed backups & Data pump.

Experience as On-Call 24x7 production DBA support, application/development DBA.

Extensive knowledge on database administration for Oracle 8i, 9i, 10g 11g and 12c r2, with experience in very large-scale database environment and mission critical large OLTP and OLAP systems.

Hands on experience in Oracle 10g/11g 12c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).

Good experience RAC Clusterware administration, Configuration and Patching.

Extensive experience in Data guard configuration and implementing; Golden Gate as well as maintaining standby databases.

Hands on experience in Grid control, Streams, Golden Gate Replication.

Setup Oracle Enterprise Manager (OEM) and Grid Control for 10g, 11g and 12c for database monitoring/performance/diagnostics.

Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.

Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Table spaces.

Good experience in writing/editing UNIX Shell Scripts as well as Patching and upgrading

Expertise in upgrading Oracle Development and Production databases from 8i to 9i, 9i to 10g & 11g, 10g to 11g, 11g to 12c

Know legible in managing very large Data Warehouse databases.

Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.

Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.

Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.

Experience in Capacity Planning and Bench Marking.

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).

Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.

Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.

Implemented and configured of Oracle Enterprise manager (OEM) Grid Control 12C and Oracle Management Server for maintenance and monitoring of production databases, multiple databases and application servers.

Extensively managed Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.

Strong Exposure in creation on an Oracle 12c Multi-tenant RAC data base with 2 node cluster and instances using ASM storage.

Extensively used Oracle Enterprise Manager (OEM), TOAD, SQL*DEVELOPER, SQL*PLUS and command-line for maintaining and monitoring databases, as well as setting up security profiles for users connecting to the database. I have also created and managed users, roles and granted privileges to different user profiles as needed.

Extensive experience in performance monitoring and tuning of database, instances, SGA, I/O, and Rollback segment, using different methods and detecting locks.

Implemented security measures on databases by configuring transparent database encryption (TDE), network encryption, strong authentication using Oracle password verification function and implementation of views/ materialized views.

Proactive, goal oriented DBA with good communication /presentation skills, a devoted attention to detail team player who takes pride delivering projects in a timely fashion.

Fast learner and work well under supervision as well as independently and stops at nothing until goals are met. Ability to adapt to new skills & technologies and dedicated to maintaining high standards. I am open and flexible to providing on-call and after hours support, including overnight and over the weekends.

TECHINICAL SKILLS:

RDBMS: Oracle 12c, Oracle 11g RAC, Oracle 10g RAC, oracle 9i, oracle 8i, Oracle 7.3, SQL Server, MySQL.

Operating Systems: Solaris 9/10, Linux RHAT 4/5,6, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows NT,2000/2003/2005.

High Availability, Tuning& Monitoring Products: Oracle 12c RAC, Oracle 10g RAC, Oracle 11g RAC,

Tools & Utilities: ASM, Data Guard, Grid Control (OEM), Tkprof, Statspack, AWR, ADDM, ASSM, TOAD, RMAN, Export/Import, Data Pump (expdp/impdp), SQL Loader, EXPLAIN PLAN, Putty, Win-scp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

ETL & Reporting Tools: Informatica, Power Center 8.5/8.0,Data Stage6.0,1.0, Business Objects Xi R26.1, Oracle Data Integrator, SAS,

Backup Tools: Veritas Netback up, NetApp, HP Omni Back, TSM,EMC

Environment

RHEL Linux 5.9, HP-UX, 10g, and 11g, Oracle 12c, 10g/11g RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, ERWIN 7.2, Golden Gate, RAC, SQL*Plus, PL/SQL, SQL*Loader

Education

BS in Computer Science University of Buea 2007-2010

BS in Finance Kean University, Union NJ 2010-2014

WORK EXPREIENCE

Oracle database administrator (Capital one) Richmond Virginia 05/2017 to present

24x7 Production database and applications support as well AWR cloud service.

Installed, configured, and maintained Oracle 10g,11gR2 and 12C R2

Upgraded databases from Oracle 9i, 10g,11g and 12C R2

Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.

Restoration and Recovery of databases at the times of occurrence of critical failures.

Created databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance; and applied patches.

Implemented Oracle database backup & recovery solutions using RMAN and manual methods.

Performed block recovery using RMAN and Moved data between databases using Data Pump.

Performed large batch jobs, tuning of SQL queries and database systems.

Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Partitioned large tables for better performance and manageability.

Installed and configured Golden Gate for replication.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.

Written PL/SQL Stored Procedures, Packages, Functions and Triggers.

Worked with Data Pump to take the logical backups of databases.

Experienced in performing Point-in-Time Recovery.

Performed Capacity Planning and Bench Marking

Load and Transform data using SQL*Loader and External Tables

Logical and Physical Database Design

Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Oracle database administrator (UT Health Science Centre) at San Antonio, TX 03/2015 – 04/2017

Successfully installed and configured Oracle 11g and 12c databases on Linux, windows and AIX OS platforms.

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

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

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

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

Implemented oracle 12c active standby database for test database environment.

Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.

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.

Documented all Oracle 12c installation/Up gradation work and delivered KT to all team peers.

Worked with projects/operations/professional services team and co-ordinate multiple tasks at hand with expertise and solid plan.

Administer User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Import/export utilities for cloning/migration of small sized databases and Data pump

Import/export to move data between 11g and 12c database environments.

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).

Implemented Flashback technology of the Oracle 11g and 12c along with Recycle in for a faster recovery of the databases and database objects.

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 10g (10.2.0.5) to Oracle 11g (11.2.0.4) and also, upgraded from Oracle 11g (11.2.0.4) to 12c for Standalone and 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.

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 and 12c two Node RAC (Real Application Cluster) with ASM file system on RHEL Linux platform.

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

Used TOAD and OEM for database management and monitoring

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Environment: Oracle 12c R2 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, Golden Gate, IBM AIX V6.1, RHEL 6.7, SQL* Plus, TOAD 10.0.

Oracle database administrator (FedEx Services) Colorado Springs, CO 01/2012 – 02/2015

Installation, configuration, and upgrades of Oracle databases 10g, 11g and 12c RDBMS software.

Experience in upgrading databases and applied PSU to multiple databases.

Monitored health of database by keep an eye on all Alert log and trace files and if any error comes find out the root cause & analysis for resolution.

Regular maintenance activities like cloning, patching and custom code migration provide by developer and working with their issues.

Successfully implemented Backup & Recovery using RMAN, which includes hot backups and Cold backups.

Proficiency in backup and recovery procedures including RMAN techniques.

Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.

Implemented and managed optimum physical database design (table space, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.

Monitored Day-Day Backups, Log's & recovering them as per the requirement.

Gathered, analyzed, and normalized relevant information related to, and from business processes.

Identified poor SQL and pass to development teams for review.

Involved in designing and implementing Oracle backup and recovery methods and disaster recovery methods using RMAN.

Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.

Performed Database Refresh in RAC Environment using transportable table spaces, expdp, and impdp on Solaris, Red Hat Linux and UNIX Platforms.

Successfully Implemented key RMAN 11g and 12c new features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals.

Experience on Performance tuning tools like AWR, ADDM, ASH, Stats packs, TKPROF, Explain Plan.

Generated DDL statements for creation of new database objects like tables, views, sequences, synonyms, indexes and created triggers, packages, procedures, functions and granted privileges.

Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance.

Supporting multiple databases for production, development, and test staging purposes on RHEL Linux environments.

Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.

Configured and administered unidirectional replication on Oracle Golden Database.

Created database objects in operational data store and maintaining them in Golden Gate.

Implemented initial Data Load, Batch/Online replication, and Security in Golden Gate.

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 custom applications like Portfolio Management Systems and vendor applications like SAP Business solutions

Involved in 24x7 on-call support for two 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, and Granting required privileges to users.

Applying upgrade patch, maintenance and interim patches on all the databases using opatch, migration of Databases from 11.2.0.4 to 12.1

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.

Efficiently performed installation, setup and creation of two 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.

Developed compliance reports and performed auditing at higher levels.

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

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

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 indexes, dropping unnecessary indexes, using hints wherever possible, amongst others.

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.

Experience with service now and remedy ticketing systems.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments and Oracle OLTP.

Experience with PeopleSoft, OEB Application server.

Exposure to MySQL database, SQL Server 2012 11.0

Environment

Oracle 12 C 10.2.0.4, 11gR1, OEL 6.3, HP-Unix, Windows server 2008R2, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, RMAN, Data Pump, TOAD.

Contact this candidate