24 Sep
|
Intertec Systems
|
Indore
24 Sep
Intertec Systems
Indore
Technical Indore, India Permanent 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 workplace.
📌 Software Engineer – Oracle DBA (Indore)
🏢 Intertec Systems
📍 Indore