Senior Oracle Developer

Job description

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

• Database Development: Design, analyze, and implement robust business applications using Oracle Autonomous Database (ADB) / RDBMS (19c/12c/11g/10g) and PL/SQL.
  
  
• Advanced Programming: Develop complex database objects, including Stored Procedures, Functions, Packages, and Triggers.
  
  Utilize advanced PL/SQL features such as Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, and Query Re-Write.
  
  
• Performance Optimization: Expertise in performance tuning for SQL, PL/SQL, and SEGMENTS.
  
  Analyze execution plans and use Explain Plan, AWR, ASH, and ADDM reports to optimize database performance.
  
  
• Agile Collaboration: Experience in an Agile development environment for at least 3 years, including managing and executing assignments in Jira and Confluence.
  
  
• Data Integration & Modelling: Strong experience in Data Warehouse concepts and ETL.
  
  Develop and implement ETL solutions using Talend.
  
  Perform logical and physical data modelling using normalization techniques to create/manage Tables, Views, Constraints, and various types of Indexes.
  
  
• Data Management: Manage data replication in distributed environments by developing and maintaining Materialized Views.
  
  Utilize Oracle packages, Dynamic SQL, Records, PL/SQL Tables, and SQL Loader for data loading.
  
  
• Scripting and Automation: UNIX shell scripting for automation and scheduling tasks.
  
  
• Requirements Implementation: Understand and implement detailed business, functional, and non-functional technical requirements, including recovery, security, data volumes, performance, and audit aspects.
  
  
• Problem-Solving: Strong analytical and problem-solving abilities in fast-changing environments.
  
  
• Leadership and Teamwork: Integrity, accountability, and effective communication across technical and non-technical audiences.
  
  
• Continuous Improvement: Proactiveness in improving processes and adopting new technologies.
  
  

Seniority

• Mid-Senior level

Employment Type

• Full-time

Job Function

• Information Technology
• Industries: IT Services and IT Consulting

Required Skill Profession

It & Technology