Manager Oracle
Resume:
DANIEL TCHOUMBE *
Daniel Tchoumbe
ac959v@r.postjobfree.com
An experience, determined and motivated oracle database administrator with over 6 years of hands on experience. I supported databases across a full SDLC, from development, test, UAT and production. Some key areas of support include installation, configuration, upgrades, performance tuning, backup and recovery, database and schema refreshes, space management, and database security. I have worked with Oracle (10g, 11g, and 12C) on Sun Solaris, Red Hat Linux, and Windows Platforms. My area of expertise includes:
• Dataguard & Broker
• Golden gate
• RAC
• Upgrade & Patches
• Migration of system
• Installation & Configuration
• ORACLE 10g, 11g, & 12C
• AWR REPORT
• ADDM REPORT
• SQL SERVER
• TOAD
• RMAN
• Backup & Recovery
• Recovery Catalog
• Development
• Testing
• QAT
• Creation of Conceptual,
Logical, & physical Model
• Database auditing
• Flashback
• EXADATA
• Optimization of SQL &
PL/SQL
• Project & Production Support
• TDE
• OEM & Grid Control
• Linux
• Windows OS
• TKPROF
• Shell Scripts
• SQL-TRACE
• AWS
PROFESSIONAL EXPERIENCE
ORACLE DBA, FIRST TENNESSE BANK – CHARLOTTE, NC AUGUST 2016 – PRESENT
• Experience in designing and configuring high-availability systems using DataGuard with physical standby effectively configured and used DataGuard Broker utility.
• Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data guard (DG Broker), Stage and Dev systems.
• Involve in 24x7 on-call support for 12 databases of 2.0 TB Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Installed and configured golden gate for replication.
• Responsible in configuring Integrated Extract (to support compressed table extraction ) and Co- ordinated replicate after upgrading Golden gate to 12.1
• Setup the unidirectional replication on oracle 11g databases using Golden gate.
• Monitoring and troubleshooting the gaps between source and target databases configured with golden gate.
• Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 10G to 12C.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab.
DANIEL TCHOUMBE 2
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
• Worked on Database Wallet and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and tablespace encryption.
• Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Linux Redhat)
• Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure
(Clusterware and ASM) and Oracle rdbms software on a 3 nodes RAC architecture in development and UAT running oracle.
• Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction
• Performance Tuning of SQL statements and Database Tuning using tools like Explain plan, SQL Analyze, ADDM, and AWR reports.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage. Debugging SQL tuning
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Migrate databases from Oracle and AWS vice versa.
• Backup and recovery including AWS.
• Managed databases in Exadata.
ORACLE DATABASE ADMINISTRATOR, KEYBANK – CLEVELAND, OH JUNE 2013—JULY 2016
• Applied Bug fixes patches and Quarterly Security Patches for the stand-alone databases and 2-node RAC databases with in the maintenance window.
• Installed RAC/GRID Infrastructure on Oracle 11g and worked on ASM feature of Oracle on HP- UNIX/LINUX. Worked on the ACFS file system and scheduled backup using RMAN on ACFS file system sharing between the nodes
• Maintained a 2-node RAC environment on LINUX AS 4.0(RHEL) for the staging purpose to support the business requirements and provide High Availability.
• Upgraded DEV/Qa/performace databases from 11.2.0.3 to 12.1.0.2
• Installed and configured golden gate for replication.
• Managed DSS (Decision Support System) and OLTP (On Line Transaction Processing system) full life cycle projects with multiple databases at one time, biggest database around 10 TBytes
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Data loads using SQL*Loader and refresh the test environments using Data Pump export/import
• Ministering the databases using Grid Control including but not limited to Space Management, Performance Tuning, and Workload Analysis (AWR, ADDM)
• Involved in setting up disaster recovery sites using Data Guard technology. Configuring the Physical Standby, active data guard and snapshot standby database
• Used Shell Scripts to automate database operation and schedule jobs using CRONTAB
• Working with Oracle Support to fix the production issues and also to get the merge patches. DANIEL TCHOUMBE 3
• Providing application support to create database objects and apply database changes. TECHNICAL SKILLS
Operating Systems
HP-UX 10.x, 11.x. Sun
Solaris 2.5, 2.6, 8, 9, 10. AIX
5.1, 5.2, 5.3, 6.1 RHEL 2.1,
3.x, 4.x, 5.x.Linux Enterprise
Server 9, 10. Windows
95/98/NT/2000.
Languages
SQL, PL/SQL
Database Utilities
SQL*Plus, Oracle Enterprise
Manager, Real Application
Cluster, ASM, Transportable
Tablespaces, SQL*Loader,
RMAN, DataPump.
RDBMS
Oracle 10g, 11g and 12c
Tools
TKPROF, EXPLAIN
PLAN, STATSPACK,
AWR, and ADDM.Toad,
Putty, Cisco VPN, WinSCP,
Remote Desktop
Connection, VNC, Team
Viewer,LogMeIn.
EDUCATION / CERTIFICATION
• Oracle Certified Associate (OCA 12C)
• ASSOCIATE’S DEGREE IN GENERAL STUDY-MONTGOMERY COLLEGE
Contact this candidate