Description
PROFESSIONAL SUMMARY * Oracle Certified Professional (DBA track) & Oracle Certified GoldenGate Implementation specialist with 15+ years in IT industry. * Over 15 years complex query developing and tuning with EXPLAIN PLAN, TKPROF, SQL Advisor, AWR/ASH, SPM and other tuning tools. Design Leading team in implementing 11g RAC and ASM in VLDB OLTP environment. * Admin and develop EBS (11i and 12i). * Extensively worked on RAC/ASM setup, configuration, maintenance, patching and upgrades. * Support production, development and test environment, support developers and lead various database projects, including loading and moving data, coding in PL/SQL, design and implementing ETL processes. * Work with architecture and develop team for database related application designs and implementation. * Install, configure and administer OEM and perform query tuning for various development teams. and implemented core code and functions in loan processing application using PL/SQL and embedded Java. * Design and implemented loading and process XML functionality for major customer applications. Design and implementing ETL processes. * Designed and implemented core functions in investment applications for clients. * Oracle database admin routines and query tuning. Successfully converted Informix databases into Oracle databases. Designed, implemented and administered enterprise wide oracle/Informix databases. * Implemented various oracle advanced and streams replications. * Effectively managed full Oracle database development cycle from release to release, including requirements gathering and analysis, design, code, prototyping, testing, delivery and post release support. * Conducted post release analysis for process improvement. * Created system and database performance guidelines after each release. * Design and implement effective space control and disaster recovery strategy from release to release. * Proactive monitor and tune client system and database for better performance. * Successfully upgraded and migrated Oracle databases from release to release. * Make constructive proposals for system and database performance tuning. * Significantly reduced client production database downtime and crashes. * Mentored junior DBAs to become more productive in handling DBA routines. * Actively involved in hardware and software selection and purchase. * Actively involved in architecture and box reviews from release to release. * Created and posted on internal web site well-accepted practical performance guidelines for SQL Plus and PL/SQL developers/programmers. * Support more than 100 developers with all kinds of Oracle database issues. * Successfully re-architecture databases into one central database with three branch databases. * Effectively applied Oracle advanced replication strategy for three data marts. Develop ETL (extract-transfer-load) tools with UNIX shell and PL/SQL. * Implemented effective backup and recovery strategy for company wide Oracle databases. * Support development teams with database installation and configuration and with expertise on SQL and PL/SQL coding guidelines database testing methodology and performance tuning issues. * Proactively monitor and troubleshoot system and database issues in a timely manner. *
Accomplishments
Highlights:
Job Skills
Keywords
