Oracle Data

Frank Lin

Contact Information

Cell Phone : 513-***-****

Email : ****************@*****.***

Objectives

Oracle Database Administrator

Oracle GoldenGate Administrator

Oracle PL/SQL Developer

Professional Summary

8+ years of experiences in Information Technology industry, especially in database / system administration, software design and implementation, network integration; self-motivated and enjoy working in a team environment.

More than 5 years solid Oracle database (9i / 10g / 11g R2) administration skills and hands-on experiences in high-end telecom and financial enterprise environments (database size from 3 TB to 60 TB).

Expert in Installation, Configuration, Cloning, Administration, Trouble shooting and Performance tuning of Oracle 9i/10g/11g databases on IBM AIX, Solaris, HP-UX, Redhat Linux and Windows platforms.

Hands-on experienced in providing 24/7 on-call support for Oracle production/development databases to ensure maximum availability.

Involved in Installation, Configuration and implementation of Oracle database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM)

More than 8 years experiences in Unix-like system administration (including Solaris / IBM AIX / HP-UX / Linux).

Solid hands-on experiences and outstanding troubleshooting skills to setup / configure / monitor / maintain Oracle 10g/11g RAC / ASM / Data Guard high availability environments.

More than 5 years experiences and solid hands-on experiences in Installation / Configuration / Performance Tuning / Troubleshooting Oracle GoldenGate middleware in Oracle to Oracle homogeneous environments and heterogeneous environments (including MS SQL Server / MySQL to Oracle).

Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full/incremental backup.

Highly skilled in SQL and PL/SQL Tuning, TKProf, Explain Plan. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.

Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, ERWIN and TOAD Data modeling utilities, Logical and Physical database design.

Experienced in day-to-day DBA activities including schema management and database security(creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.

Very good experience in doing cross platform migrations using RMAN and Transportable tablespaces.

Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

Education Background

Master Degree of Financial Mathematics, University of Cincinnati, Cincinnati, OH

Professional Experiences

J.P MORGAN CHASE BANK - Columbus, OH - March 2015 to Current

Position: Senior Oracle DBA, Consultant

Working as a DBA in the Database Support Team to support (daily On-Call rotation) production and non-production environments.

Working with the Information / Data Architect and Database Designer / Modeler to help implement the physical data model for the development and production environments for Data Warehouse and OLTP systems.

Worked for a number of tuning projects. Working with third party vendor developers on SQL code review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, Statspack, OEM 12c, Performance Manager, Spotlight and home-cooked scripts by using Korn shell/Perl.

Worked on maintaining oracle Databases and Exadata X2 with Half Rack.

Implementing High Availability Oracle GoldenGate (OGG) from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11gR2 RAC environments. Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc. Performance Tuning OGG in high data volume environments. Installing and configuring OGG heterogeneous environments (from Oracle to MS SQL Server).

Designing the production system monitoring framework, Configuring/Tuning Oracle Enterprise Management 12c (OEM), developing and maintaining the Korn shell based home-cooked monitoring scripts to monitor database instance status, tablespace usage, goldengate process running status, J2EE/Weblogic server status, etc.

Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export / Import utilities and SQL*Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.

Diebold Inc - North Canton, OH-June 2012 to January 2015

Position: Oracle DBA, Consultant

Installation and Maintenance of Oracle 11gR2 on Oracle Linux and IBM-AIX Platforms.

Worked on DBMS Datapump packages at schema, table and partition level for moving data using network link.

Supported production, development and testing environment with database ranging from 3TB to 60TB.

Configured and Implemented Oracle 11gR2 Two node Real Application Cluster (RAC) databases using Automatic Storage Management (ASM).

Upgrade/Migration of Databases from Oracle 10g to 11g, Cross platform migration from different platforms.

Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.

Migrated two node RAC databases from HP-UX 10.2.0.3 to 11.2.0.3 Oracle Linux.

Configured Goldengate in unidirectional replication for Oracle 11gR2 Databases for High Availability.

Involved in a team migrating 12TB & 40TB production database using Goldengate Zero-down time migration.

Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN Catalog for the same.

Installing ASM environment and migrating database from NON-ASM to ASM.

Creating and dropping of users, granting and revoking permissions to users/roles as and when required.

Troubleshooting errors and using the Expdp/Impdp utility on a very regular basis for copying data across schemas.

Configured Data guard to provide high availability by implementing Physical stand by database.

Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.

Rebuilding of Indexes for better performance and maintenance of Oracle Database.

Performance tuning and Monitoring using Grid Control database & managing instances using OEM

Simulated copy of Production databases into Test databases for the Application and Upgrade testing.

Supported off-hour on call support and advised the development teams on database related issues.

Worked on Distributed Database Configuration, Creation of Database links and Snapshots used Streams for 2 way replication of data.

Assisted developers in creating stored Procedures, Triggers, Functions, Cursors and Packages.

Responsible for monitoring and resizing Oracle database objects (Table spaces, Tables, Indexes etc.,

Responsible for memory and Application tuning of the databases using the Oracle utilities like OEM, SQL Trace, TK Prof and Explain Plan.

worked on 12C Oracle Enterprise Manager (OEM) grid control for monitoring needs

Configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.

Used UNIX shell programs & CRON jobs for automating the process of refresh of data periodically.

Documentation of Data Base Setup and administration of Server Environment.

Maximus - Austin, TX - November 2010 to May 2012

Position: Oracle PL/SQL Developer

Responsible for requirements gathering, status reporting, creating various metrics, project deliverables.

Developed PL/SQL Procedures, Functions and Packages and used SQL loader/Shell script to load data into the database.

Involved in migrating warehouse database from Oracle 9i to 10g database.

Involved in analyzing and adding new features of Oracle 10g like DBMS_SHEDULER, Create Directory, Data pump, CONNECT_BY_ROOT in existing Oracle 9i application.

Used partitioning and sub partitioning of big tables to improve performance.

Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.

Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.

Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.

Oracle China Corporation-Beijing, China- June 2009 to July 2010

Position: Customer Support Engineer in Database Team

Provide POC(proof of concept) and finial technical solutions based on Oracle's flagship database servers according to customer's requirements.

Analyze technical fit of Oracle's products and professional services against prospects requirements.

Installed, configured Oracle database production in different complex customer's environments. Provide initial technical assistance to customers and prospects, and coordinate customer technical staff and Oracle's resources.

Training customers about Oracle's products and in charge of POC(Proof of Concepts) based on customer's requirements.

Onsite hands-on performance tuning and trouble-shooting with Oracle database team and application vendors for Oracle's important customers.

Provide technical presentation about application server technology during Oracle's marketing road show campaign.

Reference

Available upon request.

Contact this candidate