Oracle Database administrator

WILLIAM NOEL

NGONGANG NGASSA

Oracle Database Administrator

************@*****.***

804-***-****

Over 5 years of experience as an Oracle Database Administrator with hands on experience in database installation, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation. I am also a very good team player, self-motivated person, dedicated in any work environment and excellent in documentation.

Database administration

5 + years

BACKUP AND RECOVERY

5 years

RMAN, SQL 5 + years MIGRATION 4 years

PERFORMANCE TUNING 5 years DATAPUMP 5+years

LINUX 5 + years GOLDENGATE 5+ years

UPGRADE & PATCHES 5 + years ORACLE 12C 4 years

DATAGUARD 5 + years SQL DEVELOPER, TOAD 3 years

OEM 12c 3 years RAC 5+ years

SECURITY 5 years PL/SQL 2 years

WINDOWS 2 years SHELL SCRIPTING 2 years

PostgreSQL 2Years EXADATA 2 years

OEM13c 2Years SQL SERVER 2Years

Oracle Database Administrator DEUTSCHE BANK – Jersey City, NJ July 2017 – Present

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, TDE, network and database encryption.

Backed up and recovered/Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2 and 11g.

Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning. WORK EXPERIENCE

PROFILE

SKILLS SUMMARY

WILLIAM NGASSA

2

Create recover catalog to keep my backup information longer than the controlfiles will do. Scheduling Physical backups (hot & cold) in CRONTAB using RMAN utility and monitoring the scheduled jobs. Tuned Databases and SQL Statements using OEM, AWR, ADDM, ASH, SQL TRACE, TKPROF, SQL TUNING ADVISOR, EXPLAIN PLAN …

Expertise in implementing data refreshes using RMAN utility, Transportable Tablespace (TTS) feature, Datapump and conventional Export/Import of Oracle 11g, 12c. Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Involved in Oracle Golden Gate installation, configuration and monitoring. Provided 24X7 support for all the production and development databases. Strong skills in applying CPU, PSU and One-off Patches using “runInstaller” and perl based utility “opatch”. Data loading using external tables, SQL*LOADER, Logical backups using full export and DATAPUMP. Involved in DATAGUARD configuration.

Oracle Database Administrator TIAA- CREF - Charlotte, NC April 2014 – July 2017

Created tablespaces, tables, indexes, set privileges and user logins Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, performed DBA day-to-day activities

Troubleshoot installation errors both independently and with Oracle support (via My Oracle Support) Production support for Oracle database 11g/12c.

Implemented auditing such as standard, value-based and fine-grained for data security. Implemented TDE and Network Encryption as advanced security measure for data protection and integrity. Performed conversion of Single Node Instance to Multi Node RAC, add an instance to existing RAC and upgrade Oracle 10g RAC to 11g RAC.

Installed and configured 2 nodes oracle 11gR2 RAC on ASM and NFS file systems for production environment. Database migration from Oracle to Exadata DB system using transportable tablespaces. Worked extensively on Performance Tuning, Memory (SGA) Tuning, SQL and PL/SQL tuning, Net backup, RAID, RAW Devices

Monitoring database performance and database operation to prevent downtime and slowness of the services. Implemented shell-scripts for automation of day to day activities. WILLIAM NGASSA

3

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre- developed UNIX shell scripts.

Created Physical Standby databases and switch to snapshot standby databases for application testing. Applied Critical Patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bugfixes on database products.

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration Created and managed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL developer and SQL navigator. Analyzing schema of databases created to collect statistics using the DBMS STATS package. Experience working on 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN.

Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature. Migrated 11gR2 oracle databases to PostgreSQL 9.6

Bachelor’s Degree in Computer Science

Oracle 12C Certified

EDUCATION

Contact this candidate