Job Responsibilities:
- Design, develop, and maintain ERP modules using Oracle SQL and PL/SQL.
- Customize existing ERP applications based on business needs.
- Write and manage complex SQL queries, procedures, triggers, and functions.
- Create and manage database objects like tables, views, indexes, etc.
- Optimize database performance through query tuning and indexing.
- Perform database migrations and version upgrades with minimal downtime.
- Develop Oracle reports and tools to support business analysis.
- Document applications, including code and database structures.
- Improve the efficiency and scalability of database operations.
- Troubleshoot and resolve database and application issues.
- Test code for performance, functionality, and security.
- Provide technical support for Oracle-based systems.
Job Requirements:
- Bachelor's degree in Computer Science, IT, or related field (Master’s is a plus).
- At least 4 years of experience in Oracle development (SQL and PL/SQL).
- Experience with Oracle versions 11g, 12c, and 19c, including setup and maintenance.
- Strong skills in performance tuning, backup and recovery using RMAN.
- Experience with high availability, standby databases, and Oracle Data Guard.
- Proficient in PL/SQL development (packages, procedures, triggers, etc.).
- Skilled in SQL query optimization and execution plan analysis.
- Familiarity with front-end technologies: JavaScript, C#, ASP.NET, HTML, XML.
- Experience with web-based applications using Oracle databases.
- Knowledge of Oracle Cloud technologies is an advantage.
Job Type: Full-time