ORACLE DATABASE ADMINISTRATION

Name: Raphael ngam TEDJI

Email: adttko@r.postjobfree.com

Tell: 763 - 442 - 8952

PROFESSIONAL SUMMARY

Information Technology leader with over 14 years of IT related experience. An accomplished Oracle Database Administrator with 9 years of experience in supporting Oracle Databases and 5 years supporting Sql Server version of 2012 -2019. Oracle database server with versions 10g, 11g, and 12c, 19c with extensive knowledge in Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, and Oracle Streams.

TECHNICAL EXPERTISE

Operating Systems: Unix, Linux- Red Hat Linux 5.4, 6.X, Windows 2000 Server

RDBMS: Oracle 10g, 11g, 12c, and 19c

Tools/Utilities: RMAN, SSMS, Sql server engine, TSQL, ssis, OEM Oracle Management Server, SQL*Plus, Export/Import, Data Pump, AWR, ASH, ADDM.

Languages: HTML, JavaScript, PL/SQL, SQL, UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE

Chart Industries New Praque, MN

Oracle Database Administrator April 2010 - Present

Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.

Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, and Crontab

Proactively monitor the database environments to ensure secure services with minimum downtime.

Design tables with partitioning and sub-partitioning with indexes for efficient performance for online real-time search operations

Installed and configured software for Oracle 10g, 11g, 12c, 19c on both Windows and UNIX platforms

Experience in design, build new 12c/13c Oracle Enterprise Manager, management of Agent setup, management console configuration, dashboard setup/monitoring, and automating database jobs

Provide trend analysis and database documentation / reports to management team to enable them to make informed decisions regarding resource management and availability of the systems.

Involved in performing database upgrade from Oracle 11g, 12c to Oracle 19c Single Instances and RAC.

Installed and administered Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)

Monitoring and performance tuning using oracle Enterprise Manager cloud console and SQL Developer to manage daily task regarding performance and maintenance

Evaluate, test, and apply quarterly database Critical Patch Updates/Patch Set Update (CPU/PSU), and other Bug fix patches.

Experience in data encryption using Oracle TDE to protect the organization’s critical information and exceeding the industry standard.

Work collaboratively with other teams including Project Managers, Developers, and Architects to ensure project success

Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11g/12c on two node RAC

Constantly monitored the dynamic performance Views (V$) at peak load of the Databases and checking RAC background processes log files & Trace files to troubleshoot performance

Responsible for improvement and maintenance of the databases to include patching and upgrades

Implementation and release of database changes to support the application development teams in both the development and production environments.

Performing Day-to-Day DBA tasks: performance tuning, system security, database Installation configuration, patching, technical database support in 24X7 environments to ensure System performance and stability

Responsible for quarterly patches, /maintaining/monitoring/upgrading the production and test databases.

Setup/configured oracle RMAN for database backup and recovery. Application of different recovery Procedures for complete and incomplete recoveries depending on the type of failure by using Export/Import scripts.

Monitors database performance, identifies potential areas for improvement, and makes modifications as appropriate.

Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.

Perform database tuning by reviewing AWR & ADDM reports, implementing SQL profiles and baselines, designing table and index partitioning and coalescing of database objects for faster query performance. Include memory, I/O, contention, and SQL statement tuning.

Used Oracle Transparent Data Encryption to encrypt tables and Tablespaces.

Executed daily health checkup of production which included testing databases and performances of the Oracle Infrastructure,

Worked with developers/testers to troubleshoot day-to-day issues like tablespace management, user creation, JDBC/application database connectivity, and ORA- errors.

Deployed and implemented Oracle Grid Control (10g and 11g,) to monitor all databases.

Integer Holdings, Chaska, MN

Oracle Database Administrator July 2007 -April 2010

Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.

Handled Chained Rows and Row migration, and solved the database performance issues.

Ensure associated hardware resources are optimally allocated to database servers.

Creating, configure, manage CBDs and PDBs. Including the upgrading and transporting of CDBs and PDBs

Restore and Recover of database from offline, online and RMAN backup.

Ensure associated hardware resources are optimally allocated to database servers.

Experience with very large scale database environment and mission critical OLTP and OLAP systems

User Management, creation, monitoring and management of database users. Altering passwords and granting/revoking access to system/object privileges, roles and auditing user actions.

Migration of database components from/to DEV, QA, and Production in support of Development teams.

Table space monitoring, Performance monitoring and tuning for performance improvement.

Extensive experience implementing Oracle Advanced Security: Transparent Data Encryption (TDE) to enforce data-at-rest encryption and Data Redaction to reduce the risk of unauthorized data exposure in applications/redacting sensitive data before it leaves the database.

Managing, troubleshooting and resolving Oracle database and application issues.

Responsible for database backups, design, development, testing, and performance tuning.

Created scripts and scheduled backups in Cron for RMAN database backups and recoveries.

Database upgrades, resource capacity planning, platform migrations, application consolidations and data center rationalization.

In-depth understanding of security and backup procedures to ensure database integrity.

Performance Monitoring and Tuning of Database, Application, System Global Area, I/O, Rollback segments using self-developed scripts, Oracle Enterprise Manager, Spotlight on Oracle, ASH reports and Application tuning using Explain Plan, SQL Trace, Tkprof Utilities and Stats pack

Data transferring with export/import utilities and Data Pump and SQL* Loader.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in Oracle Database 10g, 11g, and 12c

Installed Oracle and grid software on standalone servers on ASM and file system.

Maintained database security via unique database roles and object permissions. Resized database files to decrease cloning, backup, and restoring time.

Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance.

Migrated data from Oracle 10g R2 database on UNIX to Oracle 11g on a Linux platform.

Maintained various SLA’s including ticket response and resolution time.

EDUCATION/CERTIFICATIONS

MS, Mechanical Engineering University of St. Thomas St. Paul MN 2014

BS, Biology University of Dschang Cameroon, 2004

Certified Scrum Master CPrime 2018

Oracle Certified Associate

Contact this candidate