Manager Oracle

Lancelot Kenfack

PostgreSQL and Oracle database

administrator

240-***-**** adb7tj@r.postjobfree.com

Seasoned PostgreSQL and Oracle DBA with over 06 + years of total experience with an extended knowledge of LINUX /UNIX OS. Expertise in database administration include Installation, configuration, patch installation and upgrades, performance tuning, database backup and recovery, security, database optimization, data migration, database refresh.

Professional Summary

Have experience on Linux red hat, windows, sun Solaris

Extensive knowledge with DDL, DML Select statements.

Managed Database Resource Management

Knowledge on PostgreSQL Database Refresh.

USED AWR, ADDM, ASH, EXPLAIN PLAIN, SQL TUNING ADVISOR for performance tuning.

BATCH/SHELL SCRIPTING.

Have implemented backup and recovery using pgbackrest.

PL/SQL, T-SQL AND SQL

BATCH/SHELL SCRIPTING

Have worked with SQL DEVELOPER

CROSS PLATFORM MIGRATION

LENOVO - MORRISVILLE, NC July 2017 – Present

PostgreSQL Database Administrator

Installed and Configured PostgreSQL version: 9, 10 and 11 on LINUX OS ( CENTOS, UBUNTU).

Used customized scripts and crontab to perform maintenance and schedule backups.

Installed, monitored, and maintain PostgreSQL and MySQL software.

Implemented and monitored alerting.

Upgraded from version 9 to 10 and 10 to 11 using PG_UPGRADE ; PG_DUMPALL.

Implemented backup and recovery processes: logical backup(pg_dump and pg_dumpall) and physical backup (pgbackrest and pg_basebackup)

Configured and monitored pgbouncer for connection pooling and performance enhancement.

Experience as On-Call 24x7 production DBA support, application/development DBA.

Developed database monitoring/health check alert scripts for database up-time/downtime status, and sizing issues.

provided system and SQL performance tuning using explain analyze, PG_STAT_ACTIVITY, pghero and pgbadger.

configured and monitored streaming replication (MASTER and SLAVE) and cascading replication.

performed database restore and database refresh using PG_RESTORE and PG_DUMP.

Migrated database to a remote host using PG_DUMP and SCP.

Performed database and schema refresh using PG_DUMP and PG_RESROE .

Carried out maintenance and performance tasks with the help of vacuum, vacuum full, analyze, reindexing etc..

Migrated from ORACLE to POSTGRESQL using the MTK and ora2pg.

Managed users access by creating roles, password file and granting privileges.

WALGREEN COMPANY - DEERFIELD, IL August 2013 – July 2017

Oracle Database Administrator

Successfully installed and configured Oracle 11g, Oracle 12c databases on AIX platforms.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Loading data from flat files to database using SQL*Loader, External Tables.

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

Involved in the installation, configuration and extended support to Oracle 11g, 12c two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 12c RAC databases.

Installed ASM environment and migrated databases from NON-ASM to ASM.

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).

Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases

Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.

Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.

Ran Scripts for Health Check on Exadata Storage Servers.

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Experienced in cloning the databases using HOT and COLD backups.

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

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

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

Documented the Standard Processes for peers to follow.

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

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

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

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

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

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

EDUCATION/CERTIFICATION

Bachelor Degree of Economic Analysis.

Oracle 12c Certified Associate (OCA).

SQL Fundamental certified.

Languages

SQL, PL/SQL

Tools

ORACLE: EXPLAIN PLAN, AWR, and ADDM. Toad, Putty, Winscp, Remote Desktop Connection, VNC, Team Viewer.

POSTGRESQL: :pgadmin, pg_ctl, pgbouncer, pgpool, pgbasebackup, pgdump, psql, pgrestore, PGANALYSE, EXPLAIN ANALYSE, AUTOVACUUM, pg_lock, EDB-MTK, ORA2PG.

Database Utilities

SQL*Plus, Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import.

Contact this candidate