jobs in NEPTUNEZ SINGAPORE PTE. LTD.

NEPTUNEZ SINGAPORE PTE. LTD. Hiring! Full Time Oracle PL SQL Developer ( Teradata, Control M, Batch Scheduling, EDW, Shell Scripting) in , Earn up to SGD 9,500 - Ricebowl

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

NEPTUNEZ SINGAPORE PTE. LTD.

Singapore

Share
Save

Working Location

  • Singapore

Job Description

Responsibilities

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.

NEPTUNEZ SINGAPORE PTE. LTD. is an IT services company that specializes in RPA, ServiceNow, and Automation Testing. Their commitment to innovation, client-centric approach, and expertise in these domains make them a valuable partner for businesses looking to leverage technology for improved efficiency and competitiveness.

Important Information

Never provide your bank or credit card details when applying for jobs. Do not transfer any money or complete unrelated online surveys. If you see something suspicious, Report this Job ad.

Learn More