Job Responsibilities:

·Develop and maintain ERP modules using Oracle SQL, PL/SQL, and related tools.

·Customize existing ERP applications to meet business needs.

· Write complex queries, stored procedures, triggers, and functions to support business processes and application features.

· Develop and implement database objects, such as tables, views, indexes, sequences, and other schema objects.

· Optimize database performance by writing efficient SQL queries, indexing, and performing routine database tuning.

· Perform database migrations and upgrades as necessary, ensuring minimal disruption to operations.

· Develop and maintain Oracle Reports and data extract tools to support business decision-making.

· Ensure all Oracle applications are well-documented, including code, database schemas, and user manuals.

· Optimizing database queries, stored procedures, and other code to enhance efficiency and scalability.

· Troubleshooting database issues, resolving errors, and ensuring system stability.

· Test developed code and scripts for functionality, performance, and security.

· Troubleshoot and debug Oracle-based applications and database-related issues.

· Provide technical support and troubleshooting for Oracle-based applications and databases.

Job Requirements:

· Bachelor’s degree in Computer Science, Information Technology, or a related field. A Master’s degree is a plus.

· Minimum 4 years of experience as an Oracle Developer with strong skills in SQL and PL/SQL. Experienced in installing, configuring, and maintaining Oracle Enterprise Server (11g, 12c, and 19c), setting up high-availability databases, and working with standby database technologies and Oracle Data Guard

· Skilled in performance tuning, configuring and scheduling backups, and performing consistent and logical backups using RMAN and handling backup restoration and recovery as per the backup plan.

· Good Knowledge in Database Synchronization, Database upgrades and migrations, Monitoring database Performance and Tuning instances and databases

· Proficient in developing database applications using PL/SQL—packages, functions, procedures, triggers, and complex SQL; experienced with Oracle collections, object types, SQL query tuning, and analyzing SQL plans.

· Knowledge in JAVASCRIPT ,C#,ASP Net, HTML, XML , reporting tool and PL/SQL Programming (web based) as front end and database Oracle as back end

· Knowledge in oracle cloud technology.