Oracle PL SQL Developer ( Teradata, Control M, Batch Scheduling, EDW, Shell Scripting) - #1176164
NEPTUNEZ SINGAPORE PTE. LTD.
Date: 2 hours ago
District: Singapore
Salary:
$8,000
-
$9,500
/ month
Contract type: Contractor
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.
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
R0450904 Corporate Bank – Transactional FX Product Manager, Cash Management - AVP
DEUTSCHE BANK AKTIENGESELLSCHAFT,
Singapore
$10,350
-
$16,200
/ month
1 hour ago
Details of the Division and Team The Transactional FX & GMPO team develops and manages products & connectivity to bring the Bank’s Cash Management, FX and Global Mass Payment Optimization (GMPO) capabilities together to deliver against the complex needs of...
Securities dealing lead
RANDSTAD PTE. LIMITED,
Singapore
$12,000
-
$15,000
/ month
1 hour ago
about the job. Lead the development of securities trading operations, driving process stability and regional expansion across key global markets. Build and refine core trading workflows for multi-asset products, including equities, options, and margin financing. Collaborate closely with product, technology,...
(URGENT ) Marketing Associate (Students Welcome | Weekly Pay)
AUDERE MARKETING,
Singapore
$3,000
-
$4,000
/ month
2 hours ago
Looking for a role that allows you to earn while gaining valuable real-world experience? Whether you're studying in Polytechnic or University, this opportunity allows you to build practical communication, teamwork, and leadership skills while maintaining flexibility around your schedule. What...