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 queries.
Performing 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 and procedures.
Job Requirements:
Bachelors 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, and 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 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 applications in PL/SQL Packages, Functions, Procedures, Triggers, and Complex SQL. Knowledge and experience of Oracle Collections, Objects, Types, and 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 Oracle as back end.
Knowledge in Oracle cloud technology.
Knowledge in ERP, dashboarding, and business domain is an advantage.
Job Type: Full-time
Education:
Experience: