SUMMARY:

• 20 years of proven experience in Information Technology.
• 15 years of hands-on experience with Oracle Databases, SQL Serveradministration and development.
• Lead Sr. DBA for whole enterprises' databases recent over six years without unplanned down time.
• Oracle, SQL Server, MySQL installations, configurations and administrations.
• Convert and sync databases between Oracle and SQL server.
• Lead Sr. DBA for databases, AS, WebLogic, ERP, EBS, OFSA, and other third parties' applications, for various corporations since 1995.
• Proficient at time, priority management. Provide operations support to resolve issues proactively and with utmost urgency.
• Expert with planning, design, creating, installations, configurations, administrations, patching, migrations, cloning, upgrading, and troubleshooting databases in Productions, QA, UTA, Benchmark Test, development and POC environments.
• Proven experience with ORACLE RDBMSperformance tuning and related OS UNIX, Linux, Windows , Capacity planning, optimize SQL queries and PL/SQL programs, with AWR/ADDM.
• Fine-tuned analytical and troubleshooting on databases servers and clientson all environments, databases, EBS, OFSA, OEMs, Crystal Report, Discoverer, MicroStradegy, Cognos, Informatica.
• Defining and acting on opportunities to increase operational efficiency overall system availability and working closely with development teams.
• Plan, develop, implement, and maintain databases DR procedures including regular backup procedures via RMAN, expdp/exp and others.
• Recommended, providing guidance, configured and implemented Oracle RAC, Oracle Replication DataGuard, Streams, GoldenGate for HA and DR.
• Advised senior management and implemented approved timely detailed action plans for high priority and recommended patches, migration and upgrade.
• Proficient with Administration/Data Architect/Capacity Planning/Data Warehousing/Data Modeling, OLAP OLTP Database Applications Development.
• Prepared Technical Analysis, Capacity Planning, Architecture Upgrade Assessment proposals and plans for Oracle clients to implement Oracle RDBMS and Financials.
• Data Modeling with normalization and star schemas.
• Oracle Financial Application EBS Migrations and upgrade.
• Implemented, Managed databases TDE with PCI compliance. Audit databases accesses and various activities for security and audit compliance.
• Experience with Linux Unix and DOS scripting, automation of monitoring, alert and balancing workload for databases environments.
• Establish, administrate version control in Subversion for databases and applications.
• Excellent presentation, interpersonal, coordination and communication skills, team player, leadership.

EXPERIENCE:

Confidential

Lead Sr. Database Administrator

• Full responsible for Oracle, SQL Server, DB2 i5/OS for WMS, BI systems.
• Timely and fully support and closely work with development and QA Teams.
• Full support for customers' productions, troubleshooting, performance tuning, backup, proactive monitoring.
• Capacity planning, architectural design and benchmark test for systems up on customers' requirements.

Confidential

Lead DBA and PL/SQL developer

• Provide 24/7/365 support to Production environment for whole enterprise's databases around the world.
• Evaluated at A plus performance Rate.
• Eliminated unplanned downtime for all databases, in addition to increase performance and utilized new features.
• Installation, configuration and administration Confidential.

Confidential

Lead DBA

• Provide 24/7 support to Production/Dev/QA environments for Oracle, SQL Server databases onmulti-tier OLTP Web applications, ERP/EBS in RAC, and VL Data Warehouse.
• Upgrade RAC Oracle database from 9i to 10g under UNIX HP-UX and Linux platforms.
• Coordinated with Business and developer teams on upgrading EBS and other apps on RAC configuration and HP Superdome.

Confidential

Sr. Oracle DBA

• Full administration responsibilities for Oracle E-Business Suite and various Oracle Databases with 3rdparties applications, including imaging system for Oracle E-business suite and customized system under Oracle AS and RDBMS.
• Enhance system performance by tuning PL/SQL statements and algorithms, database, and server, improved architectures, troubleshooting and scheduling.
• Design, develop, and implement DR strategy and procedures, with routine Backup and Recovery plan with RMAN scripts.
• Design, develop and administer Data Warehouse Database, plus ETL, BI integration, implementation, optimization and maintenance.
• Deal with various third party vendors on scopes of sales, technical evaluation and support.

Confidential

Sr. Oracle DBA

• Systems Design with Sun, HP, IBM EMC and all these servers and storages Integration Testing.
• Conducted Benchmark tests and Scalability with multi Terabytes database size for major U.S. financial firms in conjunction with IBM, Sun and EMC.
• Build, Clone and Manage POC, Development, UAT/TEST/QC and Production of Confidential Data Warehouse Systems, Oracle Financial Applications version 11i, 11 10.x, and models GL, FA, AP AR , 9iAS and other applications.
• Performance Tuning on Operation Systems, Oracle database servers, Oracle Applications, Data Warehouse multi Terabytes and Applications with OWB 2.0 and 3i on Oracle multinational financial institutions' sites around the world.
• Principal Financial Consultant for various major International Financial Institutions in the United States and overseas.
• Provided mentoring to clients' DBAs in the installation, configuration, upgrade, implementation, performance tuning, etc.

Confidential

Sr. DBA

• Project plan and management for design, development, deployment and maintenance of Banking Information System OLTP with ORACLE RDBMS including logical and physical database design, business function modeling, performance tuning, SQL optimizing,
• PL/SQL stored procedures developing, security managing, Oracle server installation, configuration, patching, upgrading, ETL from Sybase, mainframe, and SAS, coding PL/SQL programs as a project leader and Oracle DBA and developer.
• Designed, developed Banking ISfor QC and Marketing Research with ORACLE, SAS, Excel VBA under Solaris NT environment.
• Provided significant value-addednew features to the IS Quality Improvement.

SKILLS HIGHLIGHT:

• Oracle Products: Oracle 12c/11g/10g/9i/8i/7.x RDBMS, OFSA OFSAA, OFSDW , EBA R12,11i,11 , RAC, DataGuard, GoldenGate, Fusion, AS, WebLogic, ASM, FDM, Express, Developer, Discoverer, OFA, Forms, Reports etc.
• Databases and others: Oracle, SQL server, AS400 DB2, MySQL, Crystal Report, MicroStradegy, Cognos, Informatic, ERwin, Toad, IIS., etc.
• OS: UNIX HP-UX, Solaris, AIX , Linux, Microsoft Windows 8, 7, 2008, Vista, 2003, XP, NT, 98, 3.x , DOS.
• Languages: PL/SQL, UNIX/Linux Shell and DOS Scripts, Java, C , VB, VBA, Perl, SAS, etc.
• Life Cycle: Full project life cycle of enterprise level of database application system design, development, test, deployment, implementation and maintenance.