Senior Oracle Developer

Overview

Location : Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

Role : Senior Oracle Developer

We are seeking a highly experienced Senior Oracle PL / SQL Developer with a minimum of 10 years of programming experience and application DBA to join our distributed, cross-functional team. The candidate will drive the full Software Development Life Cycle (SDLC) from analysis and design through implementation and maintenance, with advanced expertise in Oracle database technologies, performance tuning, and agile methodologies.

Responsibilities

• Database architecture and design : Architect, design, and implement robust, scalable, and high-performance Oracle database solutions to support mission-critical business applications.
• Advanced PL / SQL development : Develop, maintain, and optimize complex PL / SQL packages, stored procedures, functions, and triggers, utilizing advanced features such as bulk collections, dynamic SQL, and autonomous transactions.
• Performance tuning : Serve as a subject matter expert in performance tuning and query optimization for large-scale enterprise environments. Use advanced tools and techniques, such as AWR, ADDM, SQL Trace, and execution plan analysis, to resolve performance bottlenecks.
• Technical leadership and mentorship : Lead and mentor junior and mid-level developers, conduct code reviews, and promote best practices in Oracle database development.
• Data modelling and governance : Design and enforce data modelling standards. Ensure data integrity, consistency, and compliance with data governance policies across all database systems.
• Complex data integration : Design and implement sophisticated ETL processes and data migration strategies for large volumes of data.
• Solution delivery and project management : Lead database-related projects throughout the SDLC, from requirements gathering and design to deployment and post-implementation support.
• Troubleshooting and production support : Provide advanced, third-level production support for critical database issues, offering real-time problem resolution.
• Strategic planning and innovation : Stay current with the latest Oracle technologies and industry trends. Evaluate and recommend new solutions, contributing to the strategic roadmap for the company's database and data management practices.
• Ownership : Take ownership of assigned deliverables, proactively identify areas for improvement, and implement solutions. Demonstrate initiative in addressing issues, optimizing processes, and proposing innovations to enhance data engineering practices.
• Business and regulatory compliance : Takes accountability in considering business and regulatory compliance risks and takes appropriate steps to mitigate the risks.
• Maintains awareness of industry trends on regulatory compliance, emerging threats and technologies to understand risk and safeguard the company.
• Highlight potential concerns / risks and proactively share best risk management practices.
• Collaborate with IT risk, security, infrastructure, legal, and finance teams.

Requirements / Qualifications

Seniority

Employment Type

Job Function

#J-18808-Ljbffr