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.
