Software Developer

Job Summary: To analyse, design and architecting the infrastructure,middleware & database transformation related enhancements formission-critical banking applications, ensuring stability, complianceand high availability. The role requires strong expertise in ServerHardware, Server OS and schedulers, Oracle Database, Middleware(WebLogic, Forms & Reports, WebSphere), integration tools for maintaining server performance as per requirement 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 & Architecting, capacity planning, scheduling, execution, testing, and go-live). Analyse client needs to design & develop solutions using mathematical analysis for Server performance and capacity planning. Lead end-to-end migration projects covering servers for 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) . • Installand configure Oracle Databases (9i-19c) , including RAC and standaloneenvironments, with proper sizing, storage allocation, and security hardening.• Performinstallation and configuration of Oracle WebLogic Server (12c/14c) ,including creating domains, clusters, and managed servers for high availabilitysetups.• Setup and configure Oracle Forms & Reports infrastructure , includinginstance creation, runtime configuration, and integration with WebLogicdomains.• Designand configure JDBC data sources, connection pools, and deploymentenvironments for applications (WAR/EAR).• ConfigureSSL/TLS, SSO (SiteMinder/Secure SSO) , and other security componentsduring middleware installation.• Fine-tuneOracle Forms & Reports runtime parameters , ensuring faster responsetimes and stable concurrent user sessions.• Analyseand resolve Forms rendering issues, report generation delays, and sessionbottlenecks in production environments.• PerformSQL query tuning and optimization using execution plans, indexes andbind variables to improve transaction performance in critical bankingapplications.• AnalyzeAWR (Automatic Workload Repository) and ADDM (Automatic Database DiagnosticMonitor) reports to identify system bottlenecks, inefficient queries, andresource-heavy sessions.• OptimizePL/SQL procedures, packages, and migration scripts , reducing executiontime and improving efficiency in large-scale data migration projects.• Monitordatabase memory structures (SGA, PGA) and adjust configurations foroptimal throughput.• Fine-tunedatabase parameters, indexes, and statistics to ensure high availabilityand minimal response time.• Collaboratewith application developers and business analysts to review SQL code andrecommend improvements before production deployment.• Supportclient teams by providing recommendations for SQL & DB environmentperformance improvements.• Ensuredatabase tuning practices comply with audit and performance SLAs formission-critical banking systems.• Design,develop, and maintain shell scripts to automate routine database,middleware, and application administration tasks (backups, monitoring, jobscheduling, log rotation, file transfers).• Enhanceexisting scripts by improving error handling, logging, and performanceoptimization to ensure reliability in production environments.• Troubleshootand fix script-related issues in BAU (Business-As-Usual) and projectenvironments, ensuring minimal business impact.• Collaboratewith application and infrastructure teams to analyze requirements andimplement script-based solutions for new business or infra needs.• Developcustom utility scripts for infra monitoring, batch job automation, andreport generation.• Conductcode reviews and knowledge sharing to improve team scripting standards.Conduct risk assessment, impact analysis, and mitigation planning for project delivery. • Planand coordinate High Availability (HA) setups for critical bankingapplications, 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 .