Senior Middleware and Database Administrator

**Job Summary**:
**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.
- 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.
- 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 mínimal response time.
- 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.
- **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 mínimal business impact.
- 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.
- 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).
- Hands-on expertise in **SQL performance tuning & shell scripting**.
- Experience in **sta