Software Engineer – Oracle DBA

Intertec Systems; Indore District; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Intertec Systems is seeking a Software Engineer – Oracle DBA to support Oracle Database and Oracle E-Business Suite environments. The role covers L2 incident resolution, L3 troubleshooting, performance tuning, patching, upgrades, and ensuring database and application availability.

The candidate should have 5–10 years of hands-on experience with Oracle databases (10g/11g/12c/18c/19c), Oracle EBS R12.2, RAC, RMAN, Data Guard, and Linux/Unix.

Qualifications

• Degree in Computer Science or Information Technology (or equivalent).
• 5–10 years of hands-on Oracle DB and Apps DBA experience.
• Strong Linux/Unix, SQL, and shell scripting skills.
• Experience with RMAN, Data Guard, RAC, and patching.
• Exposure to Oracle E-Business Suite R12.2 and ADOP workflows.

Responsibilities

• Install, configure, administer, and maintain Oracle databases across prod/non-prod environments.
• Monitor health, availability, performance, storage, and capacity.
• Troubleshoot incidents, connectivity issues, and resource contention.
• Analyze AWR/ASH, SQL plans, and wait events for tuning.
• Manage RMAN backups, recovery, and validation.

Skills

Oracle DBA

Linux/Unix

SQL

Shell scripting

EBS Administration

ADOP

Education

Degree in CS/IT

Tools

RMAN

Rapid Clone

AutoConfig

Data Guard

WebLogic

Oracle Enterprise Manager

Job description

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.
• Willingness to participate in rotationalshifts and on-call support.
• 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.

Stay up to date with insights from Intertec