Role & responsibilities

Detailed

Oracle Database Appliance (ODA) Administrator

Supporting IFS ERP Environment

Experience: 5-9 Years

Role Summary

We are seeking an experienced Oracle Database Appliance (ODA) Administrator to manage and support Oracle Database Appliance infrastructure hosting mission-critical IFS ERP applications.

The role will be responsible for administration, monitoring, performance tuning, patching, backup & recovery, high availability, disaster recovery, and lifecycle management of Oracle databases supporting IFS ERP production, test, and development environments.

The candidate should possess solid Oracle DBA skills combined with expertise in Oracle Database Appliance administration and enterprise ERP support. Relevant Oracle database, Exadata, ODA, migration, backup, and Oracle platform capabilities are reflected in Tech Mahindra's Oracle practice experience.

__________________________________________________

Primary Responsibilities:

Oracle Database Appliance Administration

Administer Oracle Database Appliance (ODA) environments.

ODA deployment, patching, upgrades, and lifecycle management.

Capacity planning and hardware resource utilization.

ODA monitoring and health checks.

Storage management and performance optimization.

ODA troubleshooting and root cause analysis.

__________________________________________________

Oracle Database Administration

Oracle Database 12c / 19c / 21c administration.

Database creation and cloning.

Tablespace management.

User and security administration.

Database performance tuning.

Database upgrades and migrations.

Oracle Grid Infrastructure administration.

Oracle ASM administration.





Relevant Oracle database administration and support activities are reflected in Tech Mahindra Oracle capability assets and Oracle database support engagements.

__________________________________________________

IFS ERP Database Support

Support IFS Application environments.

Database performance optimization for IFS workloads.

Troubleshoot ERP batch jobs and database issues.

Support IFS upgrades and application patches.

Analyze SQL performance impacting IFS transactions.

Coordinate with IFS application teams and infrastructure teams.

__________________________________________________

Backup, Recovery & DR

RMAN administration.

Backup validation and recovery testing.

Disaster Recovery planning and execution.

Oracle Data Guard administration.

Switchover and failover activities.

Business continuity support.

Oracle RMAN, backup automation, and Oracle HA/DR capabilities are highlighted in Oracle database support case studies.

__________________________________________________

Performance & Monitoring

AWR analysis.

ASH analysis.

SQL tuning.

Query optimization.

Index optimization.

Blocking/session analysis.

Oracle Enterprise Manager monitoring.

Performance capacity planning.

__________________________________________________

Security & Compliance

Database security administration.

User access management.

Oracle Wallet.

Transparent Data Encryption (TDE).

Audit support.

Vulnerability remediation.

Compliance reporting.

Oracle security, encryption, Wallet,



VPD, and audit monitoring are referenced in Oracle support case studies and DBA knowledge assets.

__________________________________________________

Required Technical Skills

Must Have

Oracle Database Appliance (ODA)

Oracle Database Administration

Oracle RAC

ASM

RMAN

Oracle Data Guard

Linux Administration

SQL Performance Tuning

Oracle Enterprise Manager

Preferred

IFS ERP support experience

Oracle Cloud Infrastructure (OCI)

Oracle GoldenGate

Ansible / Shell Scripting

Oracle Exadata exposure

Automation and monitoring tools

OCI, Oracle platform modernization, Exadata, and cloud migration capabilities are common within Oracle practice offerings.

__________________________________________________

Typical Day-to-Day Activities

Monitor ODA and Oracle database health.

Review database alerts and capacity.

Execute backups and recovery validation.

Perform database patching and maintenance.

Tune slow-running SQL impacting IFS users.

Support month-end and business-critical ERP processing.

Manage DR readiness and failover testing.

Work with IFS application teams on performance and availability issues.

__________________________________________________

Ideal Candidate Profile A strong fit would be:

Oracle ODA Administrator + Oracle DBA + ERP Infrastructure Support Engineer with:

3 to 5 years Oracle DBA experience

2+ years Oracle Database Appliance administration

Experience supporting ERP applications (preferably IFS, Oracle ERP, SAP, or similar)

Hands-on experience in RAC, ASM, Data Guard, RMAN, Performance Tuning, and Production

If you are interested, Please share your profile on below mail id : [email protected]

📌 Oracle Database Appliance (ODA) Administrator (Bengaluru)
🏢 Tech Mahindra
📍 Bengaluru