Senior Oracle PL/SQL Developer: Performance & Architecture

encora10

Kuala Lumpur

Sur place

MYR 180 000 - 280 000

Plein temps

14 jours+

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Résumé du poste

Encora in Kuala Lumpur seeks a senior Oracle Database Developer/DBA to design, implement, and optimize Oracle-based applications. You will drive performance tuning, data modelling, ETL, and migrations while ensuring robust availability and governance.

You will collaborate with cross-functional teams across business, security, and operations, providing L3 production support and contributing through the SDLC from requirements to post-production support.

Qualifications

  • At least 10 years of Oracle database development experience.
  • Minimum 8 years of advanced PL/SQL development.
  • Strong experience with Oracle 10g, 11g, 12c, 19c, and Oracle Autonomous Database (ADB).
  • Minimum 7 years of hands-on performance tuning and optimization.
  • Strong expertise in database architecture, schema design, partitioning, indexing, and high-volume database solutions.
  • Minimum 6 years of data modelling experience (logical and physical).
  • Minimum 5 years of ETL and data integration experience; Talend exposure is advantageous.
  • Experience managing Materialized Views and replication strategies.
  • Strong experience with SQL Loader and database migrations to Oracle environments.
  • Minimum 4 years of UNIX Shell Scripting experience.
  • Strong Application DBA exposure, including deployment, monitoring, backup, recovery, and production support.
  • Minimum 5 years of L3 production support experience in mission-critical environments.

Responsabilités

  • Design, develop, and maintain complex Oracle database applications using PL/SQL.
  • Develop and enhance Stored Procedures, Functions, Packages, Triggers, and Dynamic SQL.
  • Perform advanced SQL and PL/SQL performance tuning using AWR, ADDM, ASH, SQL Trace, and Explain Plan.
  • Design scalable database architectures, schema structures, indexing strategies, partitioning models, and high-availability solutions.
  • Lead data modelling activities, including logical and physical data design, normalization, constraints, indexes, and governance standards.
  • Design and implement ETL processes and data integration solutions for large-volume data environments.
  • Manage Materialized Views, replication mechanisms, and distributed database environments.
  • Execute data migration initiatives and large-scale data loading activities using SQL Loader and Oracle migration utilities.
  • Develop and maintain UNIX shell scripts for automation, batch processing, and operational support.
  • Support application database deployments, environment setup, release management, monitoring, backup, recovery, and production support activities.
  • Provide L3 production support, perform root cause analysis, and resolve critical incidents within SLA timelines.
  • Participate throughout the full Software Development Life Cycle (SDLC), from requirements gathering to post-production support.
  • Work closely with business users, infrastructure teams, security, risk, compliance, legal, and finance stakeholders.
  • Lead code reviews, establish development standards, and mentor junior developers.
  • Produce technical documentation, solution designs, operational procedures, and governance artifacts.
  • Drive database modernization initiatives and recommend innovative solutions to improve system performance, scalability, and reliability.

Connaissances

Oracle DBA
PL/SQL
Oracle 10g-19c
Oracle ADB
Performance tuning
DB architecture
Data modelling
ETL integration
Talend
Materialized Views
Replication
SQL Loader
DB migrations
UNIX Shell
Production support

Outils

UNIX Shell

Description du poste

Encora in Kuala Lumpur seeks a senior Oracle Database Developer/DBA to design, implement, and optimize Oracle-based applications. You will drive performance tuning, data modelling, ETL, and migrations while ensuring robust availability and governance.

You will collaborate with cross-functional teams across business, security, and operations, providing L3 production support and contributing through the SDLC from requirements to post-production support.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Senior Oracle PL/SQL Lead, Performance & Architecture
Senior Oracle PL/SQL Lead, Performance & Architecture

Encora Inc. • Kuala Lumpur

Sur place
MYR 284 900 - 407 000
Senior Data Engineer | Talend ETL & Oracle PL/SQL
Senior Data Engineer | Talend ETL & Oracle PL/SQL

DIGITAL BRIGHT TECHNOLOGIES • Kuala Lumpur

Sur place
MYR 180 000 - 270 000
Senior Oracle & SQL Server DBA
Senior Oracle & SQL Server DBA

Tech Tiera Corporation • Kuala Lumpur

Sur place
MYR 180 000 - 280 000
Senior Oracle DB Architect — RAC, Data Guard & DR
Senior Oracle DB Architect — RAC, Data Guard & DR

AmBank Group • Petaling Jaya

Sur place
MYR 180 000 - 320 000
Senior Database Engineer: Oracle, MySQL & MariaDB Specialist
Senior Database Engineer: Oracle, MySQL & MariaDB Specialist

Accenture PLC • Kuala Lumpur

Sur place
MYR 120 000 - 180 000
Senior Java Backend Engineer | REST & SOA Expert
Senior Java Backend Engineer | REST & SOA Expert

encora10 • Kuala Lumpur

Sur place
MYR 50 000 - 90 000
Hiring for Oracle Database Admin -Malaysia
Hiring for Oracle Database Admin -Malaysia

Path Infotech Pte Ltd • Kampung Malaysia Raya

Sur place
MYR 120 000 - 180 000
Senior Oracle PL SQL Developer
Senior Oracle PL SQL Developer

Encora Inc. • Kuala Lumpur

Sur place
MYR 284 900 - 407 000
Senior Data Center Program Lead - Strategy, Delivery & Risk
Senior Data Center Program Lead - Strategy, Delivery & Risk

Oracle • Kuala Lumpur

Sur place
MYR 180 000 - 360 000
Senior Oracle PL SQL Developer
Senior Oracle PL SQL Developer

encora10 • Kuala Lumpur

Sur place
MYR 180 000 - 280 000
Lieux principaux