Senior Oracle PL/SQL Developer

Location: Kuala Lumpur

Department: Malaysia Team

Day to Day :

• Architect, design, and implement robust, scalable, and high-performance Oracle database solutions to support mission-critical business applications.
• Develop, maintain, and optimize complex PL/SQL packages, stored procedures, functions, and triggers using advanced features such as bulk collections, dynamic SQL, autonomous transactions, analytical functions, partitioning, and materialized views.
• Perform advanced SQL and PL/SQL performance tuning by analyzing execution plans and leveraging tools such as AWR, ASH, ADDM, SQL Trace, and Explain Plan to resolve performance bottlenecks.
• Design and maintain logical and physical data models, ensuring adherence to normalization standards, indexing strategies, constraints, and data governance policies.
• Develop and manage ETL processes and data migration strategies for large volumes of data, including the use of tools such as Talend and SQL Loader.
• Manage data replication and distributed database environments through materialized views and Oracle-supplied packages.
• Participate actively in Agile ceremonies including sprint planning, daily stand-ups, sprint reviews, and retrospectives, while managing assignments through Jira and Confluence.
• Lead database-related activities across the full Software Development Life Cycle (SDLC), from requirements gathering and design through development, testing, deployment, and post-implementation support.
• Provide advanced Level 3 production support, including root cause analysis and real-time resolution of critical database issues.
• Utilize UNIX shell scripting for automation, scheduling, and operational support tasks.
• Evaluate and implement detailed business, functional, and non-functional requirements, including performance, recovery, audit, data security, and scalability considerations.
• Conduct code reviews and mentor junior and mid-level developers, promoting best practices and maintaining high development standards.
• Collaborate with cross-functional teams including IT risk, security, infrastructure, legal, and finance to ensure compliance and operational alignment.
• Ensure all database solutions comply with regulatory requirements, data governance standards, and internal risk management frameworks.
• Proactively identify risks, highlight potential concerns, and recommend mitigation strategies to safeguard system stability and data integrity.
• Continuously evaluate emerging Oracle technologies and industry trends, recommending improvements to enhance database architecture, performance, and data engineering practices.