OBJECTIVE:

Seeking a challenging growth oriented career to leverage company’s investment and provide opportunities for career advancement

SUMMARY:

• Over 18 years of experience in Oracle of which 15 years as Oracle Database Administrator (OLTP, Data warehouse) and 2 years administering databases on Oracle Exadata
• Over 2 years of experience in Oracle Goldengate Bi - Directional replication
• Install/Upgrade Oracle on various Operating Systems (Sun Solaris 2.x, HP-UX 10.2,11i, IBM AIX 4.3.3, 5.x (5.1-5.3), Windows 2000 and Windows NT.4) and Upgrading Oracle databases from Oracle 7.3.4 to 8.0.6, 7.3.4 to 8i (8.1.6), Oracle 8.1.6 to 8.1.7.4, 9i, 10g R2,11gR2
• Oracle Enterprise Manager 10g, 11g, 12c. Lead Architect for Oracle Enterprise Manager 12c Implementation.
• Expert in the logical and physical design of the databases, setting up High Availability Clusters (9i RAC, 10g RAC) and Oracle Data guard as part of Disaster Recovery strategy.
• Performance tuning - Tune SQL statements, I/O, Memory, latches etc. Worked extensively on SQL Profiler, Explain Plan, AWR/ASH report and Stats Pack for tuning top wait events, high cost SQL’s.

TECHNICAL SKILLS:

Hardware: Sun Enterprise 4500, 6500, 6900, 10000, 15000, M5000, M9000, HP 9000, IBM RS/6000 (p690, and s80), Compaq Proliant, IBM Netfinity,Exadata, Exalogic

Operating System: Sun Solaris 2.x, HP-UX 10.2, 11i, AIX 4.x, 5.x, Red Hat Linux ASE 3.0,MS Windows 2000,NT4.5, Windows 95,98, Windows ME, Windows XP

Software/Tools: TOAD, SQL Navigator, BMC Patrol, SQL Backtrack, DB Artisan, Oracle Enterprise Manager (9i, 10g, 11g, 12c), PVCS.

RDBMS: Oracle 7.x to Oracle 11g (9i RAC, 10g RAC, 11gRAC), SQL Server 6.5/7.0, 2000

ERP: Oracle Applications 11i, R12 (Applications DBA Support)

Replication: Oracle Goldengate Replication (Unidirectional/Bi-Directional with Conflict Detection and Resolution Enabled), Shareplex, Oracle Streams

Others: Oracle Demantra 7.2 & 7.3, Oracle Transportation Management (OTM) 6.2, Shell Scripting

WORK SUMMARY:

Confidential

Sr.Oracle Database Architect

Responsibilities:

• Migrate Oracle Applications database to Exadata and applications to Exalogic Server
• Automated scripts for Getpaid nightly auto update job
• Recommended to apply Oracle Recommended patches to fix Performance issues in Oracle Applications R12 HR Modules
• Implemented RMAN backup on Dataguard system to reduce load on Primary Database
• Implemented RMAN incremental backup using Block Change tracking to improve the performance of incremental backups.
• Responsible for performing Oracle database tasks including installation, configuration, backup, recovery, and tuning.
• Created SQL profile for sql’s that perform poorly or when there is a change in execution plan
• Ran AWR/ASH reports to analyze performance issues and fix performance issues for top SQL’s
• Failover R12 applications and database to DR when Primary site was not available due to Storage Issues
• Recovered Primary database/applications and switched over back to Primary site

Confidential

Sr.Oracle Applications DBA/Goldengate Architect

Responsibilities:

• Support Oracle ASM instances / Oracle 11g RAC databases and troubleshoot RAC issues like node eviction, Cluster wait events, and database hung scenarios.
• Architected and Implemented Oracle Goldengate Bi-Directional replication with complex Conflict Detection and Resolution (CDR) for YODA ATT Order Entry Middleware System.
• Worked with BSA, Development and Business team on requirements gathering, project planning, testing etc.,
• Partition Applications to avoid potential data conflicts and Load Balanced Applications using automatic Load Balancers, run batch jobs on Master Site
• Tested Goldengate failover scenarios between Master and Slave Sites and validate data using Veridata
• Automated scripts for creating CDR tables and CDR routines
• Filed Oracle Bug 14702344 CDR Replicat abend without valid error when UPDATEROWEXISTS invoked
• Lead Architect for Oracle Enterprise Manager 12c Implementation
• Installed and upgraded Oracle Grid Infrastructure from 10g to 11g and configure SCAN listeners
• Troubleshoot Grid Infrastructure issues and manage ASM instance, ASM Disk groups
• Configured ACFS file system to store Goldengate binaries and trail files on a 3 node RAC.
• Installed and configured Oracle Demantra 7.2 for Confidential & Confidential Demand Planning System
• Patched and upgraded Oracle Demantra to 7.3 from 7.2.
• Performance tuned Demantra applications (Database and WS) and analyze engine logs.
• Assisting with the planning, reporting, implementation, and support for the project.
• Multitasking on various projects and tasks like cloning, installations and upgrades.

Confidential

Sr. Oracle Applications DBA

Responsibilities:

• Support Oracle Applications 11i Financial s Applications and its database
• Upgrade databases from Oracle 10g to 11g
• Upgrade Oracle Applications 11i from CU1 to CU2 (11.5.10.2)
• Architected and implemented Single Sign on (SSO) for Oracle Financials Applications.
• Architected and implemented OID for Financials Application.
• Reduced cost of backups by implementing incremental backup as well as reducing contentions
• Perform Oracle application refreshes for Development and UAT databases
• Perform masking on Development databases to protect sensitive data
• Installed & Configured Oracle Application Express (APEX)
• Extensive performance tuning to reduce the long running process from several hours to few minutes
• Co-ordinate with India team and Distributed Database support team to perform upgrades, patches etc
• Support DR test for Financials database and its Data mart

Confidential, Orangeburg, NY

Sr. Oracle DBA

Responsibilities:

• Support 24x7 mission critical Confidential Billing Systems, Fraud systems, Number Activations Systems
• Performance tuning of queries which uses Advanced Queuing tables
• Upgrade Oracle database to 10gR2 from 9i and apply latest Security Patches
• Tested and Implemented Backup and Recovery strategy using 10g RMAN Fast Incremental backups
• Convert Oracle export jobs to Datapump reducing the export times by more than 75%
• Improved transactions rate from 300 TPS to 800 TPS for Fraud Database Systems
• Identified top SQL and performance tune using SQL Advisor/profiler
• Set up 10g Grid Control to monitor dB and system performance
• Implemented Quest Shareplex replication

Confidential, Allentown, PA

Oracle Business Applications DBA

Responsibilities:

• Provide 24x7 Support of Mission Critical Applications and worked on enhancing the Database/Application monitoring process
• Patch Oracle Applications from 11.5.10 CU1 to 11.5.10 CU2 without issues
• Install, Configure Oracle 9iAS portal and configure OID to maintain user repository in sync with other Applications
• Resolving Critical High Priority Remedy tickets with meeting the Service Level
• Configure iSupplier in Oracle Applications 11i
• Upgrade databases from Oracle 7.3 to 10g and troubleshoot issues during the upgrade
• Setup 4 Node Oracle 9i extended RAC and working on testing Oracle 10g RAC to Support Oracle 11i Applications
• Install Citrix and support the applications running on Citrix
• Upgrade Mercury Test Director 8.0 to Quality Center 9.0 and document the upgrade process
• Upgrade Primavera Projects and Time sheet from 4.0 to 5.0

Confidential, Mahwah, NJ

Sr. Oracle Applications DBA

Responsibilities:

• Managed Data Warehouse & Oracle 11i Applications 11i databases
• Recovered tables (due to user error) using Flashback recovery technique.
• Managed 1 TB Oracle 10g Data warehouse and used table compression to manage space
• Installed Cluster Ready Services (CRS) and configured 2 node Oracle 10g RAC. Used Cluster verification utility for providing update to Oracle Service Request (SR)
• Configured Oracle RMAN database backup and backed up to tape using Veritas Netbackup as the Media Management software
• Upgrade Oracle from 9.2.0.4 to 9.2.0.6 and configured Oracle 10g Grid Control to monitor database alerts, events and scheduling jobs
• Install Informatica and manage its repository.

Confidential, Hartford, CT

Oracle DBA

Responsibilities:

• Manage 6 Data marts for Personal Lines Division and 1 Large Data Warehouse environment
• Create periodical Data mart refresh
• Migrated 7TB (Terabyte) of Oracle Data warehouse from HP Tru 64 to HP-UX11i using cross platform TTS technique under 48 hours.
• Perform capacity planning, design, and optimizing of multi-terabyte VLDB databases
• Saved more than 1 TB of space by enabling table compression
• Installed and configured 10g Grid Control and have worked with Oracle Support in fixing bugs. Documenting the changes that are made to the database parameters. Preparing scripts for performance tuning and database reorganization
• Managed Oracle Applications 11i HRMS database which includes cloning, patching, troubleshooting etc

Confidential, St. Petersburg, FL

Oracle Applications DBA

Responsibilities:

• Upgraded Oracle Applications from 11.5.5 to 11.5.8
• Upgrade Oracle Database from 8.1.7.2 to 9i (9.2.0.4) and applied required interoperability patches
• Good understanding in trouble shooting of errors during patching
• Migrated Oracle applications from AIX4.3 to 5.1 and relink oracle software and Oracle Applications
• Implemented iPayment with Order Management and Account Receivables, iStore with Oracle Order Capture, Advanced Pricing, Receivables, APS

Confidential, Allentown, PA

Oracle Applications DBA

Responsibilities:

• Maintained and supported over 500 GB Database which includes OLTP, and Data warehouse database
• Created Multi-dimensional models for Data Warehouse database and performance tuned init parameters for Data Warehouse database.
• Implemented Star Schema and created schema design, database, physical storage design and performance tuning
• Implemented Quest Shareplex replication for Reports Server from OLTP.