OBJECTIVE A challenge position as an Oracle DBA/Oracle Applications DBA

TECHNICAL SUMMARY

• Oracle Certified Professional DBA and Applications DBA
• Over 15 years of experience in database administration and computer programming
• Servers and Tools: Oracle Database 7.x, 8, 8i, 9i, 10g, 11g , Oracle Applications/E-Business Suite 10.7, 11i, R12 , Oracle Application Server 9i/10g OID, SSO, BI, Portal, Forms , Oracle Fusion Middleware 11g WebLogic, OID, OAM, SSO , MS Sql Server 2005, 2008 , WebFocus, Apache, Toad, ERwin, Oracle Designer, Oracle Developer, Access
• Operating Systems: Sun Solaris, HP-UX, LINUX, AIX, Windows, MSDOS, VM/XA
• Languages: SQL, PL/SQL, Unix Shell Script, Java, Java Servlet, JSP, EJB, UML, Visual Basic, HTML, XSL, XML, C/C , FORTRAN, SAS

EXPERIENCE

Confidential

Senior Oracle DBA

• Supporting Oracle databases which include Non-Prod and Prod databases.
• Handling 2 Node 11g R2 RAC databases hosted on IBM AIX.
• Experience in handling Oracle 11R2 databases hosted on windows environment.
• Extensively worked on configuring and managing Physical standby databases.
• Adhering to ITIL policies such as Incident management and change management while working on day to day tasks.
• Configured OEM 12c for database monitoring and configuring alerts.
• Worked on database cloning using RMAN
• Handling database change releases.
• Using HPSM tool for ticketing.
• Using IBM clear quest tool for release management.
• Troubleshooting and performance tuning for Oracle databases

Confidential

Senior Oracle DBA/Oracle

• Responsible for daily Oracle/Oracle RAC and MS Sql Server database support and troubleshooting, backup and recovery, database design and implementation, technical support for development teams.
• Performed Oracle database platform migration from HP-UX to Linux as well as upgrade from 10.2.0.3 to 11.2.0.1, including Oracle 11g installation and database export/import with Oracle Data Pump
• Implemented RMAN hot backups with NetBackup and cloned/refreshed Oracle database using RMAN duplicate procedure
• Implemented Oracle Data Guard for database high availability
• Created Oracle Application Server AS 10g development environment from production environment using Oracle AS staging procedure, including AS infrastructure installation, AS middle tier clone and metadata export/import

• Performed Oracle Applications/E-Business upgrade from 11.5.8 to 12.1.3 with platform migration and deployment change, including pre-upgrade, upgrade from 11.5.8 to 12.0.4, upgrade from 12.0.4 to 12.1.1, upgrade 12.1.1 to 12.1.3 and post upgrade with lots of problems fixed
• Upgraded RDBMS from 9.2.0.8 to 10.2.0.4 for Applications R12 upgrade.
• Installed Oracle Applications 12.0.4 with Rapid Install
• Merged applications ties from two node to one node and migrated database tier from HP-UX PA-RICS to HP-UX Itanium for 11i split operation
• Upgraded Discoverer and Noetix View for Oracle Applications R12
• Upgraded Oracle RDBMS 8.1.7.4 to 9.2.0.8 with Applications 11i interoperability
• Upgraded Developer 6i with Oracle Applictions11i
• Upgraded 11i AutoConfig, patched 11i for Rapid Clone readiness, cloned Oracle Applications 11i with Rapid Clone
• implemented Oracle RAC 10gR2 on RedHat Enterprise Linux 4 for Case Connect system, including Oracle Clusterware installation, Oracle RAC software installation, Oracle ASM instance creation and RAC database creation

• Built a data mart for Oracle Applications AR module to support financial reporting, including 10g database installation, database patching, data model creation, integration of security for report distribution, ETL scripting, performance tuning for data loading
• Involved in reporting platform evaluation and business analysis for corporation reporting/data warehouse system
• Developed dimensional and relational models for corporation data mart and data warehouse
• Performed database capacity sizing, resource planning and configuration for corporation data mart and data warehouse
• Improved corporation data mart/data warehouse data access and data loading performance with materialized views, proper indexes and parallel processes
• Implemented customer data integration for data warehouse using data hub and Oracle stream replication
• Performed WebFocus 7.6.5 installation, 7.6.7 upgrade, configuration and security integration with Oracle OID
• Improved security with dual security implementation for both internal user and external user accesses

• Installed and configured Oracle 10g AS on Red Hat Linux for Discoverer, Reports, Forms and Portal
• Implemented Oracle OID and Microsoft AD integration with Oracle AS single sign-on
• Deployed j2ee application to Oracle portal as portlets, implemented security for Oracle portal application
• Installed and configured Oracle 9i AS with the infrastructure on HP-UX and the application server on Red Hat Linux, including system planing, pre-configurations, post-installations.
• Helped developers to implement Oracle Portal, Oracle Discoverer and enterprise reporting on Oracle 9iAS.
• Worked as an Oracle database technical lead for Case Management System project. Performed CPU and hard disk capacity planning, database configuration and sizing, logical and physical data modeling, database implementation.
• Configured Oracle Connection Manager and Multithreaded Server to optimize resources and performance for the company intranet. Installed and configured Oracle InterMedia Text to help developers to build intranet search engine.
• Monitored financial reporting system on Oracle using SQL Trace, TKPROF and EXPLAIN PLAN. Improved the system performance by partitioning tables and indexes, eliminating Cartesian joins, reducing full table scans and reorganizing indexes. Established backup strategy and developed the scripts for database hot back to give more database up-time.
• Diagnosed bill review system. Resolved locking conflicts through restructuring database and implementing indexes on foreign key columns. Improved performance by eliminating chained rows, rebuilding indexes and de-fragmentation.
• Installed and configured Oracle database servers, Java VM on UNIX and NT. Applied patches on Oracle databases. Migrated Oracle databases from v7.3.4 to v8.0.6. and from v7.3.4 to v8.1.6. Upgraded v8.0.6 to v8.1.7. Implemented scripts to get database statistical information.
• reviewed SQL scripts, PL/SQL codes, Unix shell scripts for developers to make database operations more efficient.
• Performed WebLogic application server installation, configuration, administration and performance tuning

Confidential

Consultant/Oracle DBA

• Installed and configured Oracle database server software and related products on Unix and Windows NT. Implemented and maintained database security. Performed database tuning and performance monitoring.
• Established and maintained backup and recovery procedures. Wrote shell scripts for hot backup. Implemented database recovery when media crashed/problems occurred. Recovered a dropped table through cloning instead of performing entire database recovery.
• Installed and configured the Oracle Names Server for central management of tnsnames.ora files. Developed scripts for database space management, database object management and performance tuning.
• Diagnosed Invoice system on Oracle with dynamic performance view, SQL Trace and TKPROF. Tuned the system by increasing the number of DBWR processes and free lists. Configured multithreaded server MTS to minimize the server's memory and processing resources.
• Developed shell scripts and NT batch files for data extraction and transfer between servers. Wrote SQL scripts to display all the relationships and constraints between primary keys and foreign keys.
• Reorganized and configured Oracle database for field case management system based on OFA. Implemented triggers with dynamic SQL to avoid sort key too long problem on elimination of duplicated insertion. Improved performance by reducing the number of round trips through the network.
• Participated in design of clinical supplies inventory system CSIS database on Oracle. Designed database architecture and data model using Erwin. Installed and configured Oracle database on NT and UNIX. Wrote SQL scripts and shell scripts for Oracle database implementation, backup and maintenance.
• Designed and developed a chemical process database on Oracle. Participated in the analysis of information requirements. Coded business logic with PL/SQL stored procedures, triggers . Designed reports in SQL PLUS
• Converted prescribing guide system from Clipper to Oracle. Redesigned database structure, migrated data and implemented business rules using SQL LOADER, SQL, PL/SQL for back end and Visual Basic for front end