Job Description
Job Purpose
The Oracle EBS DBA will be responsible for administering, maintaining, and optimizing Oracle E-Business Suite environments across DEV, TEST, UAT, and PROD landscapes. The role requires strong expertise in Oracle database management, patching, environment cloning, and security compliance. In addition, the candidate will support SQL Server administration tasks including performance tuning, backup/restore management, and maintenance activities. The position ensures high availability, reliability, scalability, and security of enterprise database systems supporting key business applications.
Desired Skills And Experience
Candidates should have a B.E./B.Tech/MCA/MBA in Information Systems, Computer Science or a related field
68 years of hands-on experience as an Oracle Database Administrator in enterprise-level environments.
Strong experience managing Oracle E-Business Suite (EBS) environments.
Experience with SQL Server DBA responsibilities including backup, recovery, performance tuning, and high availability setups.
Oracle EBS environment management, monitoring, and troubleshooting.
Oracle EBS patch management (Application, Technology Stack, Database).
Oracle R12, AD & TXK patching, CPU/PSU patching.
Environment cloning and refresh activities
Oracle database performance tuning, backup/recovery, and RMAN.
Strong understanding of Oracle architecture, WebLogic/OHS, concurrent managers, and workflow.
SQL Server performance monitoring and tuning (Profiler, Execution Plans, DMVs, Performance Monitor).
Experience with AlwaysOn Availability Groups, log shipping, replication.
Backup and recovery strategy implementation & monitoring.
Database maintenance plans, index optimization, and security patching.
Strong analytical and troubleshooting skills.
Ability to work in a fast-paced environment with tight deadlines.
Exposure to financial services or enterprise performance management domains.
Ability to manage multiple tasks and priorities effectively.
Excellent communication skills to interact with stakeholders and provide clear updates.
Must possess good verbal and written communication and interpersonal skills
Key Responsibilities
Maintain and monitor the health, performance, and stability of Oracle EBS across DEV, TEST, UAT, and PROD environments. Support code migrations and deployments.
Apply Oracle EBS patches (application, tech stack, database) based on business, compliance, and security needs.
Identify and remediate vulnerabilities. Ensure environments remain compliant by applying R12, AD/TXK, CPU, and PSU patches in accordance with required schedules.
Perform end-to-end environment cloning procedures. Refresh UAT and DEV environments from Production as required.
Monitor SQL Server performance using standard tools; identify and resolve performance bottlenecks.
Administer and monitor high availability configurations such as AlwaysOn Availability Groups, log shipping, and replication. Manage database backups and restorations.
Configure and maintain database maintenance plans, index management, consistency checks, and apply critical security patches.
Work closely with application teams, developers, and infrastructure teams for issue resolution and optimization.
Maintain documentation for database environments, configurations, and operational procedures.
Behavioral Competencies
Effectively communicate with business and technology partners, peers and stakeholders
Ability to deliver results under demanding timelines to real-world business problems
Ability to work independently and multi-task effectively
Identify and communicate areas for improvement
Demonstrate high attention to detail, should work in a dynamic environment whilst maintaining high quality
standards, a natural aptitude to develop good internal working relationships and a flexible work ethic
Responsible for Quality Checks and adhering to the agreed Service Level Agreement (SLA) / Turn Around Time
(TAT)
