PROFESSIONAL SUMMARY:

• 15+ years of experience as a Senior/Lead Oracle Core and Applications DBA for Oracle E - Business Suite R11i, 12.2.4
• Proficient in various administration activities such as installing, configuring, migrating, upgrading and supporting Oracle applications R11.5, R12.1, R12.2 and Oracle databases 19c, 18c,13c, 12c, 11g, 10g and previous versions
• Worked with various databases including MySQL, MongoDB, PostgreSQL, SQL Server and Oracle DB
• Collaborated with technical and functional teams to troubleshoot and resolve critical issues in a timely fashion
• Generated BI reports, dashboards and database growth summaries for capacity planning using Oracle APEX tool
• Actively implemented best practices following Oracle OFA (Optimal Flexible Architecture)
• Supported mission critical environments (DDW loads) and provided on-call support for crisis calls and escalations
• Skilled in database support, performance tuning and troubleshooting (SQL, PL/SQL tuning, application tuning etc.)

TECHNICAL SKILLS:

Computer Systems:: IBM PCs, Sun Ultra, Enterprise Class, HP-RP s, E10K, E15K, Qtr Rack Exalogic (OEL 5.5 - Linux x86-64) - 8 compute nodes (12 cores/node, 96 GB RAM/node), Half Rack Exadata OEL 5.5 (Linux x 86-64) - 4 DB nodes (12cores/node, 96GB RAM/node)

Oracle Tools/Methods:: Oracle Enterprise Manager (OEM), Oracle Configuration Manager (OCM), WebLogic, Oracle Access Management (OAM), Internet Directory, BI Foundation Suite (Hyperion, Essbase, BI Publisher), Data Guard, Standby, Optimal Flexible Architecture, Application Express (APEX) for customized reporting, Recovery Manager (RMAN), GoldenGate, Automatic Storage Management (ASM), Data Pump, NetBackup, Server Control (SRVCTL)

Related Thirdparty Tools: Sabrix (for transaction tax integration), Citrix, SQL Backtrack, Appworx, AutoSys, Toad 8.5.3, EMC Timefinder, EMC Admin Tool

Operating Systems: Unix (Solaris, NCR, HPUX, Linux & Digital), Win NT/2K, MS-DOS

Databases: Oracle 7.x, 8.x, 8i, 9i, 10g, 11g, 12c/13c cloud - RAC, DB2, Sybase, SQL MongoDB, PostgreSQL, MSSQL Server 2007/2012, MS Access

Application Modules: Oracle Apps 10.7, 11.0, 11i, R12.2, I-pay, I-procurement, I-Store, E-commerce, Adv Collections, Financials, WMS, SCM, Demantra (7.3.1.4, 12.2.5.1), CRM, HRMS, Manufacturing

Languages: Fox plus PL/SQL, SQL, Unix Shell Scripting, Perl scripting

Frontend tools: Developer 2000 (Forms 4.5/5.0/6i, Reports 2.5/3.0/6i), Designer 2000, ERWIN, Remedy, ServiceNow

Highavailability Systems/DB: Veritas Cluster, MC Service guard, Hitachi Shadow, SSO/SSL implementation

Windows/Unix Tools:: Putty, SFTP, WINSCP, Hummingbird Exceed, VNC, Microsoft Remote Desktop, IBM Encryption

PROFESSIONAL EXPERIENCE:

Confidential, Bethesda, MD

Senior Oracle Apps DBA

Responsibilities:

• Collaborated closely with Project Manager, team, and users to enhance and maintain Oracle E-Business Suite Apps, e-voucher, CAPS, e-Profile, PTM, Prism, Sunflower, Kofax, Loftware, GRC, and AppWorx
• Performed Oracle R12 apps installation, configuration, database administration, cloning, patching, performance tuning and backup & recovery
• Implemented and managed Oracle Rest Data Services (ORDS) to provide web interface and REST API for on-premise Oracle databases
• Supported Kofax architectural and software components and their integration with Oracle E-Business Suite (EBS) R12.2
• Performed upgrades for CAPS, GRC and Prism applications
• Prism from 7.2 SP7 to Prism 7.3 SP3
• GRC from 8.6.5 to 8.6.6
• WebLogic from 12.1.3 to 12.2.2 with additional components and application runtime (ADR) 12.1.3.1.0, JDK 7 and JDeveloper
• Applied CPU patches, PSU patches, and application patches in EBS, Sunflower, Prism and CAPS
• Streamlined and documented procedures to install and deploy configurations across instances

Confidential, NC

Lead Oracle Apps DBA

Responsibilities:

• Worked extensively in 12c/13c administration using OEM Cloud Control; performed activities including patching, cloning, performance tuning and support for release management team during production migration
• Implemented 4-node RAC cluster with 7 application nodes in EBS R12.2.5
• Upgraded EBS from 12.1.3 to 12.2.4 and 12.2.5 and provided support for related middleware applications
• Proactively monitored and implemented audit in EBS following security standards and best practices
• Identified vulnerabilities in systems and implemented security measures for business compliance
• Generated BI reports, dashboards and database growth summaries for capacity planning using Oracle APEX tool
• Installed, configured, and administered applications in Oracle BI Foundation Suite (BIFS) ie., OBIEE, Hyperion, Essbase and BI Publisher

Confidential Boston, MA

Lead Oracle Apps DBA

Responsibilities:

• Used Oracle Application Manager (OAM) to administer Concurrent Manager in Oracle E-business Suite Application
• Handled all Oracle support service escalations and ensured issues were resolved in timely basis
• Proactively monitored applications and their performance using Grid Advisor/SPM/profile/AWR/ADDM tools
• Provided Oracle statistics, BI reports, and generated database growth summaries for capacity planning
• Completed reorg activities, created SQL stored procedures, and performed tuning of SOA components
• Installed, configured, and helped troubleshoot Oracle Middleware applications like OBIEE, Hyperion, Essbase and BI Publisher
• Upgraded from R12.1.3 to R12.2.4 to R12.2.5 in development/test/production environments with complex architecture and design - DMZ, load balancing, shared file systems, core framework and custom applications

American Tire Distributors, Huntersville, NC

Lead Oracle Apps BA

Responsibilities:

• Supported production and non-production ERP databases (11.5.10.2/12.1.3 ) and performed multi-node RAC administration
• Managed large-scale RDBMS and analyzed DB growth in production for capacity planning
• Upgraded Oracle Application 11.5.10.2. to R12.1.1 to R12.1
• Used SQL profiles for performance analysis during batch jobs and carried out tuning
• Installed, configured, administered 12c cloud, GoldenGate 11.2.0.2 on Exadata servers
• Provided support for Oracle applications and SOA components

Confidential Grand Rapids, MI

Oracle Apps DBA

Responsibilities:

• Global Implementation of EBS 12.1.3 and database 11.2.0.3 on Exalogic (2.0) and Exadata (2.2) servers
• Implemented 2-node RAC cluster with Automatic Storage Management (ASM) for disk management
• Upgraded from R12.1.3 to R12.2.4 in development instance
• Experienced in SQL/Unix scripting and SQL tuning - PL/SQL programming, stored packages/procedures/functions
• Leveraged IBM Optim tool to encrypt data and meet business requirements for compliance and security
• Performed administration activities i.e., patching, cloning, performance tuning and provided support for release management team during production migration

Confidential, Huntersville NC

Oracle Apps DBA

Responsibilities:

• Upgraded from 10.2.0.4 to 11g R2 (64bit) and supported data migration from 10.2.0.4 to 11.2.0.3.0.6
• Upgraded from 11i to R12.2.0 on multiple environments - dev, test, and production.
• Supported Oracle 12c upgrade with IPAY and SSL and migrated databases to Oracle Exadata machine.
• Installed, configured, monitored Fusion Middleware Control (10gAS), Oracle 12c/OEM Cloud Control
• Database administration on DB2 and Oracle 11g/10g / 9i Database - i.e. CPU patches, PSU patches
• Implemented 2-node RAC cluster with Automatic Storage Management (ASM) for disk management
• Provided production support for RAC and non-RAC during go-live activities
• Improved ETL through SQL tuning for better performance
• Administered WebLogic including monitoring and troubleshooting using admin console
• Reorg tablespaces, tables, and indexes and carried out workflow purge activities for performance improvements.