Resume

Sign in

Maintenance Data

Location:
Hyattsville, MD
Posted:
March 19, 2020

Contact this candidate

Resume:

Database Administrator with *+ years of experience on oracle RAC, GOLDENGATE, DATA GUARD, and EDBPostgres Maintenance, replication and migration. Skilled at migrating oracle databases to PostgreSQL on premise and to AWS cloud with tools like MTK, SCT and DMS. Also have extensive knowledge on performance tuning tools likes AWR, ASH, ADDM, PG_STAT_ACTIVITIES, pgBadger and extended event to troubleshoot performance issues and ensure that the system works at its optimal. Highly detailed oriented, with a drive to continually expand and obtain knowledge to better service Databases and assist in solving problems. Looking to apply skills learned through experience in assisting companies to archive their goals and objectives.

Areas of expertise include:

Project & Production Support

Oracle 12c, 11g, & 10g Versions

Installation & Configuration

Upgrades & Patches

Migration of Systems

Backup & Recovery

Performance Tuning

Dataguard & Broker

Goldengate

RAC

Development

RMAN

Recovery Catalog

Optimization of SQL & PL/SQL Scripts

Database Security

AWR Report

ADDM Advisors

Auditing

Flashback

SQL-Trace

TKPROF

SHELL Scripts

OEM Database & Grid Control

PostgreSQL

SQL SERVER

AWS

OLAP

OLTP

Streaming Replication

Ora2pg

PgBouncer

Mtk tool

Enterprisedb

Pgadmin 4

Databases:

Oracle 10g, 11g and 12c, PostgreSQL 9.6, 10, 11

Technical Proficiencies:

Platforms: Windows Server, Linux (red hat, centos),

Languages: SQL, PL/SQL PL/PgSQL, Bash

Tools: OEM Grid Control, AWR, ADDM, ASH, PgHero, PgAdmin 4, PEM, PgTune, PgBouncer, PgBadger, Remedy,

PROFESSIONAL EXPERIENCE

Caterpillar - Peoria, IL

November 2017 – 2020

Database Administrator

Oracle DBA

Database Administrator responsible for managing all aspects of oracle and PostgreSQL (Cloud and on – premise) databases.

Oversaw 24/7 on-call support for databases using Oracle 12c Cloud Control for alert monitoring and notification.

Upgraded databases from 10g to 12C

Monitor and troubleshoot RAC databases to maintain availability of production databases

Migrated systems to Multitenant Architecture using CDB and PDB applications

Extensively investigated and followed-up with application teams, and proposed solutions to resolve slowness and performance issues

During production hours, resolved lock and resource contention issues

Provided tuning recommendations to application teams through troubleshooting systems using SQL baselines, SQL profiles, and SQL Tuning Advisor

Identified root causes of SQL performance issues by analyzing EXPLAIN PLAN, SQL-TRACE, and TKPROF trace files

Aided troubleshooting of performance issues through analysis of AWR, ASH, and ADDM reports

Cloned and migrated small databases using import/export utilities, and used Datapump import/export for 11g/12c databases

Applied patches, upgrades, and maintenance on all databases

Utilized production data to refresh development and test instances regularly.

Provided technical assistance for installation and upgrading of existing Oracle databases.

Data Pump, EM Grid Control, and various other daily, and enhanced features in 12c such as table and partition recovery

Implemented Oracle TDE to provide transparent encryption of stored data

Used Oracle Enterprise Manager to perform database monitoring, maintenance, and performance tuning

PostgreSQL DBA:

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.

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

Migrated from oracle to PostgreSQL on-premise using mtk

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

Use pg_tune for performance tuning

United Airlines - Chicago, IL

Database Administrator

August 2014 – November 2017

Implemented procedures for automation of database management through tables and indexes.

Executed processes for evaluation of system space, database allocation and storage metrics.

Maintained all existing databases and new installations at current and stable production levels

Installed 11gR2 RAC while performing disk group management in ASM

Monitored health checks of OCR and VOTING DISKS while troubleshooting issues in RAC environment

Ensured the secure and efficient operation of Oracle Database Systems

Performed daily tasks such as resolving tickets, development support, and collaboration with application tuning

Created and implemented recovery strategies, and successfully recovered databases using RMAN

Utilized RMAN utility to schedule and monitor physical backups in the CRON tab

Created users, groups, roles, profiles, and granted privileges according to job needs

Optimized and tuned SQL queries using SQL-TRACE, TKPROF, and EXPLAIN PLAN utilities

Applied security patches such as Patch set, Critical Patch Updates, and Patch Set Updates

Used Transportable Tablespace (TTS) to quickly move a user’s tablespace across Oracle databases

Implemented data refreshes using RMAN, Datapump, and conventional export/import for Oracle 11g and 10g

Installed and configured Oracle 11.2.0.1 database on LINUX and WINDOWS platform

Upgraded databases from 11g to non-CDB 12c

Successfully used materialized views and Oracle Streams in Oracle 10gR2 to perform data replication

Implemented Tablespace level TDE security and created Oracle wallets

Constantly monitored the performance of databases through viewing alert log and trace files

Managed space, capacity planning, disaster recovery, and overall maintained the databases

Sql server experience

schedule database and transactional log backup using the database maintenance plan wizard

on performance tuning I have use extended event to tune the performance of sql queries and store procedures and index tuning wizard

done maintenance using the maintenance wizard

schedule jobs and alert using sql server AGENT

install sql server 2012,2014, on windows.

hands on import and export of databases

backup and recovery of database base on recovery models

extensive knowledge of the alwayson high availability on sql server

EDUCATION & CERTIFICATION

BSc in English common law

University of Yaounde II



Contact this candidate