Software Developer

NUCLEUS SOFTWARE SOLUTIONS PTE LTD; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

A leading technology firm in Singapore seeks an experienced IT professional to lead projects delivering database and middleware solutions for mission-critical banking applications. The role involves end-to-end project management, stakeholder coordination, and ensuring compliance with regulatory standards. Candidates should have over 15 years of experience in IT, particularly in database administration and infrastructure migration, along with strong SQL tuning and shell scripting skills. This position offers competitive remuneration in a dynamic and compliant environment.

Benefits

Competitive salary

Career advancement opportunities

Qualifications

• 15+ years of IT experience in Database Administration and Middleware.
• Proven experience in managing infra migration projects.
• Strong knowledge of banking application environments.

Responsibilities

• Lead end-to-end project delivery including design and execution.
• Manage infrastructure migration projects and ensure compliance.
• Oversee production support for middleware and DB environments.

Skills

SQL performance tuning

Shell scripting (Linux/Unix)

Oracle Database expertise

Middleware knowledge

Project management

Stakeholder management

Tools

Oracle WebLogic

Autosys

IBM MQ

AppDynamics

ServiceNow

RHEL7/8

Job description

Job Summary

To analyse, design and architect the infrastructure, middleware & database transformation related enhancements for mission‑critical banking applications, ensuring stability, compliance and high availability. The role requires strong expertise in Server Hardware, 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).

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.

Setup 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.

Analyse 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 optimisation 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 analyse 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.

Additional Responsibilities

• 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 optimisation, 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 optimisation
• 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.