Job Title

Job Description: Oracle Database Administrator (Oracle Apps DBA)Experience: 8+ yearsLocation: Mumbai | HybridNotice Period : Upto 60daysRole OverviewWe are seeking an experienced Oracle Database Administrator / Oracle Apps DBA to manage, maintain, and support Oracle Databases and Oracle E-Business Suite (EBS) environments. The role involves database administration, application support, performance tuning, automation, security, disaster recovery, and proactive system monitoring across multiple Oracle versions.Key ResponsibilitiesDatabase AdministrationInstall, configure, upgrade, and maintain Oracle Databases (9i, 11g, 12c, 19g).Perform database creation, sizing, capacity planning, and performance tuning.Manage database users, roles, privileges, password policies, and access reviews.Handle database locking issues, space management, and object maintenance.Perform database export/import operations.Create, review, and execute DDL/DML scripts.Implement database security features such as TDE, e-wallet, DB Vault, and Oracle Key Vault.Backup, Recovery & Disaster RecoveryImplement and manage RMAN hot and cold backups.Perform backup validation and recovery testing.Configure and support Data Guard Physical Standby for disaster recovery.Proactively monitor backup jobs and resolve failures.Oracle E-Business Suite (Apps DBA)Install, upgrade, clone, and patch Oracle EBS (11i, R12 – 12.1 & 12.2).Perform application and database cloning.Manage AD utilities and Online Patching (ADOP).Administer Concurrent Managers and resolve concurrent request issues.Manage workflows and Workflow Administrator configuration.Handle SYSADMIN activities including:User administrationResponsibilities and request groupsPrinter setupForm registrationCustom application registrationSystem & Infrastructure SupportWork on Linux/Unix environments.Monitor systems proactively and address performance and availability issues.Manage log files and perform regular cleanup.Provide first-level escalation support for technical and process-related issues.Monitoring, Automation & ToolsUse Oracle Enterprise Manager (OEM 12c/13c Cloud Control) for monitoring and alerting.Develop shell scripts to automate routine DBA and Apps DBA tasks.Support and maintain WebLogic Server components.Implement automation for monitoring, maintenance, and reporting.Performance Tuning & OptimizationPerform database and application-level performance tuning.Tune SQL and PL/SQL queries using Oracle performance tools.Identify performance bottlenecks proactively and implement solutions.Governance & DocumentationPlan and schedule changes, coordinating with multiple stakeholders.Maintain technical documentation and operational runbooks.Provide subject matter expertise (SME) for Oracle Database and EBS-related issues