SUMMARY:

• Over 15 years as Database Infrastructure Architect, Administrator, and DBA Mentor. Oracle Certified Master, Subject Matter Expert in Performance Tuning, Exadata and RAC implementation. Lead Engineer in establishing database standard, automating installation and setup, implementing monitoring and patching, Key DB resource for projects from massive OLTP (6M daily transactions) to Huge Data Warehouse (10TB) and complex ERP systems (Oracle Financials, SAP, SIBEL, PEGA). Integrate Oracle standalone and RAC implementation on Cloud (Rackspace) wif fully automated solution. Additionally, I is well versed in various tools and familiar wif Oracle advanced options.

TECHNICAL SKILLS:

RDBMS: Oracle, DB2, SQL Server, MySQL

Adv Ops: RAC, Data Guard, ASO, GlodenGate, Partitioning, VPD, Exadata, OEM, OID

ERP: Oracle Financials, SAP, SIEBEL, OBIEE, PEGA, Centrify

OS: Unix (Solaris, HPUX, AIX), Linux (Redhat, Suse), Windows, VMWare/ESXi, Cloud (Rackspace)

Languages: PL/SQL, Shell Scripts, Java, Perl, T - SQL, C/C++, C#.NET, Salt, Python

Others: APEX, OWB, ERWin, DTS, NetBackup, Tivoli, TSM, CommVault, DD Boost

PROFESSIONAL EXPERIENCE:

Sr. DB Infrastructure Architect/DBA

Confidential

Environment: - Oracle 12c/11g/10g/9i RAC, Linux(Redhat/Suse)/UNIX(AIX/HPUX/Solaris)/VM/Cloud (Rackspace)Oracle RDBMS - Infrastructure Architecture Design, Setup, Implementation, Monitoring and Patching Maintanance

Responsibilities:

• Establish TD Oracle DB (12c/11g/10g) standard wif IDS (Infrastructure Design Specification) Document
• Certify Oracle DB (12c/11g/10g) Setups in TD on basic and advanced features, e.g. Multi-tenant, ASO, ADG
• Integrate Oracle DB implementation wif TD standard, e.g. Tivoli Monitoring, TSM/CommVault/DDBoost Tape Backup, AutoSYS scheduling, Centrify Security
• Fully automate Oracle DB (Standalone and RAC) build process including installation, patching, backup, Data Guard)
• Develop Oracle (Standalone and RAC) blueprint on Cloud (Rackspace) wif Cinder and iSCSI storage
• Work wif Oracle ACS engineer on 2 Projects wif Exadata Deployment at BDC and SOC data center
• Design and implement OEM Cloud/Grid Control wif HA and DR capability
• Design and implement TD Oracle Shared Glod Infrastructure
• Setup APEX environment and develop utilities using APEX to halp DBA team to keep track project status, secure password sharing, etc.
• Deploy applications into Oracle RAC infrastructure wif SOA (Service Oriented Architecture) design.
• Core Solution DB Engineer responsible for Oracle detail design on all TD LOB IT projects
• Technical Escalation point for all Oracle related issues from build, deploy to performance tuning on production DB.
• Primary DBA on many high priority, high visibility, high complexity, high volume, high demanding projects.
• BBP (Business Banking Program) project which consists of 5 phases, multiple development streams, 4 database components (Siebel, FC, TAG, ECD) and more TEMPthan 100 environments and huge production databases (3TB)
• AIM, a.k.a. Diamond (Digital Identity Access Management on Demand) project for a core enterprise security management system
• Compliance Surveillance Project to address significant issues identified by TDW Wealth Compliance wif teh current manual surveillance process for teh Wealth Brokerage businesses - Discount Brokerage, Private Investment Advice, Financial Planning and Institutional Services.
• STARS (Strategic Trading Analytic Reporting System), teh system wif high CPU usage, huge I/O throughput, faster response requirement.
• DCC (Data Center Consolidation) project.
• Migrate and upgrade CapStone Adjudication database (600G in Production) from Oracle 9i on AIX to Oracle 11gR2 on Linux wif 2 hour down time requirement using Gloden Gate
• PEGA implementations, ESAS(FileNet), PeopleSoft GL database and Oracle Financials AP database, Atlas, Capstone, LRM/TAC, Audit, RPM, LCMROAD, AIS, CDM, TAG, CMPL, ERPro, TradeO, CESMS, RAA etc.
• IT Optimization - Oracle Grid Project for Oracle 10g RAC

Oracle Application DBA

Confidential

Environment: - Oracle Financials 11i, Oracle 9i/10g, Solaris 5.8, Windows 2000, ERWing, OWB, OWF, Forms/ReportsOracle RDBMS - Infrastructure Architect, Setup, Patching, Performance Tuning, Change Management, Data Modeling

Responsibilities:

• Working on huge project (FSRP/SIRIS) on Oracle Financials 11i (11.5.8) implementation, e.g. setup, maintenance, patching, and trouble-shooting.
• Explore and provide various technical solutions on RAC, Data Guard and roadmap to 10g
• Architect, design and implement data warehouse wif target size over 3TB
• Data Modeling and Architecture wif ALLFUSION (ERWin)
• Performance Tuning on expensive queries using hints, indexes, materialized views and other techniques
• Customization code promotion and change management.
• Capacity planning and cost saving through server consolidation and data archival techniques
• Self developed monitoring system, together wif BMC Patrol, provides proactive measurement through tables and charts presented via HTML DB
• Develop and implement Oracle VPD on data warehouse to meet business requirement on fine grained security control.
• Implement sophisticated audit mechanism on DB objects, sensitive data, and application roles and responsibilities.
• Streamline Oracle Financials environment cloning process and Disaster Recovery process.
• Design and implement database high availability option using Oracle data guard.

Database Architect

Confidential

Environment: - Oracle 8i/9i/10g, SQL Server 2000, MySQL, DB2 UDB, Linux Redhat, Solaris 5.8, AIX, Windows 2000Database Infrastructure Design and Application Development Integration

Responsibilities:

• Re-architect and implement teh infrastructure for various databases (Oracle, SQL Server, DB2, and My SQL)
• Provide database solutions to simplify teh complexity of WEB based applications.

Sr. Oracle DBA

Confidential

Responsibilities:

• Architect Oracle database infrastructure, e.g. hardware selection, OS configuration, disk array arrangement etc
• Install databases for development, testing, system integration and production environments.
• Provide database physical design based on development logical design.
• Promote changes from development to system integration and QA environment and eventually implement on hospital production database. Changes include object creation (table, view, index, trigger and stored procedure) and alternation.
• Perform database upgrade from Oracle8/Orcle8i to Oracle9i
• Provide 7X24 database technical support.
• Monitor database activities using Oracle Enterprise Manager (OEM) and self developed scripts
• Develop comprehensive database backup strategies using Oracle online backup, RMAN, Export Utility.
• Document and test database recovery scenarios
• Fix production data corruption / problem
• Troubleshooting database related issues
• Collect application / database statistics information using SQL Trace / TKPROF / PERFSTAT
• Tune database performance from hardware, disk storage, memory, to database physical layout, SQL queries, etc.
• Prepare and conduct technical for others DBAs / Developers
• Collect business requirement for Baxter Patient Care system (BPCS) to handle hospital patient enrollment, physician order, pharmacy medication preparation, and nurse bedside administration.
• Design table structure to connect wif other hospital systems using HL7 standard and XML to exchange information on lab results and billing data.
• Maintaining BPCS data model / ER Diagram using tools e.g. ALLFUSION (ERWin), Oracle Designer
• Construct many data intensive business logic wif Oracle PL/SQL language.
• Provide scripts to handle data conversion / migration
• Planned and tested application / database upgrade from release to release.
• Manage source code / database changes using VSS and RUP
• Develop data access layer using C#.NET and ADO.NET
• Design data warehouse database to store historical for reporting purpose
• Implement data warehouse / data mart concepts using ETL(Extract/Transform/Load) techniques
• Tune specific slowness area via systematic method e.g. identify, SQL trace, analysis, re-engineering
• Configure partitioned table for performance benefit

Sr. Oracle Architect

Confidential

Environment: - Oracle Financials 11i, Oracle 9i, Solaris 5.8, Windows 2000Oracle RDBMS - Architecture Design, Installation, Setup, Creation and Support

Responsibilities:

• Setup and install Oracle database enterprise edition 8.1.7 on Sun Solaris E65000 server
• Configure standby database for database emergency
• Monitor database activities on 7X24
• Install Oracle Application 11i (Financials) GL/AR/AP/PO/FA/CM modules on multiple environments, e.g. development, testing and production.
• Setup Oracle Financials database which TEMPhas more TEMPthan 10,000 objects in multiple schemas for each implementation.
• Implement table partitioning on production database for GL module.
• Clone Oracle Applications environments from Production to QA for testing purpose
• Apply patches for Oracle Financials various modules and database.
• Tune database performance using PERFSTAT
• Troubleshoot Oracle Applications setups, user problems, etc.
• Develop and implement database backup / recovery strategy using RMAN.

Sr. Oracle DBA / ERP (SAP) Consultant

Confidential

Environment: - SAP 3.0E/4.5B (R/3), Oracle 8i, Solaris E10K, IBM AIX R6000Database Administration - Collect information, Research and Development and Planning

Responsibilities:

• Architecture design and evaluation on database new platform implementation
• Upgrade SAP from SAP 3.0E (on IBM AIX) to SAP 4.5B (on Sun Solaris E10K)
• Evaluate and demonstrate teh upgrade technique on this 600G database wif 1,000+ concurrent users
• Perform pre-upgrade research and tasks, e.g. database object categorize, DDL extraction, Referential constraint analysis.
• Provide detail plan on teh upgrade
• Test and document teh upgrade process step by step
• Conduct teh actual system / database upgrade using Import/Export to transfer database across platform
• Monitor teh database activity on alert log file, dump directory, etc.
• Identify hot spot, high resource usage SQL statements and performance slowness area
• Tune performance at various levels e.g. hardware, disk allocation, physical layout, memory hit ratio, etc.
• Configure table partitioning on GL single table which is about 25G in data and 20G in index.
• Setup database online backups using SAP DBA
• Setup database monitoring parameters based on thresholds e.g. space usage, memory hit ratio, etc.

Sr. Oracle DBA / Data Warehouse Consultant

Confidential, Chicago, IL

Environment: - Oracle EE 8, Solaris E5500Operation Database (OLTP) - Administration, Maintenance and Performance Tuning

Responsibilities:

• Support Oracle database wif 200G in size and 2G SGA running on a 12 CPUs and 4G physical RAM Sun Solaris E6500 environment.
• Tune teh database to handle 6 million records daily hit on single table and 600 insertions per second during peak hour.
• Configure table partitioning on detail transaction table to have range partition setup based on transaction date time.
• Perform database online backup at table space level and interface wif Tapes (NetBackup).
• Design Data warehouse using star schema method and identify fact tables and various dimensions.
• Construct PL/SQL, SQL and Shell scripts to extract data from OLTP production database, transform and load into data warehouse database wif SQL*Loader
• Tune teh extraction SQL queries to minimize teh impact on OLTP database and eliminate snapshot too old error
• Configure database table space in teh way to minimize teh backup effort and provide better space usage.