Data Engineer

Key Responsibilities

1. Technical Escalation & High-Severity Incident Management (L3 Support)

• Act as the senior L3 technical authority for Oracle Core and EBS databases, supporting day-to-day BAU tasks, Incident Management, and Requests for Change (RFCs).

• Lead diagnostic efforts during complex technical disruptions and actively engage to drive rapid resolution of high-severity/critical production incidents.

• Guarantee overall production readiness across all supported database environments in alignment with strict Service Level Agreements (SLAs).

• Review proposed technology changes to identify potential operational risks and ensure zero-downtime execution.

2. Service Improvement & Infrastructure Optimization

• Proactively propose continuous service improvements for all Oracle and EBS services across the organization.

• Provide reactive and proactive technical expertise to safeguard system availability, performance, and disaster recovery capabilities.

• Champion operational efficiency by adhering to global IT frameworks and LEAN-CA-CIB best practices.

• Maintain global IT perspective and anticipate interrelationships across interconnected organizational platforms.

3. Strategic Collaboration & Transformation

• Partner closely with technical peers, Development teams, Service Managers, Solution Architects, and Project Managers on project delivery and technical roadmaps.

• Facilitate strategic IT transformation initiatives and recommend future directions for platform enhancements.

• Continuously evaluate emerging database technologies and industry trends to assess their feasibility for integration into Bank operations.

Technical Qualifications & Skills

Mandatory Requirements (Must Have)

• Oracle Core & EBS Expertise: Deep technical expertise as an Oracle Core & Apps DBA with extensive hands-on experience in EBS R12.1.x and R12.2.x environments, as well as Oracle 12c and 19c databases within RAC environments.

• Exadata & High Availability Architecture: Hands-on working experience with Oracle ExaCC, RAC, and Data Guard (Physical Standby, Snapshot Standby, Switchover, and Failover).

• ExaCC Patching: Proven track record in executing ExaCC patching across DOM0, DOMU, GRID, and DATABASE layers.

• Upgrades & Migrations: Proven record of successfully executing at least one database upgrade from 11g to 12c / 12c to 19c, alongside an EBS Application upgrade from 12.1.3 to 12.2.x.

• EBS High Availability Design: Deep experience maintaining multi-node EBS High Availability setups, including:

  • Database Nodes: RAC, Active Data Guard.

  • Web/Forms Nodes: Load-balanced Web and Forms nodes, Servlets, DNS/Network configuration.

  • Processing & Nodes: Parallel Concurrent Processing (PCP) load distribution and adding EBS nodes within shared application tier filesystems.

• Patching & Maintenance: Proficiency in applying CPU/PSU security patches (Opatch and ADOP), performing instance cloning/refreshes, and running installations in complex multi-node environments.

• Troubleshooting & Performance Tuning: Advanced troubleshooting capabilities in resolving critical issues across Concurrent Managers (CM), Apache, and Database engines, alongside expertise in SQL query fine-tuning.

Desirable Requirements (Good to Have)

• Automation & Scripting: Strong scripting skills using Shell, Ansible, or Python to automate repetitive DBA administrative tasks.

• Data Replication: Hands-on experience configuring and troubleshooting Oracle GoldenGate replication components.

• Cloud & Cloud Database Services: Knowledge of Oracle Cloud Infrastructure (OCI) and DbaaS utilities.

• Domain Experience: Prior experience within the Banking or Financial Services (BFSI) sector.

Candidate Profile & Soft Skills

• Experience Level: Senior-level experience as an L3 Oracle/EBS DBA capable of working under high-pressure, critical production environments.

• Communication: Exceptional verbal and written communication skills suitable for reporting to management and collaborating with cross-functional teams.

• Interpersonal & Team Dynamics: Highly independent, self-motivated worker combined with strong teamwork and interpersonal capabilities.

• Problem-Solving Mindset: Analytical thinker driven by operational excellence, risk mitigation, and proactive solution design.