SUMMARY:

• Progressive IT professional over 9+ years of IT experience; A highly motivated professional with an aptitude for innovation and creative problem solving. Communicative and personable. Proven ability to solve a wide variety of software and business issues. Excellent analytical, organizational, multi - tasking skills. Operate well independently or within a team. Looking for a challenge and love creative solutions to complex problems.
• A senior Oracle DBA of 9+ years solid experience in both Oracle physical and application side with hands-on experiences in Oracle (12c, 11gR2, 10gR2, 9i), installation, upgrade, design, backup, recovery, performance tuning and migration on various platforms in production and development environment. Skilled in designing and preparing databases configurations for complex and resource intensive applications.
• More than 10 years administration expertise in different operating systems including Sun Solaris, HP UNIX, AIX, Linux, and Windows. Proficient in developing management / monitoring scripts by using Korn/Bash Shell and Perl. Proficient in developing management / monitoring scripts by using UNIX shell scripting and Perl.
• 5+ years solid experience in setup, installation, configuration, maintenance, performance tuning and troubleshooting Oracle 10g/11g RAC / ASM / Data Guard high availability in OLTP & Warehouse (Exadata) environments.
• 5+ years solid hands-on experiences in Installation / Configuration / Performance Tuning / Troubleshooting Oracle GoldenGate (OGG) in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and MS SQL Server to Oracle).
• Deep understanding Oracle Goldengate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicat.
• . 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.

PROFESSIONAL EXPERIENCE:

Senior Oracle DBA & Goldengate Specialist

Confidential, Irving, TX

• Working as a DBA in the Database Support Team to support (daily On-Call rotation) production and non-production environments.
• Oracle Database Administration 10gR2, 11gR2 and 12c on Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control on both Exadata machine, Linux X64 server and IBM PowerPC p770, including very large databases more than 50 TB.
• Install the Oracle GoldenGate (OGG) software to implement one-way/two-way data replicate process, enable DML/DDL data replicate, setup the heart-beat table to monitor OGG replicate lag and provide real-time lag report.
• Implementing High Availability Oracle Golden Gate (OGG) from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11gR2 RAC 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.
• Upgrading and migrating the database to different version depending on Business requirements. (For Example 10g R2 to 11gR1, 11gR2 to 10gR2 on different OS). Applying CPU, PSU and other patches per Citi audit/compliance requirements.
• 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.
• 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.
• 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.
• Migrated Oracle databases to ORaaS cloud.
• Carried out Disaster Recovery tests using DataGuard and flashback
• Set up Autosys jobs using jil for database backup and monitoring.
• Created centralized db server standard build documents and backup standardization scripts and documents for the DBA teams.
• Designing the production system monitoring framework, Configuring/Tuning Oracle Enterprise Management 12c/13c (OEM), developing and maintaining the Korn shell based home-cooked monitoring scripts to monitor database instance status, tablespace usage, goldengate process running status, J2EE/Weblogic server status, etc.
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export /Import utilities and SQL*Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.

Senior Oracle DBA,

Confidential, South San Francisco, CA

• Provided 24 x 7 production support for Oracle databases. Responsible for 47 production and 64 non-production instances on various Linux and IBM AIX platforms located in different data centers in the U.S.
• Installed/Set up/Supported/Upgraded database servers on Unix/Linux/Windows platforms.
• Built and supported RAC databases on Linux platform with crs 11gR2 using ASM.
• Applied CRS patches, ASM patches and database patches.
• Cloned RAC databases to single node databases in test and development environment.
• Implemented online and cold backups with RMAN. Created backup policies and monitored/optimized their performance.
• Worked closely with Unix SA to set up High Availability and Disaster Recovery procedures for production servers.
• Wrote UNIX shell scripts on cron jobs to automate DBA daily tasks such as monitoring database size, alert log, and daily backups, rebuilding indexes, cleaning-up obsolete export files, archives, and so on.
• Implemented and tested failover process using Veritus Cluster (VCS) for company website databases.
• Worked in a Team, handling more than 15 clients for Production support & working in day to day maintenance of development and QA databases.
• Excellent knowledge of oracle 10g &; 11g architecture and administration, good understanding of new features.
• Tuned Database (Tuning of Shared Pool, Buffer Cache, Redo Buffers, and Rollback Segments)
• Lead Oracle DBA Team for maintenance and Operational Support of Oracle Databases.
• Troubleshooted and diagnosed Oracle (ASM) databases and application Issues. Configure Database for Optimum performance on Sun Solaris.
• Cloned Oracle database through RMAN Duplicates. Maintaining the Oracle Backup and recoveries through RMAN.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Upgraded Oracle databases from 10g to 11gR2, and migrated the platform from HP to AIX 6.1, from AIX to Linux.
• Responsible for setup and implementation of 2 Node RAC on IBM-AIX in 10g & 11g R2 using Veritas Cluster Server.
• Set up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments
• Documented the entire core procedures required for the oracle database maintenance.
• Created Materialized Views/Snapshots for replications and increase query performance.
• Refreshed PROD, DEV, UAT databases using Data pump, RMAN, Transportable Tablespaces etc.
• Developed Shell Scripts and SQL scripts to carry out routine checks on databases and perform various tasks on the database.

Oracle DBA and Oracle Developer

Confidential, Addition, TX

• Provided emergency 7x24 support and problem solutions
• Created, administered and maintained Oracle 9i/10g databases
• Upgraded the Oracle 10g to the latest Release 2 and applied patches as required.
• Provided full life cycle DBA support for development and test team
• Installed, configured, patched and maintained Oracle database in Redhat Linux X64 boxes.
• Oracle database backup and recovery by using command line, RMAN
• Oracle database and SQL performance and tuning (trace file, statspack)
• Identified Database bottleneck proactively and resolved the potential issues
• Managed high volume transactional table and index (reorganization and rebuild as needed)
• Built and tested SQL and PL/SQL code in SQLPLUS, SQL Developer
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Involved in Code Reviews and preparing Unit test cases.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards besides reviewing the code.
• Primarily supported Oracle RAC databases for critical bank applications such as Trims NA, EMEA, WL CBA, Open Collateral, FMS TGAnet, performance tuning, COB tests, troubleshooting, and upgrade, etc.
• Setup, maintained, and failed over Physical Standby database for data protection and disaster recovery.
• Tested disaster recovery strategy with dataguard switchover and flashback methods.
• Used OEM Grid, SQLTrace, AWR, ADDM, ASH, EXPLAIN PLAN, SPM and various SQL scripts to monitor database performance and identify problematic SQL statements.
• Designed and implemented RMAN and NetBackup strategy to prevent data loss.