EBS HR/HCM Consultant at Splash BI · Hyderabad · 4 - 10 years · ₹6L - ₹15L / yr · Profitable · Posted 30 May 2024

Responsibilities
• Should be able to understand functional & technical requirements from business and come up with solutions.
• Development, Support, Debugging and troubleshooting of the existing developed applications (Forms, Reports, Interfaces etc.).
• Should be able to configure Oracle EBS/Cloud including the configuration of Business Processes and security.
• Integrations of customized applications with Oracle standard applications modules.
• Should be very strong in SQL and strong in PLSQL (especially Packages, Procedures and Functions).
• Database structure design for Tables, views, sequences, synonyms, and database triggers etc.
• Training users/BSAs when required & preparing technical documentation.
• Ensure customer satisfaction, Self-drive and perform duties with minimal supervision.
• Ensure tickets are resolved within SLA’s and assignments are completed within the agreed deadlines
• Good enough to understand the existing PLSQL packages/procedures/functions and modified / create new ones as needed.
• Ability and willingness to stay updated with the latest developments and updates in Oracle Fusion technologies and best practices.
Requirement:
• 4+ years of Technical or Techno-Functional experience in Oracle EBS R12/Cloud Applications on Oracle HR/HCM (Any Modules in HR), SQL/PLSQL.
• Good experience with HR/HCM (Any Modules in HR) is a must and should understand the functionality.
• Should be able to understand (Any Modules in HR) data model and should be quick enough to switch from one product to another product easily.
• Ability to develop custom solutions, extensions, and integrations to meet specific business requirements.
• Proficiency in creating custom reports, dashboards, and analytics using Oracle BI Publisher, Oracle OTBI (Oracle Transactional Business Intelligence), and other reporting tools.
• Knowledge of security models, user roles, and access controls within Oracle Fusion applications to ensure data integrity and compliance.
• Strong analytical and problem-solving skills to identify and address technical issues, system errors, and integration challenges.
• Good to have experience in Performance tuning techniques.
• Effective communication skills at all organizational levels, including written, oral, and presentation skills.
• Should be a good team with can do attitude.
• Capability to switch and willingness to work in any of the technologies as per the need basis.
• Should have a good understanding in working with onsite-offshore model.

About Splash BI
About
Connect with the team
Similar jobs (2)
We are looking for an experienced Oracle EPM Technical Consultant with strong hands-on expertise in Oracle EPM Cloud Planning / EPBCS technical components. The candidate will be responsible for configuring, developing, migrating, and supporting EPM applications across implementation, enhancement, and AMS engagements.
The ideal candidate should have practical experience with Forms, Business Rules, Groovy Calculations, Reports, Data Maps, Data Management, metadata management, and application artifact migration, along with a good understanding of Oracle EPM SaaS products.

Job Description — L2/L3 Oracle DBA and Oracle Apps DBA
Experience: 5–10 years of relevant experience
Support coverage: Dubai customer business hours and on-call support as required
Role Overview
We are seeking an experienced Oracle DBA and Oracle Apps DBA to support
customer Oracle Database and Oracle E-Business Suite (EBS) environments. The role
involves L2 incident resolution, L3 troubleshooting, performance tuning, patching,
upgrades, and maintaining database and application availability.
Key Responsibilities
Oracle Database Administration
∙Install, configure, administer, and maintain Oracle databases across
production and non-production environments.
∙Monitor database health, availability, performance, storage, and capacity.
∙Troubleshoot database incidents, connectivity failures, locking, blocking, and
resource issues.
∙Analyse AWR and ASH reports, SQL execution plans, and database wait
events to resolve performance problems.
∙Configure and manage RMAN backups; perform recovery and restore
validation.
∙Administer Oracle RAC, ASM, Grid Infrastructure, and Data Guard
environments.
∙Perform database patching, upgrades, migrations, and refreshes through
approved change procedures.
∙Manage database users, roles, privileges, auditing, and security controls.
∙Execute disaster recovery drills, Data Guard switchovers, and failovers.
∙Automate routine administration and monitoring using shell scripts and SQL.
Oracle Applications DBA
∙Administer Oracle E-Business Suite R12.2 application and database tiers.
∙Monitor and troubleshoot concurrent managers, concurrent requests,
Workflow Mailer, application services, and login issues.
∙Perform EBS online patching using ADOP and manage the associated
patching lifecycle.
∙Clone and refresh EBS environments using supported tools, including Rapid
Clone.
∙Maintain application configuration using AutoConfig and context files.
∙Administer EBS-related WebLogic Server, Oracle HTTP Server, and Forms
services.
∙Troubleshoot application-tier performance and coordinate with functional
and development teams.
∙Support EBS upgrades, technology-stack patches, certificate renewals, and
integration-related incidents.
∙Maintain operational procedures for application startup, shutdown, backup,
recovery, and maintenance.
L2/L3 Support and Customer Operations
∙Own incidents and service requests within agreed SLAs.
∙Provide L2 troubleshooting and escalate complex issues with complete
diagnostic evidence.
∙Lead L3 investigation, root-cause analysis, and permanent corrective actions.
∙Support major incidents, communicate progress, and document recovery
actions.
∙Raise and manage Oracle Support service requests.
∙Prepare change plans, risk assessments, validation steps, and rollback
procedures.
∙Maintain runbooks, knowledge articles, configuration records, and shift
handovers.
∙Coordinate with customer teams and internal infrastructure, storage,
network, and application teams.
∙Mentor junior DBAs and identify opportunities to reduce recurring incidents.
Required Skills and Experience
∙Hands-on production experience administering Oracle Database, including
Oracle 10g, 11g, 12c, 18c and 19c.
∙Strong experience supporting Oracle EBS R12.2 as an Apps DBA.
∙Practical knowledge of RAC, ASM, Data Guard, RMAN, Data Pump, and






