SUMMARY:

• Senior Oracle DBA with 15+ years of experience developing, maintaining, and troubleshooting mission critical databases in Financial, pharmaceutical, telecommunications, Banking, Manufacturing, and services companies.
• Proven track record of successfully installing, upgrading, patching, maintaining, troubleshooting and optimizing databases on HP - UX, IBM/AIX, Sun Solaris, and Linux platforms.
• In depth knowledge and experience with MAA Oracle Technology Stack including RAC, ASM, Data Guard, Flashback Technologies, and RMAN.
• Managing and maintaining 20TB database with partitioning and Materialized View.
• Installing, upgrading, patching oracle 9i, 10g RAC/ASM, 11g software
• Expertise in identifying bottlenecks and tuning to improve application availability and response time
• Expertise in installing/upgrading/configuring Oracle Management Server Grid Control.
• Skilled in Oracle Server Installations / Upgrades, Space Management, Oracle Applications System Administration, Process improvement, normalization/de-normalization, Replication, Capacity Planning, Disaster Recovery, Database Performance Tuning, Memory Tuning, and Application Tuning.
• Over 10 years of IT experience as a Senior Oracle Database Administrator Ver. 6.x / 7.x / 8.0 / 8i / 9i/10g, 11g, and 12c on a variety of platforms including UNIX (Solaris, AIX, HP-UX), Linux RedHat, and Windows (2000, 2003, and XP) and Mainframe.
• Expertise in implementing and managing Oracle Data Guard, and RMAN backup/recovery.
• Knowledge of ETL (Informatica).

TECHNICAL SKILL:

Databases: Oracle 6, 7, 8, 8i, 9i, 10g, 11g, 12c, Fox Pro, Access

Languages: PL/SQL, SQL, Pro C, Pro COBOL, PL/1, FORTRAN

Operating Systems: HP-UX 11, SUN/Solaris, RS 6000/AIX, UNIX, Linux, Novell, Windows 2000, XP, NT (Personal Oracle 7,8,9,10g Development & Client install), BS2000/OSD.

Reporting / Tools: Oracle SQL*MENU, SQL*FORMS, SQL*REPORTS, Oracle Developer/2000, Developer Forms 6/6i Reports 6/6i, SQL Loader, OEM, Oracle designer, Oracle Discoverer, Statspak, DB Artisan, Oracle NET, ERstudio, UTM, BAAN(ERP), RMAN, TOAD, Remedy

Mainframe: IBM, Siemens

EXPERTISE AREA:

• Installed Oracle RDBMS
• Oracle Database Appliance
• Oracle Exadata
• Oracle RAC
• Oracle ASM
• Data Guard
• OEM Grid control
• RMAN Backup/Recovery
• Oracle Database Migration/Upgrade/patching
• Documentation and team building
• Strong Tuning, Installation, migration, and UNIX, Development
• Practical approaches to migrations, conversions, tuning and capacity planning
• Strong Automation and People Skills
• Team builder
• Strong Oracle developer PL/SQL, SQL, TOAD, Reports and Forms

PROFESSIONAL EXPERIENCE:

Confidential, Santa Ana, CA

Senior Oracle DBA

Responsibilities:

• Responsible for ensuring high-availability and performance of the databases that support the system in oracle 9i, 10g RAC,11g RAC, and 12c RAC, and other standalone database environments.
• Work with technical team to ensure the associated hardware resource allocation to the database.
• Proactively monitor the database system to ensure secure service with minimum downtime.
• Responsible for providing trend analysis to the development team to enable them to make informed decisions regarding resource management.
• Responsible for problem escalation to Development team and Oracle Tech Support as appropriate.
• Responsible for improvement and maintenance of the database to include rollout and upgrade/patches.
• Responsible for implementation and release of database changes as submitted by development team.
• Build and maintain the data structures required by the application, per the data model specs; ensure the physical implementation of the database is always in-sync with the physical data model.
• Define and implement database security rules and policies, monitor and audit the compliance and violation of these rules/policies.
• Provide DBA assistance and RDBMS support to the development and QA throughout the application lifecycle.
• Collaborate with the application development team to create, test, and maintain effective database-coupled application logic (i.e., Stored procedure, trigger, and user-defined function), if used by application.
• Design, develop, and deploy 24x7 database welfare and light-out monitoring solution for proactive assessment of database performance and identification of potential database resource bottlenecks.
• Participate in the diagnosis, resolutions, and avoidance of database problems/outages to insure optimal database performance and continuous database operations.
• Accountable for database performance optimization and preventative maintenance work such as backup/recovery, database object reorganization and storage defragmentation, database environment reconstruction, etc.
• Collaborate with application development team in SQL optimization and tuning opportunities.
• Transform logical data models to physical data model imposing the RDBMS specific rules, properties, and parameters that are required for the physical implementation of the database.
• Perform Oracle Database Appliance configuration, install and configure Oracle RAC/ASM on ODA.
• Participate in patching Oracle Exadata.
• Perform oracle database installation and configuration (RAC 12c, 11g standalone, RAC 11gR2/10gR2, ASM, 9i)
• Perform Oracle Enterprise Manager 12c Grid Control installation/configuration with SLB.
• Migrate database from 10gR2 on Solaris to 11gR2 on AIX machine.
• Setup and configure physical standby database (Data Guard)
• Practice and implement oracle switchover and failover.
• Responsible for upgrading and patching oracle RAC.
• Perform daily monitoring and maintenance of database and on call responsibilities.
• Performance tuning of database.
• Implement Oracle resource manager to priorities users and allocate resources accordingly.
• Implement and maintain oracle partitioning and materialize view
• Install and configure oracle text and XMLDB.
• Documentation of processes and procedures

Environment: Oracle Exadata, Oracle ODA, Oracle RAC 12c,11gR2,10gR2, ASM, oracle 9i, OEM 12c, Quest software, Spotlight,Toad, Sqldeveloper,Control-M Hardware/OS: AIX 7.1/6.1, 5.3, LINUX RedHat 4/5/6, Solaris 10, Windows 200

Confidential, Hercules, CA

Oracle DBA

Responsibilities:

• Responsible for administering 90 Oracle development and production database on AIX, HP-UX, Sun Solaris, and Windows NT (mix of Oracle 9i, 8i, 8.0.6, 7.3.4) on 24/7 basis.
• Supported the Bio-Rad’s BAAN global financial, distribution and manufacture systems and other production.
• Performs Database and SQL performance tuning
• Set up Capacity monitoring and performance monitoring of all Oracle systems
• Used Explain plan, SQL-Trace, TKPROF, and statspack for SQL tuning.
• Perform Database refresh as needed.
• Perform Database upgrade from oracle8i to 9i.
• Installation and configuration of Oracle Enterprise Manager 9.1&9.2 on Windows XP.
• Install and configured Oracle 9i on SUN, AIX, and HP-UX.
• Document oracle database creation, database refresh, oracle upgrading 8i to 9i, cloning database, and backup/recovery.
• Migrated large tables and indexes using export and import.
• Performs tables and indexes analyze to generate / gathered statistics.
• Performs Data Backup and Recovery
• Performs space management to eliminate fragmentation.
• Using DB link and synonym to run some SQL script that used more than one database tables.
• Install and configure Oracle Enterprise Manager and Agent.
• Automate tasks via Shell, SQL, and PL/SQL scripting.
• Install and apply patches on SUN and AIX server.

Environment: Database (Oracle 7.3.4/8.0.6/8.1.6/8.1.7/9.1.0.4/9.2.0.5 ), Hardware/Platform (Win XP, HP-Unix, AIX, and Sun Solaris), OS (HP-UX 11, IBM/AIX 5.2, Sun Solaris 3.x, Win XP), Tools (OEM, SQL*Plus, PL/SQL, Statspack, DBArtisan)

Confidential, Irvine, CA

Oracle Reports Developer

Responsibilities:

• Install and configure Oracle Developer/2000 and Oracle Reports6i on Windows XP.
• Generate reports with Developer 2000 and Reports6i.
• Write stored procedures, Package, and Function.
• Convert reports from Developer/2000 in Oracle 7.3x to Reports6i in Oracle 9i.
• Transferred Stored Procedures, Package, and Functions from Oracle 7.3x to Oracle 9i.

Environment: Database (Oracle 7.3/9i), Hardware/Platform (Win XP, HP-Unix), OS (HP UNIX, Win XP), Tools (Developer/2000, Reports6i, SQL*Plus, Remedy System)

Confidential, Whittier, CA

Oracle DBA

Responsibilities:

• Installed and configured Oracle Enterprise Manager, Oracle 8i/9i software on Windows 2000.
• Installed Oracle 9i on Linux.
• Upgraded database from Oracle 8i to Oracle 9i.
• Rollback segment & Temp tablespace tuning.
• Performed backup and recovery using RMAN.
• Database monitoring and sizing SGA component for better performance.
• Familiar and worked with ER/studio data modeling

Environment: Database (Oracle 8i/9i), Hardware/Platform (Win 2000, Linux), OS (Linux, Win 2000), Tools (OEM, SQL*Plus, RMAN, Statspack, ERstudio)

Confidential

Sr. Oracle DBA and Systems Administrator

Responsibilities:

• Leading OS and Operation groups in a data center.
• Experience in data center operations to include hardware planning, production scheduling, change management, hardware, and operating upgrades, issue resolution, system failure and fault isolation, and overall technical center oversight
• Performed production, certification, test, and development DBA duties.
• Supported the Confidential ’s UTM (OLTP) application and other production.
• Migrated Oracle 6 database to Oracle 8i (SQL Loader, SQL script, and C coded conversion).
• Installed and configured Oracle Enterprise Manager and Oracle 8i software on Windows 2000.
• Performs weekly full and nightly incremental RMAN backups for several Oracle databases.
• Install and configure Oracle Database on mainframe and UNIX.
• Performs Backup (cold and hot) and Recovery duties on Mainframe platform.
• Performs logical backup using Export/Import.
• Performs database monitoring and performance tuning.
• Sizing SGA on mainframe and improve performance by 40 percent.
• Performed and responsible for space management, database and system security.
• Performs oracle software installation.
• Performs system software installation and configuration.
• Provide DBA support for development team.
• Implement and create application schema owner.
• Provide documentation for software installation, backup and recovery.
• Performs system monitoring for performance issues.

Environment: Database (Oracle 8i, Oracle 7, and Oracle 6), Hardware/Platform (Mainframe, UNIX), OS (BS2000/OSD V3, UNIX, Win 2000), Tools (OEM, SQL*Plus, RMAN, COBOL, UTM)

Confidential

Oracle Developer

Responsibilities:

• Data modeling and data analysis - defined business requirement, data analysis and ER Diagram.
• Programmed Research and Development Management system for Ministry of Energy using Oracle Developer Forms 6i, Reports 6i.
• Programmed large Management Information System with more than 400 forms and 400 reports for Ministry of Energy Water Affairs.
• Program Administrator and business client/server software.

Environment: Database (Oracle 7.3, Oracle 8), Hardware/Platform (WIN NT 4.0, UNIX), OS (WIN NT, UNIX), Tools (SQLPlus, PL/SQL, UNIX K-Shell, SQLLoader, Oracle Discover, Oracle designer 2000, Oracle Developer 2000, Oracle Forms 4.5, Oracle Reports 2.5, Oracle Developer Forms 6i, Reports 6i, SQL*Forms, SQL*Reports, Visio)