Lead Consultant(Development)

Job description

## Position **Oracle E-Business Suite (EBS) Applications DBA and OCI Admin ** **Experience:** 5–10 Years **Employment Type:** Full-Time *** ## Job Summary We are seeking an experienced Oracle E-Business Suite (EBS) Applications DBA with 5–10 years of hands-on experience supporting enterprise-scale Oracle EBS environments. The ideal candidate should possess strong expertise in Oracle EBS administration, database management, performance tuning, troubleshooting, upgrades, high-availability architectures, disaster recovery, and complex multi-node deployments. The role demands deep technical knowledge of Oracle EBS R12.2, Oracle Database administration, middleware technologies, and cloud/on-premises infrastructure, along with the ability to resolve critical production issues and support business-critical applications in a 24x7 environment. # Key Responsibilities ## Oracle EBS Administration * Install, configure, upgrade, patch, and maintain Oracle EBS R12.2 environments. * Perform EBS application and database upgrades, migrations, and technology stack upgrades. * Manage and support multi-node and large-scale EBS production environments. * Execute application and database cloning, refreshes, and environment provisioning activities. * Administer ADOP online patching cycles and troubleshoot patching-related issues. * Support EBS integrations with third-party applications and external systems. ## Database Administration * Administer Oracle Databases (19c, 23ai, and newer versions as applicable). * Configure, maintain, and monitor Oracle Data Guard and Standby databases. * Plan and execute database patching, upgrades, backup, recovery, and disaster recovery activities. * Perform database capacity planning, space management, and storage optimization. * Implement and maintain high-availability solutions and DR architectures ## Performance Tuning & Optimization * Analyze and resolve application, database, and concurrent processing performance issues. * Perform Advanced SQL Tuning, Query Optimization, AWR, ASH, ADDM, TKPROF, and Statspack analysis. * Monitor and tune Oracle EBS Concurrent Managers, Workflow components, Forms, Reports, and WebLogic services. * Identify performance bottlenecks across application, database, middleware, network, and infrastructure layers. * Optimize JVM performance, WebLogic domains, Apache configurations, and database parameters. * Conduct proactive health checks and recommend performance improvement initiatives. * Analyze execution plans and implement indexing and optimizer recommendations. ## Complex Architecture Support * Support complex Oracle EBS deployments consisting of: * Multi-node Application Tier * RAC Databases * Oracle Data Guard * Disaster Recovery Environments * Load Balancers * DMZ Architectures * PCP (Parallel Concurrent Processing) * SSO and Identity Integration * OCI-hosted EBS Environments * Participate in architecture reviews and implementation of highly available EBS environments. * Troubleshoot cross-tier issues spanning application, middleware, database, storage, and network components. ## Security & Compliance * Apply Oracle Critical Patch Updates (CPU), Security Patches, and Regulatory Compliance updates. * Implement and maintain SSL/TLS certificates across EBS environments. * Ensure compliance with corporate security policies and audit requirements. * Support vulnerability remediation and security assessments. ## Troubleshooting & Production Support * Lead major incident resolution and root cause analysis activities. * Troubleshoot complex issues related to: * EBS Services * WebLogic Server * Concurrent Processing * XML Publisher * Workflow Mailers * Oracle Forms and Reports * Database Performance * Integration Failures * Coordinate with Oracle Support and manage Service Requests (SRs) through resolution. * Develop problem management procedures and preventive maintenance practices. * Provide 24×7 production support and particip ## Automation & Cont Key Responsibilities ## Position **Oracle E-Business Suite (EBS) Applications DBA and OCI Admin ** **Experience:** 5–10 Years **Employment Type:** Full-Time *** ## Job Summary We are seeking an experienced Oracle E-Business Suite (EBS) Applications DBA with 5–10 years of hands-on experience supporting enterprise-scale Oracle EBS environments. The ideal candidate should possess strong expertise in Oracle EBS administration, database management, performance tuning, troubleshooting, upgrades, high-availability architectures, disaster recovery, and complex multi-node deployments. The role demands deep technical knowledge of Oracle EBS R12.2, Oracle Database administration, middleware technologies, and cloud/on-premises infrastructure, along with the ability to resolve critical production issues and support business-critical applications in a 24x7 environment. # Key Responsibilities ## Oracle EBS Administration * Install, configure, upgrade, patch, and maintain Oracle EBS R12.2 environments. * Perform EBS application and database upgrades, migrations, and technology stack upgrades. * Manage and support multi-node and large-scale EBS production environments. * Execute application and database cloning, refreshes, and environment provisioning activities. * Administer ADOP online patching cycles and troubleshoot patching-related issues. * Support EBS integrations with third-party applications and external systems. ## Database Administration * Administer Oracle Databases (19c, 23ai, and newer versions as applicable). * Configure, maintain, and monitor Oracle Data Guard and Standby databases. * Plan and execute database patching, upgrades, backup, recovery, and disaster recovery activities. * Perform database capacity planning, space management, and storage optimization. * Implement and maintain high-availability solutions and DR architectures ## Performance Tuning & Optimization * Analyze and resolve application, database, and concurrent processing performance issues. * Perform Advanced SQL Tuning, Query Optimization, AWR, ASH, ADDM, TKPROF, and Statspack analysis. * Monitor and tune Oracle EBS Concurrent Managers, Workflow components, Forms, Reports, and WebLogic services. * Identify performance bottlenecks across application, database, middleware, network, and infrastructure layers. * Optimize JVM performance, WebLogic domains, Apache configurations, and database parameters. * Conduct proactive health checks and recommend performance improvement initiatives. * Analyze execution plans and implement indexing and optimizer recommendations. ## Complex Architecture Support * Support complex Oracle EBS deployments consisting of: * Multi-node Application Tier * RAC Databases * Oracle Data Guard * Disaster Recovery Environments * Load Balancers * DMZ Architectures * PCP (Parallel Concurrent Processing) * SSO and Identity Integration * OCI-hosted EBS Environments * Participate in architecture reviews and implementation of highly available EBS environments. * Troubleshoot cross-tier issues spanning application, middleware, database, storage, and network components. ## Security & Compliance * Apply Oracle Critical Patch Updates (CPU), Security Patches, and Regulatory Compliance updates. * Implement and maintain SSL/TLS certificates across EBS environments. * Ensure compliance with corporate security policies and audit requirements. * Support vulnerability remediation and security assessments. ## Troubleshooting & Production Support * Lead major incident resolution and root cause analysis activities. * Troubleshoot complex issues related to: * EBS Services * WebLogic Server * Concurrent Processing * XML Publisher * Workflow Mailers * Oracle Forms and Reports * Database Performance * Integration Failures * Coordinate with Oracle Support and manage Service Requests (SRs) through resolution. * Develop problem management procedures and preventive maintenance practices. * Provide 24×7 production support and particip ## Automation & Cont Skill Requirements ## Position **Oracle E-Busines