Oracle Database Administrator
Resume:
YVAN FEUDJIO
Oracle Database Administrator
*********@*****.***
PROFESSIONAL SUMMARY
Over 8 years experience as an Oracle Database Administrator. I have hands on work history in database administration including production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning and database security with Oracle (10g, 11g, 12c) on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.
Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.
Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.
Oracle Database Upgrades 10g to 11g, 11g and 11gr2 to 12c.
Migrating and consolidation of 11g databases into 12c in both QA and Production environments.
Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.
Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.
Experience in Installation of Oracle Databases 9i, 10g, 11g and 12c versions.
Experience in the Upgrade of Oracle Databases in patch set Level and also in version Level (9i to 10g), (10g to 11g) and (11g to 12c).
Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
Excellent knowledge on oracle 10g and 11G architecture and administration, good understanding of new features.
Experience in configuration of Oracle 10g, 11g and 12c physical & logical standby database using Data Guard.
Expertise in Disaster Recovery Planning and high availability solutions by performing switchover and failover operations in Data Guard.
Experience in creating and managing Single Instance databases and RAC primary and standby databases under various business critical environments.
Good hands-on experience in High Availability solutions with Oracle 10g, 11g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams, Golden gate.
Good hands-on experience in configuration of Oracle 10g R2, 12c OEM Grid Control to monitor database.
Good hands-on experience applying recommended Upgrade Patches as well as CPU/SPU and PSU patches to the standalone and RAC databases. design, development, system integration phase, quality assurance phase, development and production support activities.
Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB
Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g..
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.
Performing Fault Injection Test Cases for verifying the High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.
Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM.
Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.
Configuration and Management of Data Guard on RHEL, OEL.
Extensive skills in performing database crash recoveries techniques like Point in time/scn/cancel using full backup, level 0 and level 1 incremental differential and cumulative backups.
Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
Excellent skills in generating execution plan using EXPLAIN PLAN and gathering reports using TKPROF for Application Tuning and gathering optimizer statistics for SQL Tuning.
Experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
Experience in creating and managing control files, redolog files, data files and archive redolog files.
Experience in Database and table reorganization using methods like Online table reorganization, coalesce, deallocate and shrink space.
Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).
Proactively monitoring the database's health and taking preventive or corrective actions
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).
Used EXPDP&IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD.
Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.
Automated many common tasks using crontab including Backups, exports and imports.
WORK EXPERIENCE
Sedgwick CMS - Memphis, TN
Jun 2014 – Present
Oracle Database Administrator
Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON-CDB) Databases.
Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switchover and Export & Import.
Applied the Clusterware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using opatch.
Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c. as part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1).
Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Datapump and Normal ) for restoring the specific objects at the database level.
Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.
Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
Worked and implemented Database Wallet for Oracle 11g also called as keystore from 12c and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and tablespace encryption, also used TDE for Goldengate replication too.
Also tested disaster recovery with database failover and switchover also tested Goldengate replication after that using DBFS filesystem and ACFS.
Efficiently performed installation, setup and creation of four 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
Leading the effort of Cross-platform migration of Oracle databases to Oracle SuperCluster.
Monitoring of the databases using Oracle Enterprise Manager (12c).
using Oracle Enterprise Manager (12c).
Setting up replication of databases using Oracle Golden Gate.
Involved in Installation and configuration of Oracle 11gR2 RAC (2node) using oracle Clusterware and ASM.
Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database (Active Data Guard), Replication.
Worked on import/export, export data pump/import data pump and SQL- loader.
HP-UX Platform migration to Oracle Linux 6.3 Using RMAN Transportable table space
Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
Recovering GoldenGate corruptions and managing host/cluster maintenance mode blackouts
Implemented Initial DataLoad, Batch/Online replication, Security in GoldenGate.
Applying PSU / CPU Patches applying Oracle DST Patches on Oracle database.
Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Write and modify UNIX shell scripts to manage Oracle environment.
Implemented Initial DataLoad, Batch/Online replication, Security in Golden Gate
Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.
Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
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.
Bank of Oklahoma - Tulsa, OK
Mar 2010 - May 2014
Oracle Database Administrator
Installation, configuration and maintenance of Oracle 10g/11g Real Application Clusters (RAC).
Implement Grid based monitoring solution for large Databases and Installation of Cluster ware, configuring public, private and VIP.
Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
Implemented and configured 11g grid control on RHEL.
Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled jobs (Cron Job).
Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.
Experience in using 11g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
Involved in Defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance. 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.
Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing
Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
Efficiently performed installation, setup and creation of four 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 switchovers on primary and standby databases as a part of planned maintenance activities.
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.
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.
24 X 7 Production & Development database support and administration.
CERTIFICATIONS/LICENCES
Oracle Database 11g Administrator Certified Associate (Febuary 2017)
Oracle Database 11g: SQL Fundamentals I (December 2016)
EDUCATION
Bachelor Degree in Mathematics
LANGUAGE
English
French
TECHNICAL SKILLS
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, Top, DBCA, DBUA, ADDM, Remedy, Putty, WinSCP
Operating Systems : 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
Middleware : BEA Weblogic 10.2.3
Remote Tools : Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware Virtualization
Contact this candidate