Browse the latest developer jobs in Singapore.Join TelegramNew job alerts are currently paused.
< Back to all jobs

Oracle PL SQL Developer ( Teradata, Control M, Batch Scheduling, EDW, Shell Scripting)

NEPTUNEZ SINGAPORE PTE. LTD.

Software EngineeringSenior ExecutiveContractIslandwide, Singapore

Job Description

Responsibilities • Own production-level database support for enterprise data applications, with a focus on Oracle-based processing, complex SQL operations and scheduled data workflows. • Analyse failures arising from PL/SQL execution, database objects, data transformation logic and upstream/downstream dependencies; identify the underlying technical cause and implement corrective solutions. • Develop and modify PL/SQL components, including stored procedures, packages, functions, cursors and dynamic SQL, to address application defects and data-processing requirements. • Investigate data mismatches across source and target systems by performing SQL-based validation, record-level reconciliation and integrity checks within data warehouse environments. • Administer scheduled processing activities through Control-M, investigating unsuccessful job executions, resolving dependency issues and coordinating controlled job reruns to restore processing cycles. • Troubleshoot UNIX/Linux-based processing workflows by analysing shell scripts, execution logs, file transfers and database connectivity issues. • Examine slow-running SQL statements and database execution plans to identify performance bottlenecks, applying indexing and query restructuring techniques where required. • Support enterprise data warehouse operations involving data sourcing, enrichment, ledger-related processing and recurring business reporting cycles. • Handle production defects through technical investigation, impact assessment, resolution tracking and post-fix verification, ensuring business-critical processing is restored within agreed timelines. • Participate in database migration and implementation activities, including data conversion checks, validation of migrated records and post-release production stabilisation. Requirements • Minimum 11+ years of experience in Oracle SQL/PLSQL development, database operations and production support. • Strong hands-on experience in Oracle databases, with the ability to independently develop, debug and troubleshoot complex PL/SQL code. • Experience with Teradata and SQL-based data processing in large-scale enterprise database environments. • Experience with Control-M, particularly in batch scheduling, job dependency management, execution monitoring, failure investigation and job recovery. • Experience in UNIX/Linux and Shell Scripting for troubleshooting automated processing workflows, analysing logs and resolving script-related failures. • Experience with Oracle database objects, including packages, procedures, functions, triggers, views, cursors and dynamic SQL. • Experience in SQL performance diagnostics using Explain Plan, index analysis and query optimisation techniques. • Experience in Enterprise Data Warehouse (EDW) environments, data sourcing, data enrichment, migration validation and reconciliation activities. • Experience in handling complex production incidents involving database failures, data discrepancies and batch-processing interruptions. • Experience with database development and query tools such as Oracle SQL Developer, TOAD and SQLPlus, along with production incident management tools such as ServiceNow or Jira. • Oracle Database or PL/SQL certifications will be preferred.

Listing closes 17 Dec 2026.

Apply directly through the original listing. The employer’s page has the latest application details.