GISELE PEGGY

Oracle Database Administrator (DBA) Email: adgon4@r.postjobfree.com cell: 240-***-****

PROFESSIONAL SUMMARY:

An accomplished Oracle Database Administrator with over five (5) years of extensive experience in database design, Monitoring security, performance tuning, migration, upgrades, patching, backup & recovery. Also, possess hands-on knowledge in implementing high availability solutions such as Golden Gate and Data Guard for Disaster recovery. Proficient in various platforms such as Linux, Unix, Windows, and multiple database systems such as Oracle 10g, 11g, 12c. Exceptional writing, verbal, analytical, and problem-solving skills. Also, an energetic achiever who can successfully prioritize and manage multiple projects, perform effectively well under pressure and adapt to a fast-paced environment.

TECHNICAL SKILLS AND TOOLS

RDBMS: Oracle RDBMS 10.2.0.1, 11.2.0.1, 11.2.0.4, 12.1.0.2, 12.2.1.0, MySQL, and MS SQL Server

Installation, configuration and update of Oracle 11g and 12c using OUI, DBCA, DBUA

Plan, Statspack /AWR, ADRCI, ADDM, DRA, Dbms_monitor, Alert Log, SQL Tuning Advisor, SQL

MS Windows Servers (2008, 2012, 2014), UNIX (Solaris 8/9/10), LINUX (Red Hat, Ubuntu, Centos)

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Stats pack/AWR, Top, DBCA, DBUA, ADDM,

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware Virtualization

Operating Systems: UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

ESTES-EXPRESS - RICHMOND, VA

Oracle Database Administrator Jan 2016 – present

Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Responsibilities:

Support multiple databases running Oracle 11g and 12c on Linux platforms in all environments in multiple data centers.

Designed backup strategies following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. Used block change tracking (BCT), reducing backup time from 5hrs down to 45mins. Resolved space issues with backup optimization, reducing storage costs by 20%.

Executed SQL queries with pre-defined aggregated functions such as COUNT, MAX or MIN.

Applied Oracle’s quarterly Critical Patch Update (CPU/PSU application) using Opatch utility to install, test, and deploy patches to all database instances.

Performing Database Refresh from production to test and development environments using RMAN Duplicate.

proactively monitor the database systems to ensure secure services with minimum downtime.

Constructed database security policy using passwords, privileges, user profiles, Transparent Data Encryption to encrypt tables and Tablespaces; implemented auditing policies as well as data redaction and data masking.

Installed and administered Physical Standby databases to achieve high availability and disaster recovery solutions (DATA GUARD).

Supported daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2008 and 2012 (Database sizes range 100GB to 35TB).

Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS_STATS, Trace files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports.

Implemented table and index partitioning and materialized views to minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.

Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases.

Generated shell scripts with developers to automate maintenance and backup jobs.

Reconciled functional and technical problems through research and training workshops, achieving a 65% increase in satisfaction rate of database end users and supervised the coaching of junior DBAs.

Part of the support team for 24/7 on-call production support. Generating Standard operating procedures (SOPs)

Critically analyzed and tuned the Database to identify potential issues such as response delay, locking contention, etc. using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.

Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, Node RAC Clusters

Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.

Setup, reconfigured and monitored 2, 3 Node RAC Primary to 2, 3 Node RAC Dataguard for DR.

Tested the Dataguard (DR) SWITCHOVER of RAC to RAC DataGuard as part of the migration.

Created new databases/instances on 12c/11g RAC and single instances using customized scripts, DBCA.

Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints

Performance monitoring and Database Instance, clustered and Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.

Redesigned table and index partitioning strategies, using HINTS to improve the query performance.

Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.

Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, etc.

Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.

Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.

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

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

Applied necessary Patches during installation and also in up-gradation of databases on Oracle database versions 10g and 11g.

Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the Data guard status via DGMGRL and GUI.

Implemented Backup and Recovery using RMAN, which includes hot backups and Cold backups to tape, drives, and disks.

Acxiom Little Rock, AR

Oracle and SQL Server DBA Sept 2014 – Jan2016

Created documentation on standard procedures and maintenance of existing DBs and routine tasks

Configured alerts on database, system and application performance monitoring and notifications

Participated in Change Management Control meetings and new project implementations reviews

Participated in on call services during off hours and weekends

Installed and configured various SQL Server and Oracle database software and maintenance tools

Enforced DB security using passwords policy, Least Privileges Rule, profiles creation and Encryptions

Participated in configuring Oracle DB backups using RMAN and Datapump

Created Oracle DB link, set up and configured ODBC (Data source)

Participated in database Migration from Oracle 11gR2 to 12cR2 using DBUA and Datapump

Performed Database cloning and refresh using RMAN and Datapump

Participated in Oracle 11g Golden gate installation and unidirectional configuration.

Performed daily management, administration, monitoring of oracle golden gate using ggserr.log and view command

Used AWR, ADDM, ASH, Alert log, dynamic performance views, stats pack, DBMS_STATS, Trace files, explain plan, System Event Logs to tune and analyze performance issues

Participated in setting up Physical Standby Database from Active Database using RMAN Duplicate

Performed Oracle Data guard quarterly switchover to DR site for validations and SLAs compliance

Applied various security patches and updates on existing DBs and track update changes

Used Sql server Management Studio (SSMS) to managed sql databases, objects creation, users’ logins, role access, backups, restore and other administration tasks

Installed PostgreSQL software and create database. Schedule backup requested by vendor

Experienced in supporting Very Large databases, data redaction and data masking.

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

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

Applied necessary Patches during installation and also in up-gradation of databases on Oracle database versions 10g and 11g.

Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the Data guard status via DGMGRL and GUI.

Implemented Backup and Recovery using RMAN, which includes hot backups and Cold backups to tape, drives, and disks.

Involved in query optimization and using rule-based optimizers and cost-based optimizers.

EDUCATION:

Bachelor’s Degree in Business Management – University of Buea

CERTIFICATIONS:

Oracle Certified Associate (OCA) 11g

Oracle Certified Associate (OCA) 12C

Certified Scrum Master – Scrum Alliance

Amazon Web Services (AWS) solutions Architect (In progress)

Contact this candidate