Oracle DBA Resume , Atlanta, GA - Hire IT People

SUMMARY:

Oracle DBA with 5+ years of extensive experience supporting next - generation oracle database solutions on a multi-platform, integrated IT environment
Rich hybrid of process improvement and service delivery optimization experience
Strong business acumen, communication skills and ability to effortlessly interface and build rapport with technical and non-technical users.
Multi-lingual; English, French & Dutch.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g, SQL Server 2008, MS Access

Methodologies: Structured Analysis/Design

RDBMS Tools/Technologies: OEM, Toad, DBArtisan, SQL*Plus, RMAN, DGMGRL, EMCTL, SRVCTL, ASMCMD, Golden Gate, Oracle streams, TCP/IP Protocol

Office Applications: MS Office 2013 - Access, Excel, Word, Power Point, Project

Hardware: IBM AIX pSeries with the 47 GHz PowerPC POWER7, Sun Fire V880, EMC Data Storage devices

Data Models: ERD, Logical/Physical

Operating Systems: UNIX (AIX, Sun), Red Hat Linux, Windows

Languages: SQL, T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Atlanta, GA

Responsibilities:

Provided database support for three (3) production Oracle11.2.0.3/4 and 12.1.0.2 two-node RAC and single instance DG databases running on AIX and Linux platforms; the databases ranged in size from 0.7 TB - 4.1 TB.
Leveraged TOAD and OEM heavily for administrative, monitoring, scheduling, and query (SQL) optimization tasks
Traced user sessions and utilized AWR/ADDM/ASH reports for tuning
Wrote shell (korn and bash) scripts to automate routine work like backups and refreshes
Conducted security audit vulnerability assessments and remediate flagged flaws
Utilized a variety of tools - OEM, EMC TimeFinder, RMAN, Data Guard, Data Pump, UNIX shell scripts - to backup, refresh/clone databases
Leveraged AWR/ASH/ADDM/ reports and OEM (SQL Monitoring and Tuning Advisor) to monitor and optimize poor performing reports
Routinely applied scheduled PSU/CPU and one-off oracle patches to and upgrade databases using DBUA
Utilized SQL*Loader to load data in flat files from DB2 into Oracle
Participated in primary and back up 24X7 DBA on-call rotation schedule
Participated in the high-level design (HLD) and low level design (LLD) of projects with database impacts
SME on partitioning and advanced compression techniques

Oracle DBA

Confidential, Douala, CMR

Responsibilities:

Installed, configured and administered Oracle 10g and 11g Development, Test, QA, and Pre-Prod single instance and RAC (two-node) databases on Red Hat Linux platform
Supported Change Management processes by migrating changes between environments
Utilized RMAN and Data Pump for physical and logical backups
MS SQL Server experience - tuning and HA/BCP
Worked with the Network team during OEM configuration to define ports in the firewall to enable traffic between the Oracle Management Server (OMS) and the Oracle Enterprise Manager (OEM) agent
Reviewed and optimized SQL and PL/SQL code for and from developers
Tested, assessed and recommended alternative processes, procedures and tools to streamline operations and provide a more efficient database environment
Supported SQL Server 2008 in RAC environment for HA, RMAN for physical backups, data pump for logical backups/bulk copier (bcp) for inserting data at command line.

Jr. Oracle Application DBA

Confidential, Douala

Responsibilities:

Installed, configured and supported the sandbox, development, test, and QA Oracle 10g and 11g R2 databases running on Sun Fire V880 servers for the Loan Solutions, group
Planned backup/restoration strategy; scheduled physical backups using RMAN and logical backups using Data Pump in OEM and cron
Utilized OEM and DBArtisan for monitoring, administrative, reporting and tuning tasks
Migrated objects/schemas between environments and tuned bad queries

Level III IT Support Specialist

Confidential, Douala

Responsibilities:

Managed user accounts, network access and file permissions using DOS & UNIX utilities
Installed newly built and re-imaged desktops/laptops in offices
Built test cases and performed software testing prior to release.
Troubleshoot and resolved network related issues over the phone and remotely via WebEx/GoToMyPC