encora10 logoencora10 logo

Senior Oracle PL/SQL Developer

encora10Kuala Lumpur
On-site Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Experience Level

Senior

Qualifications

Proven experience as a Senior Oracle PL/SQL Developer with a strong understanding of database architecture and performance optimization. Proficiency in PL/SQL, SQL, and database design principles is essential. Experience with ETL tools and UNIX shell scripting is highly desirable. Familiarity with Agile methodologies and tools such as Jira and Confluence is preferred.

About the job

The Senior Oracle PL/SQL Developer at encora10 in Kuala Lumpur will design, build, and maintain robust Oracle database solutions to support essential business applications. This role involves working with advanced PL/SQL features, optimizing performance, and ensuring data integrity across large, mission-critical systems.

What you will do

  • Design and develop scalable Oracle database solutions for business-critical applications.
  • Write, maintain, and optimize complex PL/SQL packages, procedures, functions, and triggers, using advanced techniques such as bulk collections, dynamic SQL, autonomous transactions, analytical functions, partitioning, and materialized views.
  • Analyze and tune SQL and PL/SQL performance by reviewing execution plans and using tools like AWR, ASH, ADDM, SQL Trace, and Explain Plan to resolve bottlenecks.
  • Create and maintain logical and physical data models, following normalization standards, indexing strategies, and data governance policies.
  • Lead ETL processes and data migration for large datasets, using tools such as Talend and SQL Loader.
  • Manage data replication and distributed database environments with materialized views and Oracle-provided packages.
  • Participate in Agile ceremonies (sprint planning, daily stand-ups, sprint reviews, retrospectives) and manage tasks in Jira and Confluence.
  • Guide database activities through the full Software Development Life Cycle, from requirements to post-implementation support.
  • Provide advanced Level 3 production support, including root cause analysis and real-time resolution of critical database issues.
  • Use UNIX shell scripting for automation, scheduling, and operational support.
  • Assess and implement business, functional, and non-functional requirements, focusing on performance, recovery, audit, data security, and scalability.
  • Conduct code reviews and mentor junior and mid-level developers, promoting best practices and high standards.
  • Collaborate with teams across IT risk, security, infrastructure, legal, and finance to ensure compliance and operational alignment.
  • Ensure all database solutions comply with regulatory requirements, data governance, and internal risk management frameworks.
  • Identify risks, highlight concerns, and recommend mitigation strategies to maintain system stability and data integrity.
  • Stay updated on emerging Oracle technologies and industry trends, recommending improvements to database architecture and engineering practices.

About encora10

Encora is a leading technology services firm specializing in software development, data engineering, and digital transformation. We are committed to delivering innovative solutions that drive business success and empower our partners to excel in a competitive landscape.

Similar jobs

Browse all companies, explore by city & role, or SEO search pages.

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.