Oracle Developer

VAM Systems is currently looking for Oracle Developer for our Bahrain operations with the following skillsets & terms and conditions:

Skills

• At least 5 years’ experience in Oracle From/Report /Oracle Apex platform  
• Deep knowledge in Oracle Reports 19C(PDF reports, Emailing)
• Deep knowledge in Oracle APEX
• 22.1.6(Transactional Forms, Security Menus, CSS, for look and feel, JavaScript for client-side, functionalities)
• Deep knowledge in Oracle Database 19C(DML operations, DCL operations, PL/SQL routines, Webservice / API consumption)
• Proficiency in PL/SQL
• Understanding of software development best practices, including version control and testing methodologies.
• Strong understanding of software testing principles and methodologies.
• Experience with automated testing frameworks and tools.
• Experience in Oracle Forms 12c (transactional, APIs consuming, Excel exporting, emailing)
• Experience in Oracle Reports 12c (groups, matrix, Excel, PDF, command line)
• Experience in Oracle Apex 22.1.6 (progressive web & mobile applications, Reporting with templates, plugins)
• Experience in Oracle DB 19c: SQL, PL/SQL, Analytical functions and queries, Scheduled Jobs, JQuery, XQuery

Duties & Responsibilities

Backend

• Handle all operations work in Oracle Database 19c
• Perform required DML operations
• Perform required DDL operations
• Perform required DCL operations
• Perform required ACL operations
• Perform required DB to S3 bucket and reverse operations
• Provide and consume Webservices and APIs

Frontend

• Develop new Applications required in Oracle Apex environment
• Support existing Oracle Applications and perform any required introduced changes or reports and fix bugs.

Database, Testing, and Quality Assurance for Oracle

• Design, develop, and maintain databases using Microsoft SQL Server/Oracle database or other relational database management systems.
• Optimize database performance through proper indexing, query optimization, and database tuning.
• Ensure data integrity and security through proper data modeling and access control mechanisms.
• Collaborate with backend developers to design database schemas that support application requirements.
• Implement data migration, ETL (DTS), and transformation scripts as needed.
• Develop and execute comprehensive test plans for front-end and backend applications.
• Automate testing processes using frameworks.
• Perform manual testing to identify bugs, defects, and usability issues.
• Collaborate with developers to ensure timely resolution of identified issues.
• Monitor application performance and conduct load testing to identify bottlenecks.

Terms and conditions

Joining time frame: (15 - 30 days)

Terms and conditions: 

Joining time frame:   maximum 4 weeks