Database Infrastructure Transformation Expert

Job Summary

To manage and deliver infrastructure, middleware, and database transformation projects for mission-critical banking applications, ensuring stability, compliance, and high availability.

• Lead end-to-end project delivery including requirement gathering, design, capacity planning, scheduling, execution, testing, and go-live.
• Manage infrastructure migration projects including 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.
• Install and configure Oracle Databases including RAC and standalone environments, with proper sizing, storage allocation, and security hardening.
• Perform installation and configuration of Oracle WebLogic Server 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.
• Configure SSL/TLS, 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 and ADDM 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.
• 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 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 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.
• Design, implement, and validate Disaster Recovery 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 testing across APAC markets involving multi-country stakeholders to validate business continuity and regulatory compliance.
• Drive automation initiatives 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.