Job Summary
DBA Key Responsibilities
Position is expected to work on-site at Client Premises in a 24X7 shift.
Candidate will have 5+ years of experience with Oracle Database with role as
n DBA/Consultant/Data Base Support Engineer. Academic Qualifications with
BE/BTech and/or MS in Computer Science or equivalent preferred.
1. Performance Engineering & Optimization (Core Focus)
• Lead advanced performance tuning using:
o AWR/ASH analysis
o SQL tracing
o Execution plan deep analysis
o Wait-event methodology
o SQL Monitor & Real-Time ADDM
• Diagnose systemic issues (I/O bottlenecks, latch contention, memory pressure, CPU saturation).
• Optimize:
o Indexing strategies
o Partitioning strategies
o Query rewrites
o PL/SQL optimization
o Connection pooling patterns
• Establish performance baselines for OLTP-heavy core banking workloads.
2. High Availability & Disaster Recovery
• Architect and manage:
o Oracle RAC (multi-node clustering)
o Data Guard / Active Data Guard
o 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, good 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.
• Support mission-critical systems such as:
o Core Banking (CBS)
Confiden'al - Oracle Restricted \Employees Only
Confiden'al - Oracle Restricted \Employees Only
o UPI / Payments / Switch systems
o Treasury systems
o Risk & Compliance platforms
o Data Warehouse & Regulatory reporting
• Ensure compliance with RBI/central bank guidelines and audit standards.
• Support high transaction throughput environments (large OLTP systems).
4. Security & Compliance
• Implement database hardening and security best practices:
o Role-based access control
o Privilege minimization
o Database Vault (if applicable)
o Transparent Data Encryption (TDE)
o 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:
o Shell / Python
o Ansible
o 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:
o Oracle RAC
o Data Guard / Active Data Guard
o RMAN
o AWR/ASH performance diagnostics
o Partitioning & Advanced Compression
o OEM
• Strong experience in large OLTP workloads (high TPS environments).
• Experience handling multi-terabyte databases.
• Strong scripting/automation experience (Shell, Python, Ansible).
Confiden'al - Oracle Restricted \Employees Only
Confiden'al - Oracle Restricted \Employees Only
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.