Oracle Database Administration
Resume:
EDOUARD MARIUS TSAFACK TSAGUEU
*********@*****.***
Summary:
Highly skilled and motivated professional with over 7 years and a proven track record in network engineering and Oracle database administration. Proven expertise in Oracle database administration, encompassing installation, configuration, and maintenance of databases to support critical business applications. strong problem-solving abilities and a commitment to delivering high-quality solutions within specified timelines. excellent communication and teamwork skills, with a focus on enhancing organizational efficiency through strategic IT initiatives.
Configured and maintained replication using Oracle Golden Gate version 19c/12c/11g.
Used Oracle Enterprise Manager OEM 13c for monitoring databases. extensively monitored Goldengate using OEM 13c.
Worked on DataGuard 11.2.0.4, 12.1.0.2, 12.2, 19.14 on oracle EXADATA.
Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.
Providing DBA support to multiple Cluster, Non-cluster and ASM Database in production, development, and Testing Servers in Exadata, UNIX, Linux, Windows, and Solaris Environments.
Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch.
Have Hands on working in both Application and Production support environment.
Experience in patching RAC databases in rolling fashion to maintain high availability.
Excellent experience in Installation, administration and troubleshooting of Oracle for OLTP (multiple instances)/ OLAP environment on Very Large or Highly Transactional Databases.
Configure OEM 13.4, deploy agents, set up matrix and threshold for database monitoring.
Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) on versions 19c,12c and 11g.
Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate abend issues.
Experienced in Partitioning and creating Global, Local Indexes on Partitioned Tables.
Implemented different RMAN backup strategies (Full and incremental). Performed Incomplete and complete recovery.
Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
System administration, Oracle Problem analysis and resolution and active cloning of databases from one server to another server.
Testing and implementing different physical (hot/cold) and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
Created database & database objects like table, index, table space, rollback/undo segments and views & analyzed relevant objects to collect statistics to tune the system performance.
Tune and optimize databases for better performance. Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of Disk I/O, Sizing of tables and indexes.
Load data from flat files into the database using SQL*LOADER.
Tune applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.
Implemented oracle 12c active standby database for test database environment.
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 19c,12c,11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 7.9
Experience with large databases (15Tb) for OLTP and OLAP applications.
Performed installation, configuration, and maintenance of oracle 19C/12C/11G.
Experience in configuring oracle 11g Real application cluster (RAC) (2 and 3 nodes) using clusterware and automatic storage management (ASM).
Performed migration of oracle 11g non-RAC single instance to RAC database instances.
Experience with 19C/12C/11g cluster maintenance using CRSCTL command.
Experience in using SRVCTL command for Oracle 19C/12C/11g RAC database.
Implemented Disaster Recovery database 12C/11g Data 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.
Applied PSU Patches on version (11.2.0.3, 11.2.0.4) as a part of maintenance activity.
Experience in Monitoring and Tuning system resources associated with database performance, hit ratios, I/O, lock, and latch contention.
Excellent analytical, problem solving, communication and interpersonal skills.
Database Administration/Grid Control - Oracle 11gR2/12c/19c & OEM 12c/13c
Installed, administered 11.2.0.4.0, 12.1.0.1,12.2.0.2 and 19c DB versions.
Successfully Upgraded Oracle DB from 11.2.0.3.0 to 12.1.0.1, 11.2.0.4.0 to 12.1.0.1,12.1.0.1 to 19.0.0
Installed, configured, administered 3 node RAC on OEL 7.9
Upgraded OEM repository/agents from 12c to 13c.
PROFESSIONAL EXPERIENCE
Role: Oracle Database Administrator
Company: CITI BANK, Tampa, Florida March 2022 – Till Date
Supported multiple databases for production, development, test and staging purposes on Sun Solaris, Linux, and Windows environments.
Installed, configured, Maintained, Upgraded and Supported Oracle 19C/12C/11g Databases. Managed and monitored databases using OEM 13.4.
Maintained and troubleshooting issues in version 11,12c, GoldenGate unidirectional, bidirectional, peer-peer replication environments.
Used logdump to investigate logging of tables and used ggserr.log and report files to find out root cause and fixing issues.
Created definition files and used defgen utility in GoldenGate environment and enabled OGG monitoring on servers.
Applied the Database (RDBMS) Patches, PSU patches and one-off patches for Bug resolution using opatch utility.
Proficient with Veritas/NetBackup storage systems
Shell scripting for post and pre-validation automation for the ansible team.
Worked with Service Now and remedy ticketing systems.
Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled repetitive activities like gathering schema statistics, exports, tablespace usage report.
Installation, configuration, upgrade, and performance tuning of Oracle 19c/12c/11g RAC.
Upgraded/Migration of Databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c.
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Performed database real-time unidirectional replication using oracle Golden Gate 12c.
Built Oracle Standby databases, both Active Data guard for real-time replication and normal Data guard for disaster recovery.
Migrated Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switchover and Export & Import.
Refreshed 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.
Developed compliance reports using UNIX/SHELL scripts and performed auditing at higher levels.
Provided instance level performance monitoring and tuning for Event Waits, Blocking Sessions, Physical and Logical I/O and Memory Usage.
Performed RMAN recovery testing, RAC, and standalone database.
Set up Oracle ASM storage for Oracle RAC databases.
Used SRVCTL commands for Real Application Cluster (RAC) Databases
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
Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF. Performing monthly and annual performance reports for trend analysis and capacity planning.
Assisted in SQL tuning and providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes, using hints wherever possible, amongst others.
Oracle Database Administrator
JPMorgan chase, New York, NY September 2017 – March 2022
Worked as a team member for 24x7 support with on call rotation in all prods, QA, and dev environments.
Performed incremental (L0 and L1) backups of large databases to reduce backup time and storage space.
Configured a catalog database for storing backup and recovery metadata.
Successfully completed point-in-time recovery and tablespace recovery as per business requirements.
Automated backup processes using shell scripts and CRONTAB.
Used RMAN active duplicate to refresh databases for performance testing.
Created and scheduled jobs using DBMS_SCHEDULER.
Implemented Transparent Data Encryption (TDE) to secure data at rest.
Utilized RMAN for full backups, incremental backups, database refresh, duplication, and cloning.
Configured Oracle Data Guard Broker to manage physical and standby databases.
Performed switchover and failover operations using DataGuard Broker.
Converted physical standby to snapshot standby using DGMGRL.
Configured Active DataGuard from physical standby.
Setup New databases on Clustered and Non clustered environment and Implemented Maximum Availability Architecture using RAC, DATAGUARD and Golden Gate
Upgrade 11G Rac to 12c RAC and Administering the RAC Environment through SRVCTL and CRSCTL and applied patches in rolling fashion.
Worked on 12c RAC new builds and administering 12c RAC and managed ASM on RAC
Creating Volume and Configured ACFS on ASM disk group and extensively worked on creation oracle Databases with ASM filesystem.
Configured disk groups with different redundancy levels and created fail groups and managing and tuning ASM parameters.
Configuration & Troubleshooting the Oracle Data Guard & GoldenGate environment in Oracle 11g & 12c versions. Created diskgroups and managing diskgroups in ASM and created ACFS managing in clusterware environment.
Created services in RAC using SRVCTL and used CRSCTL to manager cluster ware resources.
Created and managed CDBs and PDBs to support multiple applications.
Converted non-CDB’s to PDB’s and created PDB’s from PDB$seeds.
Cloned UAT PDB databases from PROD using dblink approach.
Unplugged and plugged PDBs into remote CDBs.
Created database objects, dblinks, creating indexes, creating materialized views, writing packages, Stored Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle
Configured Golden Gate 12c RAC, RAC Active configuration with 12c database.
Hands on experience in GGSCI utility for administering Extract, Pump, Replicate & reviewing the error logs and troubleshooting Abend scenarios.
Configured GoldenGate BI-DIRECTIONAL replication and extensively used CDR parameters.
Full database, Schema refresh using RMAN, Datapump and Implemented the Backup strategies using RMAN catalog and noncatalog methods.
Setting up of Oracle and Application user accounts and passwords, monitoring application security
Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
Handled High volume production databases around 5TB size along with Physical standby databases.
Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.
Performed Data file recovery from logical and physical block corruptions.
Good understanding and Implementation expertise in RAC, ASM, Data Guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability. Continuous monitoring of performance during peak and non-peak loads using AWR reports, ASH, ADDM and Optimization SQL code using SQL Trace, tkprof, Explain plan.
Experience working with SQL, PL/SQL coding, stored procedures, functions, packages, triggers.
Work with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data, and metadata movement of Oracle database contents.
Management of schema objects, partitioning of tables & indexes and performing SQL*Loader jobs for loading data from flat files (ETL) and Oracle Database monitoring, troubleshoot and resolve the issues.
SQL tuning - AWR history of SQL execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpret Execution plans, Re-write more efficient SQLs.
Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery.
Using TCP/IP Protocol Configured SQL*Net files on server / client machines and resolved client connectivity issues.
Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 12c RAC databases.
Technical Skills
• Technical Skills Oracle Applications 12.2.4/12.1.3/12.0.4, 11.5.10.2/ 11.5.9 ● MIDDLEWARE: Oracle 12c/11g ● Oracle 19c/12c/11g/10g/ ● MySQL ● Exadata X6-2, X7-2 ● AIX/HP-UX/Solaris/Linux/Windows ● OEM/Grid Control (13c/12c/11gR1/10gR5) ● Data Guard(12c/11gR2/10gR2) ● RAC ●JIRA ● Confluence ●Networking (11gR2/11gR1/10gR2/19R3)● Oracle Goldengate ● RMAN (Symantec NetBackup/EMC Networker/IBM TSM) ● Data Pump ● Sql*Loader ● ASM ● MV Replication● TOAD ● Change Management ● IT Controls ● Oracle Diagnostics(RDA 4/OS Watcher)● SOX Compliance ● ODBC/ODAC ●Oracle Tuning (ASH/ADDM/AWR/TKPROF) ● TKPROF ● CVS ● Unix Shell (ksh,bash) ● VMWare
EDUCATION/CERTIFICATIONS:
OCA
CCNA
COMPTIA Net+
AUSTIN COMMUNITY COLLEGE TEXAS Bootcamp Software Developer
THE UNIVERSITY INSTITUTE of TECHNOLOGY CAMEROON Bachelor’s degree in computer science
Contact this candidate