NS

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

  • Neptunez Singapore Pte. Ltd.
  • Singapore
  • On-site
  • Contract
  • SGD 8k–10k / month
  • Posted 3 days ago
Other softwareDatabase OptimizationTeradata SQLlogging bugsAutomated Operation Monitoring

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.
Apply on MyCareersFuture

You apply on MyCareersFuture, where this job was posted. Peter Nowak isn’t the employer and doesn’t check listings.

Get new jobs like this by email

Other software · Singapore

Free. Confirm by email first; unsubscribe anytime in one click.

Similar jobs

Oracle PL SQL Developer ( Teradata, Control M, Batch Scheduling, EDW, Shell Scripting) at Neptunez Singapore P | Peter Nowak