OBJECTIVES

• Senior Oracle Database Administrator
• Oracle GoldenGate Specialist
• Oracle Exadata DMA (Database Machine Administrator)

TECHNICAL SKILLS

Hardware: Oracle X2/X4 full rack Exadata machine, Sun SPARC T - Series server, Dell/HP X86 64 box

Storage: ASM, Veritas, EMC/Dell SAN, NFS

Operating System: Oracle Solaris 10.X, Oracle Enterprise Linux 5.X, Red Hat/Centos Linux, Windows 20XX, IBM AIX, HP-UX

Language: SQL, PL/SQL, Bash/Korn, Perl, C/C++/VC++, Java, C#

Database: Oracle Database 10g/11gR2/12c, Sybase 15.X, MySQL 5.X

Monitoring: OEM 11g/12c, Spotlight, Tivoli, Zabbix

Data Replication: Oracle GoldenGate 11gR2/12c, Veridata, Streams, Advanced Replication, TIBCO

Tools/Utilities: SQL Plus, SQL Developer, Quest Toad, DBArtisan, RMAN, Log Miner, TKPROF, AWR, ADDM, Data Pump

EXPERIENCE SUMMARY

• More than 11+ years of experience of system and database management and programming languages. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.
• More than 9+ years experiences in Unix-like system administration including Oracle Solaris, Oracle Linux, IBM AIX and HP-UX.
• Proficient in developing management or monitoring scripts by using Korn/Bash Shell and Perl. Can develop automatic monitor framework by using CRON jobs.
• More than 10+ years solid Oracle database administration skills and experiences in high-end telecom and financial enterprise environments (DB size from 2 TB to 60TB) across multiple industries including design, development, implementation, migration, upgrading, maintenance of RAC, ASM, Data Guard, GoldenGate and production support of complex database applications and huge data warehouse system.
• Experience with Oracle 10g/11g/12c new features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo Management, Grid Monitoring and Recycle Bin.
• More than 10 years experiences in PL/SQL, Procedure, Functions, Triggers, Packages development in applications such as Financial, Telecom fields.
• More than 6 years experiences and solid hands-on experiences in installation, configuration, performance tuning and troubleshooting Oracle GoldenGate in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and Sybase/MySQL to Oracle).
• Firsthand experiences in setting up Oracle GoldenGate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions. Extensive skills in upgrading OGG 11gR2 to 12c, configuring OGG in RAC high available environment.
• Primary technical resources to upgrade Oracle GoldenGate from 11g to 12c in Exadata machine environment. Design GoldenGate HA solutions by using Oracle 11.2.0.4 Clusterware functionality.
• Deep understanding Oracle GoldenGate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate. Developed home-cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM (Oracle Enterprise Manager) 12c.
• 3+ years solid hands-on Oracle Exadata X2/X4 full rack machine experiences in administration, migration, health check, resource management, patching, upgrade and SQL tuning and troubleshooting.
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Deep understanding of Exadata hardware architecture including Storage, Grid and InfiniBand and key Exadata features including HCC (Hybrid Columnar Compression), Smart Scan, Smart Flash Cache, Storage Index and Storage Management.
• More than 8 years experiences in support large-scale (up to 8 nodes), mission critical production RAC environment from 9i version to 11gR2 version RAC on deferent platform(including IBM AIX, Red Hat Linux, Sun SPARC Solaris, HP-UX)
• Deep knowledge of Oracle 11g Grid Infrastructure, Clusterware, ASM, RAC internal, Active Data Guard in RAC environment.
• 7+ years’ experience in huge size Oracle data warehouse (more than 30TB) solutions and ETL architecture, development, maintenance, production support, data modeling, reporting fields. Extensive knowledge and experiences on various ETL, reporting, and database development tools such as Informatica, Erwin and Power Design.
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager 12c solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Monitoring the health of a database and ensuring that it performs optimally is an important task for a database administrator with OEM (Oracle Enterprise Manager) 11g/12c, Spotlight, Tivoli and Zabbix.
• 8+ years solid hands-on experiences and outstanding troubleshooting skills to setup, configure, monitor, maintain Oracle 10g/11g/12c RAC/ASM/Data Guard environments.
• Highly skilled in SQL and PL/SQL Tuning, TKProf, Explain Plan. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.
• Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold/hot backup, full/incremental backup.

PROFESSIONAL EXPERIENCES

Confidential, San Diego, CA

Senior Oracle DBA & GoldenGate Specialist

Responsibilities:

• As a senior member of Oracle Advanced Technical support group, provide advanced technical support to enterprise DBA team on Oracle database related technologies such as Exadata, Golden Gate, Streams, RAC, upgrades, migration, Performance Tuning, Backup and Recovery, RMAN, Partitioning, Oracle Enterprise Manager, SQL, PL/SQL, Code review and optimization, Materialized views, Flashback, troubleshooting, Data pump, RDBMS security, VLDB, optimize server resource utilization etc.
• Mainly work on Performance tuning. Working with primary DBAs in the DB support team, support the mission critical OLTP and Data Warehouse production databases. Working as one key member of the technical resources pool to support the Front Line Support On-Call team according emergence requirements and issues.
• Duplicate all the non-production databases on Exadata server according the Data Warehouse development project's requirement. Help compress large volume partition table by using Oracle HCC (Hybrid Columnar Compression) techniques.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Primary technical resources in SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments (Front-end: Sun SPARC Server, Back-end: Oracle Exadata Full Rack).
• Upgrade Oracle GoldenGate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
• Participating in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Maintenance of production database and development database which includes table space management, user creation, and privileges, roles. Support RMAN backup and recovery including physical backups and logical backups by using data pump(Export/Import) tool. Extensively develop and maintain Korn shell and Perl scripts.
• Worked on Sev1, Sev2 issues and also providing 24x7 On-Call Support and provided on-call and day-to-day support.

Confidential, West Des Moines, IA

Senior Oracle DBA & GoldenGate Administrator

Responsibilities:

• Manage all aspects of the OGG design, implement and support in development, UAT and production environments. Identify and resolve OGG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning).
• Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments (Front-end: Sun SPARC Server, Back-end: Oracle Exadata Full Rack).
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abend by using GGSCI / Log dump / discard file analysis etc.
• Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from MySQL/Sybase to Oracle Exadata).
• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 12c
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• Installed, configured and maintained Oracle 11g Real Application Cluster (RAC) / ASM on Oracle Enterprise Linux 5.X boxes.
• Application DBA specialist for a large number of tuning projects. Working with third party developers on SQL code review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, Statspack, OEM Performance Manager and home-cooked scripts by using Korn shell/Perl.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Develop and record certified processes or procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.

Confidential, Dublin, OH

Senior Oracle Consultant

Responsibilities:

• Perform CORE DBA tasks such as Database Administration on Oracle 9i, 10g and 11g environments, performance tuning, Schema creation, maintenance, and troubleshooting.
• Architecting, planning, designing, developing, deploying and supporting Oracle 10g/11g R2 RAC/ASM environment.
• Installing & configuring Oracle 10g/11g Clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of Clusterware).
• Worked with customer for different RAC related issue: hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on. Troubleshoot performance issues for the RAC instances (GC events).
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle Clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking and flash recovery area.
• Maintain Oracle SQL and PL/SQL scripts, Unix Shell Scripts, debugging and tuning. Implement Production Control and Change Management.
• Provide expertise and make recommendations for physical database design, architecture, testing, performance tuning, and implementation of Oracle database.
• Handle daily database operation performance issues (track and trend overall database performance and database area, index, and drive performance). Recommending application code changes (processing strategies, queries, use of Oracle10g/11g new features).
• Plan and Design Backup/Recovery solutions using shell scripts and RMAN. Ensure that the database software infrastructure is in place and up to date to support other infrastructure components (e.g., operating system and hardware) and application development.

Confidential

Technical Consultant

Responsibilities:

• Provide POC (proof of concept) and finial technical solutions based on Oracle's flagship database servers according to customer's requirements.
• Analyze technical fit of Oracle's products and professional services against prospects requirements.
• Configured and installed Oracle database production in different complex customer's environments. Provide initial technical assistance to customers and prospects, and coordinate customer technical staff and Oracle's resources.
• Training customers about Oracle's products and in charge of POC(Proof of Concepts) based on customer's requirements.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application. Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.
• Installed Oracle database, and applied Patches and DB migrating. Monitoring, Tuning and optimizing the performance of the database.
• Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
• Onsite hands-on performance tuning and trouble-shooting with Oracle database team and application vendors for Oracle's important customers.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Provide technical presentation about application server technology during Oracle's marketing road show campaign.
• Provided application 7x24 technical support for high availability system via on-call and troubleshooting. Responsible for production application maintenance involving enhancements and performance improvements.