Job Description

Job Summary:

To manage and deliver

infrastructure, middleware, and database transformation projects

for mission-critical

banking applications

, ensuring stability, compliance and high availability. The role requires strong expertise in

Oracle Database, Middleware (WebLogic, Forms & Reports), integration tools and project delivery

, along with proven leadership in managing stakeholders, migrations and regulatory-driven projects across APAC.

Key Responsibilities:

Lead

end-to-end project delivery

(requirement gathering, design, capacity planning, scheduling, execution, testing, and go-live). Lead

end-to-end migration projects

covering database, middleware, scheduling tools, and OS platforms, ensuring smooth transition with zero business disruption. Manage

infrastructure migration projects

(OS upgrades, DB migrations, Middleware upgrades, Autosys job transitions, MQ/SSO migrations). Coordinate with

stakeholders, vendors, and cross-functional teams

across multiple countries to ensure timely project execution. Oversee

production L3 support

for middleware & DB environments, ensuring compliance with

regulatory standards (e.g., OCC)

. Install and configure

Oracle Databases (9i-19c)

, including RAC and standalone environments, with proper sizing, storage allocation, and security hardening. Perform

installation and configuration of Oracle WebLogic Server (12c/14c)

, including creating domains, clusters, and managed servers for high availability setups. Set up and configure

Oracle Forms & Reports infrastructure

, including instance creation, runtime configuration, and integration with WebLogic domains. Design and configure

JDBC data sources, connection pools, and deployment environments

for applications (WAR/EAR). Configure

SSL/TLS, SSO (SiteMinder/Secure SSO)

, and other security components during middleware installation. Fine-tune

Oracle Forms & Reports runtime parameters

, ensuring faster response times and stable concurrent user sessions. Analyse and resolve

Forms rendering issues, report generation delays, and session bottlenecks

in production environments. Perform

SQL query tuning and optimization

using execution plans, indexes and bind variables to improve transaction performance in critical banking applications. Analyze

AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor) reports

to identify system bottlenecks, inefficient queries, and resource-heavy sessions. Optimize

PL/SQL procedures, packages, and migration scripts

, reducing execution time and improving efficiency in large-scale data migration projects. Monitor

database memory structures (SGA, PGA)

and adjust configurations for optimal throughput. Fine-tune

database parameters, indexes, and statistics

to ensure high availability and minimal response time. Collaborate with application developers and business analysts to

review SQL code

and recommend improvements before production deployment. Support

client teams

by providing recommendations for SQL & DB environment performance improvements. Ensure

database tuning practices comply with audit and performance SLAs

for mission-critical banking systems.

Design, develop, and maintain shell scripts

to automate routine database, middleware, and application administration tasks (backups, monitoring, job scheduling, log rotation, file transfers).

Enhance existing scripts

by improving error handling, logging, and performance optimization to ensure reliability in production environments.

Troubleshoot and fix script-related issues

in BAU (Business-As-Usual) and project environments, ensuring minimal business impact. Collaborate with application and infrastructure teams to

analyze requirements and implement script-based solutions

for new business or infra needs. Develop

custom utility scripts

for infra monitoring, batch job automation, and report generation. Conduct

code reviews and knowledge sharing

to improve team scripting standards. Conduct

risk assessment, impact analysis, and mitigation planning

for project delivery.

Plan and coordinate High Availability (HA) setups

for critical banking applications, ensuring minimal downtime and adherence to RTO/RPO targets. Ensure

HA/DR/COB exercises are defect-free

, with successful cutover, fallback, and validation of infra components (DB, Middleware, MQ, Autosys, File transfers).

Design, implement, and validate Disaster Recovery (DR) strategies

across primary and secondary data centers, ensuring readiness for failover in case of outages or incidents Act as

primary coordinator during critical failover situations

, ensuring seamless business continuity without impact to end users

Coordinate annual and ad-hoc Continuity of Business (COB) testing

across APAC markets, involving multi-country stakeholders, to validate business continuity and regulatory compliance. Drive

automation initiatives

(shell scripting, SQL optimization, job scheduling improvements) to improve system reliability. Provide

technical leadership

and mentor junior team members in database, middleware, and project delivery best practices. Prepare and deliver

project status reports

to senior management and client stakeholders.

Technology Skills Required:

Databases:

Oracle (9i-19c), RAC, SQL Tuning, AWR/ADDM Analysis, ORaaS Cloud

Middleware & Application Servers:

Oracle WebLogic 12c/14c, Forms & Reports, Open Liberty (preferred)

Integration & Messaging:

IBM MQ, Connect:Direct, SFTP, RabbitMQ

Scheduling Tools:

Autosys, Tivoli (TWS)

Monitoring & Security:

AppDynamics, Splunk, ServiceNow, ITRS, CyberArk, SiteMinder / Secure SSO

OS & Infra:

RHEL7/8, AIX, HP-UX, Windows Server

Scripting & Automation:

Shell scripting (Linux/Unix), SQL optimization

Banking Applications:

Corporate Transaction Banking (Receivables, Payables, Reconciliation)

Qualifications & Experience:

15+ years of IT experience

in

Database Administration, Middleware, and IT Project Delivery

(banking/financial services preferred). Proven experience in

managing infra migration projects

(DB, Middleware, OS, Autosys, MQ, SSO). Strong knowledge of

banking application environments

and

regulatory compliance (OCC, audit)

. Hands-on expertise in

SQL performance tuning & shell scripting

. Experience in

stakeholder management

across multiple regions (APAC preferred).

Key Attributes:

Strong leadership and problem-solving skills. Ability to manage

multiple projects simultaneously

under strict timelines. Excellent communication and coordination skills with technical & non-technical stakeholders. * Detail-oriented, proactive, and committed to

zero-defect delivery

.