Oracle Data

JULIUS FUH

443-***-**** ******@*****.***

Summary

An Oracle DBA with over 5 years of IT experience in Oracle (11gR2, 10gR2, 12c) 11gRAC, 10gRAC, installation, upgrade, designing, backup, recovery, migration, performance tuning, streams, data guard etc. in a variety of environments like UNIX (Solaris, HP-UX, AIX), LINUX Redheart & Windows NT 4.0/2000/2003 in production, test as well as development databases.

Experience Summary

Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.

Experienced in using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle databases.

Monitor and maintain system security and Auditing. Experienced in executing SOX related auditing controls.

Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).

Bulk loads and data migrations (using SQL*Loader, data pump import/export)

Expert in RMAN backups including full, incremental and cumulative.

Having hands on experience in Hot/Cold Backup, Recovery of databases using RMAN with VERITAS Net Backup.

Hands on experience in Performance Tuning and Memory (SGA) Tuning by identifying top Sqls/Sessions and Tuning.

Gathered database/Objects statistics using DBMS_UTILITY, DBMS_STATS packages and ANALYZE command.

Managed users roles and access across the board using OIM (Oracle Identify Manager)

Efficient in SQL query Optimization using Explain plan, Auto trace, TKPROF, Gathering statistics, pinning objects.

Experienced in loading data from flat files using SQL Loader and External Tables.

Knowledge on Oracle Support processes for technical requests through Meta link.

Monitoring & Reorganizing Tablespaces/Tables/Indexes.

Skilled in using tools such as SQL Developer and TOAD.

Replication (snapshots/materialized views)

Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks

Performed FLASHBACK features to handle efficient database recovery.

Qualified at writing SHELL Scripts and using CRONTAB for automatic backups.

Adept at installation of OEM Database Control, OEM grid control and Deploying Agents

In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and Data Pump Import/Export tools.

Technical Skills

Databases

Oracle 10g, 11g, 12c

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, Oracle Identify Manager, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy, Demantra,

Operating Systems

MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware

Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

Remote Tools

Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop

Professional Experience

CGI Technology Services / Fannie Mae- Phoenix, AZ. February 2015 - Present

Role: Oracle Database Administrator

Applied patches 11.2.0.2, 11.2.0.3, 11.2.0.4 and 12c.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24X7 support for all the production and development databases.

Responsible imports and exports, databases refreshes.

Responsible for monitoring and troubleshooting performance issues on databases in all environments (Development to Production).

Responsible for monitoring SQL SERVER database using MySQL.

Responsible for monitoring CPU / Memory utilization on all systems and killing process as needed to ensure uptimum performance.

Responsible for monitoring GOLDEN GATE replication tool.

Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases ( 10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11)

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Database migration on Unix Linux Redhat, CPU/PSU Patches.

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

Responsible for working in close collaboration with the backup support team in providing root causes for job failures.

Responsible for troubleshooting support incident tickets ranging from performance related issues to database outrages within Fannie Mae.

Responsible for troubleshooting on all Fannie Mae Oracle and Sybase Databases.

Experience with Oracle Golden Gate in a production environment.

Frontier Telecom - Dallas, TX July 2012 – November 2014

Role: Oracle Database Administrator

Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases ( 10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11)

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

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.

Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.

Backup/Recovery monitoring and reporting using Oracle RMAN

Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.

Extensive hands on experience with Oracle Cluster ware, MC/Service Guard and configuration with Oracle 10g and 11g RAC. Strong skills on Data guard.

Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.

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

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

Used Secure SCP & FTP extensively for the File transfers from machines to remote server.

Application of Oracle software patches when/where necessary.

Create oracle databases on configured servers using both the DBCA & Database creation scripts.

Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 11g database control, oracle 11g Grid Control as well as other third party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).

Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 11g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.

Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.

Create database Objects, Tablespaces, Schemas as needed.

Schema migrations from Development to Production via Tech Test environments.

Database refresh from Production to Tech Test as needed.

Environment: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Cox Communication Inc., Atlanta, GA May 2010 – June 2012

Role: Oracle DBA

Cox Communications carries the complete collection of cable capacity. The company provides basic cable service to more than 6 million customers, including 2.7 million digital cable subscribers and 3 million Internet access subscribers, making it the third-largest US cable company.

Responsibilities:

Provided Primary architectural and administrative support for new projects

Installed Oracle 10 and 11g database on HP-UX 11.0, Red hat 4.x

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Capacity planning and informing storage for next quarter disk space estimate, used tools like EM, Toad, package like dbms_space and other criteria defined by DBAs over the time.

Tuning database pro-actively for future needs, Monitor rate of archive logs generated daily, RMAN backups, alert log

Installed and configured Oracle 10g database on a test server using Oracle standard procedures for performance testing and future 10g production implementation

Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.

Troubleshooting error, reading trace file using tkprof utility etc

Refresh non production full/small size database from production database. Gold Copy of database taken, resizing down tablespaces and datafiles, excluding some of the data and truncating tables which are absolute as per business requirement

Build new database, decommissioning old out of scope database and reclaim space

Freeing up companies resources from historical database by archiving out old data to tape then removing or shrinking tablespace to high water mark if reasonable, shrinking undo/temp/other existing tablespace if reasonable by analyzing current and past usage from the time they obsolete

Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Performance Tuning i.e., Tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Oracle Grid Control Management Server Installation

Developed UNIX shell scripts to perform the above tasks efficiently

Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: Oracle 10g/11g, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, DataGuard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, and TKPROF, Toad, PL/SQL.

Lowes Inc - Mooresville, NC Mar 2009 – April 2010

Role: Jr. Oracle Database Administrator

Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.

Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database..

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.

Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.

Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.

Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24X7 support for all the production and development databases.

Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Academic Details

Department of Social Work, Bethel College.

Faculty of Law and Political Science, University of Dschang.

Contact this candidate