SME DBA

Oracle’s Support organization helps customers succeed after purchase by delivering high-quality support, troubleshooting, and best-practice guidance across Oracle technologies. The team serves as an advocate for customer needs, partnering closely with internal engineering, operations, and architecture groups to resolve complex issues, improve service reliability, and drive measurable outcomes in availability and performance.

Key Responsibilities
Define and govern enterprise Oracle database architecture  for mission-critical banking systems, including standards for scalability, resilience, lifecycle, consolidation, and capacity planning.
Architect HA/DR topologies  across data center and disaster recovery sites using Oracle RAC, Data Guard/Active Data Guard, and zero/near-zero downtime patterns (e.g., rolling upgrades, Edition-Based Redefinition).
Lead advanced performance engineering  for OLTP-heavy workloads using AWR/ASH, SQL trace, execution plan analysis, wait-event methodology, SQL Monitor, and Real-Time ADDM; establish baselines and performance dashboards.
Diagnose and remediate systemic bottlenecks  (I/O, CPU, memory, contention, network latency) and optimize indexing, partitioning, query design, PL/SQL, and connection pooling patterns.
Own RPO/RTO and DR assurance  aligned to banking regulatory expectations; plan and execute DR drills/failover simulations, maintain audit-ready evidence, and validate backup/recovery frameworks (RMAN, incremental merge, restore testing).
Drive security hardening and compliance  including least privilege/RBAC, TDE, encryption in transit (SSL/TLS), wallet management, data masking for non-prod, and audit support (including regulator-facing readiness).
Increase operational excellence through automation and observability  using Shell/Python/Ansible and IaC principles; standardize patch/upgrade/rollback processes; improve MTTD/MTTR via structured incident response.
Lead stakeholder engagement and technical governance  across Core Banking, Payments/UPI, Digital Channels, Treasury, Risk/Compliance, and Reporting; mentor senior DBAs and influence architecture decisions through reviews and CABs.

Mandatory (Must-Have)

Experience:

15+ years in enterprise Oracle Database administration/engineering, including  8+ years in architecture design & governance , plus  5+ years supporting banking/financial services  platforms.
Core HA/DR expertise:  Oracle  RAC ,  Data Guard/Active Data Guard , DR topology design, DR drills, and RPO/RTO ownership for 24x7 environments.
Performance engineering mastery:  AWR/ASH diagnostics, SQL tracing, execution plan deep analysis, wait-event methodology, SQL Monitor/Real-Time ADDM; proven tuning for  high-TPS OLTP  systems.
Backup/Recovery:  Expert-level  RMAN  design, validation, and recovery readiness; experience with multi-terabyte databases.
Oracle architecture depth:  Oracle  12c/19c/21c and Oracle Database 26ai  architecture knowledge; ASM/storage management; strong understanding of partitioning and compression.
Operations tooling:  OEM (Oracle Enterprise Manager) and strong Linux performance fundamentals (e.g., iostat, vmstat, sar, top).
Automation:  Hands-on scripting/automation using  Shell and/or Python , plus  Ansible  (or equivalent) to standardize and reduce risk in run operations.
Cloud:
OCI exposure is required  (designing, operating, or migrating Oracle database workloads on OCI); ability to align cloud adoption with banking security/compliance needs.
Leadership and communication:  Ability to lead Sev1/Sev2 database incidents, deliver executive-ready RCA, and communicate risk/strategy to senior stakeholders including auditors.