Sr. Consultant - Oracle Apps DBA Job

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