Job Description

We are seeking a highly experienced Oracle Database Developer with a minimum of 7 years of hands-on expertise in SQL and PL/SQL, to support and enhance enterprise ERP systems, particularly within HR and Finance domains. The ideal candidate is a strong problem solver with deep technical knowledge, capable of handling complex business logic, large datasets, and performance-critical operations in a production environment.

• Design, develop, and maintain complex PL/SQL packages, procedures, functions, and triggers supporting ERP modules (HR, Payroll, Finance, etc.)
• Translate business requirements into efficient and scalable database solutions aligned with ERP processes
• Implement and maintain business rules, validations, and workflows at the database level
• Optimize SQL queries and PL/SQL code for high-performance transactional systems
• Analyze and resolve performance bottlenecks using execution plans, indexing strategies, and advanced tuning techniques
• Handle complex data processing scenarios (bulk operations, validations, financial calculations, accruals, balances, etc.)
• Develop and support integrations with external systems (APIs, web services, middleware)
• Ensure data integrity and consistency across related ERP modules and transactions
• Support and troubleshoot production issues, including data inconsistencies and system performance problems
• Work closely with functional teams (HR/Finance) to understand business needs and provide technical solutions
• Maintain database standards, naming conventions, and code quality across the system
• Prepare and maintain technical documentation for database logic and processes

Requirements

• Minimum 7 years of experience in Oracle database development
• Bachelor’s degree in Computer Science, Information Technology, or a related field
• Expert-level proficiency in SQL and PL/SQL (complex joins, analytical functions, bulk processing, packages)
• Strong experience in building and maintaining ERP systems (preferably HR and/or Finance modules)
• Deep understanding of transactional systems and data consistency concepts
• Proven expertise in performance tuning (SQL Trace, execution plans, indexing)
• Experience handling large-scale data operations and high-volume transactions
• Strong knowledge of database design, normalization, and relational modeling
• Experience implementing complex validations and business rules at database level
• Familiarity with integration techniques (REST/SOAP APIs, ORDS, or similar)
• Experience with tools such as TOAD, SQL Developer, or equivalent
• Strong analytical and troubleshooting skills in production environments
• Ability to work independently and handle critical tasks under pressure
• Oracle Database / PL/SQL certifications are an advantage
• Experience with Oracle APEX, Oracle Forms, or Oracle Reports is preferred 
• Knowledge of financial systems concepts (GL, payroll, accruals, balances, cost centers, etc.) is preferred
• Experience with data migration and data masking techniques is preferred
• Familiarity with version control systems (Git or similar) is preferred
• Exposure to Agile/Scrum environments is preferred