Oracle DBA

Path Infotech Ltd.; Chennai; On-site; INR 1,200,000 - 1,700,000; Full time

Job summary

Path Infotech Ltd. is looking for an experienced Database Manager in Chennai, India, with 7-15 years of experience in enterprise Oracle databases. The role requires expert knowledge in performance engineering, high availability, disaster recovery, and security compliance in banking systems. Candidates should have strong automation skills and experience managing OLTP workloads. The position offers opportunities to lead crisis management and collaborate with cross-functional teams to ensure compliance with banking regulations.

Qualifications

• Expert-level experience in Oracle RAC, Data Guard / Active Data Guard, and RMAN.
• Strong scripting/automation experience (Shell, Python, Ansible).
• Experience handling multi-terabyte databases.

Responsibilities

• Lead advanced performance tuning using AWR/ASH analysis.
• Architect and manage Data Guard / Active Data Guard.
• Align with cross-functional stakeholders in large banking teams.
• Implement database hardening and security best practices.
• Standardize patching, upgrade, and rollback frameworks.

Skills

ASM & storage management

Exadata (Smart Scan, Storage Indexes, HCC)

Real Application Testing (RAT)

Resource Manager

Shell scripting

Python scripting

Ansible

Education

10+ years of enterprise Oracle database experience

Tools

Oracle RAC

Data Guard

RMAN

OEM

Job description

Experience (Years): 7-15

Skills

• ASM & storage management
• Exadata (Smart Scan, Storage Indexes, HCC)
• Edition-Based Redefinition (EBR)
• Real Application Testing (RAT)
• Resource Manager
• Connection pooling (WebLogic, application integration)

Qualification

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

Roles and Responsibilities

1. Performance Engineering & Optimization (Core Focus)

Lead advanced performance tuning using:

• AWR/ASH analysis
• SQL Monitor & Real‑Time ADDM

Diagnose systemic issues (I/O bottlenecks, latch contention, memory pressure, CPU saturation).

Optimize:

• Indexing 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:

• 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, 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:

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

4. Security & Compliance

Implement database hardening and security best practices:

• Role‑based access control
• 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

• Standardize patching, upgrade, and rollback frameworks.
• Enhance observability via OEM / custom monitoring.
• Improve MTTD/MTTR via structured incident response and RCA processes.