SUMMARY:

• More than 10 years of IT experience and 8 years of Oracle database administration on different operating systems including Linux, and Windows for financial and telecommunication environments.
• Extensive experience with Oracle database (10g/11g/12c) administration including backup and recovery, database monitoring, performance tuning and troubleshooting, replication (Streams and Golden Gate Replication), high availability including RAC and Data Guard, database architecture, modeling and implementation of technology solutions.
• An expert with Oracle tool, such as RMAN clone, data pump (imp/exp in binary), SQLLDR (loading text file) and third party tools.
• Skilled in installation, configuration in Oracle software, including Oracle Database Software 10g/11g/12c, Oracle Grid Infrastructure and Oracle ClusterWare .
• Skilled in trouble - shooting, performance tuning in RAC and single instance database, including 10g/11g/12c, Physical/Active DataGuard on Linux(X64) and windows environments.
• Skilled in Oracle 11g/12c new features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, Grid Monitoring, Flashback Archive Log and pluggable database.
• 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.
• An Application DBA in SQL Tuning by using Oracle statistics management, Explain Plan, TKProf and necessary SQL code rewrite.
• Proficient in monitoring scripts by using Shell and other Operating System tools.
• Golden Gate/Active-Active
• Good Knowledge about Oracle Exadata architecture
• Working on setting up on Exadata machines, migration database to Exadata database

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. Oracle DBA and Oracle GoldenGate administrator

Responsibilities:

• As an Oracle DBA, work on OLTP and OLAP implementation using Oracle 11g and 12c. Implementation of Backup, Recover, Disaster Recovery (Using Physical Standby DataGuard) and cloning of 5 TB+ database.
• Create Oracle 11gR2/12cR1/12cR2 database for several large application .
• Setup and configuration of ASM storage for RAC or single instance database, and migrate non-ASM DATAFILEs from file system or raw device to ASM storage .
• Provided 24x7 on-call supports for critical OLTP (RAC) production databases on Linux and several huge data warehouse systems with data sizes of 5~10 TB. Database versions are ranging from 10g, 11gR2 and 12c.
• Administer 11gR2/12cR1/12cR2 RAC and clusterware, resolve and issues from RAC database, CRS and OCR related issues . Distribute the applications to different database services across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
• Applied patches on Oracle Clusterware and RAC databases.
• Testing and s on AWS.
• Installed and configured of GoldenGate on 11g/12c database for data replication troubleshooting some GoldenGate issues such like abended, lagging, long transaction
• As an application DBA, coorperate with developer to design the basic database frame or object type, also tune many application SQL query and transaction
• Analyzing database performance and tuning database on Oracle Exadata

Confidential, Pontiac, MI

Oracle Database Administrator

Responsibilities:

• Performance tuning tasks in both OLTP and WAREHOUSE environments, especially review SQL code before code release to production database .
• Developed Unix Shell Scripts, Perl Scripts, PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Loaded source data files with SQL*Loader and imp/exp utilities.
• Setup oracle network including using static and dynamic listener registers for different environments, diagnosed and trouble shoot connectivity problems .
• Design and create Oracle database objects, including heap tables, partition tables, b-tree and bitmap indexes, constraints, views and materialized views.
• Code PL/SQL Procedures/Functions/Packages, SQL and Bash shell Scripts to support business needs and reports needs.
• Design and develope Oracle PL/SQL ETL processes for loading data from internal systems using SQL Loader and External tables.
• Performance tuning and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.
• Expert in Data Guard setup and maintenance. Physical standby database are used for all critical production databases.
• Setup and configuration Oracle Data Guard Broker, switch physical standby database to snapshot standby database using Broker .
• 24X7 level L3 DBA support for the production systems.

Confidential

Big Data Support Team in Computer Support

Responsibilities:

• Supported multiple phases of the project for both backup and recovery and other core database responsibilities.
• 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.
• Onsite hands-on performance tuning and trouble-shooting with Oracle database team and application vendors for Oracle's important customers.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Generated AWR/ASH reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth etc.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.