Core Database Administrator

Performance Engineering Optimization (Core Focus)

• AWR/ASH analysis
• SQL tracing
• Execution plan deep analysis
• Wait-event methodology
• SQL Monitor Real-Time ADDM

• Indexing strategies
• Partitioning strategies
• Query rewrites
• PL/SQL optimization
• Connection pooling patterns

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.

Banking Domain Alignment

• Support mission-critical systems such as:
• Core Banking (CBS)
• UPI / Payments / Switch systems
• Treasury systems
• Risk Compliance platforms
• Data Warehouse Regulatory reporting
• Ensure compliance with RBI/central bank guidelines and audit standards.
• Support high transaction throughput environments (large OLTP systems).

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).

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.

Required Experience

• 10+ years of enterprise Oracle database experience with 3+ years of preferred hands-on banking/financial services.
• Expert-level experience in:
  • Oracle RAC
  • 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).
• Experience in Pre-Sales for Oracle, MS-SQL, Open source Database
• Hands-on experience with multicloud - OCI, Azure, AWS, GCP
• Ability to execute DBA tasks such as Upgrade, migration.
• Experience with Golden Gate replications
• Experience with SQL Server AG
• Experience with Weblogic upgrade

Technical Skills (Expanded)

• Oracle 12c/19c/21c /26Ai architecture
• 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)

Preferred Qualifications

• Oracle OCP / OCM certification.
• Experience with Exadata or engineered systems.
• Exposure to cloud-native database architectures.
• Experience in regulatory audits within banking sector.