Senior Middleware and Database Administrator

Roles & Responsibilities

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.

Tell employers what skills you have

Splunk
Regulatory Compliance
IBM Tivoli
Oracle Web Logic
Shell Scripting
AIX Administration
RabbitMQ
Windows Server
CyberArk
Oracle 9i
SQL
Database Administration
System Administration
IBM WebSphere MQ
Banking
Performance Tuning
ServiceNow
Disaster Recovery
Linux
middleware architecture

---