OEM/DBA (Oracle Enterprise Manager) (Mumbai)

- Oracle 12c/19c/21c /26Ai architecture - OEM 24AI new feature knowledge - ASM & storage management - Exadata (Smart Scan, Storage Indexes, HCC) - GoldenGate (replication & migration scenarios) - Database upgrades & migration strategies - Edition-Based Redefinition (EBR) - SQL Plan Management (SPM) - Real Application Testing (RAT) - Resource Manager - Connection pooling (WebLogic, application integration) - Linux performance diagnostics (vmstat, iostat, top, sar) - Network latency analysis - Cloud exposure (OCI preferred) BE/BTech and/or MS in Computer Science or equivalent preferred. 10+ years of enterprise Oracle database experience with 3+ years of preferred hands-on banking/financial services. Expert-level experience in: - Oracle RAC - Data Guard / Active Data Guard - RMAN - AWR/ASH performance diagnostics - Partitioning & Advanced Compression - OEM Strong experience in large OLTP workloads (high TPS environments). Experience handling multi-terabyte databases. Strong scripting/automation experience (Shell, Python, Ansible). 1. Performance Engineering & Optimization (Core Focus) Lead advanced performance tuning using: - AWR/ASH analysis - SQL tracing - Execution plan deep analysis - Wait-event methodology - SQL Monitor & Real-Time ADDM Diagnose systemic issues (I/O bottlenecks, latch contention, memory pressure, CPU saturation). Optimize: - Indexing strategies - Partitioning strategies - Query rewrites - PL/SQL optimization - Connection pooling patterns Establish performance baselines for OLTP-heavy core banking workloads. 2. High Availability & Disaster Recovery Architect and manage: - Oracle RAC (multi-node clustering) - Data Guard / Active Data Guard - DR drills & failover simulations Own RPO/RTO alignment with banking regulatory requirements. Design backup & recovery frameworks (RMAN, incremental merge, backup validation). Ensure DR readiness with periodic validation and audit documentation. 3. Banking Domain Alignment - Leads client situations in crisis management, positive executive communication and cross-functional leadership to Leadership Competencies, e.g. Lead crisis resolution for Sev1/Sev2 database incidents and delivers executive-ready RCA reports. - Aligns with cross-functional stakeholders (IT, business, audit) in large banking teams - Communicate complex database risk and strategy to C-suite executives and regulatory auditors. - Ensure compliance with RBI/central bank guidelines and audit standards. - Support high transaction throughput environments (large OLTP systems). Support mission-critical systems such as: - Core Banking (CBS) - UPI / Payments / Switch systems - Treasury systems - Risk & Compliance platforms - Data Warehouse & Regulatory reporting 4. Security & Compliance Implement database hardening and security best practices: - Role-based access control - Privilege minimization - Database Vault (if applicable) - Transparent Data Encryption (TDE) - Data masking for non-prod environments Support audit requirements and regulatory inspections. Ensure encryption at rest and in transit (SSL/TLS, wallet management). 5. Automation & Operational Excellence Develop automation using: - Shell / Python - Ansible - Infrastructure-as-Code principles Standardize patching, upgrade, and rollback frameworks. Enhance observability via OEM / custom monitoring. Improve MTTD/MTTR via structured incident response and RCA processes. 6. OEM Job Responsibility - Design and manage enterprise-wide OEM architecture for large banking environments - Define monitoring strategy for databases, RAC, Data Guard, middleware, and applications - Implement advanced alerting, event correlation, and noise reduction - Lead OEM upgrades, patching, and high availability setup - Drive automation using OEM jobs, corrective actions, and scripts - Ensure OEM supports audit, compliance, and regulatory reporting needs - Perform capacity planning and performance trend analysis - Integrate OEM with ticketing/ITSM tools for incident management - Handle critical escalations and work with Oracle Support for platform issues 7. Skills Required: - Deep expertise in OEM 13c/24 AI architecture (OMS, OMR, Agents) - Strong knowledge of Oracle DB, RAC, Data Guard, Exadata (if applicable) - Experience in monitoring strategy, alert tuning, and automation - Knowledge of repository database performance and OEM scalability - Scripting (Shell/Python) for automation - Understanding of banking compliance and audit requirements Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying. .