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