SUMMARY:

• A solution oriented professional Oracle Database and E - Business Suite Application Administrator spanning several industries with expertise in architectural design, Installation, configuration, performance tuning, upgrades, disaster recovery techniques, Patching and Cloning of multi-terabyte standalone and RAC on multiple platforms like IBM-AIX, Sun-Solaris, UNIX, Linux and Windows.
• Extensive knowledge on database and application Hot/Cold backup, disaster recovery strategies and high availability using tools/technologies such as Oracle Real Application Clusters, Oracle Data Guard, Oracle Golden Gate, RMAN, Import/Export & Datapump, Oracle Streams Replication (Oracle Streams and Dataguard Physical Standby database).
• Ample knowledge and experience on Amazon Web Services(RDS) Technologies ie (EC2, Route53, ELB, CloudWatch, AMI, IAM, VPC, Subnets), etc, including on premise oracle E-Business Application and databases migration to AWS Cloud technologies.
• Proven ability to implement technologies that decrease costs and increase performance with outstanding interpersonal and communication skills and team leader trained on SOX, HIPPA, SDLC, and ITIL policies implementation and procedures.

TECHNICAL SKILLS:

Applications: Oracle E-Business Suite Versions 11.5.X, 12.0.X, 12.1.X, 12.2.X, WebLogic, Application Server 9i/10g, Oracle Discoverer, FMW 11g/12c (ADF, SOA, OSB) SSO/AD/OID, OBIEE, ODI, Vertex, Amazon Web Services(RDS) .

Database: Amazon-RDS, EC2, Oracle RDBMS 9i, 10g, 11g, 12c, 18c (Standalone, RAC, ASM) Data Guard, Golden Gate, MySQL.

Language: SQL, PL/SQL, Java, HTML, UNIX Shell Scripting, VB, C++.

Tools: Oracle SQL Developer, Oracle Enterprise Manager 13c, Toad, TPAM, SQL*Plus, SQL*Loader, RMAN, Data Pump, Putty, AD/ADOP Utilities, OAM, AppDynamics, ORDS and Solix EDM.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM, SQLT, SQL TUNING ADVISOR.

Operating Systems: Sun Solaris 9/10, AIX 4.3/5.1/7.1, HP-UX, OEL8.1, RHEL 6.10 and Windows.

Hardware: Sun Enterprise Servers 890/880/420/450 and StorEdge 6320, Dell, HP/UX-9000, IBM-Power PC, Exadata Database Machine/Storage Server.

PROFESSIONAL EXPERIENCE:

Confidential, Houston TX

Senior Oracle Application and Database Administrator

Responsibilities:

• Providing a daily Administration of Oracle E-business suit R12.2.7 applications support to ensure availability by tuning, troubleshooting and monitoring production and development applications and databases, FMW (WLS, ADF, and SOA ) applications, batch Jobs, concurrent managers, forms, Web and Report Servers, Users security, Workflow Administration, Instance Cloning, Release management, patch/impact analysis using patch wizard, applying Oracle E-business suit R12.2.7 application and database patches using ADOP utility and phases including Technology stack patches (OHS, WebLogic, FMW) and quarterly PSU/CPU Patches in DEV, TEST and PROD instances.
• Extensively providing performance Tuning on database, application and SQL queries by analyzing, troubleshooting creating SQL profiles on SQL queries with bad execution plan for stability and adding indexes on queries using improper indexes for a faster execution, by using tools/utilities such as OEM, SQL Tuning Advisor, EXPLAIN PLAN, AUTOTRACE, SQL TRACE, TKPROF, AWR, ADDM, ASH, v$performance views. Worked with Application development team and third party vendors on releases and deployment management processes including coordinating with Oracle Support on application and database issues on opened SR’s.
• Involved with third party vendors and AWS Technical support on all technical aspects in the architectureing, designing and deploying of LANDRYS on-Premise Data centers Oracle EBS Application, Oracle database and Fusion Middleware Products environments to be deployed on AWS (RDS) Cloud which includes setting up, supporting and Managing the Backup and Disaster Recovery strategy, code deployments of On-Premise Data Centers and AWS Cloud platforms on Development, testing and pre-production instances.
• Initiated upgrading Confidential 's main reporting application (EIS eXpress Reporting solution) from an older version to version 8.0.4 on an enterprise level from DEV, TEST and Production running on our E-Business application 12.2.4/7. These improved the companies reporting process from third party applications ie Aloha Work Bench, Point Of Sale, Customer Data Hub to 50%.

Confidential, Winston-Salem, NC

Oracle Application and Database Administrator

Responsibilities:

• Supporting the Global Oracle E-Business Suite Application 11.5.10.2 Consolidated Updates (CU2) of production and non-production environments and R12.2.4 Upgrade project on DEV and UAT environments.
• Providing a 24/7 support on Oracle products to ensure availability by administering, tuning, troubleshooting and monitoring production and development databases, FMW (WLS, B2B, ADF, SOA and OSB) Applications, Batch Jobs, Concurrent managers, forms, Web and Report Servers, User and Profile Management, Patch Administration and E-Business Suite, Instance Cloning and Release Management.
• Building and entire Oracle Fusion Middleware 11g and 12c application infrastructure including OBIEE and ODI and Vertex on development and production servers.
• Installed and configured OEM 12c and registered all productions and development database servers on AIX, Linux, Solaris and Windows for a proactive monitoring of infrastructure.
• Trouble-shooting daily performance and user access issues on database, EBS and FMW applications and providing capacity management on database objects and server filesystems. Using Oracle OEM grid control and Toad to manage and tune the databases as needed for optimal performance.
• Enhanced UNIX shell scripts to manage database alerts, backups, startup scripts etc and ran AWR reports to tune all areas of the database.
• Used Oracle Recovery manager (RMAN) and EMC BCV to backup Oracle databases to ensure a point-in-time recovery while performing a schedule w eekly c loning of a 35TB EBS application instance to various targeted Test and Development environments as needed by client and deleting sensitive data on targets.

Confidential, Woodlands, TX

Senior Oracle Application and Database Administrator

Responsibilities:

• Spearheaded Oracle E-Business Suite Application upgrades from 11.5.10.1 to 11.5.10.2 Consolidated Updates (CU2) of production and non-production instances.
• Provided a 24/7 support on Oracle products to ensure availability by administering, tuning, troubleshooting and monitoring database, Application Server 10g, Batch Jobs, Concurrent managers, forms, Web and Report Servers, User and Profile Management, Patch Administration and E-Business Suite, TAR Management, Instance Cloning and Release Management.
• Initiated Oracle Enterprise Manger OEM. Installed, configure the OEM agent on all productions and development database servers on AIX, Linux, Solaris and Windows for a proactive monitoring of infrastructure.
• Reduced cloning procedure 50% by developing, coordinating and implementation of a backup and recovery methodology using Oracle Recover Manager RMAN technology on production and development databases interfaced with Tivoli Storage Manager (TSM) and Symantec NetBackup for backing up to tape.
• Technical lead member in the upgrade of Oracle E-Business Suite from 11.5.10.2 on a 10gR1 database to Oracle E-Business Suite R12.1.3 on an 11gR1 database.
• Standardized the performance tuning and analysis methodology by identification of bottlenecks and elimination of database contention, memory tuning, gathering statistics, application tuning where long running jobs are identified and sent to Development team for remediation or scheduling the batch jobs after peak working hours.
• Minimized systems outages by ensuring application instances and databases meet standards identified by the technical architect, and functioned at optimal capacity.
• Met aggressive 6 month seamless migration of 250 Production, User Acceptance and Development Oracle and MySQL databases on UNIX and Windows servers from McKesson old Datacenter in Houston to a new Datacenter in California.
• Provided 24x7 supports on miscellaneous legacy production, User Acceptance and Development Oracle and MySQL databases.
• Worked in collaboration with the systems engineering team to Installed, configured and maintained EXADATA X2-2 half rack database machines while migrating databases from non-exadata servers using RMAN.
• Configured Database File System (DBFS) on EXADATA X2-2 by adding dick groups to tablespaces using OEM or command line to resolve space issues.
• Health checking of Exadata system to make sure that it’s performing at optimal expectation by using the Exachk utility. Checking Cell Server health, efficiency, Patching, Alert logs and starting/shutdown of cell services using the CellSRV/CellCLI utilities.

Confidential, Malvern, PA

Oracle Application & Database Administrator

Key Achievements:

• Performed analysis of current optimization model and provided recommendations to move to Oracle ’ s cost-based optimization. Led the stress test initiative to evaluate the success of this approach.
• Established standards for all Oracle database environments. Initiative redesigned all new and legacy environments to adhere to newly established standards.
• Handled performance monitoring and troubleshooting of Production Oracle E-Business Suite, Databases, Oracle Application Server, Concurrent Manager, Forms Server, and Report Server.
• Installed and upgraded several non-productions Oracle on Unix/Windows Server and supported various third party legacy applications for testing and development environments.
• Provided a full backup and recovery strategy on both production and development with Oracle 9i Real Application Cluster (RAC) Database, Oracle Cluster File System (OCFS) on Linux AS2.1 for production databases.