SUMMARY:

• Highly motivated, quick learner with over 15 years experiences working in the IT industry specializing in Oracle database, Oracle RAC, Exadata machine and Oracle GoldenGate administration and development. Proven ability to solve a wide variety of software and business issues. Excellent analytical, organizational, multi - tasking, planning and problem solving skills. Operate well independently or within a team. Eager to increase my knowledge and add to my technical skill set. Deal well under pressure and with rigorous deadlines. Looking for a challenge and love creative solutions to complex problems
• A Senior Oracle DBA offering 15+ years of progressive experience, specializing in high-volume, high-visibility production and development environments. Skilled in designing and preparing databases configurations for complex and resource intensive applications, especially in database and unix-like platform system administrator such as Oracle Exadata /Linux / IBM AIX / HP-UX / Oracle(Sun) Solaris / BSD.
• Solid experiences in Oracle database administration, including design, development, implementation, migration, upgrading, maintenance and production support of complex database applications and huge data warehouse system.
• 6+ years solid hands-on experiences in Installation / Configuration / Performance Tuning / Trouble shooting Oracle GoldenGate (OGG) in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and MS SQL Server to Oracle).
• Four years experiences in Oracle Exadata database machine administration, patching, upgrading, performance tuning and trouble-shooting
• First hands 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.
• Deep understanding Oracle Goldengate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicat. Developed home-cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM (Oracle Enterprise Manager) 12c.
• First hands-on skills about Exadata hardware architecture including Storage, Grid and Infiniband. Deep understanding of key Exadata features including HCC (Hybrid Columnar Compression), Smart Scan, Smart Flash Cache, Storage Index and Storage Management.
• Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full / incremental backup.
• Strong experiences with monitoring, troubleshooting, and resolving database issues in 24x7 production environment.
• 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.
• Six years solid hands-on experiences and outstanding troubleshooting skills to Setup / Configure / Monitor / Maintain Oracle 10g/11g RAC / ASM / Data Guard environments.
• Experience with Oracle 10g/11g new features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo Management, Grid Monitoring and Recycle Bin.
• Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

TECHNICAL SKILLS:

DATABASE: Oracle 10g/11g/12c, Microsoft SQL Server 2008/2012, MySQL 5.x

LANGUAGE: SQL, PL/SQL Perl, Korn/Bash Shell, Java, C/C++

PLATFORM: Oracle Exadata X2/X3/X4/X5 Full Rack, Redhat Linux, IBM AIX, HP-UX, Oracle Solaris, FreeBSD and Windows

DATA REPLICATION: Oracle GoldenGate

MONITORING: Oracle OEM 12c, Zabbix

TOOLS: SQL/Plus, Toad, SQL Developer, DBArtisanStrengths

PROFESSIONAL EXPERIENCE:

Confidential, Chevy Chase, MD

Senior Oracle Exadata DBA and GoldenGate Administrator

• 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.
• Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments (Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack).
• Upgrade Oracle GoldenGate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.
• Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from MS SQL Server 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 Redhat Enterprise Linux 6.x boxes.
• Application DBA leader 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, OEM Performance Manager and home-cooked scripts by using Korn shell/Perl.
• Duplicate all the non-production databases on Exadata server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using Oracle HCC (Hybrid Columnar Compression) techniques.
• 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.
• 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/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.
• 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
• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM, statspack/tkprof tools
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• 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).
• Implemented 11g DataGuard Physical using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Analyze data model in the existing databases and validate compatibility with Oracle GoldenGate (OGG) replicated environment, use OGG to setup the replicated implementation from MS SQL Server to Oracle 11g.
• 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 & also flash recovery area.

Confidential, Pontiac, MI

Oracle DBA

• Part of the Data Architecture team which supports development, test and production databases.
• Implementation and support of 9i and 10g migrations and upgraded from Oracle 9i to Oracle 10g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux.
• Administering and setting up of 10g RAC and clusterware and instances. Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Generated Statspack/AWR reports using OEM from Oracle 10g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace and database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.

Confidential

Oracle PL/SQL Developer

• Designed/Developed/Modified database objects like Tables, Indexes, Views, Materialized Views, Stored Procedures, Functions, Packages and Triggers.
• Worked on various tables to create indexes to improve query performance. Also worked on partitioning large Tables using Range/List/Hash Partitioning, creating Index Organized Table (IOT), Cluster Tables.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Converted Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements
• Used hash/nested loop/merge joins, indexes effectively in where clauses for Query optimization