TL;DR
Senior Oracle PL/SQL Developer: Architecting, designing, and implementing Oracle database solutions for business applications with an accent on complex PL/SQL packages, stored procedures, functions, and triggers. Focus on advanced SQL and PL/SQL performance tuning, data modeling, and ETL processes.
Location: Kuala Lumpur
Company
Encora Inc. provides outsourced software development services.
What you will do
- Architect, design, and implement robust, scalable Oracle database solutions.
- Develop, maintain, and optimize complex PL/SQL packages and stored procedures.
- Perform advanced SQL and PL/SQL performance tuning.
- Design and maintain logical and physical data models.
- Develop and manage ETL processes and data migration strategies.
- Provide Level 3 production support and root cause analysis.
Requirements
- Experience in Oracle database solutions architecture and implementation.
- Proficiency in developing and maintaining complex PL/SQL packages and stored procedures.
- Experience with SQL and PL/SQL performance tuning.
- Knowledge of data modeling and ETL processes.
- Familiarity with Agile methodologies, Jira, and Confluence.
Culture & Benefits
- Participate in Agile ceremonies including sprint planning and daily stand-ups.
- Opportunity to work with cross-functional teams.
- Contribute to compliance with regulatory requirements and data governance standards.