Experience
8 - 13 yrs
Job Location
Noida, India
Vacancy
1
Designation
Oracle Application Database Administrator
Job Type
Not specified
Job Description
Roles & Responsibility
Client Name
MMC
Position Tittle
Oracle EBS Apps DBA
Minimum Qualification
Degree in Computer Engineering field or related
Total Experience (TEX):
8 till 15 years
Relevant Experience (REX):
Typically 6 to 8 years of experience With Oracle EBS, WebLogic Middleware and Single Sign On Administration
Detailed Job Description
Must Have Skills (3-4 skills, point wise)
- Oracle EBS 12.2 and Oracle Database 19c (Solaris) to OCI.
Oracle Cloud Infrastructure (OCI)
- Lead the migration of on-premises Oracle EBS 12.2 and Oracle Database 19c on Solaris to OCI.
- Design and implement OCI infrastructure for EBS, including provisioning and configuration of required services such as compute, storage, compartments and networking. This requires in-depth knowledge of OCI services, including VCN, Subnets, Service gateways, Compute, Block Storage, Object Storage, Networking, Oracle Cloud Autonomous Services, and others relevant to EBS infrastructure.
- Set up and administer Oracle Cloud services relevant to EBS, ensuring the architecture aligns with best practices for performance, scalability, and security.
- Handle day-to-day operational tasks within OCI, including but not limited to:
- Backup and recovery strategies.
- Database security, including encryption, access control, and auditing.
- Monitoring and performance tuning of EBS and databases.
- Patching, cloning, and applying updates to the EBS and Oracle Database environments.
- Develop and maintain scripts or automation tools for routine maintenance, backups, and other administrative tasks.
- Collaborate with internal teams to support application upgrades, disaster recovery planning, and other critical business processes.
- Ensure all systems adhere to OCI best practices for security and compliance, including implementing appropriate auditing and monitoring solutions.
Support and Maintenance of Oracle E-Business Suite (EBS) R12 Applications.
- Daily support and management of Oracle E-business Suite Application support activities.
- Monitoring and Trouble-shooting issues related to E-Business Suite Application Servers and services.
- Troubleshooting issues related Apache, oacore, oafm, oc4j, Forms services and apps login through SSO.
- Monitoring the Work Flow mailer and notification queues and fix if any issues/delay in processing the WF notifications.
- Handling Configuration changes of E-Business R12 environment- Autoconfig, template customization and Localizations.
- Administration and management of Oracle E-Business suite using AD utilities that includes adadmin activities for Application objects compilation and re-linking.
- Monitoring the Concurrent Managers status and managing the operations like starting, stopping the concurrent managers, re-schedule the requests and purging the concurrent requests historical data.
- Managing Concurrent queues and Parallel Concurrent Processing.
- Administration and Management of EBS External applications like iSupplier Module on DMZ.
- Monitoring, Diagnostics and Troubleshooting application using OAM (Oracle Applications Manager).
- Pro-actively work with Prod Support Team, Project Teams to provide planning and ongoing support for Application Life cycle management.
- Analyzing the Log Files, Thread Dumps and JVM Dumps.
- Incident Management & Technical Assistance including Production and Performance diagnostics, technology assessments and troubleshooting day-to-day issues.
- Liaise with Performance Testing Team to identify any performance related issues during UAT phase.
- Java upgrades on EBS Application Servers and involve in Browser testing for Java desktop updates.
- Weekend Bounce, Maintenance and on-call Support for Production changes.
- Sanity testing of EBS Technology Stack components on regular basis.
- Perform Annual DR Tests.
- Month End Processing Hyper Care Support- tracking and reporting in doubt sessions, monitoring processing queues for long running requests, memory and space utilization.
- Creating Severity TARs/SR and conduct OWC sessions with Oracle support to resolve issues.
Good to Have Skills (3-4 skills, point wise)
Number of positions
2
CTC Range (In Lakhs)
30 LPA including variable pay of 12%
Location of demands (in specific to proactive hiring)
Preferred Delhi (Gurgaon or Noida)
Customer Name ( As per deployment)
MMC
Location of deployment (Specific customer location for deployment
Preferred Delhi (Gurgaon or Noida)
Notice period preferred range
Max 30 days
Shift Timing / Work timing ( Specify the work time slot)
1:30 to 10:30 IST as well and extension on requirement basis
Is Cab facility available
yes
Interview process: ( Number of rounds and mode of interviews) - Skype / Telephonic
2 Rounds , Teams
Team Leader / Individual contribution role
Individual
Is client open to conduct Skype interview(for off location candidates)
Teams
Any specific need
(Example) 1. Candidate should not have attended the same client interview (directly/via another vendor) in the last 3months 2. (any other)
3 - 6 Months
Requirements
Client Name
MMC
Position Tittle
Oracle EBS Apps DBA
Minimum Qualification
Degree in Computer Engineering field or related
Total Experience (TEX):
8 till 15 years
Relevant Experience (REX):
Typically 6 to 8 years of experience With Oracle EBS, WebLogic Middleware and Single Sign On Administration
Detailed Job Description
Must Have Skills (3-4 skills, point wise)
- Oracle EBS 12.2 and Oracle Database 19c (Solaris) to OCI.
Oracle Cloud Infrastructure (OCI)
- Lead the migration of on-premises Oracle EBS 12.2 and Oracle Database 19c on Solaris to OCI.
- Design and implement OCI infrastructure for EBS, including provisioning and configuration of required services such as compute, storage, compartments and networking. This requires in-depth knowledge of OCI services, including VCN, Subnets, Service gateways, Compute, Block Storage, Object Storage, Networking, Oracle Cloud Autonomous Services, and others relevant to EBS infrastructure.
- Set up and administer Oracle Cloud services relevant to EBS, ensuring the architecture aligns with best practices for performance, scalability, and security.
- Handle day-to-day operational tasks within OCI, including but not limited to:
- Backup and recovery strategies.
- Database security, including encryption, access control, and auditing.
- Monitoring and performance tuning of EBS and databases.
- Patching, cloning, and applying updates to the EBS and Oracle Database environments.
- Develop and maintain scripts or automation tools for routine maintenance, backups, and other administrative tasks.
- Collaborate with internal teams to support application upgrades, disaster recovery planning, and other critical business processes.
- Ensure all systems adhere to OCI best practices for security and compliance, including implementing appropriate auditing and monitoring solutions.
Support and Maintenance of Oracle E-Business Suite (EBS) R12 Applications.
- Daily support and management of Oracle E-business Suite Application support activities.
- Monitoring and Trouble-shooting issues related to E-Business Suite Application Servers and services.
- Troubleshooting issues related Apache, oacore, oafm, oc4j, Forms services and apps login through SSO.
- Monitoring the Work Flow mailer and notification queues and fix if any issues/delay in processing the WF notifications.
- Handling Configuration changes of E-Business R12 environment- Autoconfig, template customization and Localizations.
- Administration and management of Oracle E-Business suite using AD utilities that includes adadmin activities for Application objects compilation and re-linking.
- Monitoring the Concurrent Managers status and managing the operations like starting, stopping the concurrent managers, re-schedule the requests and purging the concurrent requests historical data.
- Managing Concurrent queues and Parallel Concurrent Processing.
- Administration and Management of EBS External applications like iSupplier Module on DMZ.
- Monitoring, Diagnostics and Troubleshooting application using OAM (Oracle Applications Manager).
- Pro-actively work with Prod Support Team, Project Teams to provide planning and ongoing support for Application Life cycle management.
- Analyzing the Log Files, Thread Dumps and JVM Dumps.
- Incident Management & Technical Assistance including Production and Performance diagnostics, technology assessments and troubleshooting day-to-day issues.
- Liaise with Performance Testing Team to identify any performance related issues during UAT phase.
- Java upgrades on EBS Application Servers and involve in Browser testing for Java desktop updates.
- Weekend Bounce, Maintenance and on-call Support for Production changes.
- Sanity testing of EBS Technology Stack components on regular basis.
- Perform Annual DR Tests.
- Month End Processing Hyper Care Support- tracking and reporting in doubt sessions, monitoring processing queues for long running requests, memory and space utilization.
- Creating Severity TARs/SR and conduct OWC sessions with Oracle support to resolve issues.
Good to Have Skills (3-4 skills, point wise)
Number of positions
2
CTC Range (In Lakhs)
30 LPA including variable pay of 12%
Location of demands (in specific to proactive hiring)
Preferred Delhi (Gurgaon or Noida)
Customer Name ( As per deployment)
MMC
Location of deployment (Specific customer location for deployment
Preferred Delhi (Gurgaon or Noida)
Notice period preferred range
Max 30 days
Shift Timing / Work timing ( Specify the work time slot)
1:30 to 10:30 IST as well and extension on requirement basis
Is Cab facility available
yes
Interview process: ( Number of rounds and mode of interviews) - Skype / Telephonic
2 Rounds , Teams
Team Leader / Individual contribution role
Individual
Is client open to conduct Skype interview(for off location candidates)
Teams
Any specific need
(Example) 1. Candidate should not have attended the same client interview (directly/via another vendor) in the last 3months 2. (any other)
3 - 6 Months