Oracle Database Developer

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 processesImplement and maintain business rules, validations, and workflows at the database levelOptimize SQL queries and PL/SQL code for high-performance transactional systemsAnalyze and resolve performance bottlenecks using execution plans, indexing strategies, and advanced tuning techniquesHandle 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 transactionsSupport and troubleshoot production issues, including data inconsistencies and system performance problemsWork closely with functional teams (HR/Finance) to understand business needs and provide technical solutionsMaintain database standards, naming conventions, and code quality across the systemPrepare and maintain technical documentation for database logic and processes