Oracle SQL/PLSQL Developer

3 days ago

Petaling Jaya, Selangor, Malaysia Nexroar Service SDN BHD Full time

About the Role

We're seeking an engineer with 
deep expertise in Oracle SQL/PL/SQL

and strong 
Python

scripting/automation skills. You will design high-performance queries, procedures, and automations that support policy, billing, and reporting workflows. 
Insurance domain knowledge (Life)

is a strong advantage.

Key Responsibilities

  • Design, write, and optimize 
    Oracle SQL
     queries, views, materialized views, indexes, and 
    PL/SQL
     packages/procedures/functions.
  • Analyze execution plans, troubleshoot slow queries, and apply performance tuning (stats, partitions, hints where appropriate).
  • Build and maintain 
    Python
     scripts for data pipelines, Excel automation, and system integrations .
  • Schedule and monitor via 
    Oracle Scheduler/DBMS_SCHEDULER
    , Windows Task Scheduler.
  • Partner with business users (Actuarial, Policy Service, Claims, Finance) to translate requirements into scalable data solutions and reports.
  • Implement data quality checks, logging, alerting, and reconciliation routines.
  • Support production issues (root-cause, fixes, post-mortems); uphold SLAs and data accuracy.

Must-Have Qualifications

  • 3–5 years
     hands-on with 
    Oracle Database
     (11g/12c/19c+) and 
    PL/SQL
    .
  • Strong SQL fundamentals: joins, window functions, CTEs, analytic functions, partitioning.
  • Proven 
    performance tuning
    : explain plan, AWR/ASH basics, indexing strategy.
  • Practical 
    Python
     for data engineering/automation (pandas, file I/O, env management, virtualenv/conda).
  • Experience building scheduled jobs and batch processes; comfortable on 
    Windows and/or Linux
    .
  • Solid understanding of software craftsmanship: testing, code reviews, documentation, version control.
  • Clear communication with non-technical stakeholders; requirements gathering & user support.

Good to Have (Insurance Domain)

  • Familiarity with policy lifecycle: new business, endorsements/riders, premium/billing, claims, lapses/surrenders, commissions.
  • Exposure to regulatory/statutory reporting and audit controls.
  • Knowledge of common insurance data models and terminology.

Tech Stack

  • Oracle
    : SQL , PL/SQL, Forms & Reports, DBMS_SCHEDULER, partitioning, materialized views.
  • Python
    : oracledb/cx_Oracle, pandas, openpyxl, requests, logging
  • Version Control
     Git, PVCS (nice to have).
  • Ops/Platform
    : Windows Server/Task Scheduler, Linux/cron, shell/PowerShell scripting.
  • Tools
    : Benthic, Oracle Forms & Reports

Education

  • Bachelors in computer science, Information Systems, Engineering or equivalent experience.

Soft Skills

  • Ownership mindset, strong debugging, attention to detail, and the ability to simplify complex data asks.
  • Collaborative, proactive, and comfortable working with distributed teams.

  • Junior Oracle PLSQL Developer

    2 weeks ago

    Petaling Jaya, Selangor, Malaysia Softenger Malaysia Full time 42,000 per year

    Job Location: Petaling Jaya, SelangorJob Type; 1- year and contractual jobMax Salary: RM3500 per monthJob Description:Are you a recent graduate with a basic technical background in Oracle PL/SQL, or are you eager to learn and be trained in working with Oracle database?Join our team as a Junior Oracle PL/SQL Developer. In this role, you will have the...

  • Senior Database Administrator

    2 weeks ago

    Petaling Jaya, Selangor, Malaysia Hitachi eBworx Full time 120,000 - 180,000 per year

    Join Us as a Senior Database Administrator (Oracle, PL/SQL)At Hitachi eBworx Sdn. Bhd, we're looking for a talented Senior Database Administrator (Oracle, PL/SQL) to be part of our dynamic team in Petaling Jaya, Selangor.Why You'll Love It Here:Latest Tools & Tech: Work with cutting-edge technologies to stay ahead in the industry.Flexible Work...

  • Senior Oracle Cloud Specialist

    2 weeks ago

    Petaling Jaya, Selangor, Malaysia PeopleScope Full time 120,000 - 240,000 per year

    Senior Oracle Cloud SpecialistThe Day-to-Day Activities: Accountable for the Oracle Fusion technical items (Integrations, Reports, Customizations) support, implementation and delivery.Ensure the finance and procurement functionalities are implemented and working fine.Contribute to the development of short and mid-long-term strategic roadmap and improvements...

  • RTD IT Developer

    1 week ago

    Petaling Jaya, Selangor, Malaysia UST Malaysia Full time 60,000 - 80,000 per year

    DescriptionDevelop and maintain applications using Java and Grails.Work within Agile and Scrum teams to deliver high-quality software solutions.Design and implement front-end components using HTML, CSS, JavaScript, jQuery, and Write and optimize PLSQL queries for backend integration.Demonstrate strong self-learning skills, with the ability to quickly pick up...

  • SQL Support Engineer

    5 days ago

    Petaling Jaya, Selangor, Malaysia A.P. Moller - Maersk Full time

    Team/Opportunity:The Fulfilled by Maersk Platform is looking for a Support engineer who will provide support to FbM Level 1 Support Engineer.The right candidates for these positions will possess a need to provide agile and quality support services for business operations, and then coordinate the installation, upgrading and daily maintenance of FbM...

  • SQL Support Engineer

    5 days ago

    Petaling Jaya, Selangor, Malaysia MAERSK Full time

    Team/Opportunity:The Fulfilled by Maersk Platform is looking for a Support engineer who will provide support to FbM Level 1 Support Engineer.The right candidates for these positions will possess a need to provide agile and quality support services for business operations, and then coordinate the installation, upgrading and daily maintenance of FbM...

  • SQL Support Engineer

    5 days ago

    Petaling Jaya, Selangor, Malaysia A.P. Moller - Maersk Full time

    Team/Opportunity:The Fulfilled by Maersk Platform is looking for a Support engineer who will provide support to FbM Level 1 Support Engineer.The right candidates for these positions will possess a need to provide agile and quality support services for business operations, and then coordinate the installation, upgrading and daily maintenance of FbM...

  • Application Developer

    2 weeks ago

    Petaling Jaya, Selangor, Malaysia Vernoin Technology Solutions Full time 30,000 - 60,000 per year

    Company Description With more than 800 consultants working on six continents, Verinon offers tailored solutions to clients. We are specialists in systems-integration around document and content management, collaboration, business intelligence, data warehousing, conversions and interfaces/adapters coupled with a select pool of custom development areas to...

  • Report Analytics Developer

    1 week ago

    Petaling Jaya, Selangor, Malaysia Two95 International Inc. Full time 80,000 - 120,000 per year

    This role is responsible for developing and supporting various global enterprise applications from onsite premise to cloud based Data Warehouse, Business Intelligence and Data Analytic solutions. These solutions integrate closely with our application, hosted on AWS (Amazon Web Services) for internal employees and an external portal for our contractual...

  • Report Analytics Developer

    3 days ago

    Petaling Jaya, Selangor, Malaysia TWO95 International, Inc Full time

    This role is responsible for developing and supporting various global enterprise applications from onsite premise to cloud based Data Warehouse, Business Intelligence and Data Analytic solutions. These solutions integrate closely with our application, hosted on AWS (Amazon Web Services) for internal employees and an external portal for our contractual...