Software Engineer – Oracle DBA

Job Title: Software Engineer – Oracle DBA

Job Purpose: We are seeking an experienced Oracle DBA and OracleApps DBA to support customer Oracle Database and Oracle E-Business Suite (EBS)environments. The role involves L2 incident resolution, L3 troubleshooting, performancetuning, patching, upgrades, and maintaining database and applicationavailability.

Qualification: Degree in Computer Science, Information Technology, or equivalentpractical experience.

Experience: 5-10 Years

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 database recovery. 
• Experience with ADOP, AutoConfig, Rapid Clone,  and concurrent processing. 
• Strong troubleshooting skills across Oracle  databases, EBS application services, and Linux/Unix. 
• Experience with SQL tuning, performance  diagnostics, and capacity management. 
• Proficiency in SQL, working knowledge of  PL/SQL, and shell scripting. 

Mandatory:

• Experience working within incident, problem,and change-management processes. 
• Clear customer communication andtechnical documentation skills. 
• Willingness to participate in rotationalshifts and on-call support. 
• Oracle Database Administration certification. 
• Experience with Oracle Enterprise Manager. 
• Exposure to Oracle Cloud Infrastructure anddatabase or EBS migrations. 
• Experience with TDE, database auditing, andsecurity remediation. 
• Experience supporting multiple customers in amanaged-services environment. 

‍