SUMMARY

TECHNICAL SUMMARY

Highly-skilled Senior Oracle DBA and solutions-oriented professional with more than ten years of experience in positions of progressively increasing responsibility, planning and leading the deployment and support of enterprise wide databases.

• Experienced in all facets of project life cycle, from initial business identification requirements and project scoping through design, development, process change review, implementation, testing, training and support.
• Organized, take-charge professional with exceptional follow-through abilities and detail orientation; able to plan and oversee projects from conception to successful conclusions.
• Analytical problem solver; ability to identify complex technical problems in initial stages and execute quick resolutions. Proven ability to develop and implement databases solutions and tools to enhance business needs.
• Skilled trainer, mentor, and project leader; able to communicate effectively with management, vendors, customers and team members at all skill levels.
• Excellent track record in managing large-scale, highly available ERP databases with 24x7 global operations.

Platforms
Windows HP-UX
Sun Solaris Linux

Database
Oracle 7-11g SQL Server

Programming
Shell Java
PL/SQL SQL

Storage
SAN NAS

Software & Tools
Grid Control/OEM RMAN
AWR/Statspack Data Pump
Data Guard RAC
SQL*Loader ASM
Quest Central Brtools
Veritas NetBackup SQL*plus

ERP Systems
JD Edwards SAP SR3
Siebel

PROFESSIONAL EXPERIENCE

Confidential, NJ (March 2010-Present)

• Support mission-critical trading and financial databases, ranging from 9i to 11g running on Linux and Solaris, as a member of the global production support team.
• Provide performance analysis and tuning for various databases and applications with a wide range of technologies, including Oracle Wait Event Interface, AWR, ADDM, ASH, Statspack, SQL Plan Management, PL/SQL Profiler, SQL Trace, and Extended Trace facilities (event 10046 and 10053).
• Implement and support various high availability and disaster recovery solutions with RMAN, Data Guard, Export/Import, Data Pump, Transportable Tablespaces, Flashback, RAC, ASM, etc.
• Work closely with application developers to provide consultancy and knowledge transfer to on Oracle database architecture, schema and query design for performance, as well as troubleshooting.
• Assume the lead DBA role for Credit business area to manage the technical aspects of database obsolescence, consolidation, DB server efficiency improvement, and compliance projects.

Confidential, NJ (February 2002-March 2010)
Senior Oracle Database Administrator – SAP (2008-2010)

• As a member of the SAP Center of Excellence, supported the SAP Oracle databases for Johnson & Johnson consumer sector (Johnson’s Baby Care, Neutrogena, Listerine, Aveeno, etc.).
• Managed 36 highly active SAP Oracle 10g and 9i instances, ranging from a couple hundred of gigabytes to over four terabytes.
• Performed database support for complex and critical issues as well as routine monitoring, maintenance, SOX compliance, performance tuning, database cloning, backup and recovery, DR testing, capacity planning, upgrade and patching activities.
• Worked closely with SAP basis team and functional teams to maintain and upgrade the environment.
• Researched new technology and features in Oracle. Adopt best practices in the industry to database management.
• Designed and led the database compliance and server capacity dashboard project, working closely with Informatica and Cognos developers to design and develop data model, stored procedure, shell scripts, ETL jobs and front-end reports with drill-down capability.

Senior Oracle Database Administrator - Siebel (2006-2008)

• Managed 14 Siebel databases while supporting a large development team to implement a multi-year, multi-phase, 40-million-dollar project to consolidate various systems in regional offices into one enterprise-level system.
• Performed installation, upgrade, backup, recovery, refreshes, performance tuning, and capacity planning tasks for stand-alone and clustered databases.
• Implemented and tested high availability and disaster recovery strategies in conjunction with infrastructure and application support teams.

Senior Oracle Database Administrator - JDE (2002-2006)

• Set up development, QA and production database environments for JD Edwards ERP system, including binary installation, database instance creation, backup/recovery strategy, hardware and database sizing requirements.
• Installed, configured, and upgraded Oracle Server 8.1.7.X-10.2.X on HP-UX, Sun Solaris and Windows platform.
• Created migration plans and migrated existing databases into Unix and Windows operating systems.
• Created and monitored master-to-slave snapshot replications using Oracle’s built-in replication functions to multiple snapshot sites.
• Monitored and analyzed database and server performance of JD Edwards database instances, including transactional analysis, benchmarking, performance analysis and SQL tuning.
• Designed and deployed backup strategy consisting of export, hot/cold backup, and incremental backup to disk or tape using RMAN in conjunction with Veritas NetBackup.
• Strengthened High Availability solutions of database systems using physical Data Guard and Veritas Cluster ServiceGuard. Tested failovers and switchovers.
• Authored backup and recovery plan for the JD Edwards databases, detailing backup method, schedules, and step-by-step recovery procedures of over 16 media failure scenarios.
• Tested various scenario of database recovery using lab databases on UNIX and Windows servers.
• Provided database system security plan guidelines and implement auditing, password, and access role management schemes.
• Wrote custom shell scripts to perform backup, environment refresh, and monitor database events.
• Implemented Oracle Internet Directory to find net service names globally.
• Installed, configured, and administered JD Edwards Content Manager module consisting of SQL Server 2000, WebSphere and SequeLink.

EDUCATION & TRAINING

• M.S. Information Technology