Ulrich Quentin Kadji Wandjie

Oracle Database Administrator

adcpsv@r.postjobfree.com Phone: 616-***-****

Professional Skills

* ***** + of experience in the field of Database Technology with experience in designing, developing, implementing Databases, Web development and Application development.

Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery.

Installed and Configured the Golden Gate software and created manager, extract, replicate trail files and tested the data is flowing from source to target database.

Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump, conventional Hot/Cold Backups, PITR, TSPITR.

Worked extensively on Cloning /Duplicate of databases using RMAN.

Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, and 11g OEM Grid monitoring custom scripts.

Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc.

Involved in tuning applications for optimal response time using SQL Optimizer Trace at various levels and events, Explain Plan, TKprof and also identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.

Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.

Upgrading and Migration of databases to higher version and other platforms using manual method, traditional Export/Import, datapump & Transportable Tablespace (TTS).

Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.

Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.

Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database.

Installing Oracle patches, Migration of database across releases.

Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Expertise in loading data from flat files using external tables, SQL* Loader.

Used vacuum, vacuum full and analyze to performed maintenance activities

Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

Installed/Configured PostgreSQL Version 9.6, 10 and 11 and monitored and managed them using PgAdmin and PSQL

Tuned Postgres Instances using Pgtune and Pgconfigurator.

Hands on experience with migration of 4 Tera bytes database from Oracle to Postgresql RDS.

Created and managed database objects such as users, roles, indexes, views, sequences and permissions.

Knowledge in SQL server backups restores and recovery processes.

Ability to manage SQL server users and resources.

Excellent analytical, problem solving, communication, documentation and interpersonal

Skills.

Databases

Oracle 10g, 11Gr1, 11Gr2, 12c. MS Sql Server 2012-2016

Database Tools

Oracle (Oracle Enterprise Manager cloud control, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Postgresql 9.6,10,11.

Exp/Imp/Data Pump/AWR, DBCA, DBUA, ADDM, Toad, Putty, Winscp, Sql Developer, Sql Server Management Studio, TKPROF, MobaXterm, Cisco Automatic workload Automation, OEM 12c, RMAN, OLTP, Oracle partitioning, Advanced Compression, Data Center implementation, Oracle Audit Vault, Oracle Key vault, Pgtune, pgBouncer, pgBackrest, pg_dump,

Streaming Replication

Operating Systems

MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Other skills

GOLDEN GATE, DATA GUARD, SSIS, PL/SQL, Upgrades and Patches, Cluster, Unix scripting, BMC Control-M for scheduling, heterogeneous platform migration.

Professional Experience

DATABASE ADMINISTRATOR (ORACLE & POSTGRESQL)

Infosys Limited – Ashburn, VA Sept 2019 – Till date

Migrated oracle database to AWS RDS PostgreSQL using SCT Data Migration Service (DMS) Tool.

Converted oracle functions, packages, procedures, sequences into postgresql format using Ora2pg.

Manually recompiled function, tables using tools as pgAdmin, Notepad ++, SQL Developer.

Hands on experience with migration of 4 Tera bytes database from Oracle to PostgreSQL RDS.

Manually Converted Oracle batch script jobs to fit the PostgreSQL format.

Ability to work hands on hand with the developer team using tool as GITLAB.

Installed/Configured PostgreSQL Version 9.6, 10 and 11 and monitored and managed them using PgAdmin and PSQL

Performed backup using pgBackrest, pg_dump and pg_Basebackup

Created and managed database objects such as users, roles, indexes, views, sequences and permissions.

Performed database Patching as well as version upgrade using Logical replication and Pg_upgrade from 9 to 11

Configured and managed Streaming Replication between master and multiple slaves for high availability

Used customized scripts to monitor table growth and automated backups using cronjobs

Used PgHero for performance tuning. Tuned SQL using Explain Analyze and PG_STAT_ACTIVITY

Performed maintenance activities like vacuum, vacuum full and analyze.

Tuned Postgre Instances using Pgtune and Pgconfigurator

Configured pgBouncer for connection pooling

ORACLE DATABASE ADMINISTRATOR

Priority Health - Grand Rapids, MI April 2017 – Sept 2019

Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.

Used TOAD for database management.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Enabled Flashback for database to create restore points and supporting DDL changes

Used Oracle database vault and proactively protecting application data, Created Oracle Wallet, Enabling Transparent Data Encryption, Automatic Login Enabled for Transparent Data Encryption, Setting and Resetting the Master Key, Adding and Removing Salt from an Encrypted Columns, created encrypted tablespaces and backup wallet and master keys to tapes

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases

Implemented replication on databases using Golden gate between homogeneous and heterogeneous databases.

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.

Achieved optimal performance tuning by using explain plan, SQL TRACE, TKPROF utilities.

Installation, configuration and maintenance of Standby database using Oracle Data Guard for Disaster recovery process on Oracle 11g, 10g.

Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.

Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.

Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database

Refreshing development/test database from production using Export/Import & RMAN backups.

Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.

ORACLE DATABASE ADMINISTRATOR

CenturyLink Inc - Monroe, LA Mar 2014 – April 2017

Implemented proactive monitoring using SQL Trace, TKPROF and EXPLAIN PLAN.

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

RMAN point in time recovery and Instance recovery done on 11g.

Developed compliance reports and performed auditing at higher levels.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

Performed Data refresh activities using the export datapump utility.

Applied PSU Patches on 11g & 12c databases as part of maintenance activity.

Excessively worked on performing database backup and recovery using RMAN. Key player in troubleshooting backup issues. Taking the RMAN incremental and cumulative backups.

Good hands on performance tuning related issues with Experience in query analyzing and Performance Tuning for the SQL queries, which are running slow, consuming high resources.

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs.

Worked on SQL server environment, scheduling backup jobs

Used the Task manager to troubleshoot SQL Server resource contention

Education & Certifications

Bachelor’s Degree in information technology

Oracle Certified Associate (OCA) 12c

SQL fundamental

Contact this candidate