Sr. Consultant - Oracle Apps DBA

Date: Nov 3, 2026

Job Requisition Id: 66942

Location

Pune, MH, IN Hyderabad, IN Pune, IN

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.

At YASH, we’re a cluster of the brightest stars working with cutting\-edge technologies. Our purpose is anchored in a single truth – bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.

• *We are looking forward to hire Oracle Apps DBA Professionals in the following areas :**

• *Position Title**

• *Senior Oracle Apps DBA \+ Data Warehouse Consultant**

• *Experience Required**

• *8\-10\+ Years**

• *Job Location**

• *Pune / Hyderabad (Hybrid)**

• *Job Summary**

We are seeking an experienced **Oracle Apps DBA \+ Data Warehouse Consultant** with **8\-10\+ years of hands\-on experience** in Oracle E\-Business Suite administration, Oracle Database management, infrastructure support, and Data Warehouse environments. The ideal candidate should possess strong expertise in **Oracle EBS R12\.1/R12\.2**, **Oracle Database 12c/19c**, high\-availability architectures, cloud exposure, performance tuning, system migrations, and enterprise data platforms.

The role requires ownership of end\-to\-end Oracle applications administration, database performance, patching, cloning, disaster recovery, environment management, and support for enterprise reporting and data warehousing initiatives. Experience in cloud technologies, automation, and large\-scale production support environments will be highly preferred.

• *Key Responsibilities**

• *Oracle Apps DBA Administration**

• *Oracle EBS Environment Management**

• Administer and support Oracle E\-Business Suite R12\.1/R12\.2 environments.
• Manage multi\-node, shared application tier, and high\-availability environments.
• Perform system monitoring, troubleshooting, and performance optimization.
• Maintain Production, UAT, Development, DR, and Testing environments.
• Manage Oracle Forms, Reports, Workflow, Concurrent Processing, WebLogic, and Oracle Fusion Middleware components.
• Support business\-critical Oracle EBS operations with minimal downtime.

• *Oracle EBS Cloning \& Refresh Activities**

• Execute end\-to\-end application and database cloning activities.
• Perform Rapid Clone configuration and post\-clone activities.
• Manage refreshes across DEV/UAT/TEST/DR environments.
• Troubleshoot cloning\-related issues and ensure environment integrity.

• *Oracle Patching \& Upgrades**

• Perform Oracle EBS Online Patching using ADOP.
• Apply CPU, PSU, RUP, TXK, and technology stack patches.
• Manage Oracle EBS point upgrades and technology stack upgrades.
• Coordinate system patching with cross\-functional teams.
• Plan and execute patch testing, cutover activities, and rollback procedures.

• *Oracle Database Administration**

• Administer Oracle 12c, 19c databases in highly available environments.
• Perform database installation, upgrades, migrations, and maintenance.
• Configure and support RAC, Data Guard, ASM, and RMAN.
• Monitor database performance and capacity planning.
• Troubleshoot complex database issues and optimize database performance.

• *Backup, Recovery \& Disaster Recovery**

• Define and maintain backup and recovery strategies.
• Perform RMAN backup/recovery operations.
• Conduct periodic DR drills and failover testing.
• Manage standby databases and Data Guard environments.
• Ensure compliance with organizational RPO and RTO objectives.

• *Performance Tuning \& Optimization**

• *Database Performance Tuning**

• Analyze AWR, ASH, ADDM, Statspack reports.
• Perform SQL tuning and execution plan analysis.
• Resolve database bottlenecks and resource contention issues.
• Optimize storage, indexing strategies, and database configurations.

• *Oracle EBS Performance Tuning**

• Tune Concurrent Managers and Workflow processes.
• Optimize forms, reports, interfaces, and custom programs.
• Monitor application server performance.
• Identify and resolve EBS\-specific performance challenges.

• *Security \& Compliance Management**

• Manage Oracle EBS users, responsibilities, menus, and security profiles.
• Implement segregation of duties (SoD) and audit requirements.
• Support internal and external compliance audits.
• Review and maintain Oracle application security controls.
• Manage SSL certificates, wallet configurations, and encryption mechanisms.

• *Automation \& Scripting**

• Develop shell scripts for administration and monitoring activities.
• Automate routine DBA and application support tasks.
• Implement proactive monitoring and alerting mechanisms.
• Create deployment automation and health\-check utilities.
• Support CI/CD integrations where applicable.

• *Data Warehouse Responsibilities**

• *Enterprise Data Warehouse Support**

• Support Oracle Data Warehouse environments and reporting platforms.
• Manage ETL schedules, monitoring, and performance optimization.
• Work closely with reporting and analytics teams.
• Ensure data quality and consistency across warehouse systems.
• Support enterprise BI reporting requirements.

• *Data Modeling \& Architecture**

* Understand and support

• + Star Schema

+ Snowflake Schema

+ Fact and Dimension Modeling

+ Slowly Changing Dimensions (SCD)

+ Data Governance Standards

• Collaborate with business and data teams for reporting and analytics initiatives.

• *ETL \& Integration Support**

Hands\-on experience with one or more

• Oracle Data Integrator (ODI)
• Informatica PowerCenter
• Talend
• SSIS
• Apache NiFi

Responsibilities include

• ETL job deployment and monitoring
• Data reconciliation
• Workflow troubleshooting
• Performance improvements
• Data quality validation

• *Data Lake \& Modern Data Platform Exposure**

Preferred experience in

• Data Lake architecture concepts
• Structured and unstructured data management
• Data ingestion frameworks
• Metadata and data catalog solutions
• Enterprise analytics ecosystems

Exposure to

• Azure Data Lake
• Azure Data Factory
• Synapse Analytics
• Hadoop Ecosystem
• Snowflake
• Databricks

will be considered a strong advantage.

• *Cloud \& Infrastructure Skills (Preferred)**

• *Oracle Cloud Infrastructure (OCI)**

• OCI Database Services
• OCI Compute
• OCI Storage
• OCI Backup \& Recovery
• OCI Monitoring

• *Microsoft Azure (Preferred)**

• Azure Virtual Machines
• Azure Storage
• Azure Backup
• Azure Monitoring
• Azure Data Services

• *AWS (Good to Have)**

• EC2
• RDS Oracle
• S3
• CloudWatch

• *Required Technical Skills**

• *Oracle Technologies**

• Oracle EBS R12\.1/R12\.2
• Oracle Database 12c/19c
• Oracle RAC
• Oracle Data Guard
• ASM
• RMAN
• Oracle Enterprise Manager (OEM)
• WebLogic Administration
• Oracle Fusion Middleware

• *Development \& Query Skills**

• SQL
• PL/SQL
• Performance Tuning
• Query Optimization
• Database Diagnostics

• *Operating Systems**

• Linux
• Unix
• AIX

• *Scripting**

• Shell Scripting
• Bash
• Korn Shell
• Python (Good to Have)

• *Leadership \& Support Responsibilities**

• Lead major production activities and maintenance exercises.
• Mentor junior DBAs and support team members.
• Participate in architecture reviews and infrastructure planning.
• Coordinate with Oracle Support for critical issue resolution.
• Drive RCA preparation and problem management processes.
• Participate in 24x7 production support and escalation management.

• *Soft Skills**

• *Stakeholder Management**

• Ability to work with business users, functional consultants, infrastructure teams, and leadership.
• Strong customer\-facing communication skills.

• *Problem Solving**

• Strong analytical and troubleshooting capabilities.
• Ability to handle critical production incidents under pressure.

• *Ownership \& Accountability**

• Demonstrated ability to independently manage enterprise environments.
• Strong commitment to service delivery and operational excellence.

• *Team Collaboration**

• Experience working in globally distributed teams.
• Excellent documentation and knowledge\-sharing practices.

• *Preferred Certifications**

• Oracle Certified Professional (OCP) Database Administrator
• Oracle E\-Business Suite R12 Certification
• Oracle Cloud Infrastructure Certification
• Microsoft Azure Fundamentals / Administrator
• ITIL Foundation Certification

• *Education**

• Bachelor's or Master's Degree in Computer Science, Information Technology, Engineering, or a related field.

At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career\-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.

• *Our Hyperlearning workplace is grounded upon four principles**

• Flexible work arrangements, Free spirit, and emotional positivity
• Agile self\-determination, trust, transparency, and open collaboration
• All Support needed for the realization of business goals,
• Stable employment with a great atmosphere and ethical corporate culture