Senior Oracle Core & Apps Database Administrator available for C2C roles. Name: Mujahid Ali Technology : ORACLE APPLICATION DBA Visa: USC Remote only. 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.
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. | | | | | | |
