Wednesday, October 18, 2023

Senior Oracle Core & Apps Database Administrator

Hi Good Afternoon.

Senior Oracle Core & Apps Database Administrator available.

Name: Mujahid 
Visa: USC

SUMMARY:

Senior Oracle Core & Apps Database Administrator with 10+ years of experience on Oracle Applications 11i/12c, Oracle RAC and Core database including 10g, 11g and 12c on Linux, Sun Solaris, AIX and Windows Platforms. Having hands on experience on Oracle Backup and Recovery (RMAN, COLD & HOT), RAC, ASM, Data Guard, Oracle Performance Tuning, Exadata.

·        Experience in Oracle Applications 11i/R12 DBA & Oracle DBA, providing 24x7 support of both Production & Development on Various Platforms.
·        Experienced in Oracle Apps Administration and Sysadmin tasks.
·        Installation, Configuration & Deployment of Oracle E-Business Suite 11i/R12.
·        Implemented Oracle Apps 11.5.10.2 with Oracle RAC.
·        Implementation of High Availability solutions with Oracle 11g/10g RAC, Physical and Logical Standby Databases (Data Guard).
·        Installation, upgradation, configuration & troubleshooting Golden Gate 12c, 18c & 19c.
  • Understand and implement functional configuration changes to E-Business Suite modules
  • 5 years of experience designing, building, testing, and deploying technical components requiredfor successful Oracle E-Business Suite (EBS) solutions
·        Configured Golden Gate downstream mining and integrated components for Active-Passive and Active-Active replication.
·        Good knowledge of Oracle Golden Gate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate. Developed home-cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM (Oracle Enterprise Manager) 12c.
·        Implemented and configured Golden Gate in RAC environment.
  • Worked on Golden Gate (18c & 19c) setup, configuration, and issue tracking with oracle support.
  • Understand all concepts of the Oracle E-Business Suite
  • Handsome knowledge of Uni & Bi-Directional Replication.
  • Use GGSCI commands for gathering process evidence.
  • Troubleshoot problems in areas such as Golden Gate extraction, replication, missed transactions, mapping, synchronization, SQLEXEC, file maintenance and more.
  • Provide and implement performance tuning recommendations of all components in Exadata database machine.
  • provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
  • Solid skills to configure Exadata to meet company internal security requirement.
  • Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
  • Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
  • Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
  • Primary technical resources to upgrade Oracle Goldengate from 11g to 12c & 19c in Exadata machine environment design Goldengate HA solutions by using Oracle 11.2.0.4 Clusterware functionality.
  • Identify what causes slow startups.
  • Monitor Golden Gate lag and statistics.
  • Identify network and disk bottlenecks.
  • Perform tuning of Manager, Golden Gate Extract and Replicate.
  • Tuned Golden Gate to handle large volumes of data for high transaction tables.
  • Diagnose and tune the latest Integrated Extract, available since release 11.2.0.4 of the Oracle RDBMS, and Integrated Replicate, available since release 12c of the Oracle RDBMS.
·        Trouble shooting Forms server, Reports server, Apache server, Jserv, Jinitiator and Workflow.
  • Debug and unit test code for APEX workflow applications.
·        Expert in 11i Apps Cloning, Implemented new techniques for Apps Refreshes.
·        Applied Patching, Upgrades, framework, SSL For 11i Apps.
·        Application and Concurrent Manager load-balancing and Failover, Shared
APPL_TOP configuration.
·        Excellent experience in Installation of Oracle 10g, 11g in UNIX/LINUX and Windows environment.
·        Proficient in Database and Applications Administration activities such as Upgrades, Patches, TAR support, Backup and Recovery, Performance tuning, script development.
·        Effective troubleshooting of Database and Performance problems.
·        Worked with development teams and data administration staff to enhance Database and application performance.
·        Experience with Data Modeling.
·        Extensive performance tuning of Concurrent programs, Concurrent Mangers and SSWA
·        Very strong in Auto Patch, Upgrade, cloning.
·        Expertise in using ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADMERGE, ADCONFIG, ADMRGPCH, ADLICMGR & PTS tools.
·        Experience on Multi Org
·        Production DBA Experience on Oracle releases 11g/10g/9i
·        Excellent knowledge in installation and maintenance of Oracle Application Server
·        Expertise in configuring various oracle application modules like Discoverer, Workflow.
  • I have hands- on experience of Oracle APEX.
·        Management of schemas, objects & partitioning the tables & indexes.
·        Experience in a variety of different environments like HP-UX, SUN SOLARIS, Linux and Windows.
·        Experience in managing very large databases (Multiple TB of size).
·        Experience in administration of large Oracle database running in SAN environment, setting up databases for bank environment.
·        Write Korn shell scripts to monitor and maintain the Oracle Applications database.
·        Performed backups and tested crash recoveries using conventional Hot & Cold backups and RMAN.
·        Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM
·        Expertise in installing, maintaining and administering Oracle Applications 11i (11.5.8, 11.5.9, 11.5.10, R12) instances.
·        Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
 
SKILLS:
 
 
Operating Systems
HP-UX, Sun Solaris, IBM AIX, Windows, Red Hat Linux, Oracle Enterprise Linux.
  
RDBMS
Oracle8i, Oracle 9i, Oracle 10g RAC, Oracle 11g RAC, Oracle 12c & Oracle 19c
 
ERP Applications
Oracle E-Business Suite 11.5.7, 11.5.8, 11.5.9, 11.5.10.2, R12.2 & R12.2.7
 
Languages
SQL, PL/SQL, Java, C, UNIX Shell Scripting.
 
Tools
RMAN, OEM, OAM, SQL*PLUS, SQL*Loader, External Tables, Erwin, TOAD, Kintana.
  
EBS Specific Skills
Oracle Apps DBA, Sysadmin, Installation, Patching, Cloning Applications and database upgrade.
  
Tuning Tools
AWR, ASH, TKPROF, EXPLAIN PLAN, STATSPACK
Other
Discoverer, EMC, NetApp, Veritas.
 
Certifications
AZ-300 Microsoft Azure Architect Technologies.



Warm Regards,
 
Ashok | Sr. Sales Recruiter |
TechSmart Global INC | Ph : 732-791-2779
666 Plainsboro Rd, Suite 1116, Plainsboro, NJ 08536.