DATABASE ADMINITRATOR

adci6c@r.postjobfree.com 443-***-****

An experience Database administrator with 6 years of deep knowledge and practice designing,maintaining, monitoring and tuning hundreds of PostgreSQL and Oracle databases on premises and cloud. Excels as an IT professional and a database analyst, easily able to work in teams to achieve common goals. Gisele has been involved in various projects such as Golden gate, Data guard, RAC. Skilled in installing, configuring, upgrading, and migrating databases as needed. Maintains strict database security and integrity standards for databases and have good knowledge of AWS. Employed as a PostgreSQL DBA at Cotiviti Atlanta, GA and Oracle DBA at Eastern Illinois University - Charleston,

Areas of expertise include:

Oracle 10g, 11g, 12c

Solaris

UNIX

AIX

Linux

Windows

TOAD

SQL DEVELOPER

Performance tuning

RMAN

RAC

PG ADMIN

Upgrades and patches

Oracle Enterprise Manager (OEM)

PG_HERO

ASM

Data pump

UNIX scripting

Database security(TDE)

AWS

PG_TUNE

PL/SQL

SQL*Loader

PG_BADGER

PROFESSIONAL EXPERIENCE

Cotiviti - Atlanta, GA June 2016 - Present

Role: POSTGRESQL DBA

Participate in a 24/7 on-call rotation position for all prod, QA, and dev environments.

Supported 130 databases in multiple SDLC environment.

Improved PostgreSQL database architecture by staying current to new features

Installing and Configuring PostgreSQL from source and packages on Linux machines.

Expert in initializing clusters and creation of PostgreSQL Databases.

Responsible for configuring, integrating maintaining development and production PostgreSQL databases

Administering large PostgreSQL Databases.

Configuring streaming replication (including cascading replication). I have configured a REPLICATION between MASTER and SLAVE and monitoring On-Going REPLICATION.

Experience in tuning PostgreSQL Databases using VACUUM and ANALYZE to improve performance

Experience with PG_BOUNCER for connection pooling.

Experience taking PostgreSQL backups using PG_BASEBACKUP and PG_BACKREST.

USE PG_HERO for Performance TUNING mostly. SQL Tuning using EXPLAIN, ANALYZE and PG_STAT_ACTIVITY.

Used Customized scripts, to monitor database growth, TABLE growth, automated backups using CRONJOBS.

Performing BASIC TASKS such as OBJECTS such as, creating roles, granting privileges, creating tables.

Hands on experience on restoration techniques on PostgreSQL like PG_RESTORE and (PITR) Point in Time Recovery. Perform BACKUPS, and RESTORE, Compressed (gzip) BACKUPS, Database or Schema REFRESHES.

Managed and monitored PostgreSQL databases using PGADMIN.

Configuring PGBAGER for generating statistic reports.

Configured PGTUNE for maximum performance for a given hardware.

Provided PRODUCTION SUPPORT based on a ticketing system. Assisted in defining and implementing MAINTAINANCE PLAN for the database system.

Experience using PG_DUMP ALL and PG_UPGRADE for database upgrade.

Hands on experience migrating from oracle to PostgreSQL using the MKT TOOL.

Leverage the AWS DMS and SCT to migrate Postgres, Oracle to AWS cloud.

Helped completing the migration and optimizing the application by fixing and migration issues and slowness that occurred.

Ensured that databases have appropriate maintenance in place including backup, index maintenance, routine and vacuuming.

Perform manual switch to redundant system / database components, in case of system failover

Implemented best practice on PostgreSQL Database and servers.

Monitored and analyzed PostgreSQL database using PEM (Postgres Enterprise Manager), Nagios core, and cluster control.

Eastern Illinois University - Charleston, IL Mar 2013 – Jun 2016

Role: Oracle/Postgresql Database Administrator

Provided prompt 24/7 support for all production and development databases.

Utilized RMAN and traditional Data pump export/import to clone and migrate databases.

Used RMAN to successfully recover database data during database crashes and media and disk failures as well as create and implement recovery strategies.

Administered PostgreSQL database using standard monitoring tools like PG _ADMIN and Solar Winds performance Analyzer.

Extensively used Crontab to schedule and monitor hot and cold physical backups.

Created all users, groups, roles, profiles, and privileges for relevant groups.

Optimized and tuned SQL queries using AWR, ASH, ADDM, Explain Plan, SQL TUNING ADVISOR.

Applied all needed security patches using patch set updates (PSU), and one-off patches.

Skillfully used RMAN and Data pump conventional import/export to implement database, schema, and table level data refreshes.

Installed and configured 10.2.0.1 database and upgraded from 11g to non-CDB 12c.

Successfully migrated from 11g to 11gR2 and from 12c non-CDB to pluggable databases.

Implemented tablespace level TDE security successfully and created Oracle Wallets.

Reviewed alert log and trace files to constantly monitor database performance (V$ dynamic performance views at peak load).

Checked database health status including table size growth, extent allocation, free and used space, and fragmentation by creating and running scripts.

Managed space maintenance, capacity planning, disaster recovery, and database overall maintenance Data guard.

Ensured zero downtime during physical standby database creation by using Data guard.

Performing failover and switchover manually and Data guard Broker.

Knowledge in resolving gaps in the data guard environment.

Resolved SRS efficiently through use of Oracle Support.

Configured Golden Gate for real time replication of data.

Knowledge in monitoring golden gate errors using ggserr.log file and the discard file.

Experience in troubleshooting golden gate processes like abending replicate and extract.

Created standard process documentation for peers to follow and utilize.

Experience with setting up physical standby Data guard environment for prod and non-prod databases.

Expert in using the data guard broker to manage the data guard environment.

Efficiently monitored application and database security along with user accounts and passwords.

Extensively used Hints, Indexes, and partitioning to improve performance.

Recovered data files from logical and physical block corruptions.

Applied all needed security patches including patch set, patch set updates (PSU), and one-off patches

Configured Golden Gate for continuous, real-time capture, routing, transformation and delivery of transactional data across heterogeneous platforms.

Hands on experience in collision handling during initial load golden gate.

Experience in trouble shooting golden gate abending processes.

Provided high speed parallel bulk and Meta data movement of database contents through skillful use of Data pump.

Reorganized databases, tables, and schemas to improve performance and aid in capacity planning.

Administered and troubleshot 3 node clusters on 10g/11gR2 and configured Grid Infrastructure SCAN listeners.

Performed task like administering the RAC using SRVCTL adding nodes, administering storage components.

Performed cluster-wide resource management, creating resource plans, service configuration, parallel instance groups, and application isolation.

Expert in logical and physical data modeling and designed logical and physical database structure

Created user accounts, roles, privileges, administrative tasks and schema deployments.

Ensured high availability, data protection, and disaster recovery through extensive use of Data guard and physical and logical standby databases.

Utilized ADDM and SQL Tuning Advisor in 10g, 11g, and 12c to improve database performance by tuning SQL and instance parameters.

Expert on Cluster management, event management, application management, connection management, storage management, load balancing and availability.

EDUCATION & CERTIFICATIONS

Bachelor’s Degree in Business Management 2012

University of Buea

Oracle Certified Associates (OCA 12C) 2019

SQL Fundamentals 2019

Oracle University

Contact this candidate