ERP Software Oracle Programmer

at  ENTERPRISE SYSTEMS ANALYSIS TECHNOLOGY ESAT

JOB REQUIREMENTS:

• Bachelor’s degree in computer science, information technology, or a related discipline
• Minimum 4 years’ experience as Oracle Developer with excellent knowledge in SQL and PL/SQL, Installing, Configuring and Maintaining Oracle enterprise server 11g, 12c & 19c, Configuring databases for high availability, Standby database technologies, Data Guard
• Should be good in Performance Tuning., Configuring, scheduling & performing consistent, logical backups, RMAN backups Restoration; ensuring scheduled/unscheduled Backups are as per backup plan and performing the recovery when needed
• Good Knowledge in Database Synchronization, Database upgrades and migrations, Monitoring database Performance and Tuning instances and databases
• Should be good in developing database application in PL/SQL – Packages, Functions, Procedures, Triggers, Complex SQL, Knowledge and Experience of Oracle Collections, Objects Types, Good Knowledge and experience with SQL Query Tuning and understanding 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.
• Knowledge in ERP, Dash boarding, Business domain is advantage
  Job Type: Full-tim

• Conducting trial runs of software applications
• Performing system analysis
• Reviewing programs
• Preparing workflow charts
• Correcting errors in programs
• Writing PL/SQL – Packages, Functions, Procedures, Triggers and Complex SQL query.
• Perform SQL Query tuning
• Involved in the requirement gathering team to develop the application according to the client needs using Oracle PL/SQL and Web API
• Followed the Agile Methodology for the development of the application
• Maintaining existing packages, procedures.