Design, develop, and maintain Oracle database applications using PL/SQL, including Packages, Functions, Procedures, Triggers, and Complex SQL queries.
Install, configure, and maintain Oracle Database Server versions 10g, 11g, and 12c.
Configure, schedule, and manage consistent, logical backups, and ensure backup integrity using RMAN (Recovery Manager).
Develop Windows-based front-end applications using WPF, C#, ASP.Net, JavaScript, HTML, and XML to interact with Oracle databases.
Work closely with front-end developers to ensure seamless integration between the application interface and Oracle backend systems.
Utilize reporting tools to create and optimize reports for business users.
Apply knowledge of ERP systems, dashboard creation, and business processes to enhance the functionality and performance of database applications.
Work closely with cross-functional teams, including system administrators, network engineers, and business analysts, to meet organizational goals.
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 10g, 11g & 12c, and configuring databases for high availability, standby database technologies, Data Guard.
Experience 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, upgrades, migrations, monitoring database performance, and tuning instances and databases.
Strong experience in developing database applications in PL/SQL – Packages, Functions, Procedures, Triggers, Complex SQL, and understanding SQL plans.
Excellent experience in WPF, JavaScript, C#, ASP.Net, HTML, XML, reporting tools, and PL/SQL programming as front-end and Oracle as back-end.
Knowledge in ERP, dashboarding, and business domain is an advantage.