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

NEPTUNEZ SINGAPORE PTE. LTD.

Singapore

Sur place

SGD 120 000 - 180 000

Plein temps

Il y a 5 jours
Soyez parmi les premiers à postuler

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

Neptunez Singapore PTE. LTD. seeks an experienced Oracle SQL/PLSQL specialist to own production-grade database support for enterprise data applications in Singapore. The role focuses on Oracle-based processing, complex SQL, and scheduled data workflows.

You will diagnose failures, develop PL/SQL components, validate data across sources, manage batch jobs with Control-M, and troubleshoot UNIX/Linux workflows. Strong EDW and production-inc ident management experience is required.

Qualifications

  • Minimum 11+ years of experience in Oracle SQL/PLSQL development, database operations and production support.
  • Strong hands-on Oracle database expertise with ability to develop, debug and troubleshoot complex PL/SQL code.
  • Experience with Teradata and SQL-based data processing in large-scale enterprise environments.
  • Experience with Control-M batch scheduling, dependencies, execution monitoring, failure investigation and job recovery.
  • Experience in UNIX/Linux and Shell scripting for troubleshooting automated processing workflows.
  • 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.

Responsabilités

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

Connaissances

Oracle SQL/PLSQL
Production support
Batch scheduling
UNIX/Linux
Shell scripting
SQL performance tuning
Data warehousing

Outils

Oracle SQL Developer
TOAD
SQLPlus
Control-M
ServiceNow
Jira
Data migration tools

Description du poste

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.
Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Data Engineer (Teradata, Control-M, Informatica PowerCenter, UNIX Shell Scripting)
Data Engineer (Teradata, Control-M, Informatica PowerCenter, UNIX Shell Scripting)

NEPTUNEZ SINGAPORE PTE. LTD. • Singapore

Sur place
SGD 90 000 - 130 000
Senior Oracle PL/SQL Engineer, Production DataOps
Senior Oracle PL/SQL Engineer, Production DataOps

NEPTUNEZ SINGAPORE PTE. LTD. • Singapore

Sur place
SGD 120 000 - 180 000
Senior Oracle Developer
Senior Oracle Developer

IDC TECHNOLOGIES (SINGAPORE) PTE. LTD. • Singapore

Sur place
SGD 90 000 - 130 000
Production Support - Unix/Oracle/GCP
Production Support - Unix/Oracle/GCP

Exasoft Pte. Ltd. • Singapore

Sur place
SGD 120 000 - 180 000
Oracle Developer
Oracle Developer

Exasoft Pte. Ltd. • Singapore

Sur place
SGD 90 000 - 120 000
Database Oracle
Database Oracle

Millennium Technology Services • Singapore

Sur place
SGD 120 000 - 180 000
PL/SQL Developer (Capital Markets industry)
PL/SQL Developer (Capital Markets industry)

DXC Luxoft • Singapore

Sur place
SGD 120 000 - 180 000
Oracle Database Admin
Oracle Database Admin

NTT Data Singapore • Singapore

Sur place
SGD 80 000 - 130 000
PL/SQL Developer (Treasury & Markets Applications)
PL/SQL Developer (Treasury & Markets Applications)

DXC Luxoft • Singapore

Sur place
SGD 120 000 - 180 000
Oracle Developer
Oracle Developer

HCL Technologies Limited • Singapore

Sur place
SGD 90 000 - 120 000