SUMMARY:

• Highly motivated, quick learner with over 8 years experiences working in the IT industry specializing in Oracle database, Oracle RAC, 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 8+ 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.
• More than 8 years experiences in Information Technology industry, especially in database and unix-like platform system administrator such as Linux / IBM AIX / HP-UX / Oracle(Sun) Solaris / BSD.
• More than 8 years experiences in Oracle database administration, including design, development, implementation, migration, upgrading, maintenance and production support of complex database applications and huge data warehouse system.
• 4+ 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).
• 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.
• Practical experiences with Oracle GoldenGate related products such as OGG with Adapter, Veridata.
• Deep understanding of 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.

STRENGTHS:

• 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, MySQL 5.x, MS SQL Server 2008

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

PLATFORM: Oracle Linux, Redhat Linux, IBM AIX, HP-UX, Oracle Solaris, FreeBSD and Windows

DATA REPLICATION: Oracle GoldenGate

MIDDLEWARE: Oracle Weblogic Server, IBM Websphere

MONITORING: Oracle OEM 12c

TOOLS: SQL/Plus, Toad, SQL Developer, SQL Management Studio

EXPERIENCES:

Confidential, West Des Moines, IA

GoldenGate Architect and Senior Oracle DBA

Responsibilities:

• Designed and implemented High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments.
• Designed and implemented High Availability Oracle GoldenGate systems on MS SQL Server cluster and Oracle 11gR2 RAC heterogeneous environments.
• Designed and implemented High Availability Oracle GoldenGate with Java Adapter to deliver changes from SQL Server/Oracle database to Java Message Service (JMS) provider (Oracle Weblogic, IBM Websphere).
• Designed and implemented High Availability Oracle GoldenGate with Java Adapter to capture change from JMS provider and deliver to relational databases.
• Implemented zero downtime migration from Sybase to Oracle and SQL Server to Oracle using Oracle GoldenGate.
• Implemented zero downtime upgrading from Oracle 11gR2 to Oracle 12c using GoldenGate.
• Upgraded Oracle GoldenGate from 11gR2 to 12c. Implemented 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.
• Configured OGG for data manipulation to meet business requirements. Used varied methods including SQLEXEC and UserExit.
• Monitored and fully analyzed 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/12c 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.

Confidential, Bensenville, IL

Senior Oracle DBA and GoldenGate Specialist

Responsibilities:

• Performed CORE DBA tasks such as Database Administration on Oracle 10g and 11g environments, performance tuning, Schema creation, maintenance, and troubleshooting.
• Architected, planed, designed, developed, deployed and supported Oracle 10g/11g R2 RAC/ASM environment
• Monitored and fully analyzed 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.
• Installed & configured 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 Data Guard, experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby. Experienced with troubleshooting Data Guard related issues like log apply lag.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & 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.
• Analyzed data model in the existing databases and validate compatibility with Oracle GoldenGate (OGG) replicated environment, used OGG to setup the replicated implementation from MS SQL Server to Oracle 11g.
• Implemented GoldenGate High Availability set up of Oracle RAC environment from OLTP to OLAP system.
• Involved in Active-Active GoldenGate High Availability implementation of two Oracle RAC environment.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Installed Oracle database, and applied Patches and DB migrating. Monitoring, Tuning and optimizing the performance of the database.
• Tuned databases by adjusting increasing sort area sizes, shared pool area, prioritizing oracle processes and increasing SGA overall.
• Planned and implemented a comprehensive Oracle backup & recovery strategy. Set up and maintained oracle disaster recovery site using DataGuard.
• Writing and tuning SQL and PL/SQL creating stored procedures, functions, Packages and DB triggers. Using IMPORT, EXPORT and SQL Loader utilities for dumping and reloading into different schemas.
• Provided application 7x24 technical support for high availability system via on-call and troubleshooting. Responsible for production application maintenance involving enhancements and performance improvements.
• 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, Weehawken, NJ

Oracle PL/SQL Developer and DBA

Responsibilities:

• Designed, and developed Oracle PL/SQL ETL processes for loading data from internal systems using SQL Loader and External tables.
• Extracted data from different databases and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Designed, developed and maintained oracle database schemas, tables, standard views, materialized views, synonyms, unique/non unique indexes, constraints, triggers, sequences, implicit/explicit cursors, cursor for loops, reference cursors and other database objects.
• Created PL/SQL packages, standalone procedures, and standalone functions. Wrote complex SQL queries with sub-queries, analytical functions and inline views
• Performance tuning and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.
• Developed complex mappings in Informatica to load the data from various sources. Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings. Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance. Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database. Wrote documentation to describe program development, logic, coding, testing, changes and corrections.
• Created and implemented Test cases for the mappings developed and then created integration Testing Document.